DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on FND_DATE

Line 954: select fnd_date.date_to_canonical(TRUNC(SYSDATE))

950:
951: BEGIN
952: qp_bulk_loader_pub.write_log('Entering Entity_header validation');
953:
954: select fnd_date.date_to_canonical(TRUNC(SYSDATE))
955: into l_start_date_active
956: from DUAL;
957:
958: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');

Line 2355: select fnd_date.canonical_to_date(start_date_active),

2351: l_header_start_date := null;
2352: l_header_end_date := null;
2353:
2354: BEGIN
2355: select fnd_date.canonical_to_date(start_date_active),
2356: fnd_date.canonical_to_date(end_date_active)
2357: into l_header_start_date, l_header_end_date
2358: from qp_interface_list_headers
2359: where orig_sys_header_ref=p_line_rec.orig_sys_header_ref(I)

Line 2356: fnd_date.canonical_to_date(end_date_active)

2352: l_header_end_date := null;
2353:
2354: BEGIN
2355: select fnd_date.canonical_to_date(start_date_active),
2356: fnd_date.canonical_to_date(end_date_active)
2357: into l_header_start_date, l_header_end_date
2358: from qp_interface_list_headers
2359: where orig_sys_header_ref=p_line_rec.orig_sys_header_ref(I)
2360: and request_id=p_line_rec.request_id(I)