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_CONSTANTS

Line 382: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

378: AND intf_lines.processing_id = p_request_processing_id
379: AND intf_headers.processing_round_num = p_request_processing_round_num
380: AND intf_headers.processing_id = p_request_processing_id
381: AND intf_lines.line_num = txn_lines.line_num
382: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
383:
384: -- select lines which have same line num as lines in draft table
385: CURSOR c_dup_lines_in_draft(p_request_processing_id NUMBER,
386: p_request_processing_round_num NUMBER) IS

Line 400: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

396: AND intf_lines.processing_id = p_request_processing_id
397: AND intf_headers.processing_round_num = p_request_processing_round_num
398: AND intf_headers.processing_id = p_request_processing_id
399: AND intf_lines.line_num = draft_lines.line_num
400: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
401:
402: -- duplicate lines in interface table
403: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
404: l_dup_intf_line_id_tbl PO_TBL_NUMBER;

Line 429: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

425: BULK COLLECT INTO
426: l_dup_intf_header_id_tbl,
427: l_dup_intf_line_id_tbl,
428: l_dup_intf_line_num_tbl
429: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
430:
431: d_position := 20;
432:
433: l_count := l_dup_intf_line_id_tbl.COUNT;

Line 469: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

465:
466: -- reject the lines and the lower level entities associated with it
467: PO_PDOI_UTL.reject_lines_intf
468: (
469: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
470: p_id_tbl => l_dup_intf_line_id_tbl,
471: p_cascade => FND_API.g_TRUE
472: );
473:

Line 476: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN

472: );
473:
474: d_position := 50;
475:
476: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
477: EXIT;
478: END IF;
479: END LOOP;
480:

Line 498: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

494: BULK COLLECT INTO
495: l_dup_intf_header_id_tbl,
496: l_dup_intf_line_id_tbl,
497: l_dup_intf_line_num_tbl
498: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
499:
500: d_position := 80;
501:
502: l_count := l_dup_intf_line_id_tbl.COUNT;

Line 538: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

534:
535: -- reject the lines and the lower level entities associated with it
536: PO_PDOI_UTL.reject_lines_intf
537: (
538: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
539: p_id_tbl => l_dup_intf_line_id_tbl,
540: p_cascade => FND_API.g_TRUE
541: );
542:

Line 545: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN

541: );
542:
543: d_position := 110;
544:
545: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
546: EXIT;
547: END IF;
548: END LOOP;
549:

Line 598: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>

594: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
595: AND intf_lines.processing_id = p_request_processing_id
596: AND intf_headers.processing_round_num = p_request_processing_round_num
597: AND intf_headers.processing_id = p_request_processing_id
598: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>
599: PO_PDOI_CONSTANTS.g_ACTION_ADD;
600:
601: -- interface line id of lines that need to be rejected
602: l_rej_intf_line_id_tbl PO_TBL_NUMBER;

Line 599: PO_PDOI_CONSTANTS.g_ACTION_ADD;

595: AND intf_lines.processing_id = p_request_processing_id
596: AND intf_headers.processing_round_num = p_request_processing_round_num
597: AND intf_headers.processing_id = p_request_processing_id
598: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>
599: PO_PDOI_CONSTANTS.g_ACTION_ADD;
600:
601: -- interface line id of lines that need to be rejected
602: l_rej_intf_line_id_tbl PO_TBL_NUMBER;
603: l_rej_intf_header_id_tbl PO_TBL_NUMBER;

Line 658: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

654:
655: -- reject the lines and the lower level entities associated with it
656: PO_PDOI_UTL.reject_lines_intf
657: (
658: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
659: p_id_tbl => l_rej_intf_line_id_tbl,
660: p_cascade => FND_API.g_TRUE
661: );
662:

Line 719: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_ADD) THEN

715:
716: -- bug5107324
717: -- cursor now selects NULL into allow_desc_update_flag_tbl as well
718:
719: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_ADD) THEN
720: d_position := 10;
721:
722: OPEN x_lines_csr FOR
723: SELECT intf_lines.interface_line_id,

