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.PO_PDOI_PREPROC_PVT dependencies on PO_PDOI_CONSTANTS

Line 71: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);

67: IF (PO_LOG.d_proc) THEN
68: PO_LOG.proc_begin (d_module);
69: END IF;
70:
71: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
72:
73: IF (PO_PDOI_PARAMS.g_request.document_type <>
74: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
75: AND

Line 74: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

70:
71: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
72:
73: IF (PO_PDOI_PARAMS.g_request.document_type <>
74: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
75: AND
76: PO_PDOI_PARAMS.g_request.process_code =
77: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
78:

Line 77: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN

73: IF (PO_PDOI_PARAMS.g_request.document_type <>
74: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
75: AND
76: PO_PDOI_PARAMS.g_request.process_code =
77: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
78:
79: update_dependent_line_acc_flag; -- bug5149827 - Renamed the procedure
80: END IF;
81:

Line 120: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);

116:
117: d_position := 100;
118: PO_PDOI_UTL.commit_work;
119:
120: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
121:
122: IF (PO_LOG.d_proc) THEN
123: PO_LOG.proc_end (d_module);
124: END IF;

Line 193: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =

189: l_price_chg_accept_flag_tbl,
190: l_price_break_flag_tbl
191: FROM po_lines_interface
192: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
193: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
194: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
195: ORDER BY po_line_id, interface_line_id;
196:
197: IF (PO_LOG.d_stmt) THEN

Line 194: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

190: l_price_break_flag_tbl
191: FROM po_lines_interface
192: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
193: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
194: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
195: ORDER BY po_line_id, interface_line_id;
196:
197: IF (PO_LOG.d_stmt) THEN
198: PO_LOG.stmt(d_module, d_position, 'number of lines with notified status ',

Line 247: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =

243: FROM po_lines_interface parent_lines
244: WHERE lines.parent_interface_line_id =
245: parent_lines.interface_line_id )
246: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
247: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
248: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
249: AND lines.parent_interface_line_id IS NOT NULL;
250:
251: IF (PO_LOG.d_stmt) THEN

Line 248: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

244: WHERE lines.parent_interface_line_id =
245: parent_lines.interface_line_id )
246: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
247: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
248: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
249: AND lines.parent_interface_line_id IS NOT NULL;
250:
251: IF (PO_LOG.d_stmt) THEN
252: PO_LOG.stmt(d_module, d_position, '# of lines updated based on parent_intf_line_id',

Line 260: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED

256: d_position := 40;
257:
258: -- Reject all records that have not been accepted
259: UPDATE po_lines_interface
260: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
261: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
262: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
263: AND price_chg_accept_flag = 'N';
264:

Line 262: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

258: -- Reject all records that have not been accepted
259: UPDATE po_lines_interface
260: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
261: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
262: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
263: AND price_chg_accept_flag = 'N';
264:
265: d_position := 30;
266: END IF;

Line 309: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>

305: PHI.process_code,
306: PHI.request_id
307: FROM po_headers_interface PHI
308: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
309: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
310: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
311: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
312: OR
313: PO_PDOI_PARAMS.g_request.batch_id IS NULL)

Line 310: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED

306: PHI.request_id
307: FROM po_headers_interface PHI
308: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
309: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
310: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
311: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
312: OR
313: PO_PDOI_PARAMS.g_request.batch_id IS NULL)
314: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code

Line 317: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>

313: PO_PDOI_PARAMS.g_request.batch_id IS NULL)
314: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code
315: OR
316: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
317: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>
318: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
319: AND
320: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
321: OR

Line 318: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

314: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code
315: OR
316: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
317: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>
318: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
319: AND
320: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
321: OR
322: PHI.process_code IS NULL)

Line 320: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)

316: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
317: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>
318: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
319: AND
320: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
321: OR
322: PHI.process_code IS NULL)
323: AND (PHI.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
324: OR

Line 338: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

334: -- request
335: -- bug5463188
336: -- Buyer acceptance process shouldn't worry about the calling module
337: AND ( PO_PDOI_PARAMS.g_request.process_code =
338: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
339: OR
340: DECODE (PHI.interface_source_code,
341: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
342: 1, 2) =

Line 341: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,

337: AND ( PO_PDOI_PARAMS.g_request.process_code =
338: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
339: OR
340: DECODE (PHI.interface_source_code,
341: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
342: 1, 2) =
343: DECODE (PO_PDOI_PARAMS.g_request.calling_module,
344: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
345: 1, 2));

Line 344: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,

340: DECODE (PHI.interface_source_code,
341: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
342: 1, 2) =
343: DECODE (PO_PDOI_PARAMS.g_request.calling_module,
344: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
345: 1, 2));
346:
347:
348: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 387: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

383: BULK COLLECT
384: INTO l_intf_header_id_tbl,
385: l_process_code_tbl,
386: l_request_id_tbl
387: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
388:
389: EXIT WHEN l_intf_header_id_tbl.COUNT = 0;
390:
391: -- Filter the list further more to only return records that are

Line 404: process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS,

400: -- Header level assignment
401: FORALL i IN 1..l_intf_header_id_tbl.COUNT
402: UPDATE po_headers_interface
403: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
404: process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS,
405: processing_round_num = NULL, -- reset processing number
406: request_id = FND_GLOBAL.conc_request_id,
407: approval_status = NVL(approval_status,
408: PO_PDOI_PARAMS.g_request.approved_status)

Line 422: PO_PDOI_CONSTANTS.g_action_ADD, action,

418: FORALL i IN 1..l_intf_header_id_tbl.COUNT
419: UPDATE po_lines_interface
420: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
421: action = DECODE (action,
422: PO_PDOI_CONSTANTS.g_action_ADD, action,
423: NULL), -- null out process code unless it is force add
424: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,
425: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
426: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

Line 425: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,

421: action = DECODE (action,
422: PO_PDOI_CONSTANTS.g_action_ADD, action,
423: NULL), -- null out process code unless it is force add
424: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,
425: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
426: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
427: process_code) -- bug5149827
428: WHERE interface_header_id = l_intf_header_id_tbl(i)
429: AND (PO_PDOI_PARAMS.g_request.process_code = process_code

Line 426: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

422: PO_PDOI_CONSTANTS.g_action_ADD, action,
423: NULL), -- null out process code unless it is force add
424: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,
425: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
426: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
427: process_code) -- bug5149827
428: WHERE interface_header_id = l_intf_header_id_tbl(i)
429: AND (PO_PDOI_PARAMS.g_request.process_code = process_code
430: OR

Line 432: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>

428: WHERE interface_header_id = l_intf_header_id_tbl(i)
429: AND (PO_PDOI_PARAMS.g_request.process_code = process_code
430: OR
431: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
432: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))

Line 433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND

429: AND (PO_PDOI_PARAMS.g_request.process_code = process_code
430: OR
431: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
432: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

Line 434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

430: OR
431: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
432: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

Line 435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

431: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
432: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)

Line 436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))

432: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
440: OR

Line 437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

433: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
440: OR
441: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND

Line 438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

434: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
440: OR
441: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
442: NVL(price_chg_accept_flag, 'N') = 'Y'))

Line 439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)

435: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
436: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
440: OR
441: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
442: NVL(price_chg_accept_flag, 'N') = 'Y'))
443: RETURNING interface_line_id

Line 441: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND

437: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
438: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
439: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
440: OR
441: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
442: NVL(price_chg_accept_flag, 'N') = 'Y'))
443: RETURNING interface_line_id
444: BULK COLLECT INTO l_intf_line_id_tbl;
445:

Line 476: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

