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.OE_SHIP_CONFIRMATION_PUB dependencies on OE_ORDER_PUB

Line 41: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type

37:
38: PROCEDURE Ship_Confirm
39: (
40: p_api_version_number IN NUMBER
41: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
42: , p_line_adj_tbl IN OE_ORDER_PUB.Line_adj_Tbl_Type
43: , p_req_qty_tbl IN Req_Quantity_Tbl_Type
44: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 42: , p_line_adj_tbl IN OE_ORDER_PUB.Line_adj_Tbl_Type

38: PROCEDURE Ship_Confirm
39: (
40: p_api_version_number IN NUMBER
41: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
42: , p_line_adj_tbl IN OE_ORDER_PUB.Line_adj_Tbl_Type
43: , p_req_qty_tbl IN Req_Quantity_Tbl_Type
44: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
46: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 50: l_line_rec OE_Order_PUB.Line_Rec_Type;

46: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47: )
48: IS
49: l_api_version_number CONSTANT NUMBER := 1.0;
50: l_line_rec OE_Order_PUB.Line_Rec_Type;
51: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;
52:
53: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
54: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 51: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;

47: )
48: IS
49: l_api_version_number CONSTANT NUMBER := 1.0;
50: l_line_rec OE_Order_PUB.Line_Rec_Type;
51: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;
52:
53: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
54: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
55: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 53: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

49: l_api_version_number CONSTANT NUMBER := 1.0;
50: l_line_rec OE_Order_PUB.Line_Rec_Type;
51: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;
52:
53: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
54: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
55: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
56: l_notify BOOLEAN := FALSE;
57:

Line 54: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

50: l_line_rec OE_Order_PUB.Line_Rec_Type;
51: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;
52:
53: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
54: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
55: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
56: l_notify BOOLEAN := FALSE;
57:
58: l_result_out VARCHAR2(30);

Line 55: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

51: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;
52:
53: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
54: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
55: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
56: l_notify BOOLEAN := FALSE;
57:
58: l_result_out VARCHAR2(30);
59:

Line 119: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

115:
116: -- HW addeded variables for DUAL (OPM)
117: -- l_OPM_requested_quantity NUMBER; INVCONV
118: l_ordered_quantity2 NUMBER;
119: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
120: l_line_set_id NUMBER;
121: l_control_rec OE_GLOBALS.Control_Rec_Type;
122: l_set_recursion VARCHAR2(1) := 'N';
123:

Line 320: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

316:
317: -- Assign the first record of the table for process order for update
318: -- of the ordered quantity.
319:
320: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
321:
322: IF l_ato_line_id IS NOT NULL and l_item_type_code <> 'STANDARD' THEN
323: l_split_line_tbl(1).line_id := l_top_model_line_id;
324: IF l_debug_level > 0 THEN

Line 348: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;

344:
345: -- Assign the second record of the table for process order for
346: -- create of new line.
347:
348: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
349:
350: IF l_ato_line_id IS NOT NULL and l_item_type_code <> 'STANDARD' THEN
351: l_split_line_tbl(2).split_from_line_id := l_top_model_line_id;
352: IF l_debug_level > 0 THEN

Line 1738: l_split_line_rec OE_Order_Pub.Line_Rec_Type;

1734: PROCEDURE Handle_Requested_Qty
1735: ( p_requested_line_rec IN OUT NOCOPY Ship_Line_Rec_Type)
1736: IS
1737: --J NUMBER := 0; bug 4422886
1738: l_split_line_rec OE_Order_Pub.Line_Rec_Type;
1739: l_control_rec OE_GLOBALS.Control_Rec_Type;
1740: l_return_status VARCHAR2(1);
1741: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1742: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;

Line 1742: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;

1738: l_split_line_rec OE_Order_Pub.Line_Rec_Type;
1739: l_control_rec OE_GLOBALS.Control_Rec_Type;
1740: l_return_status VARCHAR2(1);
1741: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1742: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;
1743: l_wdd_count NUMBER;
1744: BEGIN
1745: IF l_debug_level > 0 THEN
1746: oe_debug_pub.add('entering handle_requested_Quantity ', 5);

Line 1797: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1793: ,p_handle_req_qty => 'Y'
1794: ,p_index => I );
1795: -- ,x_dual_item => l_return_status); -- INVCONV
1796:
1797: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1798:
1799: --J := J + 1; bug 4422886
1800:
1801: IF p_requested_line_rec.ordered_quantity(I) >

Line 1848: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1844:
1845: --Bug 7534520. Ord qty2 was incorrect because two minus signs
1846: --were used. Removed one of them.
1847:
1848: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1849:
1850: l_split_line_rec.line_set_id := p_requested_line_rec.line_set_id(I);
1851: l_split_line_rec.ordered_quantity
1852: := p_requested_line_rec.ordered_quantity(I)

Line 1929: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

1925: -- ,p_opm_check IN VARCHAR2 := 'Y' -- INVCONV - NOT NEEDed NOW
1926: ,p_index IN NUMBER
1927: ,p_split_model IN VARCHAR2 := 'N')
1928: IS
1929: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1930: l_control_rec OE_GLOBALS.Control_Rec_Type;
1931: l_return_status VARCHAR2(1);
1932: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1933: l_return NUMBER; --Bug 7528326

Line 1940: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

1936: IF l_debug_level > 0 THEN
1937: oe_debug_pub.add('entering local split line', 3);
1938: END IF;
1939:
1940: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
1941: l_line_tbl(2) := l_line_tbl(1);
1942: IF l_debug_level > 0 THEN
1943: oe_debug_pub.add('local split line 1 ', 3);
1944: END IF;

Line 2251: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2247: -------------------------------------------------------------*/
2248: PROCEDURE Fulfill_Remnant_PTO
2249: (p_top_model_line_id IN NUMBER)
2250: IS
2251: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2252: l_x_result_out VARCHAR2(30);
2253: l_return_status VARCHAR2(1);
2254: l_msg_count NUMBER;
2255: l_msg_data VARCHAR2(2000);

Line 2261: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2257: l_activity_status VARCHAR2(8);
2258: l_activity_result VARCHAR2(30);
2259: l_activity_id NUMBER;
2260: l_fulfillment_activity VARCHAR2(30);
2261: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2262: l_fulfill_index NUMBER := 0 ;
2263: l_fulfillment_set_flag VARCHAR2(1); -- for bug 4176692
2264:
2265: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2338: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

2334: l_fulfillment_activity = 'SHIP_LINE') AND
2335: l_fulfillment_set_flag = FND_API.G_FALSE THEN -- bug 4176692
2336:
2337: l_fulfill_index := l_fulfill_index + 1;
2338: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2339: l_fulfill_tbl(l_fulfill_index).line_id := line_rec.line_id;
2340: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
2341: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
2342: l_fulfill_tbl(l_fulfill_index).fulfilled_quantity

Line 2722: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;

2718: IS
2719: l_count NUMBER;
2720: l_count1 NUMBER;
2721: l_proportional_ship VARCHAR2(1) := 'Y';
2722: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;
2723: l_return_status VARCHAR2(1) := 'Y';
2724: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2725: l_index NUMBER;
2726: l_model_remnant_flag VARCHAR2(1) := 'N';

Line 3501: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3497: ( p_ship_line_rec IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type
3498: ,p_index IN NUMBER
3499: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3500: IS
3501: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3502: l_line_adj_tbl OE_ORDER_PUB.Line_adj_Tbl_Type;
3503: l_req_qty_tbl Req_Quantity_Tbl_Type;
3504: l_msg_count NUMBER;
3505: l_msg_data VARCHAR2(2000);

Line 3502: l_line_adj_tbl OE_ORDER_PUB.Line_adj_Tbl_Type;

3498: ,p_index IN NUMBER
3499: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3500: IS
3501: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3502: l_line_adj_tbl OE_ORDER_PUB.Line_adj_Tbl_Type;
3503: l_req_qty_tbl Req_Quantity_Tbl_Type;
3504: l_msg_count NUMBER;
3505: l_msg_data VARCHAR2(2000);
3506: I NUMBER;

Line 3588: l_set_tbl OE_Order_Pub.Line_Tbl_Type;

3584: AND shipped_quantity is NULL;
3585:
3586: I NUMBER;
3587: J NUMBER;
3588: l_set_tbl OE_Order_Pub.Line_Tbl_Type;
3589: l_control_rec OE_GLOBALS.Control_Rec_Type;
3590: l_return_status VARCHAR2(1);
3591: l_line_id NUMBER ;
3592: --

Line 3637: l_set_tbl(J) := OE_Order_Pub.G_MISS_LINE_REC;

3633: FOR UPDATE NOWAIT;
3634:
3635: J := J + 1;
3636:
3637: l_set_tbl(J) := OE_Order_Pub.G_MISS_LINE_REC;
3638:
3639: IF line_rec.model_remnant_flag = 'N' AND
3640: line_rec.top_model_line_id is NOT NULL THEN
3641: l_set_tbl(J).line_id := line_rec.top_model_line_id;

Line 3721: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3717: ,p_requested_line_rec IN OUT NOCOPY Ship_Line_Rec_Type
3718: ,x_return_status OUT NOCOPY VARCHAR2)
3719: IS
3720: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3721: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3722: J NUMBER;
3723: l_price_control_rec QP_PREQ_GRP.control_record_type;
3724: l_request_rec OE_Order_PUB.request_rec_type;
3725: l_rem_top_model_line_id NUMBER := -1;

