DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_MX_RULES

Line 191: Organization Name using pay_mx_rules.strip_spl_chars

187: for test case ,when emp
188: terminated and ran PTU before the
189: year end process.
190: 115.45 04-Jan-2011 sjawid 9820914 Handling Special chars in Employee Name and
191: Organization Name using pay_mx_rules.strip_spl_chars
192: 115.46 01-Feb-2011 sjawid 11677462 Modified cursor load_gre to avoid invalid number
193: error by adding to_char to legal_employer_id check
194: to_char(p_le_id)
195: 115.47 10-Feb-2011 sjawid 11715919 Added cursor c_get_max_arch_end_date to fix the

Line 2402: pai_tab(ln_index).act_info1 := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');

2398: pai_tab(ln_index).action_info_category := 'MX YREND EE DETAILS';
2399: pai_tab(ln_index).jurisdiction_code := lv_jurisdiction;
2400: pai_tab(ln_index).action_context_id := p_archive_action_id;
2401: /* Bug: 9820914: Handling Special Chars in Employee name */
2402: pai_tab(ln_index).act_info1 := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
2403: pai_tab(ln_index).act_info2 := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
2404: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars(lv_names),'/','N');
2405: pai_tab(ln_index).act_info4 := lv_CURP;
2406: pai_tab(ln_index).act_info5 := lv_RFC_ID;

Line 2403: pai_tab(ln_index).act_info2 := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');

2399: pai_tab(ln_index).jurisdiction_code := lv_jurisdiction;
2400: pai_tab(ln_index).action_context_id := p_archive_action_id;
2401: /* Bug: 9820914: Handling Special Chars in Employee name */
2402: pai_tab(ln_index).act_info1 := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
2403: pai_tab(ln_index).act_info2 := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
2404: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars(lv_names),'/','N');
2405: pai_tab(ln_index).act_info4 := lv_CURP;
2406: pai_tab(ln_index).act_info5 := lv_RFC_ID;
2407: pai_tab(ln_index).act_info6 :=

Line 2404: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars(lv_names),'/','N');

2400: pai_tab(ln_index).action_context_id := p_archive_action_id;
2401: /* Bug: 9820914: Handling Special Chars in Employee name */
2402: pai_tab(ln_index).act_info1 := replace(pay_mx_rules.strip_spl_chars(lv_paternal_last_name),'/','N');
2403: pai_tab(ln_index).act_info2 := replace(pay_mx_rules.strip_spl_chars(lv_maternal_last_name),'/','N');
2404: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars(lv_names),'/','N');
2405: pai_tab(ln_index).act_info4 := lv_CURP;
2406: pai_tab(ln_index).act_info5 := lv_RFC_ID;
2407: pai_tab(ln_index).act_info6 :=
2408: fnd_date.date_to_canonical(ld_arch_start_date);

Line 2624: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars (g_ER_legal_name),'/','N');

2620: pai_tab(ln_index).action_context_id := g_payroll_action_id;
2621: pai_tab(ln_index).act_info1 := g_fiscal_year;
2622: pai_tab(ln_index).act_info2 := g_ER_RFC;
2623: /* Bug: 9820914: Handling special chars */
2624: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars (g_ER_legal_name),'/','N');
2625: pai_tab(ln_index).act_info4 := replace(pay_mx_rules.strip_spl_chars (g_ER_legal_rep_name),'/','N');
2626: pai_tab(ln_index).act_info5 := g_ER_legal_rep_RFC;
2627: pai_tab(ln_index).act_info6 := g_ER_legal_rep_CURP;
2628:

Line 2625: pai_tab(ln_index).act_info4 := replace(pay_mx_rules.strip_spl_chars (g_ER_legal_rep_name),'/','N');

2621: pai_tab(ln_index).act_info1 := g_fiscal_year;
2622: pai_tab(ln_index).act_info2 := g_ER_RFC;
2623: /* Bug: 9820914: Handling special chars */
2624: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars (g_ER_legal_name),'/','N');
2625: pai_tab(ln_index).act_info4 := replace(pay_mx_rules.strip_spl_chars (g_ER_legal_rep_name),'/','N');
2626: pai_tab(ln_index).act_info5 := g_ER_legal_rep_RFC;
2627: pai_tab(ln_index).act_info6 := g_ER_legal_rep_CURP;
2628:
2629: hr_utility.set_location(gv_package || lv_procedure_name, 220);