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 40: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type

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

Line 41: , p_line_adj_tbl IN OE_ORDER_PUB.Line_adj_Tbl_Type

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

Line 49: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 50: l_line_adj_rec OE_ORDER_PUB.Line_adj_rec_type;

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

Line 52: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

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

Line 53: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

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

Line 54: l_temp_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

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

Line 117: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

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

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

308:
309: -- Assign the first record of the table for process order for update
310: -- of the ordered quantity.
311:
312: l_split_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
313:
314: IF l_ato_line_id IS NOT NULL and l_item_type_code <> 'STANDARD' THEN
315: l_split_line_tbl(1).line_id := l_top_model_line_id;
316: IF l_debug_level > 0 THEN

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

335:
336: -- Assign the second record of the table for process order for
337: -- create of new line.
338:
339: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
340:
341: IF l_ato_line_id IS NOT NULL and l_item_type_code <> 'STANDARD' THEN
342: l_split_line_tbl(2).split_from_line_id := l_top_model_line_id;
343: IF l_debug_level > 0 THEN

Line 1652: l_split_line_rec OE_Order_Pub.Line_Rec_Type;

1648: PROCEDURE Handle_Requested_Qty
1649: ( p_requested_line_rec IN OUT NOCOPY Ship_Line_Rec_Type)
1650: IS
1651: --J NUMBER := 0; bug 4422886
1652: l_split_line_rec OE_Order_Pub.Line_Rec_Type;
1653: l_control_rec OE_GLOBALS.Control_Rec_Type;
1654: l_return_status VARCHAR2(1);
1655: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1656: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;

Line 1656: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;

1652: l_split_line_rec OE_Order_Pub.Line_Rec_Type;
1653: l_control_rec OE_GLOBALS.Control_Rec_Type;
1654: l_return_status VARCHAR2(1);
1655: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1656: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;
1657: l_wdd_count NUMBER;
1658: BEGIN
1659: IF l_debug_level > 0 THEN
1660: oe_debug_pub.add('entering handle_requested_Quantity ', 5);

Line 1710: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1706: ,p_handle_req_qty => 'Y'
1707: ,p_index => I );
1708: -- ,x_dual_item => l_return_status); -- INVCONV
1709:
1710: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1711:
1712: --J := J + 1; bug 4422886
1713:
1714: IF p_requested_line_rec.ordered_quantity(I) >

Line 1756: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1752: || l_split_line_tbl(1).ordered_quantity, 1);
1753: END IF;
1754:
1755:
1756: l_split_line_Rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1757:
1758: l_split_line_rec.line_set_id := p_requested_line_rec.line_set_id(I);
1759: l_split_line_rec.ordered_quantity
1760: := p_requested_line_rec.ordered_quantity(I)

Line 1839: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

1835: -- ,p_opm_check IN VARCHAR2 := 'Y' -- INVCONV - NOT NEEDed NOW
1836: ,p_index IN NUMBER
1837: ,p_split_model IN VARCHAR2 := 'N')
1838: IS
1839: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1840: l_control_rec OE_GLOBALS.Control_Rec_Type;
1841: l_return_status VARCHAR2(1);
1842: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1843: l_return NUMBER; --Bug 7528326

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

1846: IF l_debug_level > 0 THEN
1847: oe_debug_pub.add('entering local split line', 3);
1848: END IF;
1849:
1850: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
1851: l_line_tbl(2) := l_line_tbl(1);
1852: IF l_debug_level > 0 THEN
1853: oe_debug_pub.add('pal local split line 1 ', 3);
1854: END IF;

Line 2109: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

2105: -------------------------------------------------------------*/
2106: PROCEDURE Fulfill_Remnant_PTO
2107: (p_top_model_line_id IN NUMBER)
2108: IS
2109: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2110: l_x_result_out VARCHAR2(30);
2111: l_return_status VARCHAR2(1);
2112: l_msg_count NUMBER;
2113: l_msg_data VARCHAR2(2000);

Line 2119: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;

2115: l_activity_status VARCHAR2(8);
2116: l_activity_result VARCHAR2(30);
2117: l_activity_id NUMBER;
2118: l_fulfillment_activity VARCHAR2(30);
2119: l_fulfill_tbl OE_Order_Pub.Line_Tbl_Type;
2120: l_fulfill_index NUMBER := 0 ;
2121: l_fulfillment_set_flag VARCHAR2(1); -- for bug 4176692
2122:
2123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

2191: l_fulfillment_activity = 'SHIP_LINE') AND
2192: l_fulfillment_set_flag = FND_API.G_FALSE THEN -- bug 4176692
2193:
2194: l_fulfill_index := l_fulfill_index + 1;
2195: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2196: l_fulfill_tbl(l_fulfill_index).line_id := line_rec.line_id;
2197: l_fulfill_tbl(l_fulfill_index).fulfilled_flag := 'Y';
2198: l_fulfill_tbl(l_fulfill_index).fulfillment_date := SYSDATE;
2199: l_fulfill_tbl(l_fulfill_index).fulfilled_quantity

Line 2573: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;

2569: IS
2570: l_count NUMBER;
2571: l_count1 NUMBER;
2572: l_proportional_ship VARCHAR2(1) := 'Y';
2573: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;
2574: l_return_status VARCHAR2(1) := 'Y';
2575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2576: l_index NUMBER;
2577: l_model_remnant_flag VARCHAR2(1) := 'N';

