// ============================================================================
// *********BeforeUpdate- SET_ACTION_REASON******************
// ============================================================================
def value = dateCheck()
if(value == "No")
{
//employeeconsent()
// SetMPAReasonCode()
println("[BeforeUpdate] Before calling BBReasonCode")
//BBReasonCode()
println("[BeforeUpdate] After calling BBReasonCode")
println("[BeforeUpdate] before calling MPAReasonCode")
//MPAReasonCode()
println("[BeforeUpdate] After calling MPAReasonCode")
println("[BeforeUpdate] Before calling BBActionManualValidations")
BBActionManualValidations()
println("[BeforeUpdate] After calling BBActionManualValidations")
println("[BeforeUpdate] Before calling EPA_validations_and_Actions")
//EPA_validations_and_Actions()
println("[BeforeUpdate] Before calling EPA_validations")
//EPA_validations()
println("[BeforeUpdate] Before calling EPA_Validations_RecordLevel")
EPA_Validations_RecordLevel()
}
dev7 from eror
select rules.* , -- BBAction_c DECODE(Rule_Number, 1, 'MAV_DIR_BB_ACTION_1000', 2, 'MAV_DIR_BB_ACTION_1003', 3, 'MAV_DIR_BB_ACTION_1001', 4, 'MAV_DIR_BB_ACTION_1003', 5, 'MAV_DIR_BB_ACTION_1003', 6, 'MAV_DIR_BB_ACTION_1003', 7, 'MAV_DIR_BB_ACTION_1003', 8, 'MAV_DIR_BB_ACTION_1003', 9, 'MAV_DIR_BB_ACTION_1003', 10, 'MAV_DIR_BB_ACTION_1003', 99, 'MAV_DIR_BB_ACTION_1002', 11 , 'MAV_DIR_BB_ACTION_1002', -- Pre-approved zero BB for active sale rep NULL ) AS "BBAction_c", -- BBReasonCode_c DECODE(Rule_Number, 1, 'MVA_DIR_BB_REASON_1018', 2, 'MVA_DIR_BB_REASON_1001', 3, 'MVA_DIR_BB_REASON_1018', 4, 'MVA_DIR_BB_REASON_1001', 5, 'MVA_DIR_BB_REASON_1001', 6, 'MVA_DI...
Comments
Post a Comment