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 115: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);

111: IF (PO_LOG.d_proc) THEN
112: PO_LOG.proc_begin (d_module);
113: END IF;
114:
115: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
116:
117: IF (PO_PDOI_PARAMS.g_request.document_type <>
118: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
119: AND

Line 118: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

114:
115: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
116:
117: IF (PO_PDOI_PARAMS.g_request.document_type <>
118: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
119: AND
120: PO_PDOI_PARAMS.g_request.process_code =
121: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
122:

Line 121: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN

117: IF (PO_PDOI_PARAMS.g_request.document_type <>
118: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
119: AND
120: PO_PDOI_PARAMS.g_request.process_code =
121: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
122:
123: update_dependent_line_acc_flag; -- bug5149827 - Renamed the procedure
124: END IF;
125:

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

164:
165: d_position := 100;
166: PO_PDOI_UTL.commit_work;
167:
168: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
169:
170: IF (PO_LOG.d_proc) THEN
171: PO_LOG.proc_end (d_module);
172: END IF;

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

237: l_price_chg_accept_flag_tbl,
238: l_price_break_flag_tbl
239: FROM po_lines_interface
240: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
241: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
242: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
243: ORDER BY po_line_id, interface_line_id;
244:
245: IF (PO_LOG.d_stmt) THEN

Line 242: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

238: l_price_break_flag_tbl
239: FROM po_lines_interface
240: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
241: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
242: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
243: ORDER BY po_line_id, interface_line_id;
244:
245: IF (PO_LOG.d_stmt) THEN
246: PO_LOG.stmt(d_module, d_position, 'number of lines with notified status ',

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

291: FROM po_lines_interface parent_lines
292: WHERE lines.parent_interface_line_id =
293: parent_lines.interface_line_id )
294: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
295: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
296: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
297: AND lines.parent_interface_line_id IS NOT NULL;
298:
299: IF (PO_LOG.d_stmt) THEN

Line 296: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

292: WHERE lines.parent_interface_line_id =
293: parent_lines.interface_line_id )
294: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
295: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
296: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
297: AND lines.parent_interface_line_id IS NOT NULL;
298:
299: IF (PO_LOG.d_stmt) THEN
300: PO_LOG.stmt(d_module, d_position, '# of lines updated based on parent_intf_line_id',

Line 308: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED

304: d_position := 40;
305:
306: -- Reject all records that have not been accepted
307: UPDATE po_lines_interface
308: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
309: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
310: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
311: AND price_chg_accept_flag = 'N';
312:

Line 310: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

306: -- Reject all records that have not been accepted
307: UPDATE po_lines_interface
308: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
309: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
310: AND process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
311: AND price_chg_accept_flag = 'N';
312:
313: d_position := 30;
314: END IF;

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

353: PHI.process_code,
354: PHI.request_id
355: FROM po_headers_interface PHI
356: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
357: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
358: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
359: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
360: OR
361: PO_PDOI_PARAMS.g_request.batch_id IS NULL)

Line 358: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED

354: PHI.request_id
355: FROM po_headers_interface PHI
356: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
357: AND NVL(PHI.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
358: PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
359: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
360: OR
361: PO_PDOI_PARAMS.g_request.batch_id IS NULL)
362: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code

Line 365: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>

361: PO_PDOI_PARAMS.g_request.batch_id IS NULL)
362: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code
363: OR
364: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
365: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>
366: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
367: AND
368: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
369: OR

Line 366: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

362: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code
363: OR
364: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
365: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>
366: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
367: AND
368: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
369: OR
370: PHI.process_code IS NULL)

Line 368: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)

364: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
365: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>
366: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
367: AND
368: PHI.process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
369: OR
370: PHI.process_code IS NULL)
371: AND (PHI.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
372: OR

Line 386: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED

382: -- request
383: -- bug5463188
384: -- Buyer acceptance process shouldn't worry about the calling module
385: AND ( PO_PDOI_PARAMS.g_request.process_code =
386: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
387: OR
388: DECODE (PHI.interface_source_code,
389: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
390: 1, 2) =

Line 389: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,

385: AND ( PO_PDOI_PARAMS.g_request.process_code =
386: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
387: OR
388: DECODE (PHI.interface_source_code,
389: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
390: 1, 2) =
391: DECODE (PO_PDOI_PARAMS.g_request.calling_module,
392: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
393: 1, 2));

Line 392: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,

388: DECODE (PHI.interface_source_code,
389: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
390: 1, 2) =
391: DECODE (PO_PDOI_PARAMS.g_request.calling_module,
392: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD,
393: 1, 2));
394:
395:
396: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 435: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

431: BULK COLLECT
432: INTO l_intf_header_id_tbl,
433: l_process_code_tbl,
434: l_request_id_tbl
435: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
436:
437: EXIT WHEN l_intf_header_id_tbl.COUNT = 0;
438:
439: -- Filter the list further more to only return records that are

Line 452: process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS,

448: -- Header level assignment
449: FORALL i IN 1..l_intf_header_id_tbl.COUNT
450: UPDATE po_headers_interface
451: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
452: process_code = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS,
453: processing_round_num = NULL, -- reset processing number
454: request_id = FND_GLOBAL.conc_request_id,
455: approval_status = NVL(approval_status,
456: PO_PDOI_PARAMS.g_request.approved_status)

Line 470: PO_PDOI_CONSTANTS.g_action_ADD, action,

466: FORALL i IN 1..l_intf_header_id_tbl.COUNT
467: UPDATE po_lines_interface
468: SET processing_id = PO_PDOI_PARAMS.g_processing_id,
469: action = DECODE (action,
470: PO_PDOI_CONSTANTS.g_action_ADD, action,
471: NULL), -- null out process code unless it is force add
472: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,
473: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
474: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

Line 473: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,

469: action = DECODE (action,
470: PO_PDOI_CONSTANTS.g_action_ADD, action,
471: NULL), -- null out process code unless it is force add
472: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,
473: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
474: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
475: process_code) -- bug5149827
476: WHERE interface_header_id = l_intf_header_id_tbl(i)
477: AND (PO_PDOI_PARAMS.g_request.process_code = process_code

Line 474: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

470: PO_PDOI_CONSTANTS.g_action_ADD, action,
471: NULL), -- null out process code unless it is force add
472: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,
473: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
474: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
475: process_code) -- bug5149827
476: WHERE interface_header_id = l_intf_header_id_tbl(i)
477: AND (PO_PDOI_PARAMS.g_request.process_code = process_code
478: OR

Line 480: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>

476: WHERE interface_header_id = l_intf_header_id_tbl(i)
477: AND (PO_PDOI_PARAMS.g_request.process_code = process_code
478: OR
479: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
480: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))

Line 481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND

477: AND (PO_PDOI_PARAMS.g_request.process_code = process_code
478: OR
479: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
480: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

Line 482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

478: OR
479: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
480: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

Line 483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

479: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
480: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)

Line 484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))

480: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) <>
481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
488: OR

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

481: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
488: OR
489: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND

Line 486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

482: NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
488: OR
489: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
490: NVL(price_chg_accept_flag, 'N') = 'Y'))

Line 487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)

483: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
484: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)))
485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
488: OR
489: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
490: NVL(price_chg_accept_flag, 'N') = 'Y'))
491: RETURNING interface_line_id

Line 489: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND

485: AND (NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
486: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
487: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT)
488: OR
489: (process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED AND
490: NVL(price_chg_accept_flag, 'N') = 'Y'))
491: RETURNING interface_line_id
492: BULK COLLECT INTO l_intf_line_id_tbl;
493:

Line 524: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

