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_PARAMS

Line 117: IF (PO_PDOI_PARAMS.g_request.document_type <>

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
120: PO_PDOI_PARAMS.g_request.process_code =
121: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN

Line 120: PO_PDOI_PARAMS.g_request.process_code =

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:
123: update_dependent_line_acc_flag; -- bug5149827 - Renamed the procedure
124: END IF;

Line 227: IF (PO_PDOI_PARAMS.g_request.interface_header_id IS NOT NULL) THEN

223: IF (PO_LOG.d_proc) THEN
224: PO_LOG.proc_begin (d_module);
225: END IF;
226:
227: IF (PO_PDOI_PARAMS.g_request.interface_header_id IS NOT NULL) THEN
228:
229: -- (1) Update price break acceptance flag according to the acceptance
230: -- status of the parent line
231:

Line 240: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id

236: INTO l_intf_line_id_tbl,
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:

Line 294: WHERE lines.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id

290: ( SELECT parent_lines.price_chg_accept_flag
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:

Line 309: WHERE interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id

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:
313: d_position := 30;

Line 356: WHERE PHI.org_id = PO_PDOI_PARAMS.g_request.org_id

352: SELECT PHI.interface_header_id,
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

Line 359: AND (PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_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
363: OR

Line 361: PO_PDOI_PARAMS.g_request.batch_id IS NULL)

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
363: OR
364: ( NVL(PO_PDOI_PARAMS.g_request.process_code,
365: PO_PDOI_CONSTANTS.g_process_code_PENDING) <>

Line 362: AND (PHI.process_code = PO_PDOI_PARAMS.g_request.process_code

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
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

Line 364: ( NVL(PO_PDOI_PARAMS.g_request.process_code,

360: OR
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)

Line 371: AND (PHI.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id

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
373: PO_PDOI_PARAMS.g_request.interface_header_id IS NULL)
374: AND (PHI.document_type_code = PO_PDOI_PARAMS.g_request.document_type
375: OR

Line 373: PO_PDOI_PARAMS.g_request.interface_header_id IS NULL)

369: OR
370: PHI.process_code IS NULL)
371: AND (PHI.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
372: OR
373: PO_PDOI_PARAMS.g_request.interface_header_id IS NULL)
374: AND (PHI.document_type_code = PO_PDOI_PARAMS.g_request.document_type
375: OR
376: PHI.document_type_code IS NULL)
377: AND (PHI.processing_id IS NULL

Line 374: AND (PHI.document_type_code = PO_PDOI_PARAMS.g_request.document_type

370: PHI.process_code IS NULL)
371: AND (PHI.interface_header_id = PO_PDOI_PARAMS.g_request.interface_header_id
372: OR
373: PO_PDOI_PARAMS.g_request.interface_header_id IS NULL)
374: AND (PHI.document_type_code = PO_PDOI_PARAMS.g_request.document_type
375: OR
376: PHI.document_type_code IS NULL)
377: AND (PHI.processing_id IS NULL
378: OR

Line 379: PHI.processing_id <> PO_PDOI_PARAMS.g_processing_id)

375: OR
376: PHI.document_type_code IS NULL)
377: AND (PHI.processing_id IS NULL
378: OR
379: PHI.processing_id <> PO_PDOI_PARAMS.g_processing_id)
380: -- bug5471513
381: -- Catalog uploaded records should only be processed by catalog upload
382: -- request
383: -- bug5463188

Line 385: AND ( PO_PDOI_PARAMS.g_request.process_code =

381: -- Catalog uploaded records should only be processed by catalog upload
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,

Line 391: DECODE (PO_PDOI_PARAMS.g_request.calling_module,

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));
394:
395:

Line 412: IF (PO_PDOI_PARAMS.g_request.batch_id IS NOT NULL) THEN

408: --
409: -- ECO 4420269
410: -- If batch id is specified, update the records that match the batch id but
411: -- do not have org_id specified.
412: IF (PO_PDOI_PARAMS.g_request.batch_id IS NOT NULL) THEN
413:
414: UPDATE po_headers_interface PHI
415: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
416: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id

Line 415: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id

411: -- do not have org_id specified.
412: IF (PO_PDOI_PARAMS.g_request.batch_id IS NOT NULL) THEN
413:
414: UPDATE po_headers_interface PHI
415: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
416: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
417: AND PHI.org_id IS NULL;
418:
419: IF (PO_LOG.d_stmt) THEN

Line 416: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id

412: IF (PO_PDOI_PARAMS.g_request.batch_id IS NOT NULL) THEN
413:
414: UPDATE po_headers_interface PHI
415: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
416: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
417: AND PHI.org_id IS NULL;
418:
419: IF (PO_LOG.d_stmt) THEN
420: PO_LOG.stmt(d_module, d_position, 'updatec org id for ' ||

Line 451: SET processing_id = PO_PDOI_PARAMS.g_processing_id,

447: d_position := 30;
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,

Line 456: PO_PDOI_PARAMS.g_request.approved_status)

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)
457: WHERE interface_header_id = l_intf_header_id_tbl(i);
458:
459: IF (PO_LOG.d_stmt) THEN
460: PO_LOG.stmt(d_module, d_position, 'after header assignment. Updated ' ||

Line 468: SET processing_id = PO_PDOI_PARAMS.g_processing_id,

464: d_position := 40;
465: -- Line level assignment
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,

Line 472: process_code = DECODE (PO_PDOI_PARAMS.g_request.process_code,

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,
475: process_code) -- bug5149827
476: WHERE interface_header_id = l_intf_header_id_tbl(i)

Line 477: AND (PO_PDOI_PARAMS.g_request.process_code = 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
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

Line 479: ( NVL(PO_PDOI_PARAMS.g_request.process_code,

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
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,

Line 503: SET processing_id = PO_PDOI_PARAMS.g_processing_id

499:
500: d_position := 50;
501: FORALL i IN 1..l_intf_line_id_tbl.COUNT
502: UPDATE po_line_locations_interface
503: SET processing_id = PO_PDOI_PARAMS.g_processing_id
504: WHERE interface_line_id = l_intf_line_id_tbl(i);
505:
506: IF (PO_LOG.d_stmt) THEN
507: PO_LOG.stmt(d_module, d_position, 'after line location assignment. ' ||

Line 514: SET processing_id = PO_PDOI_PARAMS.g_processing_id

510:
511: d_position := 60;
512: FORALL i IN 1..l_intf_line_id_tbl.COUNT
513: UPDATE po_price_diff_interface
514: SET processing_id = PO_PDOI_PARAMS.g_processing_id
515: WHERE interface_line_id = l_intf_line_id_tbl(i);
516:
517: IF (PO_LOG.d_stmt) THEN
518: PO_LOG.stmt(d_module, d_position, 'after price diff assignment. ' ||

Line 523: IF (PO_PDOI_PARAMS.g_request.document_type =

519: 'Updated ' || SQL%ROWCOUNT || ' records');
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

Line 527: SET processing_id = PO_PDOI_PARAMS.g_processing_id

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);
529:
530: IF (PO_LOG.d_stmt) THEN
531: PO_LOG.stmt(d_module, d_position, 'after distirbution assignment. ' ||

Line 537: IF (PO_PDOI_PARAMS.g_request.document_type <>

533: END IF;
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

Line 543: SET processing_id = PO_PDOI_PARAMS.g_processing_id

539:
540: d_position := 90;
541: FORALL i IN 1..l_intf_line_id_tbl.COUNT
542: UPDATE po_attr_values_interface
543: SET processing_id = PO_PDOI_PARAMS.g_processing_id
544: WHERE interface_line_id = l_intf_line_id_tbl(i);
545:
546: IF (PO_LOG.d_stmt) THEN
547: PO_LOG.stmt(d_module, d_position, 'after attr value assignment. ' ||

Line 554: SET processing_id = PO_PDOI_PARAMS.g_processing_id

550:
551: d_position := 100;
552: FORALL i IN 1..l_intf_line_id_tbl.COUNT
553: UPDATE po_attr_values_tlp_interface
554: SET processing_id = PO_PDOI_PARAMS.g_processing_id
555: WHERE interface_line_id = l_intf_line_id_tbl(i);
556:
557: IF (PO_LOG.d_stmt) THEN
558: PO_LOG.stmt(d_module, d_position, 'after attr values tlp assignment.' ||

Line 703: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

699: SELECT interface_header_id, action
700: BULK COLLECT
701: INTO l_reject_tbl, l_action_tbl
702: FROM po_headers_interface
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,

Line 706: (PO_PDOI_PARAMS.g_request.document_type IN

702: FROM po_headers_interface
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,

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 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 831: AND processing_id = PO_PDOI_PARAMS.g_processing_id;

827: WHERE vendor_id IS NULL
828: AND po_header_id IS NULL -- if po_header_id is already provided,
829: -- skip vendor_id derivation as it is
830: -- not needed
831: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
832:
833: d_position := 10;
834:
835: PO_PDOI_UTL.generate_ordered_num_list

Line 850: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

846: );
847:
848: --CLM PDOI Changes Start
849: d_position := 12;
850: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
851: THEN
852: PO_PDOI_HEADER_PROCESS_PVT.derive_clm_source_document_id
853: (
854: p_key => l_key,

Line 988: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

984: vendor_doc_num
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;

Line 1041: IF (PO_PDOI_PARAMS.g_request.document_type =

1037: d_position := 50;
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:

Line 1062: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

1058: AND quote_vendor_quote_number = l_vendor_doc_num_tbl(i)
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

Line 1148: IF (PO_PDOI_PARAMS.g_request.document_type =

1144: -- For blanket, make sure that all releases should not have release
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

Line 1401: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

1397: l_po_header_id_tbl,
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;

Line 1409: IF (PO_PDOI_PARAMS.g_request.calling_module =

1405: d_position := 10;
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;

Line 1440: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type;

1436: INTO l_existing_header,
1437: l_consigned_consumption_flag
1438: FROM po_headers POH
1439: WHERE POH.po_header_id = l_po_header_id_tbl(i)
1440: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type;
1441:
1442: IF (l_existing_header = 'N' OR l_consigned_consumption_flag = 'Y') THEN
1443:
1444: IF (PO_LOG.d_stmt) THEN

Line 1455: IF (PO_PDOI_PARAMS.g_request.document_type IN

1451:
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;

Line 1473: p_role => PO_PDOI_PARAMS.g_request.role,

1469: p_document_type => l_doc_type,
1470: p_document_subtype => l_doc_subtype,
1471: p_mode => 'CHECK_UPDATEABLE',
1472: p_calling_module => PO_DRAFTS_PVT.g_call_mod_PDOI,
1473: p_role => PO_PDOI_PARAMS.g_request.role,
1474: p_skip_cat_upload_chk => l_skip_cat_upload_chk,
1475: x_po_status_rec => l_status_rec,
1476: x_return_status => l_return_status
1477: );

Line 1494: IF (PO_PDOI_PARAMS.g_request.document_type =

1490:
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';

Line 1536: IF (PO_PDOI_PARAMS.g_request.document_type IN

1532:
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;

Line 1550: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

1546: FROM po_headers POH
1547: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1548: AND POH.vendor_order_num = l_vendor_doc_num_tbl(i)
1549: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1550: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1551: AND (POH.type_lookup_code = 'STANDARD'
1552: OR
1553: (POH.type_lookup_code = 'BLANKET'
1554: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=

Line 1561: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

1557: TRUNC(nvl(POH.end_date, SYSDATE))))
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')

Line 1573: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

1569: FROM po_headers POH
1570: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1571: AND POH.quote_vendor_quote_number = l_vendor_doc_num_tbl(i)
1572: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1573: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1574: AND POH.type_lookup_code = 'QUOTATION'
1575: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=
1576: TRUNC(NVL(POH.start_date, SYSDATE))
1577: AND TRUNC(nvl(l_end_date_tbl(i), SYSDATE)) <=

Line 1589: IF (PO_PDOI_PARAMS.g_request.document_type IN

1585: d_position := 110;
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,

Line 1604: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

1600: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1601: NVL(l_vendor_doc_num_tbl(i),
1602: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))
1603: AND POH.segment1 = l_document_num_tbl(i)
1604: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1605: AND (POH.type_lookup_code = 'STANDARD'
1606: OR
1607: (POH.type_lookup_code = 'BLANKET'
1608: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=

Line 1615: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

1611: TRUNC(nvl(POH.end_date, SYSDATE))))
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')

Line 1629: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

1625: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1626: NVL(l_vendor_doc_num_tbl(i),
1627: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))
1628: AND POH.segment1 = l_document_num_tbl(i)
1629: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1630: AND POH.type_lookup_code = 'QUOTATION'
1631: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=
1632: TRUNC(NVL(POH.start_date, SYSDATE))
1633: AND TRUNC(nvl(l_end_date_tbl(i), SYSDATE)) <=

Line 1658: IF (PO_PDOI_PARAMS.g_request.document_type =

1654: END IF;
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';

Line 1665: IF (PO_PDOI_PARAMS.g_request.document_type =

1661: ELSE
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';

Line 1688: IF (PO_PDOI_PARAMS.g_request.document_type IN

1684: l_valid := FND_API.g_FALSE;
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;

Line 1706: p_role => PO_PDOI_PARAMS.g_request.role,

1702: p_document_type => l_doc_type,
1703: p_document_subtype => l_doc_subtype,
1704: p_mode => 'CHECK_UPDATEABLE',
1705: p_calling_module => PO_DRAFTS_PVT.g_call_mod_PDOI,
1706: p_role => PO_PDOI_PARAMS.g_request.role,
1707: p_skip_cat_upload_chk => l_skip_cat_upload_chk,
1708: x_po_status_rec => l_status_rec,
1709: x_return_status => l_return_status
1710: );

Line 1719: IF (PO_PDOI_PARAMS.g_request.document_type =

1715: ELSE
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';

Line 1819: IF (PO_PDOI_PARAMS.g_request.document_type =

1815: IF (PO_LOG.d_proc) 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,

Line 1839: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id

1835: AND TRUNC (NVL(PHI.expiration_date, SYSDATE)) <=
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 =

Line 1843: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

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:
1846: SELECT POH.po_header_id,
1847: PHI.interface_header_id,

Line 1863: AND PHI.processing_id = PO_PDOI_PARAMS.g_processing_id

1859: AND TRUNC (NVL(PHI.expiration_date, SYSDATE)) <=
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;

Line 1937: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

1933: -- For ORIGINAL, ADD or REPLACE action, new document will be created
1934: -- Need to assign a new po_header_id
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);

Line 1985: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

1981: -- for processing later on
1982: CURSOR c_line_intf IS
1983: SELECT rowid
1984: FROM po_lines_interface
1985: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
1986: AND NVL(line_loc_populated_flag, 'N') = 'N';
1987:
1988: --SQL What: Get line location records that are just being populated
1989: --SQL Why: Need to populate interface_line_location_id to po distributions and

Line 1997: WHERE PLLI.processing_id = PO_PDOI_PARAMS.g_processing_id

1993: SELECT PLLI.interface_line_id,
1994: PLLI.interface_line_location_id
1995: FROM po_line_locations_interface PLLI,
1996: po_lines_interface PLI
1997: WHERE PLLI.processing_id = PO_PDOI_PARAMS.g_processing_id
1998: AND PLLI.interface_line_id = PLI.interface_line_id
1999: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
2000:
2001: l_rowid_tbl DBMS_SQL.urowid_table;

Line 2381: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

2377: -- Since the default line location has been populated,
2378: -- populate 'S' to line_loc_populated_flag
2379: UPDATE po_lines_interface
2380: SET line_loc_populated_flag = 'S'
2381: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
2382: AND NVL(line_loc_populated_flag, 'N') = 'N';
2383:
2384: IF (PO_LOG.d_proc) THEN
2385: PO_LOG.proc_end (d_module);

Line 3166: WHERE PLI.processing_id = PO_PDOI_PARAMS.g_processing_id

3162: l_line_num_disp_tbl,
3163: l_clm_info_flag_tbl,
3164: l_po_header_id_tbl
3165: FROM po_lines_interface PLI,po_headers_interface phi
3166: WHERE PLI.processing_id = PO_PDOI_PARAMS.g_processing_id
3167: AND PLI.interface_header_id = phi.interface_header_id
3168: ORDER BY PLI.interface_header_id, PLI.line_num_display;
3169:
3170: l_line_num_tbl.EXTEND(l_intf_line_id_tbl.Count);