DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_OTM_SCHEDULE_LINE_TYPE

Line 33: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

29: );
30:
31: PROCEDURE populate_address_info (
32: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
33: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
34: );
35:
36: PROCEDURE populate_drop_ship_info (
37: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

Line 37: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

33: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
34: );
35:
36: PROCEDURE populate_drop_ship_info (
37: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
38: );
39:
40: PROCEDURE get_approved_po (
41: p_doc_id IN NUMBER

Line 870: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

866: AND plla.approved_flag = 'Y'
867: AND NVL(plla.cancel_flag, 'N') <> 'Y';
868:
869: l_count NUMBER;
870: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
871: l_gt_key1 NUMBER;
872: l_gt_key2 NUMBER;
873:
874: d_progress VARCHAR2(3);

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

1091: -- pull all shipments with pertinent line info
1092: LOOP
1093: d_progress := '100';
1094:
1095: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
1096:
1097: d_progress := '110';
1098:
1099: FETCH get_shipment_line_info

Line 1371: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

1367: AND NVL(p_line_loc_id, plla.line_location_id) = plla.line_location_id
1368: ;
1369:
1370: l_count NUMBER;
1371: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
1372:
1373: d_progress VARCHAR2(3);
1374: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'GET_PO_FOR_STATUS_CHANGE';
1375:

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

1425: -- pull all shipments with pertinent line info
1426: LOOP
1427: d_progress := '100';
1428:
1429: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
1430:
1431: d_progress := '110';
1432:
1433: FETCH get_shipment_line_info

Line 1629: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

1625: AND plla.approved_flag = 'Y'
1626: AND NVL(plla.cancel_flag, 'N') <> 'Y';
1627:
1628: l_count NUMBER;
1629: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
1630: l_gt_key1 NUMBER;
1631: l_gt_key2 NUMBER;
1632:
1633: d_progress VARCHAR2(3);

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

1859: -- pull all shipments with pertinent line info
1860: LOOP
1861: d_progress := '100';
1862:
1863: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
1864:
1865: d_progress := '110';
1866:
1867: FETCH get_shipment_line_info

Line 2142: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

2138: AND NVL(msi.outside_operation_flag, 'N') = 'N'
2139: AND NVL(p_line_loc_id, plla.line_location_id) = plla.line_location_id;
2140:
2141: l_count NUMBER;
2142: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2143:
2144: d_progress VARCHAR2(3);
2145: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'GET_RELEASE_FOR_STATUS_CHANGE';
2146:

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

2200: -- pull all shipments with pertinent line info
2201: LOOP
2202: d_progress := '100';
2203:
2204: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
2205:
2206: d_progress := '110';
2207:
2208: FETCH get_shipment_line_info

Line 2405: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

2401: END populate_address_info;
2402:
2403: PROCEDURE populate_address_info (
2404: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2405: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2406: )
2407: IS
2408:
2409: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;

Line 2500: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE

2496:
2497: END populate_address_info;
2498:
2499: PROCEDURE populate_drop_ship_info (
2500: x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2501: )
2502: IS
2503:
2504: l_order_line_info_rec OE_DROP_SHIP_GRP.order_line_info_rec_type;

Line 2770: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2769:
2770: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2771:
2772: l_count NUMBER := 0;
2773: BEGIN
2774:

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

2826:
2827: LOOP
2828: l_count := l_count + 1;
2829:
2830: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
2831:
2832: d_progress := '030';
2833:
2834: FETCH get_shipment_lines

Line 2928: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2927:
2928: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2929:
2930: l_count NUMBER := 0;
2931: BEGIN
2932:

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

2989:
2990: LOOP
2991: l_count := l_count + 1;
2992:
2993: l_otm_schedule_line := PO_OTM_SCHEDULE_LINE_TYPE.new_instance();
2994:
2995: d_progress := '030';
2996:
2997: FETCH get_shipment_lines