DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on HR_UTILITY

Line 85: hr_utility.set_location('pay_continuous_calc.event_update', 10);

81: else
82: l_event_type := pay_dyn_triggers.g_dyt_mode;
83: end if;
84: --
85: hr_utility.set_location('pay_continuous_calc.event_update', 10);
86: /* Search the cache does this event exist in the cache */
87: processed := false;
88: for cnt in 1..g_event_cache.sz loop
89: if ( g_event_cache.business_group_id(cnt) = p_business_group_id

Line 100: hr_utility.trace('+Discovered our event in cache.');

96: processed := true;
97: /* Ok we got the cached value */
98: if (g_event_cache.event_check(cnt) = true) then
99: --
100: hr_utility.trace('+Discovered our event in cache.');
101: hr_utility.trace('+Event: '||l_event_type||' on '||p_table_name||'.'||p_column_name);
102: --
103: /* If its an update then check the values otherwise just add it to the list */
104: if ( g_event_cache.event_type(cnt) = 'U'

Line 101: hr_utility.trace('+Event: '||l_event_type||' on '||p_table_name||'.'||p_column_name);

97: /* Ok we got the cached value */
98: if (g_event_cache.event_check(cnt) = true) then
99: --
100: hr_utility.trace('+Discovered our event in cache.');
101: hr_utility.trace('+Event: '||l_event_type||' on '||p_table_name||'.'||p_column_name);
102: --
103: /* If its an update then check the values otherwise just add it to the list */
104: if ( g_event_cache.event_type(cnt) = 'U'
105: or g_event_cache.event_type(cnt) = 'CORRECTION'

Line 109: hr_utility.trace('Comparing...'||p_old_value||' with '||p_new_value);

105: or g_event_cache.event_type(cnt) = 'CORRECTION'
106: or g_event_cache.event_type(cnt) = 'UPDATE'
107: or g_event_cache.event_type(cnt) = 'UPDATE_OVERRIDE'
108: or g_event_cache.event_type(cnt) = 'UPDATE_CHANGE_INSERT') then
109: hr_utility.trace('Comparing...'||p_old_value||' with '||p_new_value);
110: if (nvl(p_old_value, 'peu') <> nvl(p_new_value, 'peu')) then
111: /* OK record the event in the event list */
112: hr_utility.trace('>Event passes test => add to list for recording in to ppe.');
113: g_event_list.sz := g_event_list.sz + 1;

Line 112: hr_utility.trace('>Event passes test => add to list for recording in to ppe.');

108: or g_event_cache.event_type(cnt) = 'UPDATE_CHANGE_INSERT') then
109: hr_utility.trace('Comparing...'||p_old_value||' with '||p_new_value);
110: if (nvl(p_old_value, 'peu') <> nvl(p_new_value, 'peu')) then
111: /* OK record the event in the event list */
112: hr_utility.trace('>Event passes test => add to list for recording in to ppe.');
113: g_event_list.sz := g_event_list.sz + 1;
114: g_event_list.change_type(g_event_list.sz) :=
115: g_event_cache.change_type(cnt);
116: g_event_list.effective_date(g_event_list.sz) := p_effective_date;

Line 125: hr_utility.trace('>Event auto passes => add to list for recording in to ppe.');

121: := nvl(p_old_value, '')
122: ||' -> '|| nvl(p_new_value, '');
123: end if;
124: else
125: hr_utility.trace('>Event auto passes => add to list for recording in to ppe.');
126: g_event_list.sz := g_event_list.sz + 1;
127: g_event_list.change_type(g_event_list.sz) :=
128: g_event_cache.change_type(cnt);
129: g_event_list.effective_date(g_event_list.sz) := p_effective_date;

Line 140: hr_utility.set_location('pay_continuous_calc.event_update', 30);

136: --
137: end if;
138: end loop;
139: --
140: hr_utility.set_location('pay_continuous_calc.event_update', 30);
141: /* The event doesn't exist in the cache, go get it */
142: if (processed = false) then
143: declare
144: found boolean;

Line 147: hr_utility.set_location('pay_continuous_calc.event_update', 40);

143: declare
144: found boolean;
145: begin
146: --
147: hr_utility.set_location('pay_continuous_calc.event_update', 40);
148: found := false;
149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);
150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);
151: --hr_utility.trace('> p_table_name: '||p_table_name);

Line 149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);

145: begin
146: --
147: hr_utility.set_location('pay_continuous_calc.event_update', 40);
148: found := false;
149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);
150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);
151: --hr_utility.trace('> p_table_name: '||p_table_name);
152: --hr_utility.trace('> p_column_name: '||p_column_name);
153: --hr_utility.trace('> l_event_type: '||l_event_type);

Line 150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);

146: --
147: hr_utility.set_location('pay_continuous_calc.event_update', 40);
148: found := false;
149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);
150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);
151: --hr_utility.trace('> p_table_name: '||p_table_name);
152: --hr_utility.trace('> p_column_name: '||p_column_name);
153: --hr_utility.trace('> l_event_type: '||l_event_type);
154:

Line 151: --hr_utility.trace('> p_table_name: '||p_table_name);

147: hr_utility.set_location('pay_continuous_calc.event_update', 40);
148: found := false;
149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);
150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);
151: --hr_utility.trace('> p_table_name: '||p_table_name);
152: --hr_utility.trace('> p_column_name: '||p_column_name);
153: --hr_utility.trace('> l_event_type: '||l_event_type);
154:
155: for evnt in get_events (p_business_group_id, p_legislation_code,

Line 152: --hr_utility.trace('> p_column_name: '||p_column_name);

148: found := false;
149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);
150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);
151: --hr_utility.trace('> p_table_name: '||p_table_name);
152: --hr_utility.trace('> p_column_name: '||p_column_name);
153: --hr_utility.trace('> l_event_type: '||l_event_type);
154:
155: for evnt in get_events (p_business_group_id, p_legislation_code,
156: p_table_name, p_column_name, l_event_type) loop

Line 153: --hr_utility.trace('> l_event_type: '||l_event_type);

149: --hr_utility.trace('> p_business_group_id: '||p_business_group_id);
150: --hr_utility.trace('> p_legislation_code: '||p_legislation_code);
151: --hr_utility.trace('> p_table_name: '||p_table_name);
152: --hr_utility.trace('> p_column_name: '||p_column_name);
153: --hr_utility.trace('> l_event_type: '||l_event_type);
154:
155: for evnt in get_events (p_business_group_id, p_legislation_code,
156: p_table_name, p_column_name, l_event_type) loop
157: --

Line 159: hr_utility.trace('+Our event is not in cache, go get it...');

155: for evnt in get_events (p_business_group_id, p_legislation_code,
156: p_table_name, p_column_name, l_event_type) loop
157: --
158: --
159: hr_utility.trace('+Our event is not in cache, go get it...');
160: hr_utility.trace('+Event: '||l_event_type||' on '||p_table_name||'.'||p_column_name);
161: --
162: found := true;
163: g_event_cache.sz := g_event_cache.sz + 1;

Line 160: hr_utility.trace('+Event: '||l_event_type||' on '||p_table_name||'.'||p_column_name);

156: p_table_name, p_column_name, l_event_type) loop
157: --
158: --
159: hr_utility.trace('+Our event is not in cache, go get it...');
160: hr_utility.trace('+Event: '||l_event_type||' on '||p_table_name||'.'||p_column_name);
161: --
162: found := true;
163: g_event_cache.sz := g_event_cache.sz + 1;
164: g_event_cache.business_group_id(g_event_cache.sz) := p_business_group_id;

Line 180: hr_utility.trace('Comparing...'||p_old_value||' with '||p_new_value);

176: or g_event_cache.event_type(g_event_cache.sz) = 'CORRECTION'
177: or g_event_cache.event_type(g_event_cache.sz) = 'UPDATE'
178: or g_event_cache.event_type(g_event_cache.sz) = 'UPDATE_OVERRIDE'
179: or g_event_cache.event_type(g_event_cache.sz) = 'UPDATE_CHANGE_INSERT') then
180: hr_utility.trace('Comparing...'||p_old_value||' with '||p_new_value);
181: --
182: if (nvl(p_old_value, 'peu') <> nvl(p_new_value, 'peu')) then
183: /* OK record the event in the event list */
184: hr_utility.trace('>Event passes test => add to list for recording in to ppe.');

Line 184: hr_utility.trace('>Event passes test => add to list for recording in to ppe.');

180: hr_utility.trace('Comparing...'||p_old_value||' with '||p_new_value);
181: --
182: if (nvl(p_old_value, 'peu') <> nvl(p_new_value, 'peu')) then
183: /* OK record the event in the event list */
184: hr_utility.trace('>Event passes test => add to list for recording in to ppe.');
185: g_event_list.sz := g_event_list.sz + 1;
186: g_event_list.change_type(g_event_list.sz) :=
187: g_event_cache.change_type(g_event_cache.sz);
188: g_event_list.effective_date(g_event_list.sz) := p_effective_date;

Line 195: hr_utility.trace('5...');

191: g_event_cache.event_update_id(g_event_cache.sz);
192: g_event_list.description(g_event_list.sz)
193: := nvl(p_old_value, '')
194: ||' -> '|| nvl(p_new_value, '');
195: hr_utility.trace('5...');
196: end if;
197: else
198: hr_utility.trace('>Event auto passes => add to list for recording in to ppe.');
199: g_event_list.sz := g_event_list.sz + 1;

Line 198: hr_utility.trace('>Event auto passes => add to list for recording in to ppe.');

194: ||' -> '|| nvl(p_new_value, '');
195: hr_utility.trace('5...');
196: end if;
197: else
198: hr_utility.trace('>Event auto passes => add to list for recording in to ppe.');
199: g_event_list.sz := g_event_list.sz + 1;
200: g_event_list.change_type(g_event_list.sz) :=
201: g_event_cache.change_type(g_event_cache.sz);
202: g_event_list.effective_date(g_event_list.sz) := p_effective_date;

Line 214: hr_utility.trace('Not valid event, add to a cache of non-recorded events');

210: --
211: /* No this isn't a valid event hence don't call the API */
212: if (found = false) then
213: --
214: hr_utility.trace('Not valid event, add to a cache of non-recorded events');
215: --
216:
217: g_event_cache.sz := g_event_cache.sz + 1;
218: g_event_cache.business_group_id(g_event_cache.sz) := p_business_group_id;

Line 230: hr_utility.set_location('pay_continuous_calc.event_update', 900);

226: end if;
227: --
228: end;
229: end if;
230: hr_utility.set_location('pay_continuous_calc.event_update', 900);
231: --
232: end event_update;
233:
234: ---------------------------------------------------------------------------------------

Line 384: hr_utility.set_location(l_proc, 10);

380: --
381: l_proc varchar2(240) := g_package||'.pay_element_entries_f_aru';
382: BEGIN
383: --
384: hr_utility.set_location(l_proc, 10);
385: /* If the continuous calc is overriden then do nothing */
386: if (g_override_cc = TRUE) then
387: return;
388: end if;

Line 907: hr_utility.set_location(l_proc, 900);

903: end loop;
904: end if;
905: pay_continuous_calc.g_event_list.sz := 0;
906: end;
907: hr_utility.set_location(l_proc, 900);
908: --
909: end PAY_ELEMENT_ENTRIES_F_aru;
910: --
911:

Line 932: hr_utility.set_location(l_proc, 10);

928: l_object_version_number number;
929: l_proc varchar2(240) := g_package||'.element_entries_ari';
930: begin
931: --
932: hr_utility.set_location(l_proc, 10);
933: /* If the continuous calc is overriden then do nothing */
934: if (g_override_cc = TRUE) then
935: return;
936: end if;

Line 974: hr_utility.set_location(l_proc, 900);

970: end loop;
971: end if;
972: pay_continuous_calc.g_event_list.sz := 0;
973: end;
974: hr_utility.set_location(l_proc, 900);
975: end element_entries_ari;
976: --
977:
978: /* name : element_entries_ard

Line 1004: hr_utility.set_location(l_proc, 10);

1000: l_new_value date;
1001: l_noted_value pay_process_events.noted_value%type;
1002: l_proc varchar2(240) := g_package||'.element_entries_ard';
1003: begin
1004: hr_utility.set_location(l_proc, 10);
1005: /* If the continuous calc is overriden then do nothing */
1006: if (g_override_cc = TRUE) then
1007: return;
1008: end if;

Line 1082: hr_utility.set_location(l_proc, 900);

1078: end loop;
1079: end if;
1080: pay_continuous_calc.g_event_list.sz := 0;
1081: end;
1082: hr_utility.set_location(l_proc, 900);
1083: end element_entries_ard;
1084:
1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F

Line 1113: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);

1109: and p_effective_date between ee.effective_start_date
1110: and ee.effective_end_date;
1111: --
1112: begin
1113: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);
1114: /* If the continuous calc is overriden then do nothing */
1115: if (g_override_cc = TRUE) then
1116: return;
1117: end if;

Line 1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);

1152: end loop;
1153: end if;
1154: pay_continuous_calc.g_event_list.sz := 0;
1155: end;
1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1157: --
1158: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1159: --
1160:

Line 2141: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 10);

2137: )
2138: is
2139: --
2140: begin
2141: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 10);
2142: /* If the continuous calc is overriden then do nothing */
2143: if (g_override_cc = TRUE) then
2144: return;
2145: end if;

Line 2920: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);

2916: end loop;
2917: end if;
2918: pay_continuous_calc.g_event_list.sz := 0;
2919: end;
2920: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);
2921: --
2922: end PER_ALL_ASSIGNMENTS_F_aru;
2923: --
2924: /* PER_ALL_ASSIGNMENTS_F_ari */

Line 2940: hr_utility.set_location(l_proc, 10);

2936: l_process_event_id number;
2937: l_object_version_number number;
2938: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ari';
2939: begin
2940: hr_utility.set_location(l_proc, 10);
2941: /* If the continuous calc is overriden then do nothing */
2942: if (g_override_cc = TRUE) then
2943: return;
2944: end if;

Line 2981: hr_utility.set_location(l_proc, 900);

2977: end loop;
2978: end if;
2979: pay_continuous_calc.g_event_list.sz := 0;
2980: end;
2981: hr_utility.set_location(l_proc, 900);
2982: end per_all_assignments_f_ari;
2983: --
2984: /* name : per_all_assignments_f_ard
2985: purpose : This is procedure that records any deletes

Line 2999: hr_utility.set_location(l_proc, 10);

2995: l_process_event_id number;
2996: l_object_version_number number;
2997: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ard';
2998: begin
2999: hr_utility.set_location(l_proc, 10);
3000: /* If the continuous calc is overriden then do nothing */
3001: if (g_override_cc = TRUE) then
3002: return;
3003: end if;

Line 3040: hr_utility.set_location(l_proc, 900);

3036: end loop;
3037: end if;
3038: pay_continuous_calc.g_event_list.sz := 0;
3039: end;
3040: hr_utility.set_location(l_proc, 900);
3041: END per_all_assignments_f_ard;
3042:
3043:
3044: /* PAY_PERSONAL_PAYMENT_METHODS_F */

Line 3061: hr_utility.set_location(l_proc, 10);

