DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_PDOI_LINE_PROCESS_PVT

Line 416: PO_PDOI_LINE_PROCESS_PVT.reject_dup_lines_for_spo;

412:
413: -- reject lines with existing line_num when updating standard PO
414: IF (PO_PDOI_PARAMS.g_request.document_type =
415: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
416: PO_PDOI_LINE_PROCESS_PVT.reject_dup_lines_for_spo;
417: END IF;
418:
419: -- reject lines with invalid line level action.
420: -- line level action can only be NULL or 'ADD';

Line 427: PO_PDOI_LINE_PROCESS_PVT.reject_invalid_action_lines;

423: -- level action to either 'ADD' or 'UPADTE', we don't
424: -- need to check line level action for NOTOFIED lines
425: IF (PO_PDOI_PARAMS.g_request.process_code <>
426: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
427: PO_PDOI_LINE_PROCESS_PVT.reject_invalid_action_lines;
428: END IF;
429:
430: d_position := 10;
431:

Line 562: PO_PDOI_LINE_PROCESS_PVT.open_lines

558:
559: d_position := 5;
560:
561: -- open cursor for the correct query
562: PO_PDOI_LINE_PROCESS_PVT.open_lines
563: (
564: p_data_set_type => p_data_set_type,
565: p_max_intf_line_id => l_max_intf_line_id,
566: x_lines_csr => l_lines_csr

Line 591: PO_PDOI_LINE_PROCESS_PVT.fetch_lines

587: END IF;
588:
589: BEGIN
590: -- fetch one batch of line records from query result
591: PO_PDOI_LINE_PROCESS_PVT.fetch_lines
592: (
593: x_lines_csr => l_lines_csr,
594: x_lines => l_lines
595: );

Line 628: PO_PDOI_LINE_PROCESS_PVT.derive_lines

624:
625: d_position := 30;
626:
627: -- derive logic
628: PO_PDOI_LINE_PROCESS_PVT.derive_lines
629: (
630: x_lines => l_lines
631: );
632:

Line 636: PO_PDOI_LINE_PROCESS_PVT.default_lines

632:
633: d_position := 40;
634:
635: -- default logic
636: PO_PDOI_LINE_PROCESS_PVT.default_lines
637: (
638: x_lines => l_lines
639: );
640:

Line 644: PO_PDOI_LINE_PROCESS_PVT.match_lines

640:
641: d_position := 50;
642:
643: -- match related lines based on line_num/item info
644: PO_PDOI_LINE_PROCESS_PVT.match_lines
645: (
646: p_data_set_type => p_data_set_type, -- bug5129752
647: x_lines => l_lines
648: );

Line 659: PO_PDOI_LINE_PROCESS_PVT.validate_lines

655: -- case if all the lines can be matched to lines in the draft table
656:
657:
658: -- validate lines
659: PO_PDOI_LINE_PROCESS_PVT.validate_lines
660: (
661: x_lines => l_lines
662: );
663:

Line 689: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

685:
686: d_position := 90;
687:
688: -- update po_lines_interface with po_line_id and line level action
689: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
690: (
691: x_lines => l_lines
692: );
693:

Line 749: PO_PDOI_LINE_PROCESS_PVT.open_lines

745: PO_PDOI_UTL.commit_work;
746:
747: IF (l_lines_csr%ISOPEN) THEN
748: CLOSE l_lines_csr;
749: PO_PDOI_LINE_PROCESS_PVT.open_lines
750: (
751: p_data_set_type => p_data_set_type,
752: p_max_intf_line_id => l_max_intf_line_id,
753: x_lines_csr => l_lines_csr

Line 909: PO_PDOI_LINE_PROCESS_PVT.open_lines

905:
906: d_position := 5;
907:
908: -- open cursor for the correct query
909: PO_PDOI_LINE_PROCESS_PVT.open_lines
910: (
911: p_data_set_type => p_data_set_type,
912: p_max_intf_line_id => l_max_intf_line_id,
913: x_lines_csr => l_lines_csr

Line 939: PO_PDOI_LINE_PROCESS_PVT.fetch_lines

935: END IF;
936:
937: BEGIN
938: -- fetch one batch of line records from query result
939: PO_PDOI_LINE_PROCESS_PVT.fetch_lines
940: (
941: x_lines_csr => l_lines_csr,
942: x_lines => l_lines
943: );

Line 1025: PO_PDOI_LINE_PROCESS_PVT.uniqueness_check

1021:
1022: -- perform uniqueness check on all the records and
1023: -- mark the group number on the records that can be processed
1024: -- within a group
1025: PO_PDOI_LINE_PROCESS_PVT.uniqueness_check
1026: (
1027: p_type => p_data_set_type,
1028: p_group_num => l_group_num,
1029: x_processing_row_tbl => l_processing_row_tbl,

Line 1037: PO_PDOI_LINE_PROCESS_PVT.split_lines

1033:
1034: d_position := 70;
1035:
1036: -- separate data records into two set, one for create and one for update
1037: PO_PDOI_LINE_PROCESS_PVT.split_lines
1038: (
1039: p_group_num => l_group_num,
1040: p_lines => l_lines,
1041: x_create_lines => l_create_lines,

Line 1089: PO_PDOI_LINE_PROCESS_PVT.open_lines

1085: PO_PDOI_UTL.commit_work;
1086:
1087: IF (l_lines_csr%ISOPEN) THEN
1088: CLOSE l_lines_csr;
1089: PO_PDOI_LINE_PROCESS_PVT.open_lines
1090: (
1091: p_data_set_type => p_data_set_type,
1092: p_max_intf_line_id => l_max_intf_line_id,
1093: x_lines_csr => l_lines_csr

Line 1239: PO_PDOI_LINE_PROCESS_PVT.derive_lines

1235: RETURN;
1236: END IF;
1237:
1238: -- derive logic
1239: PO_PDOI_LINE_PROCESS_PVT.derive_lines
1240: (
1241: x_lines => x_lines
1242: );
1243:

Line 1247: PO_PDOI_LINE_PROCESS_PVT.default_lines

1243:
1244: d_position := 10;
1245:
1246: -- default logic
1247: PO_PDOI_LINE_PROCESS_PVT.default_lines
1248: (
1249: x_lines => x_lines
1250: );
1251:

Line 1255: PO_PDOI_LINE_PROCESS_PVT.validate_lines

1251:
1252: d_position := 20;
1253:
1254: -- validate lines
1255: PO_PDOI_LINE_PROCESS_PVT.validate_lines
1256: (
1257: x_lines => x_lines
1258: );
1259:

Line 1263: PO_PDOI_LINE_PROCESS_PVT.check_line_locations

1259:
1260: d_position := 30;
1261:
1262: -- check whether line location needs to be created for the line
1263: PO_PDOI_LINE_PROCESS_PVT.check_line_locations
1264: (
1265: x_lines => x_lines
1266: );
1267:

Line 1293: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

1289:
1290: d_position := 60;
1291:
1292: -- update po_lines_interface with po_line_id and line level action
1293: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1294: (
1295: x_lines => x_lines
1296: );
1297:

Line 1401: PO_PDOI_LINE_PROCESS_PVT.derive_lines_for_update

1397: RETURN;
1398: END IF;
1399:
1400: -- derive internal identifier for updatable attributes
1401: PO_PDOI_LINE_PROCESS_PVT.derive_lines_for_update
1402: (
1403: x_lines => x_lines
1404: );
1405:

Line 1407: PO_PDOI_LINE_PROCESS_PVT.default_lines_for_update

1403: x_lines => x_lines
1404: );
1405:
1406: -- default certain attributes for processing purpose
1407: PO_PDOI_LINE_PROCESS_PVT.default_lines_for_update
1408: (
1409: x_lines => x_lines
1410: );
1411:

Line 1413: PO_PDOI_LINE_PROCESS_PVT.validate_lines

1409: x_lines => x_lines
1410: );
1411:
1412: -- validate lines
1413: PO_PDOI_LINE_PROCESS_PVT.validate_lines
1414: (
1415: p_action => 'UPDATE',
1416: x_lines => x_lines
1417: );

Line 1422: PO_PDOI_LINE_PROCESS_PVT.check_line_locations

1418:
1419: d_position := 10;
1420:
1421: -- check whether line location needs to be created for the line
1422: PO_PDOI_LINE_PROCESS_PVT.check_line_locations
1423: (
1424: x_lines => x_lines
1425: );
1426:

Line 1438: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

1434:
1435: d_position := 30;
1436:
1437: -- update po_lines_interface with po_line_id and line level action
1438: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1439: (
1440: x_lines => x_lines
1441: );
1442: