APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_PAYSLIP_SIMULATION_MAIN

Line 1: PACKAGE BODY pay_us_payslip_simulation_main AS

1: PACKAGE BODY pay_us_payslip_simulation_main AS
2: /* $Header: pyuspssm.pkb 120.0.12020000.13 2013/04/09 03:20:42 emunisek noship $ */
3: /*
4:
5: Change List

Line 56: gv_package VARCHAR2(100) := 'pay_us_payslip_simulation_main';

52: 08-Apr-2013 emunisek 120.12 16605117 Made changes so that Element Name under Rate Details
53: section displays Simulation Name if present.
54: */
55:
56: gv_package VARCHAR2(100) := 'pay_us_payslip_simulation_main';
57: gn_gross_earn_def_bal_id number := 0;
58:
59: gv_dim_asg_tg_ytd VARCHAR2(100) := '_ASG_TG_YTD';
60: gv_dim_asg_gre_ytd VARCHAR2(100) := '_ASG_GRE_YTD';

Line 107: pay_us_payslip_simulation_main.lrr_act_tab.delete;

103: BEGIN
104:
105: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
106:
107: pay_us_payslip_simulation_main.lrr_act_tab.delete;
108: pay_us_payslip_simulation_main.emp_elements_tab.delete;
109:
110: hr_utility.set_location(gv_package || lv_procedure_name, 10);
111:

Line 108: pay_us_payslip_simulation_main.emp_elements_tab.delete;

104:
105: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
106:
107: pay_us_payslip_simulation_main.lrr_act_tab.delete;
108: pay_us_payslip_simulation_main.emp_elements_tab.delete;
109:
110: hr_utility.set_location(gv_package || lv_procedure_name, 10);
111:
112: IF p_legislation_code = 'CA' THEN

Line 133: IF pay_us_payslip_simulation_main.ltr_summary_labels.count = 0 THEN

129: ELSE
130: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
131: END IF;
132:
133: IF pay_us_payslip_simulation_main.ltr_summary_labels.count = 0 THEN
134:
135: hr_utility.set_location(gv_package || lv_procedure_name, 30);
136:
137: i := 0;

Line 141: pay_us_payslip_simulation_main.ltr_summary_labels(i).language := lbl.language;

137: i := 0;
138:
139: FOR lbl in c_arch_labels LOOP
140:
141: pay_us_payslip_simulation_main.ltr_summary_labels(i).language := lbl.language;
142: pay_us_payslip_simulation_main.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
143: pay_us_payslip_simulation_main.ltr_summary_labels(i).meaning := lbl.meaning;
144:
145: i := i + 1;

Line 142: pay_us_payslip_simulation_main.ltr_summary_labels(i).lookup_code := lbl.lookup_code;

138:
139: FOR lbl in c_arch_labels LOOP
140:
141: pay_us_payslip_simulation_main.ltr_summary_labels(i).language := lbl.language;
142: pay_us_payslip_simulation_main.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
143: pay_us_payslip_simulation_main.ltr_summary_labels(i).meaning := lbl.meaning;
144:
145: i := i + 1;
146:

Line 143: pay_us_payslip_simulation_main.ltr_summary_labels(i).meaning := lbl.meaning;

139: FOR lbl in c_arch_labels LOOP
140:
141: pay_us_payslip_simulation_main.ltr_summary_labels(i).language := lbl.language;
142: pay_us_payslip_simulation_main.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
143: pay_us_payslip_simulation_main.ltr_summary_labels(i).meaning := lbl.meaning;
144:
145: i := i + 1;
146:
147: END LOOP;

Line 2032: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

2028: NVL(ln_current_amount,0) <> 0 OR NVL(ln_current_hours,0) <> 0 THEN
2029:
2030: hr_utility.set_location(gv_package || lv_procedure_name, 230);
2031:
2032: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
2033:
2034: IF p_element_classification_name in ('Earnings',
2035: 'Supplemental Earnings',
2036: 'Taxable Benefits',

Line 2043: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11

2039: 'Alien/Expat Earnings') THEN
2040:
2041: lv_action_category := 'AC EARNINGS';
2042:
2043: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
2044: := fnd_number.number_to_canonical(ln_current_hours);
2045:
2046: IF ln_current_hours <> 0 AND ln_current_amount <> 0 THEN
2047:

Line 2069: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22:=

2065: THEN
2066:
2067: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2068:
2069: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22:=
2070: ROUND((ln_current_amount/ln_current_hours),5);
2071:
2072: ELSE
2073:

Line 2076: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22:=ln_rate;

2072: ELSE
2073:
2074: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2075:
2076: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22:=ln_rate;
2077:
2078: END IF;
2079:
2080: ELSE

Line 2084: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22 := null;

2080: ELSE
2081:
2082: hr_utility.set_location(gv_package || lv_procedure_name, 270);
2083:
2084: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22 := null;
2085:
2086: END IF;
2087:
2088: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12

Line 2088: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12

2084: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info22 := null;
2085:
2086: END IF;
2087:
2088: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
2089: := fnd_number.number_to_canonical(ln_ytd_hours);
2090:
2091: END IF; /*p_element_classification_name IF*/
2092:

Line 2093: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category

2089: := fnd_number.number_to_canonical(ln_ytd_hours);
2090:
2091: END IF; /*p_element_classification_name IF*/
2092:
2093: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
2094: := lv_action_category;
2095: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
2096: := NVL(p_jurisdiction_code, '00-000-0000');
2097: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_context_id

Line 2095: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

2091: END IF; /*p_element_classification_name IF*/
2092:
2093: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
2094: := lv_action_category;
2095: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
2096: := NVL(p_jurisdiction_code, '00-000-0000');
2097: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_context_id
2098: := p_source_action_id;
2099: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

Line 2097: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_context_id

2093: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
2094: := lv_action_category;
2095: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
2096: := NVL(p_jurisdiction_code, '00-000-0000');
2097: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_context_id
2098: := p_source_action_id;
2099: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
2100: := p_element_classification_name;
2101: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2

Line 2099: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

2095: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
2096: := NVL(p_jurisdiction_code, '00-000-0000');
2097: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_context_id
2098: := p_source_action_id;
2099: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
2100: := p_element_classification_name;
2101: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
2102: := p_element_type_id;
2103: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6

Line 2101: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2

2097: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_context_id
2098: := p_source_action_id;
2099: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
2100: := p_element_classification_name;
2101: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
2102: := p_element_type_id;
2103: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
2104: := p_primary_balance_id;
2105: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7

Line 2103: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6

2099: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
2100: := p_element_classification_name;
2101: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
2102: := p_element_type_id;
2103: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
2104: := p_primary_balance_id;
2105: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
2106: := p_processing_priority;
2107:

Line 2105: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7

2101: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
2102: := p_element_type_id;
2103: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
2104: := p_primary_balance_id;
2105: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
2106: := p_processing_priority;
2107:
2108: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));

Line 2108: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8

2104: := p_primary_balance_id;
2105: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
2106: := p_processing_priority;
2107:
2108: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));
2110: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
2111: := fnd_number.number_to_canonical(NVL(ln_ytd_amount,0));
2112:

Line 2110: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9

2106: := p_processing_priority;
2107:
2108: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));
2110: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
2111: := fnd_number.number_to_canonical(NVL(ln_ytd_amount,0));
2112:
2113: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
2114: := p_reporting_name;

Line 2113: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));
2110: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
2111: := fnd_number.number_to_canonical(NVL(ln_ytd_amount,0));
2112:
2113: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
2114: := p_reporting_name;
2115:
2116: IF p_element_classification_name <> 'Tax Deductions' THEN
2117:

Line 2123: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

2119: FETCH get_simulation_name INTO lv_simulation_name;
2120:
2121: IF get_simulation_name%FOUND THEN
2122:
2123: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
2124: := lv_simulation_name;
2125:
2126: END IF;
2127:

Line 2133: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info24

2129:
2130: END IF;
2131:
2132: IF lv_action_category = 'AC DEDUCTIONS' THEN
2133: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info24
2134: := p_reporting_name;
2135:
2136: IF pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
2137: = 'Tax Deductions' AND p_legislation_code = 'US' THEN

Line 2136: IF pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

2132: IF lv_action_category = 'AC DEDUCTIONS' THEN
2133: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info24
2134: := p_reporting_name;
2135:
2136: IF pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
2137: = 'Tax Deductions' AND p_legislation_code = 'US' THEN
2138:
2139: OPEN get_display_name(p_reporting_name,
2140: NVL(p_jurisdiction_code, '00-000-0000'));

Line 2153: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info24

2149: END IF;
2150:
2151: CLOSE get_display_name;
2152:
2153: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info24
2154: := lv_display_name;
2155:
2156: END IF;
2157:

Line 2160: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info21

2156: END IF;
2157:
2158: END IF;
2159:
2160: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info21
2161: := p_el_jurisdiction_code;
2162:
2163: END IF; /* NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_ytd_hours,0) <> 0 IF */
2164:

Line 2637: ln_element_index := pay_us_payslip_simulation_main.emp_elements_tab.count;

2633: ln_hours_balance_id := null;
2634:
2635: END IF;
2636:
2637: ln_element_index := pay_us_payslip_simulation_main.emp_elements_tab.count;
2638:
2639: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_type_id
2640: := ln_element_type_id;
2641: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_classfn

Line 2639: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_type_id

2635: END IF;
2636:
2637: ln_element_index := pay_us_payslip_simulation_main.emp_elements_tab.count;
2638:
2639: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_type_id
2640: := ln_element_type_id;
2641: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_classfn
2642: := lv_element_classification_name;
2643: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_primary_balance_id

Line 2641: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_classfn

2637: ln_element_index := pay_us_payslip_simulation_main.emp_elements_tab.count;
2638:
2639: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_type_id
2640: := ln_element_type_id;
2641: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_classfn
2642: := lv_element_classification_name;
2643: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_primary_balance_id
2644: := ln_primary_balance_id;
2645: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_processing_priority

Line 2643: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_primary_balance_id

2639: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_type_id
2640: := ln_element_type_id;
2641: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_classfn
2642: := lv_element_classification_name;
2643: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_primary_balance_id
2644: := ln_primary_balance_id;
2645: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_processing_priority
2646: := ln_processing_priority;
2647: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_reporting_name

Line 2645: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_processing_priority

2641: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_classfn
2642: := lv_element_classification_name;
2643: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_primary_balance_id
2644: := ln_primary_balance_id;
2645: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_processing_priority
2646: := ln_processing_priority;
2647: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_reporting_name
2648: := lv_reporting_name;
2649: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_hours_balance_id

Line 2647: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_reporting_name

2643: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_primary_balance_id
2644: := ln_primary_balance_id;
2645: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_processing_priority
2646: := ln_processing_priority;
2647: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_reporting_name
2648: := lv_reporting_name;
2649: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_hours_balance_id
2650: := ln_hours_balance_id;
2651: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).jurisdiction_code

Line 2649: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_hours_balance_id

2645: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_processing_priority
2646: := ln_processing_priority;
2647: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_reporting_name
2648: := lv_reporting_name;
2649: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_hours_balance_id
2650: := ln_hours_balance_id;
2651: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).jurisdiction_code
2652: := lv_jurisdiction_code;
2653:

Line 2651: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).jurisdiction_code

2647: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_reporting_name
2648: := lv_reporting_name;
2649: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).element_hours_balance_id
2650: := ln_hours_balance_id;
2651: pay_us_payslip_simulation_main.emp_elements_tab(ln_element_index).jurisdiction_code
2652: := lv_jurisdiction_code;
2653:
2654: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2655:

Line 2699: IF pay_us_payslip_simulation_main.lrr_act_tab.COUNT > 0 THEN

2695: CLOSE c_cur_action_elements_rr;
2696:
2697: END IF;
2698:
2699: IF pay_us_payslip_simulation_main.lrr_act_tab.COUNT > 0 THEN
2700:
2701: FOR i IN pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2702: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2703:

Line 2701: FOR i IN pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..

2697: END IF;
2698:
2699: IF pay_us_payslip_simulation_main.lrr_act_tab.COUNT > 0 THEN
2700:
2701: FOR i IN pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2702: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2703:
2704: hr_utility.trace('after populate_elements ftp' ||
2705: ' action_context_id is ' ||

Line 2702: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP

2698:
2699: IF pay_us_payslip_simulation_main.lrr_act_tab.COUNT > 0 THEN
2700:
2701: FOR i IN pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2702: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2703:
2704: hr_utility.trace('after populate_elements ftp' ||
2705: ' action_context_id is ' ||
2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));

Line 2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));

2702: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2703:
2704: hr_utility.trace('after populate_elements ftp' ||
2705: ' action_context_id is ' ||
2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));
2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);

Line 2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);

2704: hr_utility.trace('after populate_elements ftp' ||
2705: ' action_context_id is ' ||
2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));
2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);

Line 2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);

2706: to_char(pay_us_payslip_simulation_main.lrr_act_tab(i).action_context_id));
2707: hr_utility.trace('action_info_category ' ||
2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);

Line 2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);

2708: pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category);
2709: hr_utility.trace('act_info1 is ' ||
2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);

Line 2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);

2710: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1);
2711: hr_utility.trace('act_info10 ' ||
2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);

Line 2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);

2712: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info10);
2713: hr_utility.trace('act_info3 ' ||
2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);

Line 2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);

2714: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info3);
2715: hr_utility.trace('act_info4 ' ||
2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);

Line 2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);

2716: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info4);
2717: hr_utility.trace('act_info5 ' ||
2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);
2723: hr_utility.trace('act_info8 ' ||
2724: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8);

Line 2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);

2718: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info5);
2719: hr_utility.trace('act_info6 ' ||
2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);
2723: hr_utility.trace('act_info8 ' ||
2724: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8);
2725:
2726: END LOOP;

Line 2724: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8);

2720: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info6);
2721: hr_utility.trace('act_info7 ' ||
2722: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info7);
2723: hr_utility.trace('act_info8 ' ||
2724: pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8);
2725:
2726: END LOOP;
2727:
2728: END IF;

Line 2732: IF pay_us_payslip_simulation_main.emp_elements_tab.count > 0 THEN

2728: END IF;
2729:
2730: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2731:
2732: IF pay_us_payslip_simulation_main.emp_elements_tab.count > 0 THEN
2733:
2734: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2735:
2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..

Line 2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..

2732: IF pay_us_payslip_simulation_main.emp_elements_tab.count > 0 THEN
2733:
2734: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2735:
2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..
2737: pay_us_payslip_simulation_main.emp_elements_tab.LAST LOOP
2738:
2739: hr_utility.trace('emp_elements_tab.element_type ' ||
2740: to_char(pay_us_payslip_simulation_main.emp_elements_tab(j).element_type_id));

Line 2737: pay_us_payslip_simulation_main.emp_elements_tab.LAST LOOP

2733:
2734: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2735:
2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..
2737: pay_us_payslip_simulation_main.emp_elements_tab.LAST LOOP
2738:
2739: hr_utility.trace('emp_elements_tab.element_type ' ||
2740: to_char(pay_us_payslip_simulation_main.emp_elements_tab(j).element_type_id));
2741:

Line 2740: to_char(pay_us_payslip_simulation_main.emp_elements_tab(j).element_type_id));

2736: FOR j in pay_us_payslip_simulation_main.emp_elements_tab.FIRST ..
2737: pay_us_payslip_simulation_main.emp_elements_tab.LAST LOOP
2738:
2739: hr_utility.trace('emp_elements_tab.element_type ' ||
2740: to_char(pay_us_payslip_simulation_main.emp_elements_tab(j).element_type_id));
2741:
2742: END LOOP;
2743:
2744: END IF;

Line 2960: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN

2956: BEGIN
2957:
2958: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
2959:
2960: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN
2961:
2962: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2963:
2964: FOR i in pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..

Line 2964: FOR i in pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..

2960: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN
2961:
2962: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2963:
2964: FOR i in pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2965: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2966:
2967: IF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category
2968: = 'AC EARNINGS' THEN

Line 2965: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP

2961:
2962: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2963:
2964: FOR i in pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2965: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2966:
2967: IF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category
2968: = 'AC EARNINGS' THEN
2969:

Line 2967: IF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category

2963:
2964: FOR i in pay_us_payslip_simulation_main.lrr_act_tab.FIRST ..
2965: pay_us_payslip_simulation_main.lrr_act_tab.LAST LOOP
2966:
2967: IF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category
2968: = 'AC EARNINGS' THEN
2969:
2970: IF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2971: = 'Earnings' THEN

Line 2970: IF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

2966:
2967: IF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category
2968: = 'AC EARNINGS' THEN
2969:
2970: IF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2971: = 'Earnings' THEN
2972:
2973: lv_earnings
2974: := lv_earnings +

Line 2975: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

2971: = 'Earnings' THEN
2972:
2973: lv_earnings
2974: := lv_earnings +
2975: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2976: lv_ytd_earnings
2977: := lv_ytd_earnings +
2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2979:

Line 2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

2974: := lv_earnings +
2975: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2976: lv_ytd_earnings
2977: := lv_ytd_earnings +
2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2979:
2980: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2981: = 'Supplemental Earnings' THEN
2982:

Line 2980: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

2976: lv_ytd_earnings
2977: := lv_ytd_earnings +
2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2979:
2980: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2981: = 'Supplemental Earnings' THEN
2982:
2983: lv_supplemental_earnings
2984: := lv_supplemental_earnings +

Line 2985: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

2981: = 'Supplemental Earnings' THEN
2982:
2983: lv_supplemental_earnings
2984: := lv_supplemental_earnings +
2985: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2986: lv_ytd_supplemental_earnings
2987: := lv_ytd_supplemental_earnings +
2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2989:

Line 2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

2984: := lv_supplemental_earnings +
2985: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2986: lv_ytd_supplemental_earnings
2987: := lv_ytd_supplemental_earnings +
2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2989:
2990: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2991: = 'Imputed Earnings' THEN
2992:

Line 2990: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

2986: lv_ytd_supplemental_earnings
2987: := lv_ytd_supplemental_earnings +
2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2989:
2990: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2991: = 'Imputed Earnings' THEN
2992:
2993: lv_imputed_earnings
2994: := lv_imputed_earnings +

Line 2995: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

2991: = 'Imputed Earnings' THEN
2992:
2993: lv_imputed_earnings
2994: := lv_imputed_earnings +
2995: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2996: lv_ytd_imputed_earnings
2997: := lv_ytd_imputed_earnings +
2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2999:

Line 2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

2994: := lv_imputed_earnings +
2995: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2996: lv_ytd_imputed_earnings
2997: := lv_ytd_imputed_earnings +
2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2999:
3000: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3001: = 'Non-payroll Payments' THEN
3002:

Line 3000: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

2996: lv_ytd_imputed_earnings
2997: := lv_ytd_imputed_earnings +
2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2999:
3000: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3001: = 'Non-payroll Payments' THEN
3002:
3003: lv_non_payroll_payments
3004: := lv_non_payroll_payments +

Line 3005: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3001: = 'Non-payroll Payments' THEN
3002:
3003: lv_non_payroll_payments
3004: := lv_non_payroll_payments +
3005: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3006: lv_ytd_non_payroll_payments
3007: := lv_ytd_non_payroll_payments +
3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3009:

Line 3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3004: := lv_non_payroll_payments +
3005: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3006: lv_ytd_non_payroll_payments
3007: := lv_ytd_non_payroll_payments +
3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3009:
3010: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3011: = 'Taxable Benefits' THEN
3012:

Line 3010: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

3006: lv_ytd_non_payroll_payments
3007: := lv_ytd_non_payroll_payments +
3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3009:
3010: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3011: = 'Taxable Benefits' THEN
3012:
3013: lv_taxable_benefits
3014: := lv_taxable_benefits +

Line 3015: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3011: = 'Taxable Benefits' THEN
3012:
3013: lv_taxable_benefits
3014: := lv_taxable_benefits +
3015: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3016: lv_ytd_taxable_benefits
3017: := lv_ytd_taxable_benefits +
3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3019:

Line 3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3014: := lv_taxable_benefits +
3015: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3016: lv_ytd_taxable_benefits
3017: := lv_ytd_taxable_benefits +
3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3019:
3020: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3021: = 'Alien/Expat Earnings' THEN
3022:

Line 3020: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

3016: lv_ytd_taxable_benefits
3017: := lv_ytd_taxable_benefits +
3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3019:
3020: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3021: = 'Alien/Expat Earnings' THEN
3022:
3023: lv_alien_expat_earnings
3024: := lv_alien_expat_earnings +

Line 3025: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3021: = 'Alien/Expat Earnings' THEN
3022:
3023: lv_alien_expat_earnings
3024: := lv_alien_expat_earnings +
3025: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3026: lv_ytd_alien_expat_earnings
3027: := lv_ytd_alien_expat_earnings +
3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3029:

Line 3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3024: := lv_alien_expat_earnings +
3025: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3026: lv_ytd_alien_expat_earnings
3027: := lv_ytd_alien_expat_earnings +
3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3029:
3030: END IF; /* End of AC EARNINGS Section */
3031:
3032: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category

Line 3032: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category

3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3029:
3030: END IF; /* End of AC EARNINGS Section */
3031:
3032: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category
3033: = 'AC DEDUCTIONS' THEN
3034:
3035: IF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3036: = 'Pre-Tax Deductions' THEN

Line 3035: IF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

3031:
3032: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category
3033: = 'AC DEDUCTIONS' THEN
3034:
3035: IF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3036: = 'Pre-Tax Deductions' THEN
3037:
3038: lv_pre_tax_deductions
3039: := lv_pre_tax_deductions +

Line 3040: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3036: = 'Pre-Tax Deductions' THEN
3037:
3038: lv_pre_tax_deductions
3039: := lv_pre_tax_deductions +
3040: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3041: lv_ytd_pre_tax_deductions
3042: := lv_ytd_pre_tax_deductions +
3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3044:

Line 3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3039: := lv_pre_tax_deductions +
3040: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3041: lv_ytd_pre_tax_deductions
3042: := lv_ytd_pre_tax_deductions +
3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3044:
3045: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3046: = 'Involuntary Deductions' THEN
3047:

Line 3045: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

3041: lv_ytd_pre_tax_deductions
3042: := lv_ytd_pre_tax_deductions +
3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3044:
3045: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3046: = 'Involuntary Deductions' THEN
3047:
3048: lv_involuntary_deductions
3049: := lv_involuntary_deductions +

Line 3050: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3046: = 'Involuntary Deductions' THEN
3047:
3048: lv_involuntary_deductions
3049: := lv_involuntary_deductions +
3050: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3051: lv_ytd_involuntary_deductions
3052: := lv_ytd_involuntary_deductions +
3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3054:

Line 3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3049: := lv_involuntary_deductions +
3050: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3051: lv_ytd_involuntary_deductions
3052: := lv_ytd_involuntary_deductions +
3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3054:
3055: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3056: = 'Voluntary Deductions' THEN
3057:

Line 3055: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

3051: lv_ytd_involuntary_deductions
3052: := lv_ytd_involuntary_deductions +
3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3054:
3055: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3056: = 'Voluntary Deductions' THEN
3057:
3058: lv_voluntary_deductions
3059: := lv_voluntary_deductions +

Line 3060: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3056: = 'Voluntary Deductions' THEN
3057:
3058: lv_voluntary_deductions
3059: := lv_voluntary_deductions +
3060: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3061: lv_ytd_voluntary_deductions
3062: := lv_ytd_voluntary_deductions +
3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3064:

Line 3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3059: := lv_voluntary_deductions +
3060: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3061: lv_ytd_voluntary_deductions
3062: := lv_ytd_voluntary_deductions +
3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3064:
3065: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3066: = 'Tax Deductions' THEN
3067:

Line 3065: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1

3061: lv_ytd_voluntary_deductions
3062: := lv_ytd_voluntary_deductions +
3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3064:
3065: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3066: = 'Tax Deductions' THEN
3067:
3068: lv_tax_deductions
3069: := lv_tax_deductions +

Line 3070: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3066: = 'Tax Deductions' THEN
3067:
3068: lv_tax_deductions
3069: := lv_tax_deductions +
3070: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3071: lv_ytd_tax_deductions
3072: := lv_ytd_tax_deductions +
3073: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3074:

Line 3073: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3069: := lv_tax_deductions +
3070: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3071: lv_ytd_tax_deductions
3072: := lv_ytd_tax_deductions +
3073: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3074:
3075: END IF; /* End of AC DEDUCTIONS Section */
3076:
3077: END IF; /* action_info_category IF */

Line 3081: END IF; /* pay_us_payslip_simulation_main.lrr_act_tab.count > 0 IF */

3077: END IF; /* action_info_category IF */
3078:
3079: END LOOP;
3080:
3081: END IF; /* pay_us_payslip_simulation_main.lrr_act_tab.count > 0 IF */
3082:
3083: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3084:
3085: j := 0;

Line 3087: IF pay_us_payslip_simulation_main.ltr_summary_labels.count > 0 THEN

3083: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3084:
3085: j := 0;
3086:
3087: IF pay_us_payslip_simulation_main.ltr_summary_labels.count > 0 THEN
3088:
3089: for j in pay_us_payslip_simulation_main.ltr_summary_labels.first..
3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop
3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language