Line 844: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

840: intf_lines.clm_info_flag, /* 10354034 */
841: intf_lines.group_line_id, --PDOI CLM Integration
842:
843: DECODE(intf_lines.process_code,
844: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
845: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
846: FND_API.g_FALSE, -- need_to_reject_flag_tbl
847: FND_API.g_FALSE, -- create_line_loc_tbl
848: -1, -- group_num

Line 864: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

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,
868: intf_lines.user_document_status,

Line 900: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

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
903: --Process only priced lines which in commercial flow are normal lines
904: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'

Line 901: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

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
903: --Process only priced lines which in commercial flow are normal lines
904: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'
905:

Line 1028: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1024: NULL, -- tax_attribute_update_code
1025: intf_lines.clm_info_flag, /* 10354034 */
1026: intf_lines.group_line_id, --CLM PDOI Integration
1027:
1028: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1029: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1030: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1031: FND_API.g_FALSE, -- create_line_loc_tbl
1032: -1, -- group_num

Line 1048: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

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,
1052: intf_lines.user_document_status,

Line 1084: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

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
1087: --Process only priced lines which in commercial flow are normal lines
1088: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'

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 1090: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN

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;
1090: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
1091: d_position := 20;
1092:
1093: OPEN x_lines_csr FOR
1094: SELECT intf_lines.interface_line_id,

Line 1214: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1210: NULL, -- tax_attribute_update_code
1211: intf_lines.clm_info_flag, /* 10354034 */
1212: intf_lines.group_line_id, --CLM PDOI Integration
1213:
1214: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1215: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1216: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1217: FND_API.g_FALSE, -- create_line_loc_tbl
1218: -1, -- group_num

Line 1234: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

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,
1238: intf_lines.user_document_status,

Line 1269: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

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,
1272: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1273: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD

Line 1271: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
1275: --Process only priced lines which in commercial flow are normal lines

Line 1272: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)

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
1275: --Process only priced lines which in commercial flow are normal lines
1276: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'

Line 1273: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD

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
1275: --Process only priced lines which in commercial flow are normal lines
1276: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'
1277:

Line 1279: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN

1275: --Process only priced lines which in commercial flow are normal lines
1276: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'
1277:
1278: ORDER BY intf_lines.interface_line_id;
1279: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN
1280: d_position := 30;
1281:
1282: OPEN x_lines_csr FOR
1283: SELECT intf_lines.interface_line_id,

Line 1404: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1400: intf_lines.clm_info_flag, /* 10354034 */
1401: intf_lines.group_line_id, --CLM PDOI Integration
1402:
1403:
1404: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1405: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1406: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1407: FND_API.g_FALSE, -- create_line_loc_tbl
1408: -1, -- group_num

Line 1424: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

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,
1428: intf_lines.user_document_status,

Line 1459: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

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,
1462: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1463: AND intf_lines.action IS NULL

Line 1461: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
1465: intf_lines.vendor_product_num IS NULL AND

Line 1462: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)

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
1465: intf_lines.vendor_product_num IS NULL AND
1466: intf_lines.job_name IS NULL AND

Line 1473: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN

1469: --Process only priced lines which in commercial flow are normal lines
1470: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'
1471:
1472: ORDER BY intf_lines.interface_line_id;
1473: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN
1474: d_position := 40;
1475:
1476: OPEN x_lines_csr FOR
1477: SELECT intf_lines.interface_line_id,

Line 1597: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1593: NULL, -- tax_attribute_update_code
1594: intf_lines.clm_info_flag, /* 10354034 */
1595: intf_lines.group_line_id, --CLM PDOI Integration
1596:
1597: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1598: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1599: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1600: FND_API.g_FALSE, -- create_line_loc_tbl
1601: -1, -- group_num

Line 1617: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

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,
1621: intf_lines.user_document_status,

Line 1652: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

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,
1655: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1656: AND intf_lines.action IS NULL

Line 1654: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
1658: AND intf_lines.vendor_product_num IS NULL

