DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_OTM_SCHEDULE_LINE_TYPE

Line 28: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

24: );
25:
26: PROCEDURE populate_address_info (
27: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
28: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
29: );
30:
31: PROCEDURE populate_drop_ship_info (
32: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

Line 32: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

28: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
29: );
30:
31: PROCEDURE populate_drop_ship_info (
32: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
33: );
34:
35: PROCEDURE get_approved_po (
36: p_doc_id IN NUMBER

Line 800: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

796: AND plla.approved_flag = 'Y'
797: AND NVL(plla.cancel_flag, 'N') <> 'Y';
798:
799: l_count NUMBER;
800: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
801: l_gt_key1 NUMBER;
802: l_gt_key2 NUMBER;
803:
804: d_progress VARCHAR2(3);

Line 1025: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();

1021: -- pull all shipments with pertinent line info
1022: LOOP
1023: d_progress := '100';
1024:
1025: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
1026:
1027: d_progress := '110';
1028:
1029: FETCH get_shipment_line_info

Line 1299: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

1295: AND NVL(p_line_loc_id, plla.line_location_id) = plla.line_location_id
1296: ;
1297:
1298: l_count NUMBER;
1299: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
1300:
1301: d_progress VARCHAR2(3);
1302: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'GET_PO_FOR_STATUS_CHANGE';
1303:

Line 1357: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();

1353: -- pull all shipments with pertinent line info
1354: LOOP
1355: d_progress := '100';
1356:
1357: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
1358:
1359: d_progress := '110';
1360:
1361: FETCH get_shipment_line_info

Line 1557: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

1553: AND plla.approved_flag = 'Y'
1554: AND NVL(plla.cancel_flag, 'N') <> 'Y';
1555:
1556: l_count NUMBER;
1557: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
1558: l_gt_key1 NUMBER;
1559: l_gt_key2 NUMBER;
1560:
1561: d_progress VARCHAR2(3);

Line 1791: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();

1787: -- pull all shipments with pertinent line info
1788: LOOP
1789: d_progress := '100';
1790:
1791: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
1792:
1793: d_progress := '110';
1794:
1795: FETCH get_shipment_line_info

Line 2070: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

2066: AND NVL(msi.outside_operation_flag, 'N') = 'N'
2067: AND NVL(p_line_loc_id, plla.line_location_id) = plla.line_location_id;
2068:
2069: l_count NUMBER;
2070: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2071:
2072: d_progress VARCHAR2(3);
2073: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'GET_RELEASE_FOR_STATUS_CHANGE';
2074:

Line 2132: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();

2128: -- pull all shipments with pertinent line info
2129: LOOP
2130: d_progress := '100';
2131:
2132: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
2133:
2134: d_progress := '110';
2135:
2136: FETCH get_shipment_line_info

Line 2333: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

2329: END populate_address_info;
2330:
2331: PROCEDURE populate_address_info (
2332: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2333: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2334: )
2335: IS
2336:
2337: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;

Line 2427: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

2423:
2424: END populate_address_info;
2425:
2426: PROCEDURE populate_drop_ship_info (
2427: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2428: )
2429: IS
2430:
2431: l_order_line_info_rec OE_DROP_SHIP_GRP.order_line_info_rec_type;