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_LINE_PROCESS_PVT dependencies on PO_PDOI_PARAMS

Line 417: OPEN c_dup_lines_in_txn(PO_PDOI_PARAMS.g_processing_id,

413: PO_LOG.proc_begin(d_module);
414: END IF;
415:
416: -- first reject lines which are duplicate in txn table
417: OPEN c_dup_lines_in_txn(PO_PDOI_PARAMS.g_processing_id,
418: PO_PDOI_PARAMS.g_current_round_num);
419:
420: d_position := 10;
421:

Line 418: PO_PDOI_PARAMS.g_current_round_num);

414: END IF;
415:
416: -- first reject lines which are duplicate in txn table
417: OPEN c_dup_lines_in_txn(PO_PDOI_PARAMS.g_processing_id,
418: PO_PDOI_PARAMS.g_current_round_num);
419:
420: d_position := 10;
421:
422: LOOP

Line 486: OPEN c_dup_lines_in_draft(PO_PDOI_PARAMS.g_processing_id,

482:
483: d_position := 60;
484:
485: -- next, reject lines which are duplicate of lines in draft table
486: OPEN c_dup_lines_in_draft(PO_PDOI_PARAMS.g_processing_id,
487: PO_PDOI_PARAMS.g_current_round_num);
488:
489: d_position := 70;
490:

Line 487: PO_PDOI_PARAMS.g_current_round_num);

483: d_position := 60;
484:
485: -- next, reject lines which are duplicate of lines in draft table
486: OPEN c_dup_lines_in_draft(PO_PDOI_PARAMS.g_processing_id,
487: PO_PDOI_PARAMS.g_current_round_num);
488:
489: d_position := 70;
490:
491: LOOP

Line 614: OPEN c_invalid_action_lines(PO_PDOI_PARAMS.g_processing_id,

610: PO_LOG.proc_begin(d_module);
611: END IF;
612:
613: -- get all invalid lines from cursor
614: OPEN c_invalid_action_lines(PO_PDOI_PARAMS.g_processing_id,
615: PO_PDOI_PARAMS.g_current_round_num);
616:
617: d_position := 10;
618:

Line 615: PO_PDOI_PARAMS.g_current_round_num);

611: END IF;
612:
613: -- get all invalid lines from cursor
614: OPEN c_invalid_action_lines(PO_PDOI_PARAMS.g_processing_id,
615: PO_PDOI_PARAMS.g_current_round_num);
616:
617: d_position := 10;
618:
619: FETCH c_invalid_action_lines

Line 863: Decode(PO_PDOI_PARAMS.g_request.document_type,

859: intf_lines.clm_base_line_num,
860: intf_lines.clm_option_num,
861: intf_lines.clm_option_from_date,
862: intf_lines.clm_option_to_date,
863: Decode(PO_PDOI_PARAMS.g_request.document_type,
864: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
865: intf_lines.clm_idc_type),
866: intf_lines.line_num_display,
867: intf_lines.clm_funded_flag,

Line 896: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

892: po_headers_draft_all draft_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.draft_id = draft_headers.draft_id
895: AND intf_headers.po_header_id = draft_headers.po_header_id
896: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
897: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
898: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
899: AND intf_lines.interface_line_id > p_max_intf_line_id
900: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 897: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.draft_id = draft_headers.draft_id
895: AND intf_headers.po_header_id = draft_headers.po_header_id
896: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
897: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
898: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
899: AND intf_lines.interface_line_id > p_max_intf_line_id
900: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
901: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

Line 898: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

894: AND intf_headers.draft_id = draft_headers.draft_id
895: AND intf_headers.po_header_id = draft_headers.po_header_id
896: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
897: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
898: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
899: AND intf_lines.interface_line_id > p_max_intf_line_id
900: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
901: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
902: --PDOI CLM Integration

Line 1047: Decode(PO_PDOI_PARAMS.g_request.document_type,

1043: intf_lines.clm_base_line_num,
1044: intf_lines.clm_option_num,
1045: intf_lines.clm_option_from_date,
1046: intf_lines.clm_option_to_date,
1047: Decode(PO_PDOI_PARAMS.g_request.document_type,
1048: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1049: intf_lines.clm_idc_type),
1050: intf_lines.line_num_display,
1051: intf_lines.clm_funded_flag,

Line 1080: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

1076: po_headers_interface intf_headers,
1077: po_headers txn_headers
1078: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1079: AND intf_headers.po_header_id = txn_headers.po_header_id
1080: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1082: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1083: AND intf_lines.interface_line_id > p_max_intf_line_id
1084: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

Line 1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1077: po_headers txn_headers
1078: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1079: AND intf_headers.po_header_id = txn_headers.po_header_id
1080: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1082: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1083: AND intf_lines.interface_line_id > p_max_intf_line_id
1084: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1085: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

Line 1082: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1078: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1079: AND intf_headers.po_header_id = txn_headers.po_header_id
1080: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1082: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1083: AND intf_lines.interface_line_id > p_max_intf_line_id
1084: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1085: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
1086: --PDOI CLM Integration

Line 1085: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1082: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1083: AND intf_lines.interface_line_id > p_max_intf_line_id
1084: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1085: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
1086: --PDOI CLM Integration
1087: --Process only priced lines which in commercial flow are normal lines
1088: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'
1089: ORDER BY 1;

Line 1233: Decode(PO_PDOI_PARAMS.g_request.document_type,

1229: intf_lines.clm_base_line_num,
1230: intf_lines.clm_option_num,
1231: intf_lines.clm_option_from_date,
1232: intf_lines.clm_option_to_date,
1233: Decode(PO_PDOI_PARAMS.g_request.document_type,
1234: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1235: intf_lines.clm_idc_type),
1236: intf_lines.line_num_display,
1237: intf_lines.clm_funded_flag,

Line 1265: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

1261: po_headers_interface intf_headers,
1262: po_headers txn_headers
1263: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1264: AND intf_headers.po_header_id = txn_headers.po_header_id
1265: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1266: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1267: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1268: AND intf_lines.interface_line_id > p_max_intf_line_id
1269: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

Line 1266: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1262: po_headers txn_headers
1263: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1264: AND intf_headers.po_header_id = txn_headers.po_header_id
1265: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1266: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1267: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1268: AND intf_lines.interface_line_id > p_max_intf_line_id
1269: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1270: AND PO_PDOI_PARAMS.g_request.document_type IN

Line 1267: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1263: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1264: AND intf_headers.po_header_id = txn_headers.po_header_id
1265: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1266: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1267: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1268: AND intf_lines.interface_line_id > p_max_intf_line_id
1269: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1270: AND PO_PDOI_PARAMS.g_request.document_type IN
1271: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

Line 1270: AND PO_PDOI_PARAMS.g_request.document_type IN

1266: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1267: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1268: AND intf_lines.interface_line_id > p_max_intf_line_id
1269: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1270: AND PO_PDOI_PARAMS.g_request.document_type IN
1271: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1272: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1273: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
1274: --PDOI CLM Integration

Line 1423: Decode(PO_PDOI_PARAMS.g_request.document_type,

1419: intf_lines.clm_base_line_num,
1420: intf_lines.clm_option_num,
1421: intf_lines.clm_option_from_date,
1422: intf_lines.clm_option_to_date,
1423: Decode(PO_PDOI_PARAMS.g_request.document_type,
1424: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1425: intf_lines.clm_idc_type),
1426: intf_lines.line_num_display,
1427: intf_lines.clm_funded_flag,

Line 1455: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

1451: po_headers_interface intf_headers,
1452: po_headers txn_headers
1453: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1454: AND intf_headers.po_header_id = txn_headers.po_header_id
1455: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1456: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1457: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1458: AND intf_lines.interface_line_id > p_max_intf_line_id
1459: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

Line 1456: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1452: po_headers txn_headers
1453: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1454: AND intf_headers.po_header_id = txn_headers.po_header_id
1455: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1456: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1457: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1458: AND intf_lines.interface_line_id > p_max_intf_line_id
1459: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1460: AND PO_PDOI_PARAMS.g_request.document_type IN

Line 1457: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1453: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1454: AND intf_headers.po_header_id = txn_headers.po_header_id
1455: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1456: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1457: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1458: AND intf_lines.interface_line_id > p_max_intf_line_id
1459: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1460: AND PO_PDOI_PARAMS.g_request.document_type IN
1461: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

Line 1460: AND PO_PDOI_PARAMS.g_request.document_type IN

1456: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1457: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1458: AND intf_lines.interface_line_id > p_max_intf_line_id
1459: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1460: AND PO_PDOI_PARAMS.g_request.document_type IN
1461: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1462: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1463: AND intf_lines.action IS NULL
1464: AND NOT (intf_lines.item IS NULL AND

Line 1616: Decode(PO_PDOI_PARAMS.g_request.document_type,

1612: intf_lines.clm_base_line_num,
1613: intf_lines.clm_option_num,
1614: intf_lines.clm_option_from_date,
1615: intf_lines.clm_option_to_date,
1616: Decode(PO_PDOI_PARAMS.g_request.document_type,
1617: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1618: intf_lines.clm_idc_type),
1619: intf_lines.line_num_display,
1620: intf_lines.clm_funded_flag,

Line 1648: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

1644: po_headers_interface intf_headers,
1645: po_headers txn_headers
1646: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1647: AND intf_headers.po_header_id = txn_headers.po_header_id
1648: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1649: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1650: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1651: AND intf_lines.interface_line_id > p_max_intf_line_id
1652: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

Line 1649: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1645: po_headers txn_headers
1646: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1647: AND intf_headers.po_header_id = txn_headers.po_header_id
1648: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1649: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1650: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1651: AND intf_lines.interface_line_id > p_max_intf_line_id
1652: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1653: AND PO_PDOI_PARAMS.g_request.document_type IN

Line 1650: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1646: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1647: AND intf_headers.po_header_id = txn_headers.po_header_id
1648: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1649: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1650: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1651: AND intf_lines.interface_line_id > p_max_intf_line_id
1652: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1653: AND PO_PDOI_PARAMS.g_request.document_type IN
1654: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

Line 1653: AND PO_PDOI_PARAMS.g_request.document_type IN

1649: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1650: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1651: AND intf_lines.interface_line_id > p_max_intf_line_id
1652: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1653: AND PO_PDOI_PARAMS.g_request.document_type IN
1654: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1655: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1656: AND intf_lines.action IS NULL
1657: AND intf_lines.item IS NULL

Line 1842: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

1838: po_headers_draft_all draft_headers
1839: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1840: AND intf_headers.draft_id = draft_headers.draft_id
1841: AND intf_headers.po_header_id = draft_headers.po_header_id
1842: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1843: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1844: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1845: AND intf_lines.interface_line_id > p_max_intf_line_id
1846: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

Line 1843: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1839: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1840: AND intf_headers.draft_id = draft_headers.draft_id
1841: AND intf_headers.po_header_id = draft_headers.po_header_id
1842: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1843: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1844: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1845: AND intf_lines.interface_line_id > p_max_intf_line_id
1846: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1847: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

Line 1844: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1840: AND intf_headers.draft_id = draft_headers.draft_id
1841: AND intf_headers.po_header_id = draft_headers.po_header_id
1842: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1843: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1844: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1845: AND intf_lines.interface_line_id > p_max_intf_line_id
1846: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1847: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
1848: and nvl(intf_lines.clm_info_flag,'N') = 'Y'

Line 2204: IF (PO_PDOI_PARAMS.g_request.document_type IN

2200:
2201:
2202: d_position := 70;
2203:
2204: IF (PO_PDOI_PARAMS.g_request.document_type IN
2205: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2206: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2207: -- derive IP category_id from IP category_name
2208: derive_ip_category_id

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

2270: p_template_name_tbl => x_lines.template_name_tbl,
2271: x_template_id_tbl => x_lines.template_id_tbl
2272: );
2273: --CLM PDOI Integration Starts
2274: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
2275: THEN
2276: derive_contract_type
2277: (
2278: p_key => l_key,

Line 2351: PO_PDOI_PARAMS.g_request.create_items = 'N') THEN

2347:
2348: -- derivation error for item_id
2349: IF (x_lines.item_tbl(i) IS NOT NULL AND
2350: x_lines.item_id_tbl(i) IS NULL AND
2351: PO_PDOI_PARAMS.g_request.create_items = 'N') THEN
2352: IF (PO_LOG.d_stmt) THEN
2353: PO_LOG.stmt(d_module, d_position, 'item id derivation failed');
2354: PO_LOG.stmt(d_module, d_position, 'item', x_lines.item_tbl(i));
2355: END IF;

Line 2452: IF (PO_PDOI_PARAMS.g_request.document_type IN

2448: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2449: END IF;
2450:
2451: -- derivation error for ip_category_id
2452: IF (PO_PDOI_PARAMS.g_request.document_type IN
2453: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2454: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2455: IF (x_lines.ip_category_tbl(i) IS NOT NULL AND
2456: x_lines.ip_category_id_tbl(i) IS NULL) THEN

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

2614: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2615: END IF;
2616:
2617: --CLM PDOI Integration Stsrts
2618: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
2619: THEN
2620: -- derivation error for contract_type
2621: IF (x_lines.contract_type_display_tbl(i) IS NOT NULL AND
2622: x_lines.contract_type_tbl(i) IS NULL) THEN

Line 2776: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'

2772:
2773: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2774: END IF;
2775:
2776: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'
2777: --CLM PDOI Integration Ends
2778: END LOOP;
2779:
2780: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

Line 2883: IF (PO_PDOI_PARAMS.g_request.document_type IN

2879:
2880:
2881: d_position := 20;
2882:
2883: IF (PO_PDOI_PARAMS.g_request.document_type IN
2884: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2885: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2886: -- derive IP category_id from IP category_name
2887: derive_ip_category_id

Line 2964: IF (PO_PDOI_PARAMS.g_request.document_type IN

2960: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2961: END IF;
2962:
2963: -- derivation error for ip_category_id
2964: IF (PO_PDOI_PARAMS.g_request.document_type IN
2965: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2966: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2967: IF (x_lines.ip_category_tbl(i) IS NOT NULL AND
2968: x_lines.ip_category_id_tbl(i) IS NULL) THEN

Line 3117: x_lines.line_type_id_tbl(i) := PO_PDOI_PARAMS.g_sys.line_type_id;

3113: IF (PO_LOG.d_stmt) THEN
3114: PO_LOG.stmt(d_module, d_position, 'set default line type id on line index', i);
3115: END IF;
3116:
3117: x_lines.line_type_id_tbl(i) := PO_PDOI_PARAMS.g_sys.line_type_id;
3118: END IF;
3119:
3120: -- initialize l_index_tbl
3121: l_index_tbl(i) := i;

Line 3181: IF (PO_PDOI_PARAMS.g_request.document_type IN

3177:
3178: l_ic_category_id_tbl := PO_TBL_NUMBER();
3179: l_ic_category_id_tbl.EXTEND(x_lines.rec_count);
3180:
3181: IF (PO_PDOI_PARAMS.g_request.document_type IN
3182: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3183: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
3184:
3185: d_position := 50;

Line 3276: PO_PDOI_PARAMS.g_sys.def_category_id);

3272: x_lines.category_id_tbl(i) :=
3273: COALESCE(x_lines.category_id_tbl(i), l_it_category_id_tbl(i),
3274: l_job_category_id_tbl(i), l_ic_category_id_tbl(i),
3275: l_li_category_id_tbl(i),
3276: PO_PDOI_PARAMS.g_sys.def_category_id);
3277:
3278: IF (PO_LOG.d_stmt) THEN
3279: PO_LOG.stmt(d_module, d_position, 'default category id',
3280: x_lines.category_id_tbl(i));

Line 3291: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'N' THEN

3287: NVL(x_lines.hazard_class_id_tbl(i), l_it_hazard_class_id_tbl(i));
3288:
3289: -- set from_header_id and from_line_id to NULL
3290: --CLM PDOI Integration
3291: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'N' THEN
3292: x_lines.from_header_id_tbl(i) := NULL;
3293: x_lines.from_line_id_tbl(i) := NULL;
3294: END IF;
3295:

Line 3299: IF (PO_PDOI_PARAMS.g_request.document_type IN

3295:
3296: d_position := 70;
3297:
3298: -- the following default logic is for BLANKET/STANDARD only
3299: IF (PO_PDOI_PARAMS.g_request.document_type IN
3300: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3301: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
3302: d_position := 80;
3303:

Line 3312: IF (PO_PDOI_PARAMS.g_request.document_type =

3308: -- default list_price_per_unit
3309: IF (x_lines.list_price_per_unit_tbl(i) IS NULL) THEN
3310: IF (x_lines.item_id_tbl(i) IS NULL) THEN
3311: x_lines.list_price_per_unit_tbl(i) := x_lines.unit_price_tbl(i);
3312: IF (PO_PDOI_PARAMS.g_request.document_type =
3313: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN -- bug 9374205
3314: -- bug 9194215
3315: If x_lines.hd_currency_code_tbl(i) is not null and (x_lines.list_price_per_unit_tbl(i) is not null and x_lines.list_price_per_unit_tbl(i) <> 0) THEN
3316: fnd_currency.get_info (x_lines.hd_currency_code_tbl(i),

Line 3342: IF (PO_PDOI_PARAMS.g_request.document_type =

3338: NVL(x_lines.capital_expense_flag_tbl(i), 'N');
3339:
3340: -- default min_release_amount, negotiated_flag and
3341: -- price_break_lookup_code for blanket
3342: IF (PO_PDOI_PARAMS.g_request.document_type =
3343: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
3344: d_position := 90;
3345:
3346: IF (PO_LOG.d_stmt) THEN

Line 3371: PO_PDOI_PARAMS.g_sys.price_break_lookup_code;

3367: x_lines.purchase_basis_tbl(i) = 'SERVICES')) THEN
3368: x_lines.price_break_lookup_code_tbl(i) := NULL;
3369: ELSE
3370: x_lines.price_break_lookup_code_tbl(i) :=
3371: PO_PDOI_PARAMS.g_sys.price_break_lookup_code;
3372: END IF;
3373: END IF;
3374: ELSE
3375: -- default tax_attribute_update_code for SPO

Line 3391: NVL(x_lines.price_type_tbl(i), PO_PDOI_PARAMS.g_sys.price_type_lookup_code);

3387: NVL(x_lines.allow_price_override_flag_tbl(i), 'N');
3388:
3389: -- default price_type
3390: x_lines.price_type_tbl(i) :=
3391: NVL(x_lines.price_type_tbl(i), PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
3392:
3393: -- default closed_code
3394: x_lines.closed_code_tbl(i) :=
3395: NVL(x_lines.closed_code_tbl(i), 'OPEN');

Line 3411: IF (PO_PDOI_PARAMS.g_request.document_type IN

3407: END IF;
3408: END LOOP;
3409:
3410:
3411: IF (PO_PDOI_PARAMS.g_request.document_type IN
3412: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3413: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
3414:
3415: -- default ip category id from po category ids after all other defaulting

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

3462: );
3463:
3464: --CLM PDOI Integration Starts
3465:
3466: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
3467: THEN
3468: --default clm_option_indicator flag for base lines
3469: default_clm_option_indicator
3470: (

Line 3498: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'

3494: p_intf_line_id_tbl => x_lines.intf_line_id_tbl,
3495: x_from_header_id_tbl => x_lines.from_header_id_tbl
3496: );
3497:
3498: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'
3499: --CLM PDOI Integration Ends
3500:
3501: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
3502:

Line 3904: PO_PDOI_PARAMS.g_request.document_type);

3900:
3901: IF (x_lines.line_loc_populated_flag_tbl(i) = 'S') THEN
3902: IF (PO_LOG.d_stmt) THEN
3903: PO_LOG.stmt(d_module, d_position, 'document type',
3904: PO_PDOI_PARAMS.g_request.document_type);
3905: PO_LOG.stmt(d_module, d_position, 'order_type_lookup_code',
3906: x_lines.order_type_lookup_code_tbl(i));
3907: PO_LOG.stmt(d_module, d_position, 'action',
3908: x_lines.action_tbl(i));

Line 3915: IF (PO_PDOI_PARAMS.g_request.document_type =

3911: PO_LOG.stmt(d_module, d_position, 'shipment_num',
3912: x_lines.shipment_num_tbl(i));
3913: END IF;
3914: -- set to TRUE in certain conditions
3915: IF (PO_PDOI_PARAMS.g_request.document_type =
3916: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
3917: IF (x_lines.order_type_lookup_code_tbl(i) IN ('QUANTITY', 'RATE') AND
3918: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3919: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN

Line 3922: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

3918: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3919: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3920: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3921: END IF;
3922: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3923: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
3924: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR
3925: x_lines.quantity_tbl(i) > 0) THEN
3926: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

Line 3928: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

3924: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR
3925: x_lines.quantity_tbl(i) > 0) THEN
3926: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3927: END IF;
3928: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3929: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
3930: IF (x_lines.order_type_lookup_code_tbl(i) = 'QUANTITY' AND
3931: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3932: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

Line 4022: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =

4018: FOR i IN 1..x_lines.rec_count
4019: LOOP
4020: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
4021: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
4022: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
4023: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
4024: OR
4025: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
4026: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND

Line 4027: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =

4023: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
4024: OR
4025: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
4026: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
4027: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
4028: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
4029:
4030: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
4031: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

Line 4240: IF (PO_PDOI_PARAMS.g_request.document_type =

4236:
4237: -- If there is release shipment for a blanket line, and uom is changed,
4238: -- the existing matching line will be expired and the new line's action
4239: -- will be ADD instead of UPDATE
4240: IF (PO_PDOI_PARAMS.g_request.document_type =
4241: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
4242: d_position := 80;
4243:
4244: -- derive unit_of_measure from uom_code

Line 4565: l_inventory_org_id_tbl(i) := PO_PDOI_PARAMS.g_sys.master_inv_org_id;

4561:
4562: l_inventory_org_id_tbl.EXTEND(x_lines.intf_line_id_tbl.COUNT);
4563:
4564: FOR i IN 1..x_lines.intf_line_id_tbl.COUNT LOOP
4565: l_inventory_org_id_tbl(i) := PO_PDOI_PARAMS.g_sys.master_inv_org_id;
4566: END LOOP;
4567: l_lines.inventory_org_id := l_inventory_org_id_tbl;
4568:
4569: d_position := 20;

Line 4574: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;

4570:
4571: l_parameter_name_tbl.EXTEND(3);
4572: l_parameter_value_tbl.EXTEND(3);
4573: l_parameter_name_tbl(1) := 'CREATE_OR_UPDATE_ITEM';
4574: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
4575: l_parameter_name_tbl(2) := 'INVENTORY_ORG_ID';
4576: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
4577: l_parameter_name_tbl(3) := 'DOC_TYPE';
4578: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.document_type;

Line 4576: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416

4572: l_parameter_value_tbl.EXTEND(3);
4573: l_parameter_name_tbl(1) := 'CREATE_OR_UPDATE_ITEM';
4574: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
4575: l_parameter_name_tbl(2) := 'INVENTORY_ORG_ID';
4576: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
4577: l_parameter_name_tbl(3) := 'DOC_TYPE';
4578: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.document_type;
4579:
4580: d_position := 30;

Line 4578: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.document_type;

4574: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
4575: l_parameter_name_tbl(2) := 'INVENTORY_ORG_ID';
4576: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
4577: l_parameter_name_tbl(3) := 'DOC_TYPE';
4578: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.document_type;
4579:
4580: d_position := 30;
4581:
4582: PO_VALIDATIONS.validate_pdoi

Line 4585: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,

4581:
4582: PO_VALIDATIONS.validate_pdoi
4583: (
4584: p_lines => l_lines,
4585: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,
4586: p_action => p_action,
4587: p_parameter_name_tbl => l_parameter_name_tbl,
4588: p_parameter_value_tbl => l_parameter_value_tbl,
4589: x_result_type => l_result_type,

Line 4756: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

4752: FROM mtl_system_items_kfv
4753: WHERE p_item_tbl(i) IS NOT NULL
4754: AND x_item_id_tbl(i) IS NULL
4755: AND concatenated_segments = p_item_tbl(i)
4756: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
4757:
4758: d_position := 10;
4759:
4760: -- derive based on vendor_product_num

Line 4882: PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN

4878: FOR i IN 1..p_item_id_tbl.COUNT
4879: LOOP
4880: IF (p_item_id_tbl(i) IS NULL AND
4881: X_item_revision_tbl(i) IS NOT NULL AND
4882: PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
4883: IF (PO_LOG.d_stmt) THEN
4884: PO_LOG.stmt(d_module, d_position, 'index', i);
4885: PO_LOG.stmt(d_module, d_position, 'new item revision set to empty');
4886: END IF;

Line 5071: PO_PDOI_PARAMS.g_profile.xbg);

5067: -- execute different queries to derive job_id depending on profile and
5068: -- value of job_business_group_id
5069: IF (PO_LOG.d_stmt) THEN
5070: PO_LOG.stmt(d_module, d_position, 'business group profile value',
5071: PO_PDOI_PARAMS.g_profile.xbg);
5072: PO_LOG.stmt(d_module, d_position, 'fsp business_group_id',
5073: PO_PDOI_PARAMS.g_sys.def_business_group_id);
5074: END IF;
5075:

Line 5073: PO_PDOI_PARAMS.g_sys.def_business_group_id);

5069: IF (PO_LOG.d_stmt) THEN
5070: PO_LOG.stmt(d_module, d_position, 'business group profile value',
5071: PO_PDOI_PARAMS.g_profile.xbg);
5072: PO_LOG.stmt(d_module, d_position, 'fsp business_group_id',
5073: PO_PDOI_PARAMS.g_sys.def_business_group_id);
5074: END IF;
5075:
5076: -- bug 5489942: derive job_id from job_name based on
5077: -- line level language

Line 5078: IF (NVL(PO_PDOI_PARAMS.g_profile.xbg, 'N') = 'N') THEN

5074: END IF;
5075:
5076: -- bug 5489942: derive job_id from job_name based on
5077: -- line level language
5078: IF (NVL(PO_PDOI_PARAMS.g_profile.xbg, 'N') = 'N') THEN
5079: d_position := 10;
5080:
5081: -- derive job_id from job_name
5082: FORALL i IN 1..p_index_tbl.COUNT

Line 5094: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id

5090: AND x_job_id_tbl(i) IS NULL
5091: AND jobs_b.job_id = jobs_tl.job_id
5092: AND jobs_tl.language = NVL(p_file_line_language_tbl(i), userenv('LANG'))
5093: AND jobs_tl.name = p_job_name_tbl(i)
5094: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id
5095: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =
5096: DECODE(p_job_business_group_name_tbl(i), NULL,
5097: DECODE(x_job_business_group_id_tbl(i), NULL,
5098: PO_PDOI_PARAMS.g_sys.def_business_group_id,

Line 5095: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =

5091: AND jobs_b.job_id = jobs_tl.job_id
5092: AND jobs_tl.language = NVL(p_file_line_language_tbl(i), userenv('LANG'))
5093: AND jobs_tl.name = p_job_name_tbl(i)
5094: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id
5095: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =
5096: DECODE(p_job_business_group_name_tbl(i), NULL,
5097: DECODE(x_job_business_group_id_tbl(i), NULL,
5098: PO_PDOI_PARAMS.g_sys.def_business_group_id,
5099: x_job_business_group_id_tbl(i)), x_job_business_group_id_tbl(i))

Line 5098: PO_PDOI_PARAMS.g_sys.def_business_group_id,

5094: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id
5095: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =
5096: DECODE(p_job_business_group_name_tbl(i), NULL,
5097: DECODE(x_job_business_group_id_tbl(i), NULL,
5098: PO_PDOI_PARAMS.g_sys.def_business_group_id,
5099: x_job_business_group_id_tbl(i)), x_job_business_group_id_tbl(i))
5100: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(jobs_b.date_from, sysdate))
5101: AND TRUNC(NVL(jobs_b.date_to, sysdate));
5102: ELSE

Line 5121: PO_PDOI_PARAMS.g_sys.def_business_group_id);

5117: d_job_name_tbl);
5118: PO_LOG.stmt(d_module, d_position, 'debug: d_bg_id_tbl',
5119: d_bg_id_tbl);
5120: PO_LOG.stmt(d_module, d_position, 'debug: default bg id',
5121: PO_PDOI_PARAMS.g_sys.def_business_group_id);
5122: END IF;
5123:
5124: -- END OF info added for debugging purpose */
5125:

Line 5140: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id

5136: AND x_job_business_group_id_tbl(i) IS NULL
5137: AND jobs_b.job_id = jobs_tl.job_id
5138: AND jobs_tl.language = NVL(p_file_line_language_tbl(i), userenv('LANG'))
5139: AND jobs_tl.name = p_job_name_tbl(i)
5140: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id
5141: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =
5142: DECODE(p_job_business_group_name_tbl(i), NULL,
5143: PO_PDOI_PARAMS.g_sys.def_business_group_id,
5144: x_job_business_group_id_tbl(i))

Line 5141: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =

5137: AND jobs_b.job_id = jobs_tl.job_id
5138: AND jobs_tl.language = NVL(p_file_line_language_tbl(i), userenv('LANG'))
5139: AND jobs_tl.name = p_job_name_tbl(i)
5140: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id
5141: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =
5142: DECODE(p_job_business_group_name_tbl(i), NULL,
5143: PO_PDOI_PARAMS.g_sys.def_business_group_id,
5144: x_job_business_group_id_tbl(i))
5145: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(jobs_b.date_from, sysdate))

Line 5143: PO_PDOI_PARAMS.g_sys.def_business_group_id,

5139: AND jobs_tl.name = p_job_name_tbl(i)
5140: AND jobs_b.business_group_id = PO_PDOI_PARAMS.g_sys.def_business_group_id
5141: AND PO_PDOI_PARAMS.g_sys.def_business_group_id =
5142: DECODE(p_job_business_group_name_tbl(i), NULL,
5143: PO_PDOI_PARAMS.g_sys.def_business_group_id,
5144: x_job_business_group_id_tbl(i))
5145: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(jobs_b.date_from, sysdate))
5146: AND TRUNC(NVL(jobs_b.date_to, sysdate));
5147:

Line 5198: PO_PDOI_PARAMS.g_sys.def_business_group_id;

5194: X_job_id_tbl(i) IS NULL AND
5195: p_job_business_group_name_tbl(i) IS NULL AND
5196: x_job_business_group_id_tbl(i) IS NULL) THEN
5197: x_job_business_group_id_tbl(i) :=
5198: PO_PDOI_PARAMS.g_sys.def_business_group_id;
5199: END IF;
5200: END LOOP;
5201:
5202: d_position := 60;

Line 5278: PO_PDOI_PARAMS.g_sys.def_structure_id,

5274: d_position := 10;
5275:
5276: l_result :=
5277: FND_FLEX_EXT.GET_CCID('INV', 'MCAT',
5278: PO_PDOI_PARAMS.g_sys.def_structure_id,
5279: to_char(sysdate,'YYYY/MM/DD HH24:MI:SS'),
5280: p_category_tbl(i));
5281:
5282: IF (PO_LOG.d_stmt) THEN

Line 5862: PO_PDOI_PARAMS.g_sys.def_inv_org_id) =

5858: WHERE p_template_name_tbl(i) IS NOT NULL
5859: AND x_template_id_tbl(i) IS NULL
5860: AND template_name = p_template_name_tbl(i)
5861: AND NVL(context_organization_id,
5862: PO_PDOI_PARAMS.g_sys.def_inv_org_id) =
5863: PO_PDOI_PARAMS.g_sys.def_inv_org_id;
5864:
5865: d_position := 10;
5866:

Line 5863: PO_PDOI_PARAMS.g_sys.def_inv_org_id;

5859: AND x_template_id_tbl(i) IS NULL
5860: AND template_name = p_template_name_tbl(i)
5861: AND NVL(context_organization_id,
5862: PO_PDOI_PARAMS.g_sys.def_inv_org_id) =
5863: PO_PDOI_PARAMS.g_sys.def_inv_org_id;
5864:
5865: d_position := 10;
5866:
5867: -- read result from temp table, and delete the records from temp table

Line 6173: AND item.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id

6169: mtl_units_of_measure uom
6170: WHERE item.inventory_item_id = p_item_id_tbl(i)
6171: AND item_tl.inventory_item_id = item.inventory_item_id
6172: AND item_cat.inventory_item_id = item.inventory_item_id
6173: AND item.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6174: AND item_tl.language = USERENV('LANG')
6175: AND item_tl.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6176: AND item_cat.category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id
6177: AND item_cat.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id

Line 6175: AND item_tl.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id

6171: AND item_tl.inventory_item_id = item.inventory_item_id
6172: AND item_cat.inventory_item_id = item.inventory_item_id
6173: AND item.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6174: AND item_tl.language = USERENV('LANG')
6175: AND item_tl.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6176: AND item_cat.category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id
6177: AND item_cat.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6178: AND item.secondary_uom_code = uom.uom_code(+);
6179:

Line 6176: AND item_cat.category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id

6172: AND item_cat.inventory_item_id = item.inventory_item_id
6173: AND item.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6174: AND item_tl.language = USERENV('LANG')
6175: AND item_tl.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6176: AND item_cat.category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id
6177: AND item_cat.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6178: AND item.secondary_uom_code = uom.uom_code(+);
6179:
6180: d_position := 10;

Line 6177: AND item_cat.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id

6173: AND item.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6174: AND item_tl.language = USERENV('LANG')
6175: AND item_tl.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6176: AND item_cat.category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id
6177: AND item_cat.organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id
6178: AND item.secondary_uom_code = uom.uom_code(+);
6179:
6180: d_position := 10;
6181:

Line 6842: PO_PDOI_PARAMS.g_request.document_type =

6838: IF (x_lines.line_num_tbl(i) IS NULL) THEN
6839: IF (x_lines.hd_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
6840: x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
6841: NOT (x_lines.order_type_lookup_code_tbl(i) = 'AMOUNT' AND
6842: PO_PDOI_PARAMS.g_request.document_type =
6843: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
6844: IF (PO_LOG.d_stmt) THEN
6845: PO_LOG.stmt(d_module, d_position, 'processing index', i);
6846: END IF;

Line 7679: l_def_master_org_id := PO_PDOI_PARAMS.g_sys.master_inv_org_id;

7675: PO_LOG.proc_begin(d_module);
7676: END IF;
7677:
7678: -- get default master org id
7679: l_def_master_org_id := PO_PDOI_PARAMS.g_sys.master_inv_org_id;
7680:
7681: IF (PO_LOG.d_stmt) THEN
7682: PO_LOG.stmt(d_module, d_position, 'l_def_master_org_id',
7683: l_def_master_org_id);

Line 8964: -- Update PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_processed_lines

8960: --Start of Comments
8961: --Name: handle_err_tolerance
8962: --Function: This procedure maintains line processing information for each
8963: -- document. It also handles the error tolerance for Catalog Upload.
8964: -- Update PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_processed_lines
8965: -- for each line.
8966: --
8967: -- If line contains error, increment
8968: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_errored_lines

Line 8968: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_errored_lines

8964: -- Update PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_processed_lines
8965: -- for each line.
8966: --
8967: -- If line contains error, increment
8968: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_errored_lines
8969: --
8970: -- If the number of errored lines exceeds the error tolerance, then set
8971: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).err_tolerance_exceeded to TRUE and
8972: -- set x_lines.need_to_reject_flag_tbl to TRUE.

Line 8971: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).err_tolerance_exceeded to TRUE and

8967: -- If line contains error, increment
8968: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_errored_lines
8969: --
8970: -- If the number of errored lines exceeds the error tolerance, then set
8971: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).err_tolerance_exceeded to TRUE and
8972: -- set x_lines.need_to_reject_flag_tbl to TRUE.
8973: --
8974: -- If the line does not have error, increment
8975: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_valid_lines

Line 8975: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_valid_lines

8971: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).err_tolerance_exceeded to TRUE and
8972: -- set x_lines.need_to_reject_flag_tbl to TRUE.
8973: --
8974: -- If the line does not have error, increment
8975: -- PO_PDOI_PARAMS.g_docs_info(intf_header_id).number_of_valid_lines
8976: --Parameters:
8977: --IN OUT:
8978: -- x_lines
8979: -- record which stores all the line rows within the batch;

Line 8992: l_err_lines_tolerance NUMBER := PO_PDOI_PARAMS.g_request.err_lines_tolerance;

8988: d_api_name CONSTANT VARCHAR2(30) := 'handle_err_tolerance';
8989: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
8990: d_position NUMBER;
8991:
8992: l_err_lines_tolerance NUMBER := PO_PDOI_PARAMS.g_request.err_lines_tolerance;
8993: l_intf_header_id NUMBER;
8994: l_num_errored_lines NUMBER;
8995: l_num_processed_lines NUMBER;
8996: l_num_valid_lines NUMBER;

Line 9018: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

9014: END IF;
9015:
9016: d_position := 10;
9017:
9018: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9019: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN
9020: x_lines.need_to_reject_flag_tbl(i) := FND_API.g_TRUE;
9021:
9022: -- bug 5215781:

Line 9019: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN

9015:
9016: d_position := 10;
9017:
9018: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9019: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN
9020: x_lines.need_to_reject_flag_tbl(i) := FND_API.g_TRUE;
9021:
9022: -- bug 5215781:
9023: -- collect ids of lines for which errors on them would be removed from error interface

Line 9028: l_num_processed_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_processed_lines + 1;

9024: -- table since error tolerance threshold is hit before them
9025: l_remove_err_line_tbl.EXTEND;
9026: l_remove_err_line_tbl(l_remove_err_line_tbl.COUNT) := x_lines.intf_line_id_tbl(i);
9027: ELSE
9028: l_num_processed_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_processed_lines + 1;
9029: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_processed_lines := l_num_processed_lines;
9030:
9031: IF (PO_LOG.d_stmt) THEN
9032: PO_LOG.stmt(d_module, d_position, 'num_processed_lines', l_num_processed_lines);

Line 9029: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_processed_lines := l_num_processed_lines;

9025: l_remove_err_line_tbl.EXTEND;
9026: l_remove_err_line_tbl(l_remove_err_line_tbl.COUNT) := x_lines.intf_line_id_tbl(i);
9027: ELSE
9028: l_num_processed_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_processed_lines + 1;
9029: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_processed_lines := l_num_processed_lines;
9030:
9031: IF (PO_LOG.d_stmt) THEN
9032: PO_LOG.stmt(d_module, d_position, 'num_processed_lines', l_num_processed_lines);
9033: END IF;

Line 9038: l_num_errored_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines + 1;

9034:
9035: d_position := 20;
9036:
9037: IF x_lines.error_flag_tbl(i) = FND_API.g_TRUE THEN
9038: l_num_errored_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines + 1;
9039: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines := l_num_errored_lines;
9040:
9041: -- set corresponding line to ERROR
9042: PO_PDOI_PARAMS.g_errored_lines(x_lines.intf_line_id_tbl(i)) := 'Y';

Line 9039: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines := l_num_errored_lines;

9035: d_position := 20;
9036:
9037: IF x_lines.error_flag_tbl(i) = FND_API.g_TRUE THEN
9038: l_num_errored_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines + 1;
9039: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines := l_num_errored_lines;
9040:
9041: -- set corresponding line to ERROR
9042: PO_PDOI_PARAMS.g_errored_lines(x_lines.intf_line_id_tbl(i)) := 'Y';
9043:

Line 9042: PO_PDOI_PARAMS.g_errored_lines(x_lines.intf_line_id_tbl(i)) := 'Y';

9038: l_num_errored_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines + 1;
9039: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines := l_num_errored_lines;
9040:
9041: -- set corresponding line to ERROR
9042: PO_PDOI_PARAMS.g_errored_lines(x_lines.intf_line_id_tbl(i)) := 'Y';
9043:
9044: IF (PO_LOG.d_stmt) THEN
9045: PO_LOG.stmt(d_module, d_position, 'num_errored_lines', l_num_errored_lines);
9046: END IF;

Line 9050: IF (PO_PDOI_PARAMS.g_request.calling_module =

9046: END IF;
9047:
9048: d_position := 30;
9049:
9050: IF (PO_PDOI_PARAMS.g_request.calling_module =
9051: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9052: l_num_errored_lines = l_err_lines_tolerance) THEN
9053:
9054: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

Line 9054: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

9050: IF (PO_PDOI_PARAMS.g_request.calling_module =
9051: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
9052: l_num_errored_lines = l_err_lines_tolerance) THEN
9053:
9054: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;
9055: END IF;
9056:
9057: d_position := 40;
9058: ELSE

Line 9062: l_num_valid_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_valid_lines + 1;

9058: ELSE
9059: d_position := 50;
9060:
9061: -- maintain number of valid lines
9062: l_num_valid_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_valid_lines + 1;
9063: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_valid_lines := l_num_valid_lines;
9064:
9065: END IF;
9066: END IF;

Line 9063: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_valid_lines := l_num_valid_lines;

9059: d_position := 50;
9060:
9061: -- maintain number of valid lines
9062: l_num_valid_lines := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_valid_lines + 1;
9063: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_valid_lines := l_num_valid_lines;
9064:
9065: END IF;
9066: END IF;
9067: END LOOP;