Line 3089: for j in pay_us_payslip_simulation_main.ltr_summary_labels.first..

3085: j := 0;
3086:
3087: IF pay_us_payslip_simulation_main.ltr_summary_labels.count > 0 THEN
3088:
3089: for j in pay_us_payslip_simulation_main.ltr_summary_labels.first..
3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop
3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3092: = pay_ac_action_arch.gv_person_lang and
3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN

Line 3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop

3086:
3087: IF pay_us_payslip_simulation_main.ltr_summary_labels.count > 0 THEN
3088:
3089: for j in pay_us_payslip_simulation_main.ltr_summary_labels.first..
3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop
3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3092: = pay_ac_action_arch.gv_person_lang and
3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN
3094: lv_current_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;

Line 3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language

3087: IF pay_us_payslip_simulation_main.ltr_summary_labels.count > 0 THEN
3088:
3089: for j in pay_us_payslip_simulation_main.ltr_summary_labels.first..
3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop
3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3092: = pay_ac_action_arch.gv_person_lang and
3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN
3094: lv_current_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3095: end if;

Line 3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN

3089: for j in pay_us_payslip_simulation_main.ltr_summary_labels.first..
3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop
3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3092: = pay_ac_action_arch.gv_person_lang and
3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN
3094: lv_current_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3095: end if;
3096:
3097: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language

Line 3094: lv_current_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;

3090: pay_us_payslip_simulation_main.ltr_summary_labels.last loop
3091: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3092: = pay_ac_action_arch.gv_person_lang and
3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN
3094: lv_current_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3095: end if;
3096:
3097: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3098: = pay_ac_action_arch.gv_person_lang and

Line 3097: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language

3093: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'CURRENT' THEN
3094: lv_current_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3095: end if;
3096:
3097: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3098: = pay_ac_action_arch.gv_person_lang and
3099: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'YTD' THEN
3100: lv_ytd_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3101: end if;

Line 3099: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'YTD' THEN

3095: end if;
3096:
3097: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3098: = pay_ac_action_arch.gv_person_lang and
3099: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'YTD' THEN
3100: lv_ytd_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3101: end if;
3102: end loop;
3103:

Line 3100: lv_ytd_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;

3096:
3097: if pay_us_payslip_simulation_main.ltr_summary_labels(j).language
3098: = pay_ac_action_arch.gv_person_lang and
3099: pay_us_payslip_simulation_main.ltr_summary_labels(j).lookup_code = 'YTD' THEN
3100: lv_ytd_label := pay_us_payslip_simulation_main.ltr_summary_labels(j).meaning;
3101: end if;
3102: end loop;
3103:
3104: END IF;

Line 3108: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN

3104: END IF;
3105:
3106: /* Insert one row for CURRENT and one for YTD */
3107:
3108: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN
3109:
3110: /* CURRENT Values */
3111:
3112: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

Line 3112: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

3108: IF pay_us_payslip_simulation_main.lrr_act_tab.count > 0 THEN
3109:
3110: /* CURRENT Values */
3111:
3112: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3113: hr_utility.trace('ln_index = ' || ln_index);
3114: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3115: := 'AC SUMMARY CURRENT';
3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

Line 3114: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category

3110: /* CURRENT Values */
3111:
3112: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3113: hr_utility.trace('ln_index = ' || ln_index);
3114: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3115: := 'AC SUMMARY CURRENT';
3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3117: := '00-000-0000';
3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

Line 3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

3112: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3113: hr_utility.trace('ln_index = ' || ln_index);
3114: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3115: := 'AC SUMMARY CURRENT';
3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3117: := '00-000-0000';
3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5

Line 3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

3114: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3115: := 'AC SUMMARY CURRENT';
3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3117: := '00-000-0000';
3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6

Line 3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5

3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3117: := '00-000-0000';
3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7

Line 3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6

3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8

Line 3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7

3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9

Line 3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8

3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

Line 3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9

3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11

Line 3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12

Line 3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11

3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13

Line 3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12

3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3138: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14

Line 3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13

3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3138: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3139: := lv_current_label;
3140: /* Determining Net Current Value below. In Regular Archiver Net value is

Line 3138: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14

3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3138: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3139: := lv_current_label;
3140: /* Determining Net Current Value below. In Regular Archiver Net value is
3141: determined based on PAYMENTS Dimension. But in Payroll Simulation, since
3142: Prepayments will not be run, the Net value will be determined based on

Line 3144: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15

3140: /* Determining Net Current Value below. In Regular Archiver Net value is
3141: determined based on PAYMENTS Dimension. But in Payroll Simulation, since
3142: Prepayments will not be run, the Net value will be determined based on
3143: the Earnings and Deductions */
3144: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15
3145: := fnd_number.number_to_canonical(lv_earnings
3146: + lv_supplemental_earnings
3147: - lv_pre_tax_deductions
3148: - lv_involuntary_deductions

Line 3155: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15);

3151: + lv_alien_expat_earnings
3152: + lv_non_payroll_payments);
3153:
3154: lv_estimated_net := fnd_number.canonical_to_number(
3155: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15);
3156:
3157: /* YTD Values */
3158:
3159: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