Line 3320: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3316: ( p_ship_line_rec IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type
3317: ,p_index IN NUMBER
3318: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3319: IS
3320: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3321: l_line_adj_tbl OE_ORDER_PUB.Line_adj_Tbl_Type;
3322: l_req_qty_tbl Req_Quantity_Tbl_Type;
3323: l_msg_count NUMBER;
3324: l_msg_data VARCHAR2(2000);

Line 3321: l_line_adj_tbl OE_ORDER_PUB.Line_adj_Tbl_Type;

3317: ,p_index IN NUMBER
3318: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3319: IS
3320: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3321: l_line_adj_tbl OE_ORDER_PUB.Line_adj_Tbl_Type;
3322: l_req_qty_tbl Req_Quantity_Tbl_Type;
3323: l_msg_count NUMBER;
3324: l_msg_data VARCHAR2(2000);
3325: I NUMBER;

Line 3407: l_set_tbl OE_Order_Pub.Line_Tbl_Type;

3403: AND shipped_quantity is NULL;
3404:
3405: I NUMBER;
3406: J NUMBER;
3407: l_set_tbl OE_Order_Pub.Line_Tbl_Type;
3408: l_control_rec OE_GLOBALS.Control_Rec_Type;
3409: l_return_status VARCHAR2(1);
3410: l_line_id NUMBER ;
3411: --

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

3451: FOR UPDATE NOWAIT;
3452:
3453: J := J + 1;
3454:
3455: l_set_tbl(J) := OE_Order_Pub.G_MISS_LINE_REC;
3456:
3457: IF line_rec.model_remnant_flag = 'N' AND
3458: line_rec.top_model_line_id is NOT NULL THEN
3459: l_set_tbl(J).line_id := line_rec.top_model_line_id;

Line 3539: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

3535: ,p_requested_line_rec IN OUT NOCOPY Ship_Line_Rec_Type
3536: ,x_return_status OUT NOCOPY VARCHAR2)
3537: IS
3538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3539: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3540: J NUMBER;
3541: l_price_control_rec QP_PREQ_GRP.control_record_type;
3542: l_request_rec OE_Order_PUB.request_rec_type;
3543: l_rem_top_model_line_id NUMBER := -1;

Line 3542: l_request_rec OE_Order_PUB.request_rec_type;

3538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3539: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3540: J NUMBER;
3541: l_price_control_rec QP_PREQ_GRP.control_record_type;
3542: l_request_rec OE_Order_PUB.request_rec_type;
3543: l_rem_top_model_line_id NUMBER := -1;
3544: l_varchar1 VARCHAR2(1);
3545: l_model_tbl ship_confirm_models;
3546: l_set_tbl ship_confirm_sets;

Line 3548: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

3544: l_varchar1 VARCHAR2(1);
3545: l_model_tbl ship_confirm_models;
3546: l_set_tbl ship_confirm_sets;
3547: I NUMBER;
3548: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3549: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
3550: l_return_status VARCHAR2(1);
3551: l_ship_set_id NUMBER := -1;
3552: l_arrival_set_id NUMBER := -1;

Line 3549: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

3545: l_model_tbl ship_confirm_models;
3546: l_set_tbl ship_confirm_sets;
3547: I NUMBER;
3548: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
3549: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
3550: l_return_status VARCHAR2(1);
3551: l_ship_set_id NUMBER := -1;
3552: l_arrival_set_id NUMBER := -1;
3553: --bug 3654553

Line 4209: l_request_rec OE_Order_PUB.request_rec_type;

4205: ,x_return_status OUT NOCOPY VARCHAR2)
4206: IS
4207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4208: l_price_control_rec QP_PREQ_GRP.control_record_type;
4209: l_request_rec OE_Order_PUB.request_rec_type;
4210: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
4211: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
4212: l_return_status VARCHAR2(1);
4213: l_last_top_model NUMBER := -1;

Line 4210: l_line_tbl OE_ORDER_PUB.line_Tbl_type;

4206: IS
4207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4208: l_price_control_rec QP_PREQ_GRP.control_record_type;
4209: l_request_rec OE_Order_PUB.request_rec_type;
4210: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
4211: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
4212: l_return_status VARCHAR2(1);
4213: l_last_top_model NUMBER := -1;
4214: --bug 3654553

Line 4211: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;

4207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4208: l_price_control_rec QP_PREQ_GRP.control_record_type;
4209: l_request_rec OE_Order_PUB.request_rec_type;
4210: l_line_tbl OE_ORDER_PUB.line_Tbl_type;
4211: l_old_line_tbl OE_ORDER_PUB.line_Tbl_type;
4212: l_return_status VARCHAR2(1);
4213: l_last_top_model NUMBER := -1;
4214: --bug 3654553
4215: J NUMBER;

Line 4911: l_line_rec OE_Order_Pub.Line_Rec_Type;

4907: IS
4908: --
4909: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4910: --
4911: l_line_rec OE_Order_Pub.Line_Rec_Type;
4912: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
4913: l_start_time NUMBER;
4914: l_end_time NUMBER;
4915: I NUMBER;

Line 4912: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

4908: --
4909: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4910: --
4911: l_line_rec OE_Order_Pub.Line_Rec_Type;
4912: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
4913: l_start_time NUMBER;
4914: l_end_time NUMBER;
4915: I NUMBER;
4916: J NUMBER;

Line 5134: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;

5130: x_msg_data OUT NOCOPY VARCHAR2
5131: )
5132: IS
5133:
5134: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5135: l_line_rec OE_ORDER_PUB.line_rec_type;
5136: l_tolerance_check VARCHAR2(256);
5137: l_count NUMBER DEFAULT 0;
5138: l_return_status VARCHAR2(256);

Line 5135: l_line_rec OE_ORDER_PUB.line_rec_type;

5131: )
5132: IS
5133:
5134: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5135: l_line_rec OE_ORDER_PUB.line_rec_type;
5136: l_tolerance_check VARCHAR2(256);
5137: l_count NUMBER DEFAULT 0;
5138: l_return_status VARCHAR2(256);
5139: