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 980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))

976: ,q.HASH_KEY
977: ,q.CACHE_KEY
978: FROM qp_list_lines q
979: WHERE q.list_header_id = :hdr
980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),

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

977: ,q.CACHE_KEY
978: FROM qp_list_lines q
979: WHERE q.list_header_id = :hdr
980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
985: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))

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

978: FROM qp_list_lines q
979: WHERE q.list_header_id = :hdr
980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
985: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
986: and q.created_by=nvl(:usr,q.created_by)

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

979: WHERE q.list_header_id = :hdr
980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
985: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
986: and q.created_by=nvl(:usr,q.created_by)
987: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';

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

980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
985: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
986: and q.created_by=nvl(:usr,q.created_by)
987: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';
988:

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

981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))
983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
985: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
986: and q.created_by=nvl(:usr,q.created_by)
987: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';
988:
989: /* Check whether all_lines check box is checked if yes then archive all the lines in the pricing entity */

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

983: and nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||'''))
984: <=nvl(trunc(fnd_date.canonical_to_date(:edat)),
985: nvl(trunc(q.end_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_max_date)||''')))
986: and q.created_by=nvl(:usr,q.created_by)
987: and trunc(q.creation_date)=nvl(trunc(fnd_date.canonical_to_date(:cdat)),trunc(q.creation_date))';
988:
989: /* Check whether all_lines check box is checked if yes then archive all the lines in the pricing entity */
990: IF nvl(p_all_lines,'N') = 'N' THEN
991: IF p_product_context is not NULL THEN