Line 1655: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)

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
1658: AND intf_lines.vendor_product_num IS NULL
1659: AND intf_lines.job_name IS NULL

Line 1669: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_INFO_LINE_ADD) THEN

1665: ORDER BY intf_lines.interface_line_id;
1666:
1667: --PDOI CLM Integration
1668: --A new cursor added to process only Info lines
1669: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_INFO_LINE_ADD) THEN
1670: d_position := 45;
1671: OPEN x_lines_csr FOR
1672: SELECT intf_lines.interface_line_id,
1673: intf_lines.interface_header_id,

Line 1793: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1789: intf_lines.clm_info_flag,
1790: intf_lines.group_line_id,
1791:
1792: DECODE(intf_lines.process_code,
1793: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1794: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1795: FND_API.g_FALSE, -- need_to_reject_flag_tbl
1796: FND_API.g_FALSE, -- create_line_loc_tbl
1797: -1, -- group_num

Line 1846: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

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'
1849: ORDER BY intf_lines.interface_line_id;
1850: ELSE

Line 1847: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

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'
1849: ORDER BY intf_lines.interface_line_id;
1850: ELSE
1851: d_position := 50;

Line 2064: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

2060: x_lines.clm_base_line_num_disp_tbl,
2061: x_lines.from_header_disp_tbl,
2062: x_lines.from_line_disp_tbl
2063: --CLM PDOI Integration Ends
2064: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
2065:
2066: IF (PO_LOG.d_proc) THEN
2067: PO_LOG.proc_end (d_module);
2068: END IF;

Line 2115: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

2111: IF (PO_LOG.d_proc) THEN
2112: PO_LOG.proc_begin(d_module, 'line counts', x_lines.rec_count);
2113: END IF;
2114:
2115: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2116:
2117: -- assign a new key used in temporary table
2118: l_key := PO_CORE_S.get_session_gt_nextval;
2119:

Line 2205: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
2209: (

Line 2206: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

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
2209: (
2210: p_key => l_key,

Line 2453: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
2457: IF (PO_LOG.d_stmt) THEN

Line 2454: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

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
2457: IF (PO_LOG.d_stmt) THEN
2458: PO_LOG.stmt(d_module, d_position, 'ip category id derivation failed');

Line 2780: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

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);
2781:
2782: IF (PO_LOG.d_proc) THEN
2783: PO_LOG.proc_end (d_module);
2784: END IF;

Line 2833: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

2829: IF (PO_LOG.d_proc) THEN
2830: PO_LOG.proc_begin(d_module, 'line counts', x_lines.rec_count);
2831: END IF;
2832:
2833: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2834:
2835: -- assign a new key used in temporary table
2836: l_key := PO_CORE_S.get_session_gt_nextval;
2837:

Line 2884: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
2888: (

Line 2885: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

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
2888: (
2889: p_key => l_key,

Line 2965: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
2969: IF (PO_LOG.d_stmt) THEN

Line 2966: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

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
2969: IF (PO_LOG.d_stmt) THEN
2970: PO_LOG.stmt(d_module, d_position, 'ip category id derivation failed');

Line 3020: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

3016: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3017: END IF;
3018: END LOOP;
3019:
3020: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
3021:
3022: IF (PO_LOG.d_proc) THEN
3023: PO_LOG.proc_end (d_module);
3024: END IF;

Line 3100: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);

3096: IF (PO_LOG.d_proc) THEN
3097: PO_LOG.proc_begin(d_module);
3098: END IF;
3099:
3100: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
3101:
3102: -- get key value to identify rows in po_session_gt table
3103: l_key := PO_CORE_S.get_session_gt_nextval;
3104:

Line 3182: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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

Line 3183: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

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;
3186:
3187: -- get default po category ids from ip category ids

Line 3300: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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:
3304: IF (PO_LOG.d_stmt) THEN

Line 3301: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

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:
3304: IF (PO_LOG.d_stmt) THEN
3305: PO_LOG.stmt(d_module, d_position, 'set default value for blanket/spo');

Line 3313: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN -- bug 9374205

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),
3317: x_precision,

Line 3343: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

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
3347: PO_LOG.stmt(d_module, d_position, 'set default value for blanket');

Line 3412: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
3416: -- for po category ids have happened

Line 3413: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

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
3416: -- for po category ids have happened
3417:

Line 3501: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);

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:
3503: IF (PO_LOG.d_proc) THEN
3504: PO_LOG.proc_end (d_module);
3505: END IF;

Line 3567: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

3563: PO_LOG.proc_begin(d_module, 'po_line_id', x_lines.po_line_id_tbl);
3564: PO_LOG.proc_begin(d_module, 'draft_id', x_lines.draft_id_tbl);
3565: END IF;
3566:
3567: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
3568:
3569: -- assign a new key used in temporary table
3570: l_key := PO_CORE_S.get_session_gt_nextval;
3571:

Line 3637: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

3633: x_lines.item_id_tbl(l_index) := l_item_id_tbl(i);
3634: x_lines.job_id_tbl(l_index) := l_job_id_tbl(i);
3635: END LOOP;
3636:
3637: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
3638:
3639: IF (PO_LOG.d_proc) THEN
3640: PO_LOG.proc_end (d_module);
3641: END IF;

Line 3690: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);

