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 FND_DATE

Line 93: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN

89: LOOP
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

Line 96: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)

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'
99: AND aei_information_category = 'ES_SS_REP'
100: AND object_version_number = csr_extra_info.object_version_number;

Line 106: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN

102: END IF;
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

Line 109: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date-1)

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
112: AND aei_information3 = 'TS'
113: AND aei_information_category = 'ES_SS_REP'

Line 120: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN

116: END IF;
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

Line 123: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)

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'
126: AND aei_information_category = 'ES_SS_REP'
127: AND object_version_number = csr_extra_info.object_version_number;

Line 133: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN

129: END IF;*/
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

Line 136: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)

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'
139: AND aei_information_category = 'ES_SS_REP'
140: AND object_version_number = csr_extra_info.object_version_number;

Line 203: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

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),
204: 'AS',
205: p_asg_status_type_id,
206: 'Y',
207: 'I',

Line 208: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

204: 'AS',
205: p_asg_status_type_id,
206: 'Y',
207: 'I',
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

Line 230: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

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),
231: 'TS',
232: p_asg_status_type_id,
233: 'N',
234: 'U',

Line 235: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

231: 'TS',
232: p_asg_status_type_id,
233: 'N',
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,

Line 256: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

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),
257: 'EC',
258: p_employment_category,
259: 'Y',
260: 'I',

Line 261: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

257: 'EC',
258: p_employment_category,
259: 'Y',
260: 'I',
261: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
262: 1
263: );
264: */
265: INSERT INTO per_assignment_extra_info

Line 283: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

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),
284: 'CG',
285: NULL,
286: 'Y',
287: 'I',

Line 288: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

284: 'CG',
285: NULL,
286: 'Y',
287: 'I',
288: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
289: 1
290: );
291: END IF;
292: CLOSE csr_check_asg;

Line 373: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

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),
374: 'EP',
375: NULL,
376: 'Y',
377: 'I',

Line 378: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

374: 'EP',
375: NULL,
376: 'Y',
377: 'I',
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

Line 400: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

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),
401: 'EC',
402: NULL,
403: 'Y',
404: 'I',

Line 405: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),

401: 'EC',
402: NULL,
403: 'Y',
404: 'I',
405: fnd_date.date_to_canonical(P_EFFECTIVE_START_DATE),
406: 1
407: );
408: END IF;
409: CLOSE csr_chk_element_eit;

Line 468: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN

464: IF l_assignment_type = 'E' AND l_primary_flag = 'Y' THEN
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

Line 471: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)

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'
474: AND aei_information3 = 'EP'
475: AND object_version_number = csr_extra_info.object_version_number;

Line 494: IF p_effective_end_date >= fnd_date.canonical_to_date(csr_extra_info.last_reported_date) THEN

490: IF l_assignment_type = 'E' AND l_primary_flag = 'Y' THEN
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

Line 497: ,aei_information7 = fnd_date.date_to_canonical(p_effective_start_date)

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'
500: AND aei_information3 = 'EC'
501: AND object_version_number = csr_extra_info.object_version_number;