472: END IF;
473:
474: d_position := 70;
475: IF (PO_PDOI_PARAMS.g_request.document_type =
476: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
477: FORALL i IN 1..l_intf_line_id_tbl.COUNT
478: UPDATE po_distributions_interface
479: SET processing_id = PO_PDOI_PARAMS.g_processing_id
480: WHERE interface_line_id = l_intf_line_id_tbl(i);

Line 490: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

486: END IF;
487:
488: d_position := 80;
489: IF (PO_PDOI_PARAMS.g_request.document_type <>
490: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
491:
492: d_position := 90;
493: FORALL i IN 1..l_intf_line_id_tbl.COUNT
494: UPDATE po_attr_values_interface

Line 581: IF (p_process_code_tbl(i) = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS) THEN

577:
578: FOR i IN 1..x_intf_header_id_tbl.COUNT LOOP
579: d_position := 10;
580:
581: IF (p_process_code_tbl(i) = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS) THEN
582:
583: l_old_request_complete := PO_PDOI_UTL.is_old_request_complete
584: ( p_old_request_id => p_request_id_tbl(i)
585: );

Line 659: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

655: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
656: AND (action IS NULL
657: OR
658: (PO_PDOI_PARAMS.g_request.document_type IN
659: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,

Line 660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND

656: AND (action IS NULL
657: OR
658: (PO_PDOI_PARAMS.g_request.document_type IN
659: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))

Line 661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

657: OR
658: (PO_PDOI_PARAMS.g_request.document_type IN
659: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR

Line 662: PO_PDOI_CONSTANTS.g_ACTION_ADD,

658: (PO_PDOI_PARAMS.g_request.document_type IN
659: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND

Line 663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,

659: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))

660: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
661: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
668: PO_PDOI_CONSTANTS.g_ACTION_ADD,

Line 666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND

662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
668: PO_PDOI_CONSTANTS.g_ACTION_ADD,
669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
670:

Line 667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
668: PO_PDOI_CONSTANTS.g_ACTION_ADD,
669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
670:
671: d_position := 10;

Line 668: PO_PDOI_CONSTANTS.g_ACTION_ADD,

664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
668: PO_PDOI_CONSTANTS.g_ACTION_ADD,
669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
670:
671: d_position := 10;
672:

Line 669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));

665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
668: PO_PDOI_CONSTANTS.g_ACTION_ADD,
669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
670:
671: d_position := 10;
672:
673: IF (PO_LOG.d_stmt) THEN

Line 679: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

675: l_reject_tbl.COUNT);
676: END IF;
677:
678: FOR i IN 1..l_reject_tbl.COUNT LOOP
679: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
680: AND
681: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
682:
683: l_message_name := 'PO_PDOI_STD_ACTION';

Line 681: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN

677:
678: FOR i IN 1..l_reject_tbl.COUNT LOOP
679: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
680: AND
681: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
682:
683: l_message_name := 'PO_PDOI_STD_ACTION';
684: ELSE
685: l_message_name := 'PO_PDOI_INVALID_ACTION';

Line 701: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

697: END LOOP;
698:
699: d_position := 30;
700: PO_PDOI_UTL.reject_headers_intf
701: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
702: p_id_tbl => l_reject_tbl,
703: p_cascade => FND_API.G_TRUE);
704:
705: IF (PO_LOG.d_proc) THEN

Line 830: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

826:
827: d_position := 40;
828: -- For records that cannot derive vendor id, reject header and its children
829: PO_PDOI_UTL.reject_headers_intf
830: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
831: p_id_tbl => l_reject_list,
832: p_cascade => FND_API.G_TRUE
833: );
834:

Line 908: AND action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE;

904: BULK COLLECT INTO l_interface_header_id_tbl, l_vendor_id_tbl,
905: l_start_date_tbl, l_end_date_tbl, l_vendor_doc_num_tbl
906: FROM po_headers_interface
907: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
908: AND action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE;
909:
910: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN
911: d_position := 10;
912: RETURN;

Line 961: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