520: END IF;
521:
522: d_position := 70;
523: IF (PO_PDOI_PARAMS.g_request.document_type =
524: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
525: FORALL i IN 1..l_intf_line_id_tbl.COUNT
526: UPDATE po_distributions_interface
527: SET processing_id = PO_PDOI_PARAMS.g_processing_id
528: WHERE interface_line_id = l_intf_line_id_tbl(i);

Line 538: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

534: END IF;
535:
536: d_position := 80;
537: IF (PO_PDOI_PARAMS.g_request.document_type <>
538: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
539:
540: d_position := 90;
541: FORALL i IN 1..l_intf_line_id_tbl.COUNT
542: UPDATE po_attr_values_interface

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

625:
626: FOR i IN 1..x_intf_header_id_tbl.COUNT LOOP
627: d_position := 10;
628:
629: IF (p_process_code_tbl(i) = PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS) THEN
630:
631: l_old_request_complete := PO_PDOI_UTL.is_old_request_complete
632: ( p_old_request_id => p_request_id_tbl(i)
633: );

Line 707: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

703: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
704: AND (action IS NULL
705: OR
706: (PO_PDOI_PARAMS.g_request.document_type IN
707: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,

Line 708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND

704: AND (action IS NULL
705: OR
706: (PO_PDOI_PARAMS.g_request.document_type IN
707: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))

Line 709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

705: OR
706: (PO_PDOI_PARAMS.g_request.document_type IN
707: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR

Line 710: PO_PDOI_CONSTANTS.g_ACTION_ADD,

706: (PO_PDOI_PARAMS.g_request.document_type IN
707: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND

Line 711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,

707: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))

708: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND
709: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
716: PO_PDOI_CONSTANTS.g_ACTION_ADD,

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

710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
716: PO_PDOI_CONSTANTS.g_ACTION_ADD,
717: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
718:

Line 715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
716: PO_PDOI_CONSTANTS.g_ACTION_ADD,
717: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
718:
719: d_position := 10;

Line 716: PO_PDOI_CONSTANTS.g_ACTION_ADD,

712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
716: PO_PDOI_CONSTANTS.g_ACTION_ADD,
717: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
718:
719: d_position := 10;
720:

Line 717: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));

713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
716: PO_PDOI_CONSTANTS.g_ACTION_ADD,
717: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
718:
719: d_position := 10;
720:
721: IF (PO_LOG.d_stmt) THEN

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

723: l_reject_tbl.COUNT);
724: END IF;
725:
726: FOR i IN 1..l_reject_tbl.COUNT LOOP
727: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
728: AND
729: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
730:
731: l_message_name := 'PO_PDOI_STD_ACTION';

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

725:
726: FOR i IN 1..l_reject_tbl.COUNT LOOP
727: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
728: AND
729: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
730:
731: l_message_name := 'PO_PDOI_STD_ACTION';
732: ELSE
733: l_message_name := 'PO_PDOI_INVALID_ACTION';

Line 749: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

745: END LOOP;
746:
747: d_position := 30;
748: PO_PDOI_UTL.reject_headers_intf
749: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
750: p_id_tbl => l_reject_tbl,
751: p_cascade => FND_API.G_TRUE);
752:
753: IF (PO_LOG.d_proc) THEN

Line 911: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

907:
908: d_position := 40;
909: -- For records that cannot derive vendor id, reject header and its children
910: PO_PDOI_UTL.reject_headers_intf
911: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
912: p_id_tbl => l_reject_list,
913: p_cascade => FND_API.G_TRUE
914: );
915:

Line 989: AND action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE;

985: BULK COLLECT INTO l_interface_header_id_tbl, l_vendor_id_tbl,
986: l_start_date_tbl, l_end_date_tbl, l_vendor_doc_num_tbl
987: FROM po_headers_interface
988: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
989: AND action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE;
990:
991: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN
992: d_position := 10;
993: RETURN;

Line 1042: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1038:
1039: IF (l_valid = FND_API.G_TRUE) THEN
1040:
1041: IF (PO_PDOI_PARAMS.g_request.document_type =
1042: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1043:
1044: d_position := 60;
1045:
1046: -- Quotation: Match vendor doc num with quote_vendor_quote_number

Line 1063: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

1059: AND TRUNC(l_start_date_tbl(i)) >= TRUNC(NVL(start_date, SYSDATE))
1060: AND TRUNC(NVL(l_end_date_tbl(i), SYSDATE)) <= TRUNC(NVL(end_date, SYSDATE));
1061:
1062: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1063: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1064:
1065: d_position := 70;
1066: -- Blanket: Match vendor doc num with vendor_order_num
1067: SELECT po_header_id,

Line 1149: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

1145: -- date greater than the start date of the newly replaced blanket, whcih
1146: -- is equivalent to the end date of the old blanket
1147:
1148: IF (PO_PDOI_PARAMS.g_request.document_type =
1149: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1150:
1151: d_position := 120;
1152: check_release_dates
1153: ( p_interface_header_id => l_interface_header_id_tbl(i),

Line 1194: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

1190:
1191: d_position := 160;
1192: -- propagate errors to lower level
1193: PO_PDOI_UTL.reject_headers_intf
1194: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1195: p_id_tbl => l_reject_list,
1196: p_cascade => FND_API.G_TRUE
1197: );
1198:

Line 1402: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

1398: l_vendor_doc_num_tbl,
1399: l_document_num_tbl
1400: FROM po_headers_interface
1401: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1402: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
1403:
1404: IF (l_interface_header_id_tbl IS NULL OR l_interface_header_id_tbl.COUNT = 0) THEN
1405: d_position := 10;
1406: RETURN;

Line 1410: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN

1406: RETURN;
1407: END IF;
1408:
1409: IF (PO_PDOI_PARAMS.g_request.calling_module =
1410: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1411: l_skip_cat_upload_chk := FND_API.G_TRUE;
1412: ELSE
1413: l_skip_cat_upload_chk := FND_API.G_FALSE;
1414: END IF;

Line 1456: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1452: d_position := 30;
1453:
1454: IF (l_valid = FND_API.g_TRUE) THEN
1455: IF (PO_PDOI_PARAMS.g_request.document_type IN
1456: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1457: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1458:
1459: d_position := 40;
1460:

Line 1457: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

1453:
1454: IF (l_valid = FND_API.g_TRUE) THEN
1455: IF (PO_PDOI_PARAMS.g_request.document_type IN
1456: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1457: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1458:
1459: d_position := 40;
1460:
1461: PO_PDOI_UTL.get_processing_doctype_info

Line 1495: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1491: IF (l_valid <> FND_API.g_TRUE) THEN
1492: d_position := 70;
1493:
1494: IF (PO_PDOI_PARAMS.g_request.document_type =
1495: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1496: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1497: ELSE
1498: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1499: END IF;

Line 1537: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1533: IF (l_vendor_doc_num_tbl(i) IS NOT NULL) THEN
1534: -- Definitely need to match vendor doc num. Matching document num
1535: -- will be performed, if provided
1536: IF (PO_PDOI_PARAMS.g_request.document_type IN
1537: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1538: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1539:
1540: d_position := 90;
1541: SELECT POH.po_header_id,

Line 1538: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN

1534: -- Definitely need to match vendor doc num. Matching document num
1535: -- will be performed, if provided
1536: IF (PO_PDOI_PARAMS.g_request.document_type IN
1537: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1538: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1539:
1540: d_position := 90;
1541: SELECT POH.po_header_id,
1542: NVL(POH.consigned_consumption_flag, 'N')

Line 1562: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1558: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1559: AND NVL(POH.cancel_flag, 'N') <> 'Y';
1560:
1561: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1562: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1563: d_position := 100;
1564: SELECT POH.po_header_id,
1565: NVL(POH.consigned_consumption_flag, 'N')
1566: BULK COLLECT

Line 1590: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1586: -- Definitely need to match document num. Matching vendor doc num
1587: -- will be performed, if provided
1588:
1589: IF (PO_PDOI_PARAMS.g_request.document_type IN
1590: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1591: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1592:
1593: SELECT POH.po_header_id,
1594: NVL(POH.consigned_consumption_flag, 'N')

Line 1591: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN

1587: -- will be performed, if provided
1588:
1589: IF (PO_PDOI_PARAMS.g_request.document_type IN
1590: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1591: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1592:
1593: SELECT POH.po_header_id,
1594: NVL(POH.consigned_consumption_flag, 'N')
1595: BULK COLLECT

Line 1616: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1612: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1613: AND NVL(POH.cancel_flag, 'N') <> 'Y';
1614:
1615: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1616: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1617:
1618: SELECT POH.po_header_id,
1619: NVL(POH.consigned_consumption_flag, 'N')
1620: BULK COLLECT

Line 1659: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1655:
1656: IF (l_orig_po_header_id_tbl.COUNT <> 1) THEN
1657: IF (l_orig_po_header_id_tbl.COUNT = 0) THEN
1658: IF (PO_PDOI_PARAMS.g_request.document_type =
1659: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1660: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1661: ELSE
1662: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1663: END IF;

Line 1666: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1662: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1663: END IF;
1664: ELSE
1665: IF (PO_PDOI_PARAMS.g_request.document_type =
1666: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1667: l_message_name := 'PO_PDOI_MULTIPLE_STD_PO';
1668: ELSE
1669: l_message_name := 'PO_PDOI_INVALID_MULT_ORIG_CATG';
1670: END IF;

Line 1689: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1685: END IF;
1686:
1687: IF (l_valid = FND_API.g_TRUE) THEN
1688: IF (PO_PDOI_PARAMS.g_request.document_type IN
1689: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1690: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1691:
1692: d_position := 140;
1693:

Line 1690: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

1686:
1687: IF (l_valid = FND_API.g_TRUE) THEN
1688: IF (PO_PDOI_PARAMS.g_request.document_type IN
1689: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1690: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1691:
1692: d_position := 140;
1693:
1694: PO_PDOI_UTL.get_processing_doctype_info

Line 1720: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1716: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR
1717: l_status_rec.updatable_flag(1) = 'N') THEN
1718:
1719: IF (PO_PDOI_PARAMS.g_request.document_type =
1720: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1721: l_message_name := 'PO_PDOI_STD_PO_INVALID_STATUS';
1722: ELSE
1723: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1724: END IF;

Line 1770: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

1766:
1767: d_position := 190;
1768: -- propagate rejection status to lower level
1769: PO_PDOI_UTL.reject_headers_intf
1770: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1771: p_id_tbl => l_reject_list,
1772: p_cascade => FND_API.G_TRUE
1773: );
1774:

Line 1820: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1816: PO_LOG.proc_begin (d_module);
1817: END IF;
1818:
1819: IF (PO_PDOI_PARAMS.g_request.document_type =
1820: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1821:
1822: SELECT POH.po_header_id,
1823: PHI.interface_header_id,
1824: PHI.vendor_doc_num

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

1836: TRUNC (NVL(POH.end_date, SYSDATE))
1837: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1838: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1839: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1840: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1841: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1842:
1843: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1844: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

Line 1841: PO_PDOI_CONSTANTS.g_ACTION_ADD);

1837: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1838: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1839: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1840: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1841: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1842:
1843: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1844: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1845:

Line 1844: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

1840: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1841: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1842:
1843: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1844: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1845:
1846: SELECT POH.po_header_id,
1847: PHI.interface_header_id,
1848: PHI.vendor_doc_num

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

1860: TRUNC (NVL(POH.end_date, SYSDATE))
1861: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1862: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1863: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1864: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1865: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1866:
1867: END IF;
1868:

Line 1865: PO_PDOI_CONSTANTS.g_ACTION_ADD);

1861: AND NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1862: AND NVL(POH.cancel_flag, 'N') <> 'Y'
1863: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
1864: AND PHI.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1865: PO_PDOI_CONSTANTS.g_ACTION_ADD);
1866:
1867: END IF;
1868:
1869: d_position := 10;

Line 1888: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

1884:
1885: -- propagate rejection status to lower level for each document getting
1886: -- rejected
1887: PO_PDOI_UTL.reject_headers_intf
1888: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1889: p_id_tbl => l_reject_list,
1890: p_cascade => FND_API.G_TRUE
1891: );
1892:

Line 1939: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

1935: UPDATE po_headers_interface
1936: SET po_header_id = PO_HEADERS_S.nextval
1937: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1938: AND po_header_id IS NULL
1939: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1940: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1941: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1942:
1943: IF (PO_LOG.d_proc) THEN

Line 1940: PO_PDOI_CONSTANTS.g_ACTION_ADD,

1936: SET po_header_id = PO_HEADERS_S.nextval
1937: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1938: AND po_header_id IS NULL
1939: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1940: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1941: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1942:
1943: IF (PO_LOG.d_proc) THEN
1944: PO_LOG.proc_end (d_module);

Line 1941: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);

1937: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1938: AND po_header_id IS NULL
1939: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1940: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1941: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1942:
1943: IF (PO_LOG.d_proc) THEN
1944: PO_LOG.proc_end (d_module);
1945: END IF;

Line 2024: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

2020: LOOP
2021: FETCH c_line_intf
2022: BULK COLLECT
2023: INTO l_rowid_tbl
2024: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
2025:
2026: d_position := 10;
2027:
2028: EXIT WHEN l_rowid_tbl.COUNT = 0;

Line 2274: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

2270: FETCH c_line_loc_intf
2271: BULK COLLECT
2272: INTO l_intf_line_tbl,
2273: l_intf_line_loc_tbl
2274: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
2275:
2276: EXIT WHEN l_intf_line_tbl.COUNT = 0;
2277:
2278: d_position := 40;

Line 3245: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,

3241: END IF;
3242: END LOOP;
3243:
3244: PO_PDOI_UTL.reject_headers_intf
3245: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
3246: p_id_tbl => l_reject_list,
3247: p_cascade => FND_API.G_TRUE
3248: );
3249: