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.PER_ES_SS_REP_DYN_TRG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 58: FROM per_assignment_extra_info

54: ,aei_information3 event
55: ,nvl(aei_information4,'X') value
56: ,aei_information6 action_type
57: ,aei_information7 first_change_date
58: FROM per_assignment_extra_info
59: WHERE assignment_id = p_assignment_id
60: AND information_type = 'ES_SS_REP'
61: AND aei_information5 <> 'Y';
62:

Line 94: UPDATE per_assignment_extra_info

90: -- Checking for Assignment Status Type ID
91: IF (csr_extra_info.event = 'AS' AND csr_extra_info.value <> p_asg_status_type_id
92: AND l_system_status = 'ACTIVE_ASSIGN') THEN
93: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN
94: UPDATE per_assignment_extra_info
95: SET aei_information5 = 'Y'
96: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)
97: WHERE assignment_id = p_assignment_id
98: AND aei_information3 = 'AS'

Line 107: UPDATE per_assignment_extra_info

103: -- Checking for Termination Status Type ID
104: IF (csr_extra_info.event = 'TS' AND csr_extra_info.value <> p_asg_status_type_id
105: AND l_system_status = 'TERM_ASSIGN') THEN
106: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN
107: UPDATE per_assignment_extra_info
108: SET aei_information5 = 'Y'
109: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date-1)
110: ,aei_information4 = p_asg_status_type_id
111: WHERE assignment_id = p_assignment_id

Line 121: UPDATE per_assignment_extra_info

117:
118: -- Checking for Employement Category
119: /* IF (csr_extra_info.event = 'EC' AND csr_extra_info.value <> nvl(p_employment_category, 'X')) THEN
120: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN
121: UPDATE per_assignment_extra_info
122: SET aei_information5 = 'Y'
123: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)
124: WHERE assignment_id = p_assignment_id
125: AND aei_information3 = 'EC'

Line 134: UPDATE per_assignment_extra_info

130:
131: -- Checking for contribution group
132: IF (csr_extra_info.event = 'CG' AND csr_extra_info.value <> nvl(l_contribution_code, 'X')) THEN
133: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN
134: UPDATE per_assignment_extra_info
135: SET aei_information5 = 'Y'
136: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)
137: WHERE assignment_id = p_assignment_id
138: AND aei_information3 = 'CG'

Line 162: FROM per_assignment_extra_info

158: p_soft_coding_keyflex_id NUMBER,
159: p_primary_flag VARCHAR) IS
160: CURSOR csr_check_asg IS
161: SELECT assignment_id
162: FROM per_assignment_extra_info
163: WHERE assignment_id = p_assignment_id;
164:
165: l_ovn NUMBER;
166: l_csr_find_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 185: INSERT INTO per_assignment_extra_info

181: p_primary_flag);
182: ELSE
183: /* Insert the records directly into the table because the api used to insert the values uses savepoint*/
184: /* savepoint cannot be used in triggers */
185: INSERT INTO per_assignment_extra_info
186: (assignment_extra_info_id,
187: assignment_id,
188: information_type,
189: aei_information_category,

Line 199: (per_assignment_extra_info_s.nextval,

195: aei_information7,
196: object_version_number
197: )
198: VALUES
199: (per_assignment_extra_info_s.nextval,
200: p_assignment_id,
201: 'ES_SS_REP',
202: 'ES_SS_REP',
203: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

Line 212: INSERT INTO per_assignment_extra_info

208: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
209: 1
210: );
211: /* Inserting the Termination Status as One */
212: INSERT INTO per_assignment_extra_info
213: (assignment_extra_info_id,
214: assignment_id,
215: information_type,
216: aei_information_category,

Line 226: (per_assignment_extra_info_s.nextval,

222: aei_information7,
223: object_version_number
224: )
225: VALUES
226: (per_assignment_extra_info_s.nextval,
227: p_assignment_id,
228: 'ES_SS_REP',
229: 'ES_SS_REP',
230: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

Line 238: /* INSERT INTO per_assignment_extra_info

234: 'U',
235: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
236: 1
237: );
238: /* INSERT INTO per_assignment_extra_info
239: (assignment_extra_info_id,
240: assignment_id,
241: information_type,
242: aei_information_category,

Line 252: (per_assignment_extra_info_s.nextval,

248: aei_information7,
249: object_version_number
250: )
251: VALUES
252: (per_assignment_extra_info_s.nextval,
253: p_assignment_id,
254: 'ES_SS_REP',
255: 'ES_SS_REP',
256: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

Line 265: INSERT INTO per_assignment_extra_info

261: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
262: 1
263: );
264: */
265: INSERT INTO per_assignment_extra_info
266: (assignment_extra_info_id,
267: assignment_id,
268: information_type,
269: aei_information_category,

Line 279: (per_assignment_extra_info_s.nextval,

275: aei_information7,
276: object_version_number
277: )
278: VALUES
279: (per_assignment_extra_info_s.nextval,
280: p_assignment_id,
281: 'ES_SS_REP',
282: 'ES_SS_REP',
283: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

Line 309: FROM per_assignment_extra_info

305: p_input_value_id NUMBER) AS
306:
307: CURSOR csr_chk_element_eit(p_assignment_id NUMBER) IS
308: SELECT assignment_extra_info_id
309: FROM per_assignment_extra_info
310: WHERE assignment_id = p_assignment_id
311: AND information_type = 'ES_SS_REP'
312: AND aei_information3 IN ('EP','EC');
313:

Line 329: l_assg_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;

325: AND p_effective_start_date BETWEEN paf.effective_start_date
326: AND paf.effective_end_date;
327:
328: l_assg_id pay_element_entries_f.assignment_id%TYPE;
329: l_assg_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
330: l_input_value_id pay_input_values_f.input_value_id%TYPE;
331: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
332: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
333:

Line 355: INSERT INTO per_assignment_extra_info

351: p_epigraph_code,
352: p_input_value_id);
353: ELSE
354: /*inserting for EPIGRAPH CODE EP*/
355: INSERT INTO per_assignment_extra_info
356: (assignment_extra_info_id,
357: assignment_id,
358: information_type,
359: aei_information_category,

Line 369: (per_assignment_extra_info_s.nextval,

365: aei_information7,
366: object_version_number
367: )
368: VALUES
369: (per_assignment_extra_info_s.nextval,
370: l_assg_id,
371: 'ES_SS_REP',
372: 'ES_SS_REP',
373: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

Line 382: INSERT INTO per_assignment_extra_info

378: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
379: 1
380: );
381: /*Inserting for contract key change*/
382: INSERT INTO per_assignment_extra_info
383: (assignment_extra_info_id,
384: assignment_id,
385: information_type,
386: aei_information_category,

Line 396: (per_assignment_extra_info_s.nextval,

392: aei_information7,
393: object_version_number
394: )
395: VALUES
396: (per_assignment_extra_info_s.nextval,
397: l_assg_id,
398: 'ES_SS_REP',
399: 'ES_SS_REP',
400: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

Line 430: FROM per_assignment_extra_info

426: ,aei_information2 last_reported_date
427: ,nvl(aei_information4,'X') value
428: ,aei_information6 action_type
429: ,aei_information7 last_changed_date
430: FROM per_assignment_extra_info
431: WHERE assignment_id = p_assignment_id
432: AND information_type = 'ES_SS_REP'
433: AND aei_information3 = p_event_type
434: AND aei_information5 <> 'Y';

Line 469: UPDATE per_assignment_extra_info

465: FOR csr_extra_info IN csr_get_eit_value(l_assignment_id,'EP')
466: LOOP
467: IF csr_extra_info.value <> p_epigraph_code THEN
468: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN
469: UPDATE per_assignment_extra_info
470: SET aei_information5 = 'Y'
471: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)
472: WHERE assignment_id = l_assignment_id
473: AND aei_information_category = 'ES_SS_REP'

Line 495: UPDATE per_assignment_extra_info

491: FOR csr_extra_info IN csr_get_eit_value(l_assignment_id,'EC')
492: LOOP
493: IF csr_extra_info.value <> p_epigraph_code THEN
494: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN
495: UPDATE per_assignment_extra_info
496: SET aei_information5 = 'Y'
497: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)
498: WHERE assignment_id = l_assignment_id
499: AND aei_information_category = 'ES_SS_REP'