3057: l_process_event_id number;
3058: l_object_version_number number;
3059: l_proc varchar2(240) := g_package||'.personal_payment_methods_ari';
3060: begin
3061: hr_utility.set_location(l_proc, 10);
3062: /* If the continuous calc is overriden then do nothing */
3063: if (g_override_cc = TRUE) then
3064: return;
3065: end if;

Line 3102: hr_utility.set_location(l_proc, 900);

3098: end loop;
3099: end if;
3100: pay_continuous_calc.g_event_list.sz := 0;
3101: end;
3102: hr_utility.set_location(l_proc, 900);
3103: end personal_payment_methods_ari;
3104: --
3105: /* name : personal_payment_methods_ard
3106: purpose : This is procedure that records any deletes

Line 3121: hr_utility.set_location(l_proc, 10);

3117: l_process_event_id number;
3118: l_object_version_number number;
3119: l_proc varchar2(240) := g_package||'.personal_payment_methods_ard';
3120: begin
3121: hr_utility.set_location(l_proc, 10);
3122: /* If the continuous calc is overriden then do nothing */
3123: if (g_override_cc = TRUE) then
3124: return;
3125: end if;

Line 3162: hr_utility.set_location(l_proc, 900);

3158: end loop;
3159: end if;
3160: pay_continuous_calc.g_event_list.sz := 0;
3161: end;
3162: hr_utility.set_location(l_proc, 900);
3163: END personal_payment_methods_ard;
3164: --
3165: /* name : PERSONAL_PAYMENT_METHODS_F_aru
3166: purpose : This is procedure that records any updates

Line 3244: hr_utility.set_location('pay_continuous_calc.PERSONAL_PAYMENT_METHODS_F_aru', 10);

3240: is
3241: --
3242: begin
3243: --
3244: hr_utility.set_location('pay_continuous_calc.PERSONAL_PAYMENT_METHODS_F_aru', 10);
3245: /* If the continuous calc is overriden then do nothing */
3246: if (g_override_cc = TRUE) then
3247: return;
3248: end if;

Line 3551: hr_utility.set_location('pay_continuous_calc.PERSONAL_PAYMENT_METHODS_F_aru', 50);

3547: end loop;
3548: end if;
3549: pay_continuous_calc.g_event_list.sz := 0;
3550: end;
3551: hr_utility.set_location('pay_continuous_calc.PERSONAL_PAYMENT_METHODS_F_aru', 50);
3552: --
3553: end PERSONAL_PAYMENT_METHODS_F_aru;
3554: --
3555: /* PAY_LINK_INPUT_VALUES */

Line 3805: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_LINKS_F_aru', 10);

3801: )
3802: is
3803: --
3804: begin
3805: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_LINKS_F_aru', 10);
3806: /* If the continuous calc is overriden then do nothing */
3807: if (g_override_cc = TRUE) then
3808: return;
3809: end if;

Line 4068: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_LINKS_F_aru', 50);

4064: end loop;
4065: end if;
4066: pay_continuous_calc.g_event_list.sz := 0;
4067: end;
4068: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_LINKS_F_aru', 50);
4069: --
4070: end PAY_ELEMENT_LINKS_F_aru;
4071: --
4072: /* PAY_INPUT_VALUES */

Line 4454: hr_utility.set_location('pay_continuous_calc.PAY_ALL_PAYROLLS_F_aru', 10);

4450: where asg.payroll_id = p_payroll_id
4451: and p_effective_date < asg.effective_end_date;
4452: --
4453: begin
4454: hr_utility.set_location('pay_continuous_calc.PAY_ALL_PAYROLLS_F_aru', 10);
4455: /* If the continuous calc is overriden then do nothing */
4456: if (g_override_cc = TRUE) then
4457: return;
4458: end if;

Line 4965: hr_utility.set_location('pay_continuous_calc.PAY_ALL_PAYROLLS_F_aru', 50);

4961: end loop;
4962: end if;
4963: pay_continuous_calc.g_event_list.sz := 0;
4964: end;
4965: hr_utility.set_location('pay_continuous_calc.PAY_ALL_PAYROLLS_F_aru', 50);
4966: --
4967: end PAY_ALL_PAYROLLS_F_aru;
4968: --
4969: /* Used generator to build this procedure, but removed some of that table values.

Line 5088: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 10);

5084: )
5085: is
5086: --
5087: begin
5088: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 10);
5089: /* If the continuous calc is overriden then do nothing */
5090: if (g_override_cc = TRUE) then
5091: return;
5092: end if;

Line 5543: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);

5539: end loop;
5540: end if;
5541: pay_continuous_calc.g_event_list.sz := 0;
5542: end;
5543: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);
5544: --
5545: end PAY_ELEMENT_TYPES_F_aru;
5546: --
5547: /* PAY_GRADE_RULES_F */

Line 5803: hr_utility.set_location(l_proc, 10);

5799: --
5800: l_process_event_id number;
5801: l_proc varchar2(240) := g_package||'.per_addresses_ari';
5802: begin
5803: hr_utility.set_location(l_proc, 10);
5804: /* If the continuous calc is overriden then do nothing */
5805: if (g_override_cc = TRUE) then
5806: return;
5807: end if;

Line 5846: hr_utility.set_location(l_proc, 900);

5842: end loop;
5843: end if;
5844: pay_continuous_calc.g_event_list.sz := 0;
5845: end;
5846: hr_utility.set_location(l_proc, 900);
5847:
5848: end PER_ADDRESSES_ari;
5849:
5850: --

Line 6518: hr_utility.set_location(l_proc, 10);

6514: from per_assignments_f
6515: where person_id = p_person_id;
6516: --
6517: begin
6518: hr_utility.set_location(l_proc, 10);
6519: /* If the continuous calc is overriden then do nothing */
6520: if (g_override_cc = TRUE) then
6521: return;
6522: end if;

Line 6542: hr_utility.trace('> With in Create Process Event: ');

6538: l_process_event_id number;
6539: l_object_version_number number;
6540: begin
6541: if (pay_continuous_calc.g_event_list.sz <> 0) then
6542: hr_utility.trace('> With in Create Process Event: ');
6543: for asgrec in asgcur (p_old_PERSON_ID) loop
6544: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6545: pay_ppe_api.create_process_event(
6546: p_assignment_id => asgrec.assignment_id,

Line 6565: hr_utility.set_location(l_proc, 900);

6561: end loop;
6562: end if;
6563: pay_continuous_calc.g_event_list.sz := 0;
6564: end;
6565: hr_utility.set_location(l_proc, 900);
6566: END PER_ALL_PEOPLE_F_ard;
6567:
6568: /* PER_SPINAL_POINT_PLACEMENTS_F */
6569: /* name : PER_SPINAL_POINT_PLCMTS_F_ard

Line 6588: hr_utility.set_location(l_proc, 10);

6584: l_process_event_id number;
6585: l_object_version_number number;
6586: l_proc varchar2(240) := g_package||'.PER_SPIN_PNT_PLACEMENTS_F_ard';
6587: begin
6588: hr_utility.set_location(l_proc, 10);
6589: /* If the continuous calc is overriden then do nothing */
6590: if (g_override_cc = TRUE) then
6591: return;
6592: end if;

Line 6614: hr_utility.trace('> With in Create Process Event: ');

6610: l_process_event_id number;
6611: l_object_version_number number;
6612: begin
6613: if (pay_continuous_calc.g_event_list.sz <> 0) then
6614: hr_utility.trace('> With in Create Process Event: ');
6615: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6616: pay_ppe_api.create_process_event(
6617: p_assignment_id => p_old_assignment_id,
6618: p_effective_date => g_event_list.effective_date(cnt),

Line 6635: hr_utility.set_location(l_proc, 900);

6631: end loop;
6632: end if;
6633: pay_continuous_calc.g_event_list.sz := 0;
6634: end;
6635: hr_utility.set_location(l_proc, 900);
6636: END PER_SPIN_PNT_PLACEMENTS_F_ard;
6637:
6638:
6639: /* name : PER_SPINAL_POINT_PLCMTS_F_ari -- Added for bug 6265962

Line 6655: hr_utility.set_location(l_proc, 10);

6651: l_process_event_id number;
6652: l_object_version_number number;
6653: l_proc varchar2(240) := g_package||'.PER_SPIN_PNT_PLACEMENTS_F_ari';
6654: begin
6655: hr_utility.set_location(l_proc, 10);
6656: /* If the continuous calc is overriden then do nothing */
6657: if (g_override_cc = TRUE) then
6658: return;
6659: end if;

Line 6680: hr_utility.trace('> With in Create Process Event: ');

6676: l_process_event_id number;
6677: l_object_version_number number;
6678: begin
6679: if (pay_continuous_calc.g_event_list.sz <> 0) then
6680: hr_utility.trace('> With in Create Process Event: ');
6681: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6682: pay_ppe_api.create_process_event(
6683: p_assignment_id => p_assignment_id,
6684: p_effective_date => g_event_list.effective_date(cnt),

Line 6701: hr_utility.set_location(l_proc, 900);

6697: end loop;
6698: end if;
6699: pay_continuous_calc.g_event_list.sz := 0;
6700: end;
6701: hr_utility.set_location(l_proc, 900);
6702: END PER_SPIN_PNT_PLACEMENTS_F_ari;
6703: --
6704:
6705: /* PAY_GRADE_RULES_F */

Line 6725: hr_utility.set_location(l_proc, 10);

6721: l_process_event_id number;
6722: l_object_version_number number;
6723: l_proc varchar2(240) := g_package||'.PAY_GRADE_RULES_F_ard';
6724: begin
6725: hr_utility.set_location(l_proc, 10);
6726: /* If the continuous calc is overriden then do nothing */
6727: if (g_override_cc = TRUE) then
6728: return;
6729: end if;

Line 6749: hr_utility.trace('> With in Create Process Event: ');

6745: l_process_event_id number;
6746: l_object_version_number number;
6747: begin
6748: if (pay_continuous_calc.g_event_list.sz <> 0) then
6749: hr_utility.trace('> With in Create Process Event: ');
6750: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6751: pay_ppe_api.create_process_event(
6752: p_assignment_id => NULL,
6753: p_effective_date => g_event_list.effective_date(cnt),

Line 6770: hr_utility.set_location(l_proc, 900);

6766: end loop;
6767: end if;
6768: pay_continuous_calc.g_event_list.sz := 0;
6769: end;
6770: hr_utility.set_location(l_proc, 900);
6771: END PAY_GRADE_RULES_F_ard;
6772:
6773: --
6774: /* PER_ALL_PEOPLE_F */

Line 8832: hr_utility.set_location(l_proc, 10);

8828: l_process_event_id number;
8829: l_object_version_number number;
8830: l_proc varchar2(240) := g_package||'.per_assign_budget_values_ard';
8831: begin
8832: hr_utility.set_location(l_proc, 10);
8833: /* If the continuous calc is overriden then do nothing */
8834: if (g_override_cc = TRUE) then
8835: return;
8836: end if;

Line 8873: hr_utility.set_location(l_proc, 900);

8869: end loop;
8870: end if;
8871: pay_continuous_calc.g_event_list.sz := 0;
8872: end;
8873: hr_utility.set_location(l_proc, 900);
8874: END per_assign_budget_values_ard;
8875:
8876: --
8877:

Line 9047: hr_utility.set_location(l_proc,10);

9043: where person_id = p_person_id;
9044: l_proc varchar2(240) := g_package||'.per_periods_of_service_aru';
9045:
9046: begin
9047: hr_utility.set_location(l_proc,10);
9048:
9049: /* If the continuous calc is overriden then do nothing */
9050: if (pay_continuous_calc.g_override_cc = TRUE) then
9051: return;

Line 9700: hr_utility.set_location(l_proc,50);

9696: );
9697:
9698: --end if;
9699: --
9700: hr_utility.set_location(l_proc,50);
9701: /* Now call the API for the affected assignments */
9702: declare
9703: l_process_event_id number;
9704: l_object_version_number number;

Line 9729: hr_utility.set_location(l_proc,900);

9725: end if;
9726: pay_continuous_calc.g_event_list.sz := 0;
9727: end;
9728: --
9729: hr_utility.set_location(l_proc,900);
9730: end PER_PERIODS_OF_SERVICE_aru;
9731:
9732: --------------------------------------------
9733: -- PER_PAY_PROPOSALS_aru

Line 9829: hr_utility.set_location(l_proc,10);

9825: is
9826: --
9827: l_proc varchar2(240) := g_package||'.per_pay_proposals_aru';
9828: begin
9829: hr_utility.set_location(l_proc,10);
9830: /* If the continuous calc is overriden then do nothing */
9831: if (pay_continuous_calc.g_override_cc = TRUE) then
9832: return;
9833: end if;

Line 10185: hr_utility.set_location(l_proc,50);

10181:
10182: -- CORRECTION ONLY end if;
10183: --
10184: /* Now call the API for the affected assignments */
10185: hr_utility.set_location(l_proc,50);
10186: declare
10187: l_process_event_id number;
10188: l_object_version_number number;
10189: cnt number;

Line 10211: hr_utility.set_location(l_proc,900);

10207: end if;
10208: pay_continuous_calc.g_event_list.sz := 0;
10209: end;
10210: --
10211: hr_utility.set_location(l_proc,900);
10212: end PER_PAY_PROPOSALS_aru;
10213:
10214: /* PER_PAY_PROPOSALS */
10215: /* name : PER_PAY_PROPOSALS_ari

Line 10231: hr_utility.set_location(l_proc, 10);

10227: l_process_event_id number;
10228: l_object_version_number number;
10229: l_proc varchar2(240) := g_package||'.per_pay_proposals_ari';
10230: begin
10231: hr_utility.set_location(l_proc, 10);
10232: /* If the continuous calc is overriden then do nothing */
10233: if (g_override_cc = TRUE) then
10234: return;
10235: end if;

Line 10274: hr_utility.set_location(l_proc, 900);

10270: end loop;
10271: end if;
10272: pay_continuous_calc.g_event_list.sz := 0;
10273: end;
10274: hr_utility.set_location(l_proc, 900);
10275: end per_pay_proposals_ari;
10276: --
10277: /* name : per_pay_proposals_ard
10278: purpose : This is procedure that records any deletes

Line 10293: hr_utility.set_location(l_proc, 10);

10289: l_process_event_id number;
10290: l_object_version_number number;
10291: l_proc varchar2(240) := g_package||'.per_pay_proposals_ard';
10292: begin
10293: hr_utility.set_location(l_proc, 10);
10294: /* If the continuous calc is overriden then do nothing */
10295: if (g_override_cc = TRUE) then
10296: return;
10297: end if;

Line 10336: hr_utility.set_location(l_proc, 900);

10332: end loop;
10333: end if;
10334: pay_continuous_calc.g_event_list.sz := 0;
10335: end;
10336: hr_utility.set_location(l_proc, 900);
10337: END per_pay_proposals_ard;
10338: --
10339: --------------------------------------------
10340: -- PER_PERFORMANCE_REVIEWS

Line 10439: hr_utility.set_location(l_proc,10);

10435: where person_id = p_person_id;
10436: l_proc varchar2(240) := g_package||'.per_performance_reviews_aru';
10437:
10438: begin
10439: hr_utility.set_location(l_proc,10);
10440:
10441: /* If the continuous calc is overriden then do nothing */
10442: if (pay_continuous_calc.g_override_cc = TRUE) then
10443: return;

Line 11009: hr_utility.set_location(l_proc, 10);

11005: l_process_event_id number;
11006: l_object_version_number number;
11007: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ari';
11008: begin
11009: hr_utility.set_location(l_proc, 10);
11010: /* If the continuous calc is overriden then do nothing */
11011: if (g_override_cc = TRUE) then
11012: return;
11013: end if;

Line 11050: hr_utility.set_location(l_proc, 900);

11046: end loop;
11047: end if;
11048: pay_continuous_calc.g_event_list.sz := 0;
11049: end;
11050: hr_utility.set_location(l_proc, 900);
11051: end PAY_COST_ALLOCATIONS_F_ari;
11052: --
11053: /* name : PAY_COST_ALLOCATIONS_F_ard
11054: purpose : This is procedure that records any deletes

Line 11077: hr_utility.set_location(l_proc, 10);

11073: l_old_value date;
11074: l_new_value date;
11075: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ard';
11076: begin
11077: hr_utility.set_location(l_proc, 10);
11078: /* If the continuous calc is overriden then do nothing */
11079: if (g_override_cc = TRUE) then
11080: return;
11081: end if;

Line 11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);

11079: if (g_override_cc = TRUE) then
11080: return;
11081: end if;
11082: --
11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

Line 11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);

11080: return;
11081: end if;
11082: --
11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

Line 11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);

11081: end if;
11082: --
11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:

Line 11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);

11082: --
11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --

Line 11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

11083: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

Line 11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

11084: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11085: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11086: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11087: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11088: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11089:
11090: --
11091: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11092: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

Line 11125: -- hr_utility.trace('> l_mode: '||l_mode);

11121: end if;
11122: end if;
11123: --
11124:
11125: -- hr_utility.trace('> l_mode: '||l_mode);
11126:
11127: pay_continuous_calc.event_update(p_business_group_id,
11128: p_legislation_code,
11129: 'PAY_COST_ALLOCATIONS_F',

Line 11147: hr_utility.trace('> With in Create Process Event: ');

11143: l_process_event_id number;
11144: l_object_version_number number;
11145: begin
11146: if (pay_continuous_calc.g_event_list.sz <> 0) then
11147: hr_utility.trace('> With in Create Process Event: ');
11148: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
11149: pay_ppe_api.create_process_event(
11150: p_assignment_id => p_assignment_id,
11151: p_effective_date => g_event_list.effective_date(cnt),

Line 11168: hr_utility.set_location(l_proc, 900);

11164: end loop;
11165: end if;
11166: pay_continuous_calc.g_event_list.sz := 0;
11167: end;
11168: hr_utility.set_location(l_proc, 900);
11169: END PAY_COST_ALLOCATIONS_F_ard;
11170: --
11171:
11172: -- >>>

Line 11458: hr_utility.set_location(l_proc, 10);

11454: l_process_event_id number;
11455: l_object_version_number number;
11456: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ari';
11457: begin
11458: hr_utility.set_location(l_proc, 10);
11459: /* If the continuous calc is overriden then do nothing */
11460: if (g_override_cc = TRUE) then
11461: return;
11462: end if;

Line 11499: hr_utility.set_location(l_proc, 900);

11495: end loop;
11496: end if;
11497: pay_continuous_calc.g_event_list.sz := 0;
11498: end;
11499: hr_utility.set_location(l_proc, 900);
11500: end PAY_USER_COL_INSTANCES_F_ari;
11501:
11502: --
11503: PROCEDURE PAY_USER_COL_INSTANCES_F_aru

Line 11659: hr_utility.set_location(l_proc, 10);

11655: l_old_value date;
11656: l_new_value date;
11657: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ard';
11658: begin
11659: hr_utility.set_location(l_proc, 10);
11660: /* If the continuous calc is overriden then do nothing */
11661: if (g_override_cc = TRUE) then
11662: return;
11663: end if;

Line 11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);

11661: if (g_override_cc = TRUE) then
11662: return;
11663: end if;
11664: --
11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

Line 11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);

11662: return;
11663: end if;
11664: --
11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

Line 11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);

11663: end if;
11664: --
11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:

Line 11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);

11664: --
11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --

Line 11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

11665: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

Line 11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

11666: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11667: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11668: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11669: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11670: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11671:
11672: --
11673: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11674: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

Line 11707: -- hr_utility.trace('> l_mode: '||l_mode);

11703: end if;
11704: end if;
11705: --
11706:
11707: -- hr_utility.trace('> l_mode: '||l_mode);
11708:
11709: pay_continuous_calc.event_update(p_business_group_id,
11710: p_legislation_code,
11711: 'PAY_USER_COLUMN_INSTANCES_F',

Line 11729: hr_utility.trace('> With in Create Process Event: ');

11725: l_process_event_id number;
11726: l_object_version_number number;
11727: begin
11728: if (pay_continuous_calc.g_event_list.sz <> 0) then
11729: hr_utility.trace('> With in Create Process Event: ');
11730: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
11731: pay_ppe_api.create_process_event(
11732: p_assignment_id => NULL,
11733: p_effective_date => g_event_list.effective_date(cnt),

Line 11750: hr_utility.set_location(l_proc, 900);

11746: end loop;
11747: end if;
11748: pay_continuous_calc.g_event_list.sz := 0;
11749: end;
11750: hr_utility.set_location(l_proc, 900);
11751: END PAY_USER_COL_INSTANCES_F_ard;
11752:
11753: --
11754: /* FF_GLOBALS_F */

Line 11770: hr_utility.set_location(l_proc, 10);

11766: l_process_event_id number;
11767: l_object_version_number number;
11768: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ari';
11769: begin
11770: hr_utility.set_location(l_proc, 10);
11771: /* If the continuous calc is overriden then do nothing */
11772: if (g_override_cc = TRUE) then
11773: return;
11774: end if;

Line 11811: hr_utility.set_location(l_proc, 900);

11807: end loop;
11808: end if;
11809: pay_continuous_calc.g_event_list.sz := 0;
11810: end;
11811: hr_utility.set_location(l_proc, 900);
11812: end FF_GLOBALS_F_ari;
11813:
11814: --
11815: PROCEDURE FF_GLOBALS_F_aru

Line 11961: hr_utility.set_location(l_proc, 10);

11957: l_old_value date;
11958: l_new_value date;
11959: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ard';
11960: begin
11961: hr_utility.set_location(l_proc, 10);
11962: /* If the continuous calc is overriden then do nothing */
11963: if (g_override_cc = TRUE) then
11964: return;
11965: end if;

Line 11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);

11963: if (g_override_cc = TRUE) then
11964: return;
11965: end if;
11966: --
11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

Line 11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);

11964: return;
11965: end if;
11966: --
11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

Line 11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);

11965: end if;
11966: --
11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:

Line 11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);

11966: --
11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --

Line 11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

11967: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

Line 11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

11968: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11969: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11970: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11971: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11972: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11973:
11974: --
11975: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11976: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

Line 12009: -- hr_utility.trace('> l_mode: '||l_mode);

12005: end if;
12006: end if;
12007: --
12008:
12009: -- hr_utility.trace('> l_mode: '||l_mode);
12010:
12011: pay_continuous_calc.event_update(p_business_group_id,
12012: p_legislation_code,
12013: 'FF_GLOBALS_F',

Line 12029: hr_utility.trace('> With in Create Process Event: ');

12025: l_process_event_id number;
12026: l_object_version_number number;
12027: begin
12028: if (pay_continuous_calc.g_event_list.sz <> 0) then
12029: hr_utility.trace('> With in Create Process Event: ');
12030: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
12031: pay_ppe_api.create_process_event(
12032: p_assignment_id => NULL,
12033: p_effective_date => g_event_list.effective_date(cnt),

Line 12050: hr_utility.set_location(l_proc, 900);

12046: end loop;
12047: end if;
12048: pay_continuous_calc.g_event_list.sz := 0;
12049: end;
12050: hr_utility.set_location(l_proc, 900);
12051: END FF_GLOBALS_F_ard;
12052:
12053: PROCEDURE PQH_RATE_MATRIX_RATES_F_ari( p_business_group_id IN NUMBER
12054: , p_legislation_code IN VARCHAR2

Line 12063: hr_utility.set_location(l_proc, 10);

12059: l_process_event_id number;
12060: l_object_version_number number;
12061: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ari';
12062: BEGIN
12063: hr_utility.set_location(l_proc, 10);
12064: /* If the continuous calc is overriden then do nothing */
12065: if (g_override_cc = TRUE) then
12066: return;
12067: end if;

Line 12104: hr_utility.set_location(l_proc, 900);

12100: end loop;
12101: end if;
12102: pay_continuous_calc.g_event_list.sz := 0;
12103: end;
12104: hr_utility.set_location(l_proc, 900);
12105:
12106: END PQH_RATE_MATRIX_RATES_F_ari;
12107:
12108:

Line 12255: hr_utility.set_location(l_proc, 10);

12251: l_old_value date;
12252: l_new_value date;
12253: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ard';
12254: BEGIN
12255: hr_utility.set_location(l_proc, 10);
12256: /* If the continuous calc is overriden then do nothing */
12257: if (g_override_cc = TRUE) then
12258: return;
12259: end if;

Line 12294: hr_utility.trace('> l_mode: '||l_mode);

12290: --
12291: end if;
12292: end if;
12293: --
12294: hr_utility.trace('> l_mode: '||l_mode);
12295:
12296: pay_continuous_calc.event_update(p_business_group_id,
12297: p_legislation_code,
12298: 'PQH_RATE_MATRIX_RATES_F',

Line 12314: hr_utility.trace('> With in Create Process Event: ');

12310: l_process_event_id number;
12311: l_object_version_number number;
12312: begin
12313: if (pay_continuous_calc.g_event_list.sz <> 0) then
12314: hr_utility.trace('> With in Create Process Event: ');
12315: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
12316: pay_ppe_api.create_process_event(
12317: p_assignment_id => NULL,
12318: p_effective_date => g_event_list.effective_date(cnt),

Line 12335: hr_utility.set_location(l_proc, 900);

12331: end loop;
12332: end if;
12333: pay_continuous_calc.g_event_list.sz := 0;
12334: end;
12335: hr_utility.set_location(l_proc, 900);
12336:
12337: END PQH_RATE_MATRIX_RATES_F_ard;
12338:
12339: begin