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.QP_ARCHIVE_ENTITY_PVT dependencies on FND_DATE

Line 189: fnd_date.canonical_to_date(p_start_date_active));

185: parameter_value)
186: values
187: (p_conc_request_id,
188: 'START_DATE_ACTIVE',
189: fnd_date.canonical_to_date(p_start_date_active));
190:
191: END IF;
192:
193: IF p_end_date_active is not null THEN

Line 202: fnd_date.canonical_to_date(p_end_date_active));

198: parameter_value)
199: values
200: (p_conc_request_id,
201: 'END_DATE_ACTIVE',
202: fnd_date.canonical_to_date(p_end_date_active));
203:
204: END IF;
205:
206: IF p_created_by is not null THEN

Line 228: fnd_date.canonical_to_date(p_creation_date));

224: parameter_value)
225: values
226: (p_conc_request_id,
227: 'CREATION_DATE',
228: fnd_date.canonical_to_date(p_creation_date));
229:
230: END IF;
231:
232: END IF; -- all lines check

Line 1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))

997: ,q.HASH_KEY
998: ,q.CACHE_KEY
999: FROM qp_list_lines q
1000: WHERE q.list_header_id = :hdr
1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),

Line 1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),

998: ,q.CACHE_KEY
999: FROM qp_list_lines q
1000: WHERE q.list_header_id = :hdr
1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))

Line 1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))

999: FROM qp_list_lines q
1000: WHERE q.list_header_id = :hdr
1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
1007: and q.created_by=nvl(:usr,q.created_by)

Line 1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))

1000: WHERE q.list_header_id = :hdr
1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
1007: and q.created_by=nvl(:usr,q.created_by)
1008: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';

Line 1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),

1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
1007: and q.created_by=nvl(:usr,q.created_by)
1008: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';
1009:

Line 1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))

1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
1007: and q.created_by=nvl(:usr,q.created_by)
1008: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';
1009:
1010: /* Check whether all_lines check box is checked if yes then archive all the lines in the pricing entity */

Line 1008: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';

1004: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
1005: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
1006: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
1007: and q.created_by=nvl(:usr,q.created_by)
1008: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';
1009:
1010: /* Check whether all_lines check box is checked if yes then archive all the lines in the pricing entity */
1011: IF nvl(p_all_lines,'N') = 'N' THEN
1012: IF p_product_context is not NULL THEN