3686: IF (PO_LOG.d_proc) THEN
3687: PO_LOG.proc_begin(d_module);
3688: END IF;
3689:
3690: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
3691:
3692: -- initialize index table
3693: PO_PDOI_UTL.generate_ordered_num_list
3694: (

Line 3708: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN

3704:
3705: -- bug5129752
3706: -- For FORCE ALL, simply set all line action to 'ADD'
3707:
3708: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
3709: d_position := 15;
3710:
3711: FOR i IN 1..x_lines.rec_count LOOP
3712: x_lines.po_line_id_tbl(i) :=

Line 3721: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

3717: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num
3718: (x_lines.po_header_id_tbl(i));
3719: END IF;
3720:
3721: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
3722:
3723: END LOOP;
3724:
3725: ELSE

Line 3828: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

3824: d_position := 70;
3825:
3826: PO_PDOI_UTL.reject_lines_intf
3827: (
3828: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
3829: p_id_tbl => l_rej_intf_line_id_tbl,
3830: p_cascade => FND_API.g_TRUE
3831: );
3832:

Line 3833: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);

3829: p_id_tbl => l_rej_intf_line_id_tbl,
3830: p_cascade => FND_API.g_TRUE
3831: );
3832:
3833: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
3834:
3835: IF (PO_LOG.d_proc) THEN
3836: PO_LOG.proc_end (d_module);
3837: END IF;

Line 3916: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

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
3920: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

Line 3918: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

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
3920: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3921: END IF;
3922: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

Line 3923: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

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

Line 3929: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

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

Line 3962: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE

3958:
3959: -- obsolete the location lines that have been marked
3960: FORALL i IN 1..l_obsoleted_loc_tbl.COUNT
3961: UPDATE po_line_locations_interface
3962: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
3963: WHERE interface_line_id = l_obsoleted_loc_tbl(i);
3964:
3965: /*
3966: PO_PDOI_UTL.reject_line_locations_intf

Line 3968: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

3964:
3965: /*
3966: PO_PDOI_UTL.reject_line_locations_intf
3967: (
3968: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
3969: p_id_tbl => l_obsoleted_loc_tbl,
3970: p_cascade => FND_API.g_TRUE
3971: );
3972: */

Line 4020: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

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

Line 4021: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND

4017:
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)

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 4023: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

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
4027: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =

Line 4025: (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
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:

Line 4026: = 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
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

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 4028: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN

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
4032: IF (PO_LOG.d_stmt) THEN

Line 4036: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;

4032: IF (PO_LOG.d_stmt) THEN
4033: PO_LOG.stmt(d_module, d_position, 'update line process code to ACCEPTED. Index = ', i);
4034: END IF;
4035:
4036: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;
4037: END IF;
4038: END IF;
4039: END LOOP;
4040:

Line 4137: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);

