DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on FND_DATE

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

1106:
1107: BEGIN
1108: qp_bulk_loader_pub.write_log('Entering Entity_header validation');
1109:
1110: select fnd_date.date_to_canonical(TRUNC(SYSDATE))
1111: into l_start_date_active
1112: from DUAL;
1113:
1114: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');

Line 2483: select fnd_date.canonical_to_date(start_date_active),

2479: l_header_start_date := null;
2480: l_header_end_date := null;
2481:
2482: BEGIN
2483: select fnd_date.canonical_to_date(start_date_active),
2484: fnd_date.canonical_to_date(end_date_active)
2485: into l_header_start_date, l_header_end_date
2486: from qp_interface_list_headers
2487: where orig_sys_header_ref=p_line_rec.orig_sys_header_ref(I)

Line 2484: fnd_date.canonical_to_date(end_date_active)

2480: l_header_end_date := null;
2481:
2482: BEGIN
2483: select fnd_date.canonical_to_date(start_date_active),
2484: fnd_date.canonical_to_date(end_date_active)
2485: into l_header_start_date, l_header_end_date
2486: from qp_interface_list_headers
2487: where orig_sys_header_ref=p_line_rec.orig_sys_header_ref(I)
2488: and request_id=p_line_rec.request_id(I)