Line 3159: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

3155: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15);
3156:
3157: /* YTD Values */
3158:
3159: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3160:
3161: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3162: := 'AC SUMMARY YTD';
3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

Line 3161: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category

3157: /* YTD Values */
3158:
3159: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3160:
3161: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3162: := 'AC SUMMARY YTD';
3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3164: := '00-000-0000';
3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

Line 3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

3159: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3160:
3161: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3162: := 'AC SUMMARY YTD';
3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3164: := '00-000-0000';
3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5

Line 3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

3161: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3162: := 'AC SUMMARY YTD';
3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3164: := '00-000-0000';
3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6

Line 3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5

3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3164: := '00-000-0000';
3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7

Line 3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6

3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8

Line 3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7

3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9

Line 3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8

3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

Line 3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9

3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11

Line 3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12

Line 3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11

3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13

Line 3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12

3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14

Line 3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13

3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3186: := lv_ytd_label;
3187: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15

Line 3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14

3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3186: := lv_ytd_label;
3187: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15
3188: := fnd_number.number_to_canonical(lv_ytd_earnings
3189: + lv_ytd_supplemental_earnings

Line 3187: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15

3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3186: := lv_ytd_label;
3187: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15
3188: := fnd_number.number_to_canonical(lv_ytd_earnings
3189: + lv_ytd_supplemental_earnings
3190: - lv_ytd_pre_tax_deductions
3191: - lv_ytd_involuntary_deductions

Line 3201: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

3197: END IF;
3198:
3199: /* Archive Estimated Values for Summary */
3200:
3201: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3202: hr_utility.trace('ln_index = ' || ln_index);
3203: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3204: := 'AC SIM GRAPH ESTIMATED';
3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

Line 3203: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category

3199: /* Archive Estimated Values for Summary */
3200:
3201: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3202: hr_utility.trace('ln_index = ' || ln_index);
3203: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3204: := 'AC SIM GRAPH ESTIMATED';
3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3206: := '00-000-0000';
3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

Line 3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

3201: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3202: hr_utility.trace('ln_index = ' || ln_index);
3203: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3204: := 'AC SIM GRAPH ESTIMATED';
3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3206: := '00-000-0000';
3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);
3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2

Line 3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

3203: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3204: := 'AC SIM GRAPH ESTIMATED';
3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3206: := '00-000-0000';
3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);
3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);

Line 3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2

3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3206: := '00-000-0000';
3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);
3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3213: := fnd_number.number_to_canonical(lv_tax_deductions);

Line 3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3

3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);
3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3213: := fnd_number.number_to_canonical(lv_tax_deductions);
3214: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3215: := fnd_number.number_to_canonical(lv_estimated_net);
3216:

Line 3214: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3213: := fnd_number.number_to_canonical(lv_tax_deductions);
3214: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3215: := fnd_number.number_to_canonical(lv_estimated_net);
3216:
3217: /* Archive Current Values for Summary */
3218: /* Archived values are stored in Canonical Form. So we are directly

Line 3241: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;

3237: ,lv_prev_alien_expat_earnings
3238: ,lv_prev_non_payroll_payments;
3239: CLOSE get_prev_values;
3240:
3241: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3242:
3243: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3244: := 'AC SIM GRAPH ACTUAL';
3245: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

Line 3243: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category

3239: CLOSE get_prev_values;
3240:
3241: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3242:
3243: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3244: := 'AC SIM GRAPH ACTUAL';
3245: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3246: := '00-000-0000';
3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

Line 3245: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code

3241: ln_index := pay_us_payslip_simulation_main.lrr_act_tab.count;
3242:
3243: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3244: := 'AC SIM GRAPH ACTUAL';
3245: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3246: := '00-000-0000';
3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3248: := lv_prev_pre_tax_deductions;
3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2

Line 3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1

3243: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category
3244: := 'AC SIM GRAPH ACTUAL';
3245: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3246: := '00-000-0000';
3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3248: := lv_prev_pre_tax_deductions;
3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3250: := fnd_number.number_to_canonical(
3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +

Line 3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2

3245: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3246: := '00-000-0000';
3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3248: := lv_prev_pre_tax_deductions;
3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3250: := fnd_number.number_to_canonical(
3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +
3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3

Line 3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3

3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3250: := fnd_number.number_to_canonical(
3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +
3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)

Line 3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +
3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)

Line 3395: ,p_tab_rec_data => pay_us_payslip_simulation_main.lrr_act_tab

3391: ,p_action_context_type => 'AAP'
3392: ,p_assignment_id => p_assignment_id
3393: ,p_tax_unit_id => p_tax_unit_id
3394: ,p_effective_date => p_effective_date
3395: ,p_tab_rec_data => pay_us_payslip_simulation_main.lrr_act_tab
3396: );
3397:
3398: pay_simulator_pkg.insert_simulation_rows(p_action_context_id => p_source_action_id
3399: ,p_action_context_type => 'AAP'

Line 3983: OPEN pay_us_payslip_simulation_main.c_bgid(g_action_ctx_id);

3979: lt_per_bgId_value := 0;
3980:
3981: /* Fetch Businesss Grp Id */
3982:
3983: OPEN pay_us_payslip_simulation_main.c_bgid(g_action_ctx_id);
3984: FETCH pay_us_payslip_simulation_main.c_bgid INTO lt_per_bgId_value;
3985: CLOSE pay_us_payslip_simulation_main.c_bgid;
3986:
3987: IF p_generate_header_flag = 'Y' THEN

Line 3984: FETCH pay_us_payslip_simulation_main.c_bgid INTO lt_per_bgId_value;

3980:
3981: /* Fetch Businesss Grp Id */
3982:
3983: OPEN pay_us_payslip_simulation_main.c_bgid(g_action_ctx_id);
3984: FETCH pay_us_payslip_simulation_main.c_bgid INTO lt_per_bgId_value;
3985: CLOSE pay_us_payslip_simulation_main.c_bgid;
3986:
3987: IF p_generate_header_flag = 'Y' THEN
3988: build_sql(sqlstr,

Line 3985: CLOSE pay_us_payslip_simulation_main.c_bgid;

3981: /* Fetch Businesss Grp Id */
3982:
3983: OPEN pay_us_payslip_simulation_main.c_bgid(g_action_ctx_id);
3984: FETCH pay_us_payslip_simulation_main.c_bgid INTO lt_per_bgId_value;
3985: CLOSE pay_us_payslip_simulation_main.c_bgid;
3986:
3987: IF p_generate_header_flag = 'Y' THEN
3988: build_sql(sqlstr,
3989: l_cntr_sql,

Line 4002: OPEN pay_us_payslip_simulation_main.get_leg_code(p_action_context_id);

3998: p_root_tag||''', NULL);');
3999: END IF;
4000:
4001: /* Fetch legislation_code. */
4002: OPEN pay_us_payslip_simulation_main.get_leg_code(p_action_context_id);
4003: FETCH pay_us_payslip_simulation_main.get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
4004: CLOSE pay_us_payslip_simulation_main.get_leg_code;
4005:
4006: /* Checking for International Payroll Legislation,

Line 4003: FETCH pay_us_payslip_simulation_main.get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

3999: END IF;
4000:
4001: /* Fetch legislation_code. */
4002: OPEN pay_us_payslip_simulation_main.get_leg_code(p_action_context_id);
4003: FETCH pay_us_payslip_simulation_main.get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
4004: CLOSE pay_us_payslip_simulation_main.get_leg_code;
4005:
4006: /* Checking for International Payroll Legislation,
4007: The flag g_install_leg_check returns 'N' for International Payroll localization and 'Y' for supported legislations.

Line 4004: CLOSE pay_us_payslip_simulation_main.get_leg_code;

4000:
4001: /* Fetch legislation_code. */
4002: OPEN pay_us_payslip_simulation_main.get_leg_code(p_action_context_id);
4003: FETCH pay_us_payslip_simulation_main.get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
4004: CLOSE pay_us_payslip_simulation_main.get_leg_code;
4005:
4006: /* Checking for International Payroll Legislation,
4007: The flag g_install_leg_check returns 'N' for International Payroll localization and 'Y' for supported legislations.
4008: */

Line 4012: FOR csr_get_archived_regions_rec IN pay_us_payslip_simulation_main.csr_get_archived_regions(p_action_context_id,

4008: */
4009:
4010: g_install_leg_check := pay_ip_utility.get_ip_installation(pay_payroll_xml_extract_pkg.g_leg_code);
4011:
4012: FOR csr_get_archived_regions_rec IN pay_us_payslip_simulation_main.csr_get_archived_regions(p_action_context_id,
4013: p_action_information_id)
4014: LOOP
4015:
4016: IF csr_get_archived_regions_rec.action_information_category IN

Line 4021: 'FOR csr_get_sim_arch_info_rec IN pay_us_payslip_simulation_main.csr_get_sim_archived_info (:l_action_context_id,'''||

4017: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||
4018: ' EMPLOYER DETAILS') THEN
4019: build_sql(sqlstr,
4020: l_cntr_sql,
4021: 'FOR csr_get_sim_arch_info_rec IN pay_us_payslip_simulation_main.csr_get_sim_archived_info (:l_action_context_id,'''||
4022: csr_get_archived_regions_rec.action_information_category
4023: ||''', l_org_id, :l_action_information_id) LOOP ');
4024: ELSE
4025: build_sql(sqlstr,

Line 4027: 'FOR csr_get_sim_arch_info_rec IN pay_us_payslip_simulation_main.csr_get_sim_archived_info (:l_action_context_id,'''||

4023: ||''', l_org_id, :l_action_information_id) LOOP ');
4024: ELSE
4025: build_sql(sqlstr,
4026: l_cntr_sql,
4027: 'FOR csr_get_sim_arch_info_rec IN pay_us_payslip_simulation_main.csr_get_sim_archived_info (:l_action_context_id,'''||
4028: csr_get_archived_regions_rec.action_information_category
4029: ||''', NULL, :l_action_information_id) LOOP ');
4030: END IF;
4031: build_sql(sqlstr,

Line 4915: END pay_us_payslip_simulation_main;

4911: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
4912:
4913: END pre_processing;
4914:
4915: END pay_us_payslip_simulation_main;