DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_PDOI_LINE_PROCESS_PVT

Line 536: PO_PDOI_LINE_PROCESS_PVT.reject_dup_lines_for_spo;

532:
533: -- reject lines with existing line_num when updating standard PO
534: IF (PO_PDOI_PARAMS.g_request.document_type =
535: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
536: PO_PDOI_LINE_PROCESS_PVT.reject_dup_lines_for_spo;
537: END IF;
538:
539: -- reject lines with invalid line level action.
540: -- line level action can only be NULL or 'ADD';

Line 547: PO_PDOI_LINE_PROCESS_PVT.reject_invalid_action_lines;

543: -- level action to either 'ADD' or 'UPADTE', we don't
544: -- need to check line level action for NOTOFIED lines
545: IF (PO_PDOI_PARAMS.g_request.process_code <>
546: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
547: PO_PDOI_LINE_PROCESS_PVT.reject_invalid_action_lines;
548: END IF;
549:
550: d_position := 10;
551:

Line 699: PO_PDOI_LINE_PROCESS_PVT.open_lines

695:
696: d_position := 5;
697:
698: -- open cursor for the correct query
699: PO_PDOI_LINE_PROCESS_PVT.open_lines
700: (
701: p_data_set_type => p_data_set_type,
702: p_max_intf_line_id => l_max_intf_line_id,
703: x_lines_csr => l_lines_csr

Line 728: PO_PDOI_LINE_PROCESS_PVT.fetch_lines

724: END IF;
725:
726: BEGIN
727: -- fetch one batch of line records from query result
728: PO_PDOI_LINE_PROCESS_PVT.fetch_lines
729: (
730: x_lines_csr => l_lines_csr,
731: x_lines => l_lines
732: );

Line 774: PO_PDOI_LINE_PROCESS_PVT.derive_lines

770:
771: d_position := 30;
772:
773: -- derive logic
774: PO_PDOI_LINE_PROCESS_PVT.derive_lines
775: (
776: x_lines => l_lines
777: );
778:

Line 782: PO_PDOI_LINE_PROCESS_PVT.default_lines

778:
779: d_position := 40;
780:
781: -- default logic
782: PO_PDOI_LINE_PROCESS_PVT.default_lines
783: (
784: x_lines => l_lines
785: );
786:

Line 790: PO_PDOI_LINE_PROCESS_PVT.match_lines

786:
787: d_position := 50;
788:
789: -- match related lines based on line_num/item info
790: PO_PDOI_LINE_PROCESS_PVT.match_lines
791: (
792: p_data_set_type => p_data_set_type, -- bug5129752
793: x_lines => l_lines
794: );

Line 805: PO_PDOI_LINE_PROCESS_PVT.validate_lines

801: -- case if all the lines can be matched to lines in the draft table
802:
803:
804: -- validate lines
805: PO_PDOI_LINE_PROCESS_PVT.validate_lines
806: (
807: x_lines => l_lines
808: );
809:

Line 835: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

831:
832: d_position := 90;
833:
834: -- update po_lines_interface with po_line_id and line level action
835: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
836: (
837: x_lines => l_lines
838: );
839:

Line 912: PO_PDOI_LINE_PROCESS_PVT.open_lines

908: PO_PDOI_UTL.commit_work;
909:
910: IF (l_lines_csr%ISOPEN) THEN
911: CLOSE l_lines_csr;
912: PO_PDOI_LINE_PROCESS_PVT.open_lines
913: (
914: p_data_set_type => p_data_set_type,
915: p_max_intf_line_id => l_max_intf_line_id,
916: x_lines_csr => l_lines_csr

Line 1072: PO_PDOI_LINE_PROCESS_PVT.open_lines

1068:
1069: d_position := 5;
1070:
1071: -- open cursor for the correct query
1072: PO_PDOI_LINE_PROCESS_PVT.open_lines
1073: (
1074: p_data_set_type => p_data_set_type,
1075: p_max_intf_line_id => l_max_intf_line_id,
1076: x_lines_csr => l_lines_csr

Line 1102: PO_PDOI_LINE_PROCESS_PVT.fetch_lines

1098: END IF;
1099:
1100: BEGIN
1101: -- fetch one batch of line records from query result
1102: PO_PDOI_LINE_PROCESS_PVT.fetch_lines
1103: (
1104: x_lines_csr => l_lines_csr,
1105: x_lines => l_lines
1106: );

Line 1188: PO_PDOI_LINE_PROCESS_PVT.uniqueness_check

1184:
1185: -- perform uniqueness check on all the records and
1186: -- mark the group number on the records that can be processed
1187: -- within a group
1188: PO_PDOI_LINE_PROCESS_PVT.uniqueness_check
1189: (
1190: p_type => p_data_set_type,
1191: p_group_num => l_group_num,
1192: x_processing_row_tbl => l_processing_row_tbl,

Line 1200: PO_PDOI_LINE_PROCESS_PVT.split_lines

1196:
1197: d_position := 70;
1198:
1199: -- separate data records into two set, one for create and one for update
1200: PO_PDOI_LINE_PROCESS_PVT.split_lines
1201: (
1202: p_group_num => l_group_num,
1203: p_lines => l_lines,
1204: x_create_lines => l_create_lines,

Line 1252: PO_PDOI_LINE_PROCESS_PVT.open_lines

1248: PO_PDOI_UTL.commit_work;
1249:
1250: IF (l_lines_csr%ISOPEN) THEN
1251: CLOSE l_lines_csr;
1252: PO_PDOI_LINE_PROCESS_PVT.open_lines
1253: (
1254: p_data_set_type => p_data_set_type,
1255: p_max_intf_line_id => l_max_intf_line_id,
1256: x_lines_csr => l_lines_csr

Line 1402: PO_PDOI_LINE_PROCESS_PVT.derive_lines

1398: RETURN;
1399: END IF;
1400:
1401: -- derive logic
1402: PO_PDOI_LINE_PROCESS_PVT.derive_lines
1403: (
1404: x_lines => x_lines
1405: );
1406:

Line 1410: PO_PDOI_LINE_PROCESS_PVT.default_lines

1406:
1407: d_position := 10;
1408:
1409: -- default logic
1410: PO_PDOI_LINE_PROCESS_PVT.default_lines
1411: (
1412: x_lines => x_lines
1413: );
1414:

Line 1418: PO_PDOI_LINE_PROCESS_PVT.validate_lines

1414:
1415: d_position := 20;
1416:
1417: -- validate lines
1418: PO_PDOI_LINE_PROCESS_PVT.validate_lines
1419: (
1420: x_lines => x_lines
1421: );
1422:

Line 1426: PO_PDOI_LINE_PROCESS_PVT.check_line_locations

1422:
1423: d_position := 30;
1424:
1425: -- check whether line location needs to be created for the line
1426: PO_PDOI_LINE_PROCESS_PVT.check_line_locations
1427: (
1428: x_lines => x_lines
1429: );
1430:

Line 1456: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

1452:
1453: d_position := 60;
1454:
1455: -- update po_lines_interface with po_line_id and line level action
1456: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1457: (
1458: x_lines => x_lines
1459: );
1460:

Line 1564: PO_PDOI_LINE_PROCESS_PVT.derive_lines_for_update

1560: RETURN;
1561: END IF;
1562:
1563: -- derive internal identifier for updatable attributes
1564: PO_PDOI_LINE_PROCESS_PVT.derive_lines_for_update
1565: (
1566: x_lines => x_lines
1567: );
1568:

Line 1570: PO_PDOI_LINE_PROCESS_PVT.default_lines_for_update

1566: x_lines => x_lines
1567: );
1568:
1569: -- default certain attributes for processing purpose
1570: PO_PDOI_LINE_PROCESS_PVT.default_lines_for_update
1571: (
1572: x_lines => x_lines
1573: );
1574:

Line 1576: PO_PDOI_LINE_PROCESS_PVT.validate_lines

1572: x_lines => x_lines
1573: );
1574:
1575: -- validate lines
1576: PO_PDOI_LINE_PROCESS_PVT.validate_lines
1577: (
1578: p_action => 'UPDATE',
1579: x_lines => x_lines
1580: );

Line 1585: PO_PDOI_LINE_PROCESS_PVT.check_line_locations

1581:
1582: d_position := 10;
1583:
1584: -- check whether line location needs to be created for the line
1585: PO_PDOI_LINE_PROCESS_PVT.check_line_locations
1586: (
1587: x_lines => x_lines
1588: );
1589:

Line 1601: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

1597:
1598: d_position := 30;
1599:
1600: -- update po_lines_interface with po_line_id and line level action
1601: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
1602: (
1603: x_lines => x_lines
1604: );
1605:

Line 2940: PO_PDOI_LINE_PROCESS_PVT.open_lines

2936: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
2937: END IF;
2938:
2939: -- open cursor for the correct query
2940: PO_PDOI_LINE_PROCESS_PVT.open_lines
2941: (
2942: p_data_set_type => p_data_set_type,
2943: p_max_intf_line_id => l_max_intf_line_id,
2944: x_lines_csr => l_lines_csr

Line 2969: PO_PDOI_LINE_PROCESS_PVT.fetch_lines

2965:
2966: BEGIN
2967:
2968: -- fetch one batch of line records from query result
2969: PO_PDOI_LINE_PROCESS_PVT.fetch_lines
2970: (
2971: x_lines_csr => l_lines_csr,
2972: x_lines => l_lines
2973: );

Line 3062: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl

3058:
3059: d_position := 90;
3060:
3061: -- update po_lines_interface with po_line_id and line level action
3062: PO_PDOI_LINE_PROCESS_PVT.update_line_intf_tbl
3063: (
3064: x_lines => l_lines
3065: );
3066: --CLM PDOI Integration

Line 3120: PO_PDOI_LINE_PROCESS_PVT.open_lines

3116: PO_PDOI_UTL.commit_work;
3117:
3118: IF (l_lines_csr%ISOPEN) THEN
3119: CLOSE l_lines_csr;
3120: PO_PDOI_LINE_PROCESS_PVT.open_lines
3121: (
3122: p_data_set_type => p_data_set_type,
3123: p_max_intf_line_id => l_max_intf_line_id,
3124: x_lines_csr => l_lines_csr