Line 3724: l_request_rec OE_Order_PUB.request_rec_type;

3720: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3721: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3722: J NUMBER;
3723: l_price_control_rec QP_PREQ_GRP.control_record_type;
3724: l_request_rec OE_Order_PUB.request_rec_type;
3725: l_rem_top_model_line_id NUMBER := -1;
3726: l_varchar1 VARCHAR2(1);
3727: l_model_tbl ship_confirm_models;
3728: l_set_tbl ship_confirm_sets;

Line 3730: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

3726: l_varchar1 VARCHAR2(1);
3727: l_model_tbl ship_confirm_models;
3728: l_set_tbl ship_confirm_sets;
3729: I NUMBER;
3730: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3731: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
3732: l_return_status VARCHAR2(1);
3733: l_ship_set_id NUMBER := -1;
3734: l_arrival_set_id NUMBER := -1;

Line 3731: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

3727: l_model_tbl ship_confirm_models;
3728: l_set_tbl ship_confirm_sets;
3729: I NUMBER;
3730: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3731: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
3732: l_return_status VARCHAR2(1);
3733: l_ship_set_id NUMBER := -1;
3734: l_arrival_set_id NUMBER := -1;
3735: --bug 3654553

Line 3748: l_header_rec OE_Order_PUB.Header_Rec_Type;

3744: --CC Reversal ER#16014135 Start
3745: l_msg_count NUMBER := 0;
3746: l_msg_data VARCHAR2(2000);
3747: l_cc_rev_reauth_code VARCHAR2(30) := NULL;
3748: l_header_rec OE_Order_PUB.Header_Rec_Type;
3749: l_result_out VARCHAR2(30);
3750: --CC Reversal ER#16014135 End
3751:
3752: BEGIN

Line 4493: l_request_rec OE_Order_PUB.request_rec_type;

4489: ,x_return_status OUT NOCOPY VARCHAR2)
4490: IS
4491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4492: l_price_control_rec QP_PREQ_GRP.control_record_type;
4493: l_request_rec OE_Order_PUB.request_rec_type;
4494: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
4495: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
4496: l_return_status VARCHAR2(1);
4497: l_last_top_model NUMBER := -1;

Line 4494: l_line_tbl OE_ORDER_PUB.line_Tbl_type;

4490: IS
4491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4492: l_price_control_rec QP_PREQ_GRP.control_record_type;
4493: l_request_rec OE_Order_PUB.request_rec_type;
4494: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
4495: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
4496: l_return_status VARCHAR2(1);
4497: l_last_top_model NUMBER := -1;
4498: --bug 3654553

Line 4495: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;

4491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4492: l_price_control_rec QP_PREQ_GRP.control_record_type;
4493: l_request_rec OE_Order_PUB.request_rec_type;
4494: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
4495: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
4496: l_return_status VARCHAR2(1);
4497: l_last_top_model NUMBER := -1;
4498: --bug 3654553
4499: J NUMBER;

Line 4514: l_header_rec OE_Order_PUB.Header_Rec_Type;

4510: l_msg_count NUMBER := 0;
4511: l_msg_data VARCHAR2(2000);
4512: l_result_out VARCHAR2(30);
4513: l_cc_rev_reauth_code VARCHAR2(30) := NULL;
4514: l_header_rec OE_Order_PUB.Header_Rec_Type;
4515: --CC Reversal ER#16014135 End
4516:
4517: BEGIN
4518:

Line 5287: l_line_rec OE_Order_Pub.Line_Rec_Type;

5283: IS
5284: --
5285: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5286: --
5287: l_line_rec OE_Order_Pub.Line_Rec_Type;
5288: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
5289: l_start_time NUMBER;
5290: l_end_time NUMBER;
5291: I NUMBER;

Line 5288: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

5284: --
5285: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5286: --
5287: l_line_rec OE_Order_Pub.Line_Rec_Type;
5288: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
5289: l_start_time NUMBER;
5290: l_end_time NUMBER;
5291: I NUMBER;
5292: J NUMBER;

Line 5514: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;

5510: x_msg_data OUT NOCOPY VARCHAR2
5511: )
5512: IS
5513:
5514: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5515: l_line_rec OE_ORDER_PUB.line_rec_type;
5516: l_tolerance_check VARCHAR2(256);
5517: l_count NUMBER DEFAULT 0;
5518: l_return_status VARCHAR2(256);

Line 5515: l_line_rec OE_ORDER_PUB.line_rec_type;

5511: )
5512: IS
5513:
5514: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5515: l_line_rec OE_ORDER_PUB.line_rec_type;
5516: l_tolerance_check VARCHAR2(256);
5517: l_count NUMBER DEFAULT 0;
5518: l_return_status VARCHAR2(256);
5519: