4957: jd_codes_tbl_city_stg(l_counter).jurisdiction_code);
4958: hr_utility.trace('EMJT spelled jd code -> '|| l_spelled_jd_code );
4959:
4960: -- Fix for bug#9546119
4961: -- pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','P');
4962: pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','I');
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4958: hr_utility.trace('EMJT spelled jd code -> '|| l_spelled_jd_code );
4959:
4960: -- Fix for bug#9546119
4961: -- pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','P');
4962: pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','I');
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4966: pay_core_utils.push_token('HOURS',SUBSTR(jd_codes_tbl_city_stg(l_counter).hours,1,50));
4959:
4960: -- Fix for bug#9546119
4961: -- pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','P');
4962: pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','I');
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4966: pay_core_utils.push_token('HOURS',SUBSTR(jd_codes_tbl_city_stg(l_counter).hours,1,50));
4967: pay_core_utils.push_token('PERCENTAGE',SUBSTR(jd_codes_tbl_city_stg(l_counter).percentage,1,50));
4960: -- Fix for bug#9546119
4961: -- pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','P');
4962: pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','I');
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4966: pay_core_utils.push_token('HOURS',SUBSTR(jd_codes_tbl_city_stg(l_counter).hours,1,50));
4967: pay_core_utils.push_token('PERCENTAGE',SUBSTR(jd_codes_tbl_city_stg(l_counter).percentage,1,50));
4968: --================================================================================================
4961: -- pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','P');
4962: pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','I');
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4966: pay_core_utils.push_token('HOURS',SUBSTR(jd_codes_tbl_city_stg(l_counter).hours,1,50));
4967: pay_core_utils.push_token('PERCENTAGE',SUBSTR(jd_codes_tbl_city_stg(l_counter).percentage,1,50));
4968: --================================================================================================
4969: l_counter := jd_codes_tbl_city_stg.NEXT(l_counter);
4962: pay_core_utils.push_message(801,'PAY_US_EMJT_EMPLOYEE_INFO','I');
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4966: pay_core_utils.push_token('HOURS',SUBSTR(jd_codes_tbl_city_stg(l_counter).hours,1,50));
4967: pay_core_utils.push_token('PERCENTAGE',SUBSTR(jd_codes_tbl_city_stg(l_counter).percentage,1,50));
4968: --================================================================================================
4969: l_counter := jd_codes_tbl_city_stg.NEXT(l_counter);
4970: END LOOP; --WHILE l_counter
4963: pay_core_utils.push_token('EMPLOYEE_NAME',SUBSTR(l_full_name,1,50));
4964: pay_core_utils.push_token('ASSIGNMENT_NUMBER',SUBSTR(l_assignment_number,1,50));
4965: pay_core_utils.push_token('JURISDICTION_NAME',SUBSTR(l_spelled_jd_code,1,50));
4966: pay_core_utils.push_token('HOURS',SUBSTR(jd_codes_tbl_city_stg(l_counter).hours,1,50));
4967: pay_core_utils.push_token('PERCENTAGE',SUBSTR(jd_codes_tbl_city_stg(l_counter).percentage,1,50));
4968: --================================================================================================
4969: l_counter := jd_codes_tbl_city_stg.NEXT(l_counter);
4970: END LOOP; --WHILE l_counter
4971: --}