DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_HEADERS_INTERFACE

Line 405: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE

401: -- Procedure to process the PDOI Validation results.
402: --Parameters:
403: --IN:
404: --x_results - po_validation_results_type
405: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE
406: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE
407: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE
408: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE
409: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

Line 557: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE

553: --Function:
554: -- Procedure to derive the parent interface ids for a given entity
555: --Parameters:
556: --IN:
557: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE
558: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE
559: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE
560: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE
561: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

Line 632: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN

628: (l_key, l_seq(i), p_table_id_tbl(i));
629:
630: d_position := 30;
631:
632: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN
633:
634: d_position := 40;
635:
636: SELECT PHI.interface_header_id

Line 640: po_headers_interface PHI

636: SELECT PHI.interface_header_id
637: BULK COLLECT
638: INTO x_intf_header_id_tbl
639: FROM po_session_gt PSG,
640: po_headers_interface PHI
641: WHERE PSG.key = l_key AND
642: PSG.num1 = PHI.interface_header_id
643: ORDER BY PSG.index_num1;
644:

Line 1058: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN

1054: END IF;
1055:
1056: -- get value from each interface record based on p_table_name
1057: CASE p_table_name
1058: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN
1059: d_position := 10;
1060: l_index := p_headers.intf_id_index_tbl(p_interface_header_id);
1061: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1062: l_value := p_headers.rate_type_tbl(l_index);