957:
958: IF (l_valid = FND_API.G_TRUE) THEN
959:
960: IF (PO_PDOI_PARAMS.g_request.document_type =
961: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
962:
963: d_position := 60;
964:
965: -- Quotation: Match vendor doc num with quote_vendor_quote_number

Line 982: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

978: AND TRUNC(l_start_date_tbl(i)) >= TRUNC(NVL(start_date, SYSDATE))
979: AND TRUNC(NVL(l_end_date_tbl(i), SYSDATE)) <= TRUNC(NVL(end_date, SYSDATE));
980:
981: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
982: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
983:
984: d_position := 70;
985: -- Blanket: Match vendor doc num with vendor_order_num
986: SELECT po_header_id,

Line 1067: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

1063: -- date greater than the start date of the newly replaced blanket, whcih
1064: -- is equivalent to the end date of the old blanket
1065:
1066: IF (PO_PDOI_PARAMS.g_request.document_type =
1067: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1068:
1069: d_position := 120;
1070: check_release_dates
1071: ( p_interface_header_id => l_interface_header_id_tbl(i),

Line 1112: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

1108:
1109: d_position := 160;
1110: -- propagate errors to lower level
1111: PO_PDOI_UTL.reject_headers_intf
1112: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1113: p_id_tbl => l_reject_list,
1114: p_cascade => FND_API.G_TRUE
1115: );
1116:

Line 1320: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

1316: l_vendor_doc_num_tbl,
1317: l_document_num_tbl
1318: FROM po_headers_interface
1319: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1320: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
1321:
1322: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN
1323: d_position := 10;
1324: RETURN;

Line 1328: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN

1324: RETURN;
1325: END IF;
1326:
1327: IF (PO_PDOI_PARAMS.g_request.calling_module =
1328: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1329: l_skip_cat_upload_chk := FND_API.G_TRUE;
1330: ELSE
1331: l_skip_cat_upload_chk := FND_API.G_FALSE;
1332: END IF;

Line 1374: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1370: d_position := 30;
1371:
1372: IF (l_valid = FND_API.g_TRUE) THEN
1373: IF (PO_PDOI_PARAMS.g_request.document_type IN
1374: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1375: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1376:
1377: d_position := 40;
1378:

Line 1375: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

1371:
1372: IF (l_valid = FND_API.g_TRUE) THEN
1373: IF (PO_PDOI_PARAMS.g_request.document_type IN
1374: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1375: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1376:
1377: d_position := 40;
1378:
1379: PO_PDOI_UTL.get_processing_doctype_info

Line 1413: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1409: IF (l_valid <> FND_API.g_TRUE) THEN
1410: d_position := 70;
1411:
1412: IF (PO_PDOI_PARAMS.g_request.document_type =
1413: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1414: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1415: ELSE
1416: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1417: END IF;

Line 1455: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1451: IF (l_vendor_doc_num_tbl(i) IS NOT NULL) THEN
1452: -- Definitely need to match vendor doc num. Matching document num
1453: -- will be performed, if provided
1454: IF (PO_PDOI_PARAMS.g_request.document_type IN
1455: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1456: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1457:
1458: d_position := 90;
1459: SELECT POH.po_header_id,

Line 1456: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN

1452: -- Definitely need to match vendor doc num. Matching document num
1453: -- will be performed, if provided
1454: IF (PO_PDOI_PARAMS.g_request.document_type IN
1455: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1456: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1457:
1458: d_position := 90;
1459: SELECT POH.po_header_id,
1460: NVL(POH.consigned_consumption_flag, 'N')

Line 1480: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1476: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1477: AND NVL(POH.cancel_flag, 'N') <> 'Y';
1478:
1479: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1480: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1481: d_position := 100;
1482: SELECT POH.po_header_id,
1483: NVL(POH.consigned_consumption_flag, 'N')
1484: BULK COLLECT

Line 1508: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1504: -- Definitely need to match document num. Matching vendor doc num
1505: -- will be performed, if provided
1506:
1507: IF (PO_PDOI_PARAMS.g_request.document_type IN
1508: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1509: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1510:
1511: SELECT POH.po_header_id,
1512: NVL(POH.consigned_consumption_flag, 'N')

Line 1509: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN

1505: -- will be performed, if provided
1506:
1507: IF (PO_PDOI_PARAMS.g_request.document_type IN
1508: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1509: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1510:
1511: SELECT POH.po_header_id,
1512: NVL(POH.consigned_consumption_flag, 'N')
1513: BULK COLLECT

Line 1534: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1530: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1531: AND NVL(POH.cancel_flag, 'N') <> 'Y';
1532:
1533: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1534: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1535:
1536: SELECT POH.po_header_id,
1537: NVL(POH.consigned_consumption_flag, 'N')
1538: BULK COLLECT

Line 1577: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1573:
1574: IF (l_orig_po_header_id_tbl.COUNT <> 1) THEN
1575: IF (l_orig_po_header_id_tbl.COUNT = 0) THEN
1576: IF (PO_PDOI_PARAMS.g_request.document_type =
1577: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1578: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1579: ELSE
1580: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1581: END IF;

Line 1584: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1580: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1581: END IF;
1582: ELSE
1583: IF (PO_PDOI_PARAMS.g_request.document_type =
1584: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1585: l_message_name := 'PO_PDOI_MULTIPLE_STD_PO';
1586: ELSE
1587: l_message_name := 'PO_PDOI_INVALID_MULT_ORIG_CATG';
1588: END IF;

Line 1607: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1603: END IF;
1604:
1605: IF (l_valid = FND_API.g_TRUE) THEN
1606: IF (PO_PDOI_PARAMS.g_request.document_type IN
1607: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1608: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1609:
1610: d_position := 140;
1611:

Line 1608: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

1604:
1605: IF (l_valid = FND_API.g_TRUE) THEN
1606: IF (PO_PDOI_PARAMS.g_request.document_type IN
1607: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1608: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1609:
1610: d_position := 140;
1611:
1612: PO_PDOI_UTL.get_processing_doctype_info

Line 1638: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1634: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR
1635: l_status_rec.updatable_flag(1) = 'N') THEN
1636:
1637: IF (PO_PDOI_PARAMS.g_request.document_type =
1638: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1639: l_message_name := 'PO_PDOI_STD_PO_INVALID_STATUS';
1640: ELSE
1641: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1642: END IF;

Line 1688: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

1684:
1685: d_position := 190;
1686: -- propagate rejection status to lower level
1687: PO_PDOI_UTL.reject_headers_intf
1688: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1689: p_id_tbl => l_reject_list,
1690: p_cascade => FND_API.G_TRUE
1691: );
1692:

Line 1738: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1734: PO_LOG.proc_begin (d_module);
1735: END IF;
1736:
1737: IF (PO_PDOI_PARAMS.g_request.document_type =
1738: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1739:
1740: SELECT POH.po_header_id,
1741: PHI.interface_header_id,
1742: PHI.vendor_doc_num

Line 1758: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

1754: TRUNC (NVL(POH.end_date, SYSDATE))
1755: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1756: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1757: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1758: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1759: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1760:
1761: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1762: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

Line 1759: PO_PDOI_CONSTANTS.g_ACTION_ADD);

1755: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1756: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1757: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1758: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1759: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1760:
1761: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1762: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1763:

Line 1762: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

1758: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1759: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1760:
1761: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1762: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1763:
1764: SELECT POH.po_header_id,
1765: PHI.interface_header_id,
1766: PHI.vendor_doc_num

Line 1782: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

1778: TRUNC (NVL(POH.end_date, SYSDATE))
1779: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1780: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1781: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1782: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1783: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1784:
1785: END IF;
1786:

Line 1783: PO_PDOI_CONSTANTS.g_ACTION_ADD);

1779: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1780: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1781: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1782: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1783: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1784:
1785: END IF;
1786:
1787: d_position := 10;

Line 1806: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

1802:
1803: -- propagate rejection status to lower level for each document getting
1804: -- rejected
1805: PO_PDOI_UTL.reject_headers_intf
1806: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1807: p_id_tbl => l_reject_list,
1808: p_cascade => FND_API.G_TRUE
1809: );
1810:

Line 1857: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

1853: UPDATE po_headers_interface
1854: SET po_header_id = PO_HEADERS_S.nextval
1855: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1856: AND po_header_id IS NULL
1857: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1859: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1860:
1861: IF (PO_LOG.d_proc) THEN

Line 1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,

1854: SET po_header_id = PO_HEADERS_S.nextval
1855: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1856: AND po_header_id IS NULL
1857: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1859: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1860:
1861: IF (PO_LOG.d_proc) THEN
1862: PO_LOG.proc_end (d_module);

Line 1859: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);

1855: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1856: AND po_header_id IS NULL
1857: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1859: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1860:
1861: IF (PO_LOG.d_proc) THEN
1862: PO_LOG.proc_end (d_module);
1863: END IF;

Line 1935: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

1931: LOOP
1932: FETCH c_line_intf
1933: BULK COLLECT
1934: INTO l_rowid_tbl
1935: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
1936:
1937: d_position := 10;
1938:
1939: EXIT WHEN l_rowid_tbl.COUNT = 0;

Line 2124: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

2120: FETCH c_line_loc_intf
2121: BULK COLLECT
2122: INTO l_intf_line_tbl,
2123: l_intf_line_loc_tbl
2124: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
2125:
2126: EXIT WHEN l_intf_line_tbl.COUNT = 0;
2127:
2128: d_position := 40;