4133: l_index := x_processing_row_tbl.NEXT(l_index);
4134: END LOOP;
4135: END IF;
4136:
4137: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
4138:
4139: -- get key value for po_session_gt table
4140: l_key := PO_CORE_S.get_session_gt_nextval;
4141:

Line 4143: IF (p_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN

4139: -- get key value for po_session_gt table
4140: l_key := PO_CORE_S.get_session_gt_nextval;
4141:
4142: -- call individual uniqueness check procedure for each unique criteria
4143: IF (p_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN
4144: d_position := 10;
4145:
4146: uniqueness_check_on_desc
4147: (

Line 4212: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

4208: x_lines.vendor_product_num_tbl(i) IS NULL AND
4209: x_lines.job_name_tbl(i) IS NULL AND
4210: x_lines.line_num_tbl(i) IS NULL) THEN
4211:
4212: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
4213: x_lines.group_num_tbl(i) := p_group_num;
4214: x_lines.po_line_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
4215: x_lines.line_num_tbl(i) :=
4216: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num

Line 4241: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

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
4245: PO_PDOI_UTL.generate_ordered_num_list

Line 4296: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

4292: PO_LOG.stmt(d_module, d_position, 'expired line id',
4293: x_lines.po_line_id_tbl(l_index));
4294: END IF;
4295:
4296: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
4297: l_count := l_count + 1;
4298: x_expire_line_id_tbl(l_count) := x_lines.po_line_id_tbl(l_index);
4299: x_lines.po_line_id_tbl(l_index) :=
4300: PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;

Line 4321: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);

4317: END IF;
4318: END LOOP;
4319: END IF;
4320:
4321: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
4322:
4323: IF (PO_LOG.d_proc) THEN
4324: PO_LOG.proc_end (d_module);
4325: END IF;

Line 4384: IF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_ADD) THEN

4380: LOOP
4381: d_position := 10;
4382:
4383: IF (p_group_num IS NULL OR p_lines.group_num_tbl(i) = p_group_num) THEN
4384: IF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_ADD) THEN
4385: IF (PO_LOG.d_stmt) THEN
4386: PO_LOG.stmt(d_module, d_position, 'lines to create', i);
4387: END IF;
4388:

Line 4390: ELSIF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN

4386: PO_LOG.stmt(d_module, d_position, 'lines to create', i);
4387: END IF;
4388:
4389: l_create_index_tbl(i) := i;
4390: ELSIF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
4391: IF (PO_LOG.d_stmt) THEN
4392: PO_LOG.stmt(d_module, d_position, 'lines to update', i);
4393: END IF;
4394:

Line 4478: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);

4474: IF (PO_LOG.d_proc) THEN
4475: PO_LOG.proc_begin(d_module, 'action', p_action);
4476: END IF;
4477:
4478: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);
4479:
4480: l_lines.interface_id := x_lines.intf_line_id_tbl;
4481: l_lines.over_tolerance_error_flag := x_lines.over_tolerance_err_flag_tbl;
4482: l_lines.expiration_date := x_lines.expiration_date_tbl;

Line 4651: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);

4647: );
4648:
4649: d_position := 100;
4650:
4651: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);
4652:
4653: IF (PO_LOG.d_proc) THEN
4654: PO_LOG.proc_end(d_module, 'result_type', l_result_type);
4655: END IF;

Line 6713: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6709: PO_LOG.stmt(d_module, d_position, 'matched po line id', l_result_tbl(i));
6710: END IF;
6711:
6712: x_lines.po_line_id_tbl(l_index) := l_result_tbl(i);
6713: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6714: END LOOP;
6715:
6716: d_position := 20;
6717:

Line 6738: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6734: d_position := 30;
6735:
6736: x_lines.po_line_id_tbl(i) :=
6737: l_line_reference_tbl(l_po_header_id)(l_line_num);
6738: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6739:
6740: IF (PO_LOG.d_stmt) THEN
6741: PO_LOG.stmt(d_module, d_position, 'match found for line num');
6742: PO_LOG.stmt(d_module, d_position, 'new po line id',

Line 6750: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

6746: d_position := 40;
6747:
6748: x_lines.po_line_id_tbl(i) :=
6749: PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
6750: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
6751:
6752: l_line_reference_tbl(l_po_header_id)(l_line_num) :=
6753: x_lines.po_line_id_tbl(i);
6754:

Line 6839: IF (x_lines.hd_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

6835: -- 4. document is not AMOUNT based BLANKET
6836: FOR i IN 1..x_lines.rec_count
6837: LOOP
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

Line 6843: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) 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;
6847:

Line 6854: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

6850: -- all lines will be marked as 'ADD'
6851: x_lines.po_line_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
6852: x_lines.line_num_tbl(i) :=
6853: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num(x_lines.po_header_id_tbl(i));
6854: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
6855:
6856: IF (PO_LOG.d_stmt) THEN
6857: PO_LOG.stmt(d_module, d_position, 'new po line id', x_lines.po_line_id_tbl(i));
6858: PO_LOG.stmt(d_module, d_position, 'new line num', x_lines.line_num_tbl(i));

Line 6929: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6925: END IF;
6926:
6927: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
6928: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
6929: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6930: -- delete the corresponding node so the line won't be matched within batch
6931: l_processing_line_tbl.DELETE(i);
6932: END LOOP;
6933:

Line 7021: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

7017: LOOP
7018: l_index := l_index_tbl(i);
7019:
7020: x_lines.po_line_id_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
7021: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
7022: x_lines.line_num_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num(x_lines.po_header_id_tbl(l_index)); --bug 8295593
7023: -- delete the corresponding node so the line won't be matched within batch
7024: l_processing_line_tbl.DELETE(l_index); --bug 8295593
7025:

Line 7093: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

7089: l_match_index := l_match_index_tbl(i);
7090:
7091: x_lines.po_line_id_tbl(l_index) := x_lines.po_line_id_tbl(l_match_index);
7092: x_lines.line_num_tbl(l_index) := x_lines.line_num_tbl(l_match_index);
7093: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
7094:
7095: IF (PO_LOG.d_stmt) THEN
7096: PO_LOG.stmt(d_module, d_position, 'index', l_index);
7097: PO_LOG.stmt(d_module, d_position, 'match index', l_match_index);

Line 7504: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

7500: END IF;
7501:
7502: -- first match found
7503: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
7504: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
7505: x_lines.group_num_tbl(l_index) := p_group_num;
7506: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7507: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7508: x_processing_row_tbl.DELETE(l_index);

Line 7794: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

7790: END IF;
7791:
7792: -- first match found
7793: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
7794: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
7795: x_lines.group_num_tbl(l_index) := p_group_num;
7796: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7797: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7798: x_processing_row_tbl.DELETE(l_index);

Line 8060: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

8056: END IF;
8057:
8058: -- first match found
8059: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
8060: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
8061: x_lines.group_num_tbl(l_index) := p_group_num;
8062: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8063: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8064: x_processing_row_tbl.DELETE(l_index);

Line 8321: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

8317: END IF;
8318:
8319: -- first match found
8320: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
8321: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
8322: x_lines.group_num_tbl(l_index) := p_group_num;
8323: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8324: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
8325: x_processing_row_tbl.DELETE(l_index);

Line 8560: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

8556: LOOP
8557: l_index := l_index_tbl(i);
8558:
8559: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
8560: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
8561: x_lines.group_num_tbl(l_index) := p_group_num;
8562: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
8563: x_processing_row_tbl.DELETE(l_index);
8564:

Line 8714: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

8710:
8711: d_position := 10;
8712: l_index := p_target_lines_index_tbl(i);
8713:
8714: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
8715: x_lines.group_num_tbl(l_index) := p_group_num;
8716: x_lines.po_line_id_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
8717:
8718: IF (p_check_line_num_assign = FND_API.G_TRUE) THEN

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 9051: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

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