eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 909: hr_utility.set_location(l_proc, 900);

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

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

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

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

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

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

1021: and p_old_effective_end_date <= period.start_date;
1022:
1023:
1024: begin
1025: hr_utility.set_location(l_proc, 10);
1026: /* If the continuous calc is overriden then do nothing */
1027: if (g_override_cc = TRUE) then
1028: return;
1029: end if;

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

1110: end loop;
1111: end if;
1112: pay_continuous_calc.g_event_list.sz := 0;
1113: end;
1114: hr_utility.set_location(l_proc, 900);
1115: end element_entries_ard;
1116:
1117: --------------------------------------------
1118: -- PAY_ELEMENT_ENTRY_VALUES_F

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

1141: and p_effective_date between ee.effective_start_date
1142: and ee.effective_end_date;
1143: --
1144: begin
1145: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);
1146: /* If the continuous calc is overriden then do nothing */
1147: if (g_override_cc = TRUE) then
1148: return;
1149: end if;

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

1184: end loop;
1185: end if;
1186: pay_continuous_calc.g_event_list.sz := 0;
1187: end;
1188: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1189: --
1190: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1191: --
1192:

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

2169: )
2170: is
2171: --
2172: begin
2173: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 10);
2174: /* If the continuous calc is overriden then do nothing */
2175: if (g_override_cc = TRUE) then
2176: return;
2177: end if;

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

2948: end loop;
2949: end if;
2950: pay_continuous_calc.g_event_list.sz := 0;
2951: end;
2952: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);
2953: --
2954: end PER_ALL_ASSIGNMENTS_F_aru;
2955: --
2956: /* PER_ALL_ASSIGNMENTS_F_ari */

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

2968: l_process_event_id number;
2969: l_object_version_number number;
2970: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ari';
2971: begin
2972: hr_utility.set_location(l_proc, 10);
2973: /* If the continuous calc is overriden then do nothing */
2974: if (g_override_cc = TRUE) then
2975: return;
2976: end if;

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

3009: end loop;
3010: end if;
3011: pay_continuous_calc.g_event_list.sz := 0;
3012: end;
3013: hr_utility.set_location(l_proc, 900);
3014: end per_all_assignments_f_ari;
3015: --
3016: /* name : per_all_assignments_f_ard
3017: purpose : This is procedure that records any deletes

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

3027: l_process_event_id number;
3028: l_object_version_number number;
3029: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ard';
3030: begin
3031: hr_utility.set_location(l_proc, 10);
3032: /* If the continuous calc is overriden then do nothing */
3033: if (g_override_cc = TRUE) then
3034: return;
3035: end if;

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

3068: end loop;
3069: end if;
3070: pay_continuous_calc.g_event_list.sz := 0;
3071: end;
3072: hr_utility.set_location(l_proc, 900);
3073: END per_all_assignments_f_ard;
3074:
3075:
3076: /* PAY_PERSONAL_PAYMENT_METHODS_F */

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

3089: l_process_event_id number;
3090: l_object_version_number number;
3091: l_proc varchar2(240) := g_package||'.personal_payment_methods_ari';
3092: begin
3093: hr_utility.set_location(l_proc, 10);
3094: /* If the continuous calc is overriden then do nothing */
3095: if (g_override_cc = TRUE) then
3096: return;
3097: end if;

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

3130: end loop;
3131: end if;
3132: pay_continuous_calc.g_event_list.sz := 0;
3133: end;
3134: hr_utility.set_location(l_proc, 900);
3135: end personal_payment_methods_ari;
3136: --
3137: /* name : personal_payment_methods_ard
3138: purpose : This is procedure that records any deletes

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

3149: l_process_event_id number;
3150: l_object_version_number number;
3151: l_proc varchar2(240) := g_package||'.personal_payment_methods_ard';
3152: begin
3153: hr_utility.set_location(l_proc, 10);
3154: /* If the continuous calc is overriden then do nothing */
3155: if (g_override_cc = TRUE) then
3156: return;
3157: end if;

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

3190: end loop;
3191: end if;
3192: pay_continuous_calc.g_event_list.sz := 0;
3193: end;
3194: hr_utility.set_location(l_proc, 900);
3195: END personal_payment_methods_ard;
3196: --
3197: /* name : PERSONAL_PAYMENT_METHODS_F_aru
3198: purpose : This is procedure that records any updates

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

3272: is
3273: --
3274: begin
3275: --
3276: hr_utility.set_location('pay_continuous_calc.PERSONAL_PAYMENT_METHODS_F_aru', 10);
3277: /* If the continuous calc is overriden then do nothing */
3278: if (g_override_cc = TRUE) then
3279: return;
3280: end if;

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

3579: end loop;
3580: end if;
3581: pay_continuous_calc.g_event_list.sz := 0;
3582: end;
3583: hr_utility.set_location('pay_continuous_calc.PERSONAL_PAYMENT_METHODS_F_aru', 50);
3584: --
3585: end PERSONAL_PAYMENT_METHODS_F_aru;
3586: --
3587: /* PAY_LINK_INPUT_VALUES */

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

3833: )
3834: is
3835: --
3836: begin
3837: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_LINKS_F_aru', 10);
3838: /* If the continuous calc is overriden then do nothing */
3839: if (g_override_cc = TRUE) then
3840: return;
3841: end if;

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

4096: end loop;
4097: end if;
4098: pay_continuous_calc.g_event_list.sz := 0;
4099: end;
4100: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_LINKS_F_aru', 50);
4101: --
4102: end PAY_ELEMENT_LINKS_F_aru;
4103: --
4104: /* PAY_INPUT_VALUES */

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

4482: where asg.payroll_id = p_payroll_id
4483: and p_effective_date < asg.effective_end_date;
4484: --
4485: begin
4486: hr_utility.set_location('pay_continuous_calc.PAY_ALL_PAYROLLS_F_aru', 10);
4487: /* If the continuous calc is overriden then do nothing */
4488: if (g_override_cc = TRUE) then
4489: return;
4490: end if;

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

4993: end loop;
4994: end if;
4995: pay_continuous_calc.g_event_list.sz := 0;
4996: end;
4997: hr_utility.set_location('pay_continuous_calc.PAY_ALL_PAYROLLS_F_aru', 50);
4998: --
4999: end PAY_ALL_PAYROLLS_F_aru;
5000: --
5001: /* Used generator to build this procedure, but removed some of that table values.

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

5116: )
5117: is
5118: --
5119: begin
5120: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 10);
5121: /* If the continuous calc is overriden then do nothing */
5122: if (g_override_cc = TRUE) then
5123: return;
5124: end if;

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

5571: end loop;
5572: end if;
5573: pay_continuous_calc.g_event_list.sz := 0;
5574: end;
5575: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);
5576: --
5577: end PAY_ELEMENT_TYPES_F_aru;
5578: --
5579: /* PAY_GRADE_RULES_F */

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

5831: --
5832: l_process_event_id number;
5833: l_proc varchar2(240) := g_package||'.per_addresses_ari';
5834: begin
5835: hr_utility.set_location(l_proc, 10);
5836: /* If the continuous calc is overriden then do nothing */
5837: if (g_override_cc = TRUE) then
5838: return;
5839: end if;

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

5874: end loop;
5875: end if;
5876: pay_continuous_calc.g_event_list.sz := 0;
5877: end;
5878: hr_utility.set_location(l_proc, 900);
5879:
5880: end PER_ADDRESSES_ari;
5881:
5882: --

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

6546: from per_assignments_f
6547: where person_id = p_person_id;
6548: --
6549: begin
6550: hr_utility.set_location(l_proc, 10);
6551: /* If the continuous calc is overriden then do nothing */
6552: if (g_override_cc = TRUE) then
6553: return;
6554: end if;

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

6570: l_process_event_id number;
6571: l_object_version_number number;
6572: begin
6573: if (pay_continuous_calc.g_event_list.sz <> 0) then
6574: hr_utility.trace('> With in Create Process Event: ');
6575: for asgrec in asgcur (p_old_PERSON_ID) loop
6576: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6577: pay_ppe_api.create_process_event(
6578: p_assignment_id => asgrec.assignment_id,

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

6593: end loop;
6594: end if;
6595: pay_continuous_calc.g_event_list.sz := 0;
6596: end;
6597: hr_utility.set_location(l_proc, 900);
6598: END PER_ALL_PEOPLE_F_ard;
6599:
6600: /* PER_SPINAL_POINT_PLACEMENTS_F */
6601: /* name : PER_SPINAL_POINT_PLCMTS_F_ard

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

6616: l_process_event_id number;
6617: l_object_version_number number;
6618: l_proc varchar2(240) := g_package||'.PER_SPIN_PNT_PLACEMENTS_F_ard';
6619: begin
6620: hr_utility.set_location(l_proc, 10);
6621: /* If the continuous calc is overriden then do nothing */
6622: if (g_override_cc = TRUE) then
6623: return;
6624: end if;

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

6642: l_process_event_id number;
6643: l_object_version_number number;
6644: begin
6645: if (pay_continuous_calc.g_event_list.sz <> 0) then
6646: hr_utility.trace('> With in Create Process Event: ');
6647: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6648: pay_ppe_api.create_process_event(
6649: p_assignment_id => p_old_assignment_id,
6650: p_effective_date => g_event_list.effective_date(cnt),

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

6663: end loop;
6664: end if;
6665: pay_continuous_calc.g_event_list.sz := 0;
6666: end;
6667: hr_utility.set_location(l_proc, 900);
6668: END PER_SPIN_PNT_PLACEMENTS_F_ard;
6669:
6670:
6671: /* name : PER_SPINAL_POINT_PLCMTS_F_ari -- Added for bug 6265962

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

6683: l_process_event_id number;
6684: l_object_version_number number;
6685: l_proc varchar2(240) := g_package||'.PER_SPIN_PNT_PLACEMENTS_F_ari';
6686: begin
6687: hr_utility.set_location(l_proc, 10);
6688: /* If the continuous calc is overriden then do nothing */
6689: if (g_override_cc = TRUE) then
6690: return;
6691: end if;

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

6708: l_process_event_id number;
6709: l_object_version_number number;
6710: begin
6711: if (pay_continuous_calc.g_event_list.sz <> 0) then
6712: hr_utility.trace('> With in Create Process Event: ');
6713: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6714: pay_ppe_api.create_process_event(
6715: p_assignment_id => p_assignment_id,
6716: p_effective_date => g_event_list.effective_date(cnt),

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

6729: end loop;
6730: end if;
6731: pay_continuous_calc.g_event_list.sz := 0;
6732: end;
6733: hr_utility.set_location(l_proc, 900);
6734: END PER_SPIN_PNT_PLACEMENTS_F_ari;
6735: --
6736:
6737: /* PAY_GRADE_RULES_F */

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

6753: l_process_event_id number;
6754: l_object_version_number number;
6755: l_proc varchar2(240) := g_package||'.PAY_GRADE_RULES_F_ard';
6756: begin
6757: hr_utility.set_location(l_proc, 10);
6758: /* If the continuous calc is overriden then do nothing */
6759: if (g_override_cc = TRUE) then
6760: return;
6761: end if;

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

6777: l_process_event_id number;
6778: l_object_version_number number;
6779: begin
6780: if (pay_continuous_calc.g_event_list.sz <> 0) then
6781: hr_utility.trace('> With in Create Process Event: ');
6782: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
6783: pay_ppe_api.create_process_event(
6784: p_assignment_id => NULL,
6785: p_effective_date => g_event_list.effective_date(cnt),

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

6798: end loop;
6799: end if;
6800: pay_continuous_calc.g_event_list.sz := 0;
6801: end;
6802: hr_utility.set_location(l_proc, 900);
6803: END PAY_GRADE_RULES_F_ard;
6804:
6805: --
6806: /* PER_ALL_PEOPLE_F */

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

8860: l_process_event_id number;
8861: l_object_version_number number;
8862: l_proc varchar2(240) := g_package||'.per_assign_budget_values_ard';
8863: begin
8864: hr_utility.set_location(l_proc, 10);
8865: /* If the continuous calc is overriden then do nothing */
8866: if (g_override_cc = TRUE) then
8867: return;
8868: end if;

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

8901: end loop;
8902: end if;
8903: pay_continuous_calc.g_event_list.sz := 0;
8904: end;
8905: hr_utility.set_location(l_proc, 900);
8906: END per_assign_budget_values_ard;
8907:
8908: --
8909:

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

9075: where person_id = p_person_id;
9076: l_proc varchar2(240) := g_package||'.per_periods_of_service_aru';
9077:
9078: begin
9079: hr_utility.set_location(l_proc,10);
9080:
9081: /* If the continuous calc is overriden then do nothing */
9082: if (pay_continuous_calc.g_override_cc = TRUE) then
9083: return;

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

9728: );
9729:
9730: --end if;
9731: --
9732: hr_utility.set_location(l_proc,50);
9733: /* Now call the API for the affected assignments */
9734: declare
9735: l_process_event_id number;
9736: l_object_version_number number;

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

9757: end if;
9758: pay_continuous_calc.g_event_list.sz := 0;
9759: end;
9760: --
9761: hr_utility.set_location(l_proc,900);
9762: end PER_PERIODS_OF_SERVICE_aru;
9763:
9764: --------------------------------------------
9765: -- PER_PAY_PROPOSALS_aru

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

9857: is
9858: --
9859: l_proc varchar2(240) := g_package||'.per_pay_proposals_aru';
9860: begin
9861: hr_utility.set_location(l_proc,10);
9862: /* If the continuous calc is overriden then do nothing */
9863: if (pay_continuous_calc.g_override_cc = TRUE) then
9864: return;
9865: end if;

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

10213:
10214: -- CORRECTION ONLY end if;
10215: --
10216: /* Now call the API for the affected assignments */
10217: hr_utility.set_location(l_proc,50);
10218: declare
10219: l_process_event_id number;
10220: l_object_version_number number;
10221: cnt number;

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

10239: end if;
10240: pay_continuous_calc.g_event_list.sz := 0;
10241: end;
10242: --
10243: hr_utility.set_location(l_proc,900);
10244: end PER_PAY_PROPOSALS_aru;
10245:
10246: /* PER_PAY_PROPOSALS */
10247: /* name : PER_PAY_PROPOSALS_ari

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

10259: l_process_event_id number;
10260: l_object_version_number number;
10261: l_proc varchar2(240) := g_package||'.per_pay_proposals_ari';
10262: begin
10263: hr_utility.set_location(l_proc, 10);
10264: /* If the continuous calc is overriden then do nothing */
10265: if (g_override_cc = TRUE) then
10266: return;
10267: end if;

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

10302: end loop;
10303: end if;
10304: pay_continuous_calc.g_event_list.sz := 0;
10305: end;
10306: hr_utility.set_location(l_proc, 900);
10307: end per_pay_proposals_ari;
10308: --
10309: /* name : per_pay_proposals_ard
10310: purpose : This is procedure that records any deletes

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

10321: l_process_event_id number;
10322: l_object_version_number number;
10323: l_proc varchar2(240) := g_package||'.per_pay_proposals_ard';
10324: begin
10325: hr_utility.set_location(l_proc, 10);
10326: /* If the continuous calc is overriden then do nothing */
10327: if (g_override_cc = TRUE) then
10328: return;
10329: end if;

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

10364: end loop;
10365: end if;
10366: pay_continuous_calc.g_event_list.sz := 0;
10367: end;
10368: hr_utility.set_location(l_proc, 900);
10369: END per_pay_proposals_ard;
10370: --
10371: --------------------------------------------
10372: -- PER_PERFORMANCE_REVIEWS

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

10467: where person_id = p_person_id;
10468: l_proc varchar2(240) := g_package||'.per_performance_reviews_aru';
10469:
10470: begin
10471: hr_utility.set_location(l_proc,10);
10472:
10473: /* If the continuous calc is overriden then do nothing */
10474: if (pay_continuous_calc.g_override_cc = TRUE) then
10475: return;

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

11037: l_process_event_id number;
11038: l_object_version_number number;
11039: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ari';
11040: begin
11041: hr_utility.set_location(l_proc, 10);
11042: /* If the continuous calc is overriden then do nothing */
11043: if (g_override_cc = TRUE) then
11044: return;
11045: end if;

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

11078: end loop;
11079: end if;
11080: pay_continuous_calc.g_event_list.sz := 0;
11081: end;
11082: hr_utility.set_location(l_proc, 900);
11083: end PAY_COST_ALLOCATIONS_F_ari;
11084: --
11085: /* name : PAY_COST_ALLOCATIONS_F_ard
11086: purpose : This is procedure that records any deletes

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

11105: l_old_value date;
11106: l_new_value date;
11107: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ard';
11108: begin
11109: hr_utility.set_location(l_proc, 10);
11110: /* If the continuous calc is overriden then do nothing */
11111: if (g_override_cc = TRUE) then
11112: return;
11113: end if;

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

11111: if (g_override_cc = TRUE) then
11112: return;
11113: end if;
11114: --
11115: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

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

11112: return;
11113: end if;
11114: --
11115: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

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

11113: end if;
11114: --
11115: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:

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

11114: --
11115: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --

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

11115: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

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

11116: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_cost_allocation_ID);
11117: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11118: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11119: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11120: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11121:
11122: --
11123: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11124: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

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

11153: end if;
11154: end if;
11155: --
11156:
11157: -- hr_utility.trace('> l_mode: '||l_mode);
11158:
11159: pay_continuous_calc.event_update(p_business_group_id,
11160: p_legislation_code,
11161: 'PAY_COST_ALLOCATIONS_F',

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

11175: l_process_event_id number;
11176: l_object_version_number number;
11177: begin
11178: if (pay_continuous_calc.g_event_list.sz <> 0) then
11179: hr_utility.trace('> With in Create Process Event: ');
11180: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
11181: pay_ppe_api.create_process_event(
11182: p_assignment_id => p_assignment_id,
11183: p_effective_date => g_event_list.effective_date(cnt),

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

11196: end loop;
11197: end if;
11198: pay_continuous_calc.g_event_list.sz := 0;
11199: end;
11200: hr_utility.set_location(l_proc, 900);
11201: END PAY_COST_ALLOCATIONS_F_ard;
11202: --
11203:
11204: -- >>>

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

11486: l_process_event_id number;
11487: l_object_version_number number;
11488: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ari';
11489: begin
11490: hr_utility.set_location(l_proc, 10);
11491: /* If the continuous calc is overriden then do nothing */
11492: if (g_override_cc = TRUE) then
11493: return;
11494: end if;

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

11527: end loop;
11528: end if;
11529: pay_continuous_calc.g_event_list.sz := 0;
11530: end;
11531: hr_utility.set_location(l_proc, 900);
11532: end PAY_USER_COL_INSTANCES_F_ari;
11533:
11534: --
11535: PROCEDURE PAY_USER_COL_INSTANCES_F_aru

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

11687: l_old_value date;
11688: l_new_value date;
11689: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ard';
11690: begin
11691: hr_utility.set_location(l_proc, 10);
11692: /* If the continuous calc is overriden then do nothing */
11693: if (g_override_cc = TRUE) then
11694: return;
11695: end if;

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

11693: if (g_override_cc = TRUE) then
11694: return;
11695: end if;
11696: --
11697: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

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

11694: return;
11695: end if;
11696: --
11697: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

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

11695: end if;
11696: --
11697: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:

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

11696: --
11697: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --

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

11697: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

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

11698: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
11699: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
11700: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
11701: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
11702: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
11703:
11704: --
11705: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
11706: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

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

11735: end if;
11736: end if;
11737: --
11738:
11739: -- hr_utility.trace('> l_mode: '||l_mode);
11740:
11741: pay_continuous_calc.event_update(p_business_group_id,
11742: p_legislation_code,
11743: 'PAY_USER_COLUMN_INSTANCES_F',

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

11757: l_process_event_id number;
11758: l_object_version_number number;
11759: begin
11760: if (pay_continuous_calc.g_event_list.sz <> 0) then
11761: hr_utility.trace('> With in Create Process Event: ');
11762: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
11763: pay_ppe_api.create_process_event(
11764: p_assignment_id => NULL,
11765: p_effective_date => g_event_list.effective_date(cnt),

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

11778: end loop;
11779: end if;
11780: pay_continuous_calc.g_event_list.sz := 0;
11781: end;
11782: hr_utility.set_location(l_proc, 900);
11783: END PAY_USER_COL_INSTANCES_F_ard;
11784:
11785: --
11786: /* FF_GLOBALS_F */

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

11798: l_process_event_id number;
11799: l_object_version_number number;
11800: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ari';
11801: begin
11802: hr_utility.set_location(l_proc, 10);
11803: /* If the continuous calc is overriden then do nothing */
11804: if (g_override_cc = TRUE) then
11805: return;
11806: end if;

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

11839: end loop;
11840: end if;
11841: pay_continuous_calc.g_event_list.sz := 0;
11842: end;
11843: hr_utility.set_location(l_proc, 900);
11844: end FF_GLOBALS_F_ari;
11845:
11846: --
11847: PROCEDURE FF_GLOBALS_F_aru

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

11989: l_old_value date;
11990: l_new_value date;
11991: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ard';
11992: begin
11993: hr_utility.set_location(l_proc, 10);
11994: /* If the continuous calc is overriden then do nothing */
11995: if (g_override_cc = TRUE) then
11996: return;
11997: end if;

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

11995: if (g_override_cc = TRUE) then
11996: return;
11997: end if;
11998: --
11999: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);

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

11996: return;
11997: end if;
11998: --
11999: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);

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

11997: end if;
11998: --
11999: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:

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

11998: --
11999: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --

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

11999: -- hr_utility.trace('> p_assignment_id: '||p_assignment_id);
12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt

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

12000: -- hr_utility.trace('> p_old_cost_allocation_ID: '||p_old_user_col_instance_id);
12001: -- hr_utility.trace('> p_old_effective_start_date: '||p_old_effective_start_date);
12002: -- hr_utility.trace('> p_new_effective_start_date: '||p_new_effective_start_date);
12003: -- hr_utility.trace('> pay_dyn_triggers.g_dyt_mode: '||pay_dyn_triggers.g_dyt_mode);
12004: -- hr_utility.trace('> pay_dyn_triggers.g_dbms_dyt: '||pay_dyn_triggers.g_dbms_dyt);
12005:
12006: --
12007: if ( pay_dyn_triggers.g_dyt_mode = pay_dyn_triggers.g_dbms_dyt
12008: or pay_dyn_triggers.g_dyt_mode = 'ZAP') then

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

12037: end if;
12038: end if;
12039: --
12040:
12041: -- hr_utility.trace('> l_mode: '||l_mode);
12042:
12043: pay_continuous_calc.event_update(p_business_group_id,
12044: p_legislation_code,
12045: 'FF_GLOBALS_F',

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

12057: l_process_event_id number;
12058: l_object_version_number number;
12059: begin
12060: if (pay_continuous_calc.g_event_list.sz <> 0) then
12061: hr_utility.trace('> With in Create Process Event: ');
12062: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
12063: pay_ppe_api.create_process_event(
12064: p_assignment_id => NULL,
12065: p_effective_date => g_event_list.effective_date(cnt),

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

12078: end loop;
12079: end if;
12080: pay_continuous_calc.g_event_list.sz := 0;
12081: end;
12082: hr_utility.set_location(l_proc, 900);
12083: END FF_GLOBALS_F_ard;
12084:
12085: PROCEDURE PQH_RATE_MATRIX_RATES_F_ari( p_business_group_id IN NUMBER
12086: , p_legislation_code IN VARCHAR2

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

12091: l_process_event_id number;
12092: l_object_version_number number;
12093: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ari';
12094: BEGIN
12095: hr_utility.set_location(l_proc, 10);
12096: /* If the continuous calc is overriden then do nothing */
12097: if (g_override_cc = TRUE) then
12098: return;
12099: end if;

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

12132: end loop;
12133: end if;
12134: pay_continuous_calc.g_event_list.sz := 0;
12135: end;
12136: hr_utility.set_location(l_proc, 900);
12137:
12138: END PQH_RATE_MATRIX_RATES_F_ari;
12139:
12140:

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

12283: l_old_value date;
12284: l_new_value date;
12285: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ard';
12286: BEGIN
12287: hr_utility.set_location(l_proc, 10);
12288: /* If the continuous calc is overriden then do nothing */
12289: if (g_override_cc = TRUE) then
12290: return;
12291: end if;

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

12322: --
12323: end if;
12324: end if;
12325: --
12326: hr_utility.trace('> l_mode: '||l_mode);
12327:
12328: pay_continuous_calc.event_update(p_business_group_id,
12329: p_legislation_code,
12330: 'PQH_RATE_MATRIX_RATES_F',

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

12342: l_process_event_id number;
12343: l_object_version_number number;
12344: begin
12345: if (pay_continuous_calc.g_event_list.sz <> 0) then
12346: hr_utility.trace('> With in Create Process Event: ');
12347: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
12348: pay_ppe_api.create_process_event(
12349: p_assignment_id => NULL,
12350: p_effective_date => g_event_list.effective_date(cnt),

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

12363: end loop;
12364: end if;
12365: pay_continuous_calc.g_event_list.sz := 0;
12366: end;
12367: hr_utility.set_location(l_proc, 900);
12368:
12369: END PQH_RATE_MATRIX_RATES_F_ard;
12370: /*
12371: PER_CONTACT_RELATIONSHIPS

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

12392: l_proc varchar2(240) := 'per_contact_relationships_ari';
12393: --
12394: BEGIN
12395: --
12396: hr_utility.set_location(l_proc, 10);
12397:
12398: if p_effective_start_date is null then
12399: hr_utility.set_message(801,'PAY_505050_START_DATE_NULL');
12400: hr_utility.raise_error;

Line 12399: hr_utility.set_message(801,'PAY_505050_START_DATE_NULL');

12395: --
12396: hr_utility.set_location(l_proc, 10);
12397:
12398: if p_effective_start_date is null then
12399: hr_utility.set_message(801,'PAY_505050_START_DATE_NULL');
12400: hr_utility.raise_error;
12401: end if;
12402: /* If the continuous calc is overriden then do nothing */
12403: if (pay_continuous_calc.g_override_cc = TRUE) then

Line 12400: hr_utility.raise_error;

12396: hr_utility.set_location(l_proc, 10);
12397:
12398: if p_effective_start_date is null then
12399: hr_utility.set_message(801,'PAY_505050_START_DATE_NULL');
12400: hr_utility.raise_error;
12401: end if;
12402: /* If the continuous calc is overriden then do nothing */
12403: if (pay_continuous_calc.g_override_cc = TRUE) then
12404: return;

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

12448: pay_continuous_calc.g_event_list.sz := 0;
12449: --
12450: END;
12451: --
12452: hr_utility.set_location(l_proc, 900);
12453: --
12454: END per_contact_relationships_ari;
12455:
12456: /*

Line 12605: hr_utility.set_location(l_proc,1);

12601: where person_id = p_person_id;
12602: l_proc varchar2(100) := 'PER_CONTACT_RELATIONSHIPS_ARU';
12603: --
12604: begin
12605: hr_utility.set_location(l_proc,1);
12606: hr_utility.trace('p_business_group_id '||p_business_group_id);
12607: /* If the continuous calc is overriden then do nothing */
12608: if (pay_continuous_calc.g_override_cc = TRUE) then
12609: return;

Line 12606: hr_utility.trace('p_business_group_id '||p_business_group_id);

12602: l_proc varchar2(100) := 'PER_CONTACT_RELATIONSHIPS_ARU';
12603: --
12604: begin
12605: hr_utility.set_location(l_proc,1);
12606: hr_utility.trace('p_business_group_id '||p_business_group_id);
12607: /* If the continuous calc is overriden then do nothing */
12608: if (pay_continuous_calc.g_override_cc = TRUE) then
12609: return;
12610: end if;

Line 12612: hr_utility.set_location(l_proc,2);

12608: if (pay_continuous_calc.g_override_cc = TRUE) then
12609: return;
12610: end if;
12611:
12612: hr_utility.set_location(l_proc,2);
12613: pay_continuous_calc.event_update(p_business_group_id,
12614: p_legislation_code,
12615: 'PER_CONTACT_RELATIONSHIPS',
12616: 'BENEFICIARY_FLAG',

Line 13190: hr_utility.set_location(l_proc,3);

13186: p_new_DATE_END,
13187: p_effective_date
13188: );
13189:
13190: hr_utility.set_location(l_proc,3);
13191: /* Now call the API for the affected assignments */
13192: declare
13193: l_process_event_id number;
13194: l_object_version_number number;

Line 13197: hr_utility.set_location(l_proc,4);

13193: l_process_event_id number;
13194: l_object_version_number number;
13195: cnt number;
13196: begin
13197: hr_utility.set_location(l_proc,4);
13198: if (pay_continuous_calc.g_event_list.sz <> 0) then
13199: for asgrec in asgcur (p_old_PERSON_ID) loop
13200: for cnt in 1..pay_continuous_calc.g_event_list.sz loop
13201: pay_ppe_api.create_process_event(

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

13215: end loop;
13216: end if;
13217: pay_continuous_calc.g_event_list.sz := 0;
13218: end;
13219: hr_utility.set_location(l_proc,900);
13220: --
13221: end PER_CONTACT_RELATIONSHIPS_aru;
13222:
13223: begin