APPS.PO_PDOI_HEADER_GROUPING_PVT dependencies on PO_PDOI_CONSTANTS

Line 62: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);

58: IF (PO_LOG.d_proc) THEN
59: PO_LOG.proc_begin (d_module);
60: END IF;
61:
62: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);
63:
64: d_position := 10;
65:
66: -- set round number for interface records that will be processed in

Line 82: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD

78:
79: -- If lines for a particular catalog name will get expired, move those
80: -- records to draft table and set expiration date for those lines
81: IF (PO_PDOI_PARAMS.g_request.calling_module =
82: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD
83: AND
84: PO_PDOI_PARAMS.g_request.catalog_to_expire IS NOT NULL) THEN
85:
86: expire_lines_by_catalog_name;

Line 98: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);

94: d_position := 50;
95:
96: PO_PDOI_UTL.commit_work;
97:
98: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_GROUPING);
99:
100: IF (PO_LOG.d_proc) THEN
101: PO_LOG.proc_end (d_module);
102: END IF;

Line 178: AND action IN (PO_PDOI_CONSTANTS.g_action_ORIGINAL,

174: FROM (SELECT interface_header_id
175: FROM po_headers_interface
176: WHERE processing_round_num IS NULL
177: AND processing_id = PO_PDOI_PARAMS.g_processing_id
178: AND action IN (PO_PDOI_CONSTANTS.g_action_ORIGINAL,
179: PO_PDOI_CONSTANTS.g_action_ADD)
180: ORDER BY interface_header_id)
181: WHERE rownum <= PO_PDOI_PARAMS.g_request.batch_size;
182:

Line 179: PO_PDOI_CONSTANTS.g_action_ADD)

175: FROM po_headers_interface
176: WHERE processing_round_num IS NULL
177: AND processing_id = PO_PDOI_PARAMS.g_processing_id
178: AND action IN (PO_PDOI_CONSTANTS.g_action_ORIGINAL,
179: PO_PDOI_CONSTANTS.g_action_ADD)
180: ORDER BY interface_header_id)
181: WHERE rownum <= PO_PDOI_PARAMS.g_request.batch_size;
182:
183: IF (SQL%ROWCOUNT = 0) THEN

Line 235: AND action IN (PO_PDOI_CONSTANTS.g_action_UPDATE,

231: FROM po_headers_interface
232: WHERE processing_round_num IS NULL
233: AND processing_id = PO_PDOI_PARAMS.g_processing_id
234: AND po_header_id IS NOT NULL
235: AND action IN (PO_PDOI_CONSTANTS.g_action_UPDATE,
236: PO_PDOI_CONSTANTS.g_action_REPLACE)
237: ORDER BY interface_header_id;
238:
239: d_position := 60;

Line 236: PO_PDOI_CONSTANTS.g_action_REPLACE)

232: WHERE processing_round_num IS NULL
233: AND processing_id = PO_PDOI_PARAMS.g_processing_id
234: AND po_header_id IS NOT NULL
235: AND action IN (PO_PDOI_CONSTANTS.g_action_UPDATE,
236: PO_PDOI_CONSTANTS.g_action_REPLACE)
237: ORDER BY interface_header_id;
238:
239: d_position := 60;
240:

Line 407: IF (l_action_tbl(i) = PO_PDOI_CONSTANTS.g_action_UPDATE) THEN

403: -- allocate space to store draft ids
404: l_draft_id_tbl.extend(l_intf_header_id_tbl.COUNT);
405:
406: FOR i IN 1..l_intf_header_id_tbl.COUNT LOOP
407: IF (l_action_tbl(i) = PO_PDOI_CONSTANTS.g_action_UPDATE) THEN
408: d_position := 20;
409:
410: -- If we are updating a document, a draft for the document may or may
411: -- not exist. if the draft exists, reuse it; if not, create a new

Line 528: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

524:
525: d_position := 110;
526:
527: PO_PDOI_UTL.reject_headers_intf
528: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
529: p_id_tbl => l_reject_list,
530: p_cascade => FND_API.G_TRUE
531: );
532:

Line 769: AND PLI.process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED;

765: SELECT count(*)
766: INTO l_reject_count
767: FROM po_lines_interface PLI
768: WHERE PLI.interface_header_id = p_intf_header_id_tbl(i)
769: AND PLI.process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED;
770:
771: PO_PDOI_PARAMS.g_docs_info(l_id).number_of_processed_lines :=
772: l_reject_count;
773: PO_PDOI_PARAMS.g_docs_info(l_id).number_of_errored_lines :=