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_CONFIG_UTIL dependencies on OE_ORDER_PUB

Line 14: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);

10: PROCEDURE Query_Config
11: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
13: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
14: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
15:
16: Procedure get_transaction_id(p_caller IN VARCHAR2);
17:
18: PROCEDURE Print_Time(p_msg IN VARCHAR2);

Line 21: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

17:
18: PROCEDURE Print_Time(p_msg IN VARCHAR2);
19:
20: PROCEDURE Log_Included_Item_Requests
21: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
22: ,p_booked_flag IN VARCHAR2);
23:
24: PROCEDURE Unlock_Config
25: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

Line 25: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

21: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
22: ,p_booked_flag IN VARCHAR2);
23:
24: PROCEDURE Unlock_Config
25: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
26: x_return_status OUT NOCOPY VARCHAR2);
27:
28: /*-------------------------------------------------------------------------
29: Procedure Name : Config_Exists

Line 33: FUNCTION Config_Exists(p_line_rec IN OE_ORDER_PUB.line_rec_type)

29: Procedure Name : Config_Exists
30: Description :
31: --------------------------------------------------------------------------*/
32:
33: FUNCTION Config_Exists(p_line_rec IN OE_ORDER_PUB.line_rec_type)
34: RETURN BOOLEAN
35: IS
36: --
37: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 84: p_request_rec IN OE_Order_Pub.Request_Rec_Type,

80:
81:
82: Procedure Cascade_Changes
83: ( p_parent_line_id IN NUMBER,
84: p_request_rec IN OE_Order_Pub.Request_Rec_Type,
85: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86: )
87:
88: IS

Line 115: l_parent_line_rec OE_ORDER_PUB.Line_Rec_Type;

111: l_shipped_qty NUMBER;
112: l_model_line_id NUMBER;
113: l_model_qty NUMBER;
114: l_model_actual_ship_date DATE;
115: l_parent_line_rec OE_ORDER_PUB.Line_Rec_Type;
116: l_header_id NUMBER := 0;
117:
118:
119: -- process_order in variables

Line 121: l_header_rec OE_Order_PUB.Header_Rec_Type;

117:
118:
119: -- process_order in variables
120: l_control_rec OE_GLOBALS.Control_Rec_Type;
121: l_header_rec OE_Order_PUB.Header_Rec_Type;
122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 122: l_line_rec OE_ORDER_PUB.Line_Rec_Type

118:
119: -- process_order in variables
120: l_control_rec OE_GLOBALS.Control_Rec_Type;
121: l_header_rec OE_Order_PUB.Header_Rec_Type;
122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 123: := OE_ORDER_PUB.G_MISS_LINE_REC;

119: -- process_order in variables
120: l_control_rec OE_GLOBALS.Control_Rec_Type;
121: l_header_rec OE_Order_PUB.Header_Rec_Type;
122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
127: l_line_count NUMBER;

Line 124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

120: l_control_rec OE_GLOBALS.Control_Rec_Type;
121: l_header_rec OE_Order_PUB.Header_Rec_Type;
122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
127: l_line_count NUMBER;
128: l_queried_quantity NUMBER;

Line 125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

121: l_header_rec OE_Order_PUB.Header_Rec_Type;
122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
127: l_line_count NUMBER;
128: l_queried_quantity NUMBER;
129:

Line 214: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

210: l_ordered_qty, l_child_item_type, l_shipped_qty;
211: EXIT when children%NOTFOUND;
212:
213: l_line_count := l_line_count + 1;
214: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
215: l_line_rec.line_id := child_line_id;
216: l_line_rec.inventory_item_id := l_inv_item_id;
217: l_line_rec.ordered_quantity := l_ordered_qty;
218: l_line_rec.shipped_quantity := l_shipped_qty;

Line 577: ,x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)

573: -----------------------------------------------------------------------*/
574:
575: PROCEDURE Query_Config_Line
576: (p_parent_line_id IN NUMBER
577: ,x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)
578: IS
579: l_line_rec OE_ORDER_PUB.line_rec_type;
580: --
581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 579: l_line_rec OE_ORDER_PUB.line_rec_type;

575: PROCEDURE Query_Config_Line
576: (p_parent_line_id IN NUMBER
577: ,x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)
578: IS
579: l_line_rec OE_ORDER_PUB.line_rec_type;
580: --
581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
582: --
583: BEGIN

Line 609: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type,

605: care of change across the configuration.
606: ------------------------------------------------------------------------ */
607:
608: Procedure Change_Configuration
609: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type,
610: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
611: )
612:
613: IS

Line 615: l_changed_line_rec OE_ORDER_PUB.Line_Rec_Type;

611: )
612:
613: IS
614: -- params sent in request rec.
615: l_changed_line_rec OE_ORDER_PUB.Line_Rec_Type;
616: l_top_model_line_id NUMBER;
617: l_ato_line_id NUMBER;
618: l_line_id NUMBER;
619: l_count NUMBER:=0;

Line 624: l_header_rec OE_Order_PUB.Header_Rec_Type;

620: l_header_id NUMBER := 0;
621:
622: -- Process Order Variables
623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_header_rec OE_Order_PUB.Header_Rec_Type;
625: l_line_rec OE_ORDER_PUB.Line_Rec_Type
626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 625: l_line_rec OE_ORDER_PUB.Line_Rec_Type

621:
622: -- Process Order Variables
623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_header_rec OE_Order_PUB.Header_Rec_Type;
625: l_line_rec OE_ORDER_PUB.Line_Rec_Type
626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
629:

Line 626: := OE_ORDER_PUB.G_MISS_LINE_REC;

622: -- Process Order Variables
623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_header_rec OE_Order_PUB.Header_Rec_Type;
625: l_line_rec OE_ORDER_PUB.Line_Rec_Type
626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
629:
630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

623: l_control_rec OE_GLOBALS.Control_Rec_Type;
624: l_header_rec OE_Order_PUB.Header_Rec_Type;
625: l_line_rec OE_ORDER_PUB.Line_Rec_Type
626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
629:
630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
631:

Line 628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

624: l_header_rec OE_Order_PUB.Header_Rec_Type;
625: l_line_rec OE_ORDER_PUB.Line_Rec_Type
626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
629:
630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
631:
632: CURSOR configuration_line(p_header_id IN NUMBER,

Line 689: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

685: l_line_id);
686: LOOP
687: FETCH configuration_line into l_line_id;
688: EXIT when configuration_line%NOTFOUND;
689: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
690: l_line_rec.line_id := l_line_id;
691: l_line_rec.ship_from_org_id := l_changed_line_rec.ship_from_org_id;
692: l_line_rec.ship_to_org_id := l_changed_line_rec.ship_to_org_id;
693: l_line_rec.request_date := l_changed_line_rec.request_date;

Line 824: l_header_rec OE_Order_PUB.Header_Rec_Type;

820: IS
821:
822: -- process_order in variables
823: l_control_rec OE_GLOBALS.Control_Rec_Type;
824: l_header_rec OE_Order_PUB.Header_Rec_Type;
825: l_line_rec OE_ORDER_PUB.Line_Rec_Type
826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 825: l_line_rec OE_ORDER_PUB.Line_Rec_Type

821:
822: -- process_order in variables
823: l_control_rec OE_GLOBALS.Control_Rec_Type;
824: l_header_rec OE_Order_PUB.Header_Rec_Type;
825: l_line_rec OE_ORDER_PUB.Line_Rec_Type
826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
829:

Line 826: := OE_ORDER_PUB.G_MISS_LINE_REC;

822: -- process_order in variables
823: l_control_rec OE_GLOBALS.Control_Rec_Type;
824: l_header_rec OE_Order_PUB.Header_Rec_Type;
825: l_line_rec OE_ORDER_PUB.Line_Rec_Type
826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
829:
830: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

823: l_control_rec OE_GLOBALS.Control_Rec_Type;
824: l_header_rec OE_Order_PUB.Header_Rec_Type;
825: l_line_rec OE_ORDER_PUB.Line_Rec_Type
826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
829:
830: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
831: l_msg_count NUMBER;

Line 828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

824: l_header_rec OE_Order_PUB.Header_Rec_Type;
825: l_line_rec OE_ORDER_PUB.Line_Rec_Type
826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
829:
830: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
831: l_msg_count NUMBER;
832: l_msg_data VARCHAR2(2000);

Line 928: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

924: END IF;
925:
926: END IF; */
927:
928: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
929: l_line_rec.line_id := p_line_id;
930: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
931: l_line_tbl(1) := l_line_rec;
932:

Line 1375: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

1371: becomes invalid/incomplete.
1372: -----------------------------------------------------------------------*/
1373: PROCEDURE Configurator_Validation
1374: (p_model_line_id IN NUMBER,
1375: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1376: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1377: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1378: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1379: p_caller IN VARCHAR2 := '',

Line 1376: := OE_Order_Pub.G_MISS_REQUEST_TBL,

1372: -----------------------------------------------------------------------*/
1373: PROCEDURE Configurator_Validation
1374: (p_model_line_id IN NUMBER,
1375: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1376: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1377: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1378: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1379: p_caller IN VARCHAR2 := '',
1380: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1377: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

1373: PROCEDURE Configurator_Validation
1374: (p_model_line_id IN NUMBER,
1375: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1376: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1377: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1378: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1379: p_caller IN VARCHAR2 := '',
1380: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1381: x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1378: := OE_Order_Pub.G_MISS_REQUEST_TBL,

1374: (p_model_line_id IN NUMBER,
1375: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1376: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1377: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1378: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1379: p_caller IN VARCHAR2 := '',
1380: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1381: x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1382: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 1386: l_model_line_rec OE_ORDER_PUB.line_rec_type;

1382: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1383: IS
1384: l_header_id NUMBER := NULL;
1385: l_model_line_id NUMBER := p_model_line_id;
1386: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1387:
1388: l_updated_options_tbl OE_Order_PUB.request_tbl_type
1389: := p_updated_options_tbl;
1390: l_deleted_options_tbl OE_Order_PUB.request_tbl_type

Line 1388: l_updated_options_tbl OE_Order_PUB.request_tbl_type

1384: l_header_id NUMBER := NULL;
1385: l_model_line_id NUMBER := p_model_line_id;
1386: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1387:
1388: l_updated_options_tbl OE_Order_PUB.request_tbl_type
1389: := p_updated_options_tbl;
1390: l_deleted_options_tbl OE_Order_PUB.request_tbl_type
1391: :=p_deleted_options_tbl;
1392:

Line 1390: l_deleted_options_tbl OE_Order_PUB.request_tbl_type

1386: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1387:
1388: l_updated_options_tbl OE_Order_PUB.request_tbl_type
1389: := p_updated_options_tbl;
1390: l_deleted_options_tbl OE_Order_PUB.request_tbl_type
1391: :=p_deleted_options_tbl;
1392:
1393: l_config_header_id NUMBER;
1394: l_config_rev_nbr NUMBER;

Line 1805: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

1801: PROCEDURE Bom_Config_Validation
1802: (p_model_line_id IN NUMBER,
1803: p_header_id IN NUMBER,
1804: p_model_qty IN NUMBER,
1805: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1806: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1807: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1808: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1809: p_caller IN VARCHAR2 := '',

Line 1806: := OE_Order_Pub.G_MISS_REQUEST_TBL,

1802: (p_model_line_id IN NUMBER,
1803: p_header_id IN NUMBER,
1804: p_model_qty IN NUMBER,
1805: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1806: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1807: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1808: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1809: p_caller IN VARCHAR2 := '',
1810: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1807: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

1803: p_header_id IN NUMBER,
1804: p_model_qty IN NUMBER,
1805: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1806: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1807: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1808: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1809: p_caller IN VARCHAR2 := '',
1810: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1811: x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1808: := OE_Order_Pub.G_MISS_REQUEST_TBL,

1804: p_model_qty IN NUMBER,
1805: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1806: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1807: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1808: := OE_Order_Pub.G_MISS_REQUEST_TBL,
1809: p_caller IN VARCHAR2 := '',
1810: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1811: x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1812: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 1815: l_updated_options_tbl OE_Order_PUB.request_tbl_type;

1811: x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1812: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1813: IS
1814: l_options_tbl Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;
1815: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
1816: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
1817: I NUMBER;
1818: l_change_flag VARCHAR2(1);
1819: l_item_type_code VARCHAR2(30);

Line 1816: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;

1812: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1813: IS
1814: l_options_tbl Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;
1815: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
1816: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
1817: I NUMBER;
1818: l_change_flag VARCHAR2(1);
1819: l_item_type_code VARCHAR2(30);
1820: l_model_component VARCHAR2(1000);

Line 1821: l_req_rec OE_Order_Pub.Request_Rec_Type;

1817: I NUMBER;
1818: l_change_flag VARCHAR2(1);
1819: l_item_type_code VARCHAR2(30);
1820: l_model_component VARCHAR2(1000);
1821: l_req_rec OE_Order_Pub.Request_Rec_Type;
1822: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1823: l_msg_count NUMBER;
1824: l_msg_data VARCHAR2(2000);
1825:

Line 1971: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

1967: ( p_model_line_id IN NUMBER
1968: ,p_model_component IN VARCHAR2
1969: ,p_x_options_tbl IN OUT NOCOPY
1970: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1971: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1972: := OE_Order_Pub.G_MISS_REQUEST_TBL
1973: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1974: := OE_Order_Pub.G_MISS_REQUEST_TBL
1975: ,p_ui_flag IN VARCHAR2 := 'N'

Line 1972: := OE_Order_Pub.G_MISS_REQUEST_TBL

1968: ,p_model_component IN VARCHAR2
1969: ,p_x_options_tbl IN OUT NOCOPY
1970: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1971: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1972: := OE_Order_Pub.G_MISS_REQUEST_TBL
1973: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1974: := OE_Order_Pub.G_MISS_REQUEST_TBL
1975: ,p_ui_flag IN VARCHAR2 := 'N'
1976: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 1973: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

1969: ,p_x_options_tbl IN OUT NOCOPY
1970: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1971: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1972: := OE_Order_Pub.G_MISS_REQUEST_TBL
1973: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1974: := OE_Order_Pub.G_MISS_REQUEST_TBL
1975: ,p_ui_flag IN VARCHAR2 := 'N'
1976: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1977: IS

Line 1974: := OE_Order_Pub.G_MISS_REQUEST_TBL

1970: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
1971: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
1972: := OE_Order_Pub.G_MISS_REQUEST_TBL
1973: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
1974: := OE_Order_Pub.G_MISS_REQUEST_TBL
1975: ,p_ui_flag IN VARCHAR2 := 'N'
1976: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1977: IS
1978: I NUMBER;

Line 1981: l_req_rec OE_Order_Pub.Request_Rec_Type;

1977: IS
1978: I NUMBER;
1979: l_index NUMBER;
1980: l_ratio NUMBER;
1981: l_req_rec OE_Order_Pub.Request_Rec_Type;
1982: l_deleted_options_tbl OE_Order_PUB.request_tbl_type
1983: := p_deleted_options_tbl;
1984: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1985: l_qty NUMBER := 1;

Line 1982: l_deleted_options_tbl OE_Order_PUB.request_tbl_type

1978: I NUMBER;
1979: l_index NUMBER;
1980: l_ratio NUMBER;
1981: l_req_rec OE_Order_Pub.Request_Rec_Type;
1982: l_deleted_options_tbl OE_Order_PUB.request_tbl_type
1983: := p_deleted_options_tbl;
1984: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1985: l_qty NUMBER := 1;
1986: --

Line 2636: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

2632: because all the code is put in OEXVORDB.pls in the lines loop.
2633: -----------------------------------------------------------------------*/
2634: PROCEDURE Validate_Configuration
2635: (p_model_line_id IN NUMBER,
2636: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2637: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2638: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2639: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2640: p_validate_flag IN VARCHAR2 := 'Y',

Line 2637: := OE_Order_Pub.G_MISS_REQUEST_TBL,

2633: -----------------------------------------------------------------------*/
2634: PROCEDURE Validate_Configuration
2635: (p_model_line_id IN NUMBER,
2636: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2637: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2638: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2639: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2640: p_validate_flag IN VARCHAR2 := 'Y',
2641: p_complete_flag IN VARCHAR2 := 'Y',

Line 2638: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

2634: PROCEDURE Validate_Configuration
2635: (p_model_line_id IN NUMBER,
2636: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2637: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2638: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2639: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2640: p_validate_flag IN VARCHAR2 := 'Y',
2641: p_complete_flag IN VARCHAR2 := 'Y',
2642: p_caller IN VARCHAR2 := '',

Line 2639: := OE_Order_Pub.G_MISS_REQUEST_TBL,

2635: (p_model_line_id IN NUMBER,
2636: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2637: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2638: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2639: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2640: p_validate_flag IN VARCHAR2 := 'Y',
2641: p_complete_flag IN VARCHAR2 := 'Y',
2642: p_caller IN VARCHAR2 := '',
2643: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2861: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

2857: ---------------------------------------------------------------------*/
2858:
2859: PROCEDURE Send_input_xml
2860: ( p_model_line_id IN NUMBER ,
2861: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2862: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2863: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2864: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2865: p_model_qty IN NUMBER,

Line 2862: := OE_Order_Pub.G_MISS_REQUEST_TBL,

2858:
2859: PROCEDURE Send_input_xml
2860: ( p_model_line_id IN NUMBER ,
2861: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2862: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2863: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2864: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2865: p_model_qty IN NUMBER,
2866: p_xml_hdr IN VARCHAR2,

Line 2863: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

2859: PROCEDURE Send_input_xml
2860: ( p_model_line_id IN NUMBER ,
2861: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2862: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2863: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2864: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2865: p_model_qty IN NUMBER,
2866: p_xml_hdr IN VARCHAR2,
2867: x_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,

Line 2864: := OE_Order_Pub.G_MISS_REQUEST_TBL,

2860: ( p_model_line_id IN NUMBER ,
2861: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2862: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2863: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2864: := OE_Order_Pub.G_MISS_REQUEST_TBL,
2865: p_model_qty IN NUMBER,
2866: p_xml_hdr IN VARCHAR2,
2867: x_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
2868: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 2875: l_req_rec OE_Order_Pub.Request_Rec_Type;

2871: l_option CZ_BATCH_VALIDATE.INPUT_SELECTION;
2872: l_batch_val_tbl CZ_BATCH_VALIDATE.CFG_INPUT_LIST;
2873: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;
2874: -- update / delete options
2875: l_req_rec OE_Order_Pub.Request_Rec_Type;
2876: l_flag VARCHAR2(30) := '0';
2877:
2878: --variable to fetch from cursor Get_Options
2879: l_component_code VARCHAR2(1000);

Line 3250: l_model_line_rec OE_Order_Pub.Line_Rec_Type;

3246: param_value param_value_type;
3247:
3248: l_rec_index BINARY_INTEGER;
3249:
3250: l_model_line_rec OE_Order_Pub.Line_Rec_Type;
3251:
3252: -- SPC specific params
3253: l_database_id VARCHAR2(100);
3254: l_save_config_behavior VARCHAR2(30):= 'new_revision';

Line 3775: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

3771: PROCEDURE Query_Options
3772: (p_top_model_line_id IN NUMBER
3773: ,p_send_cancel_lines IN VARCHAR2 := 'N'
3774: ,p_source_type IN VARCHAR2 := ''
3775: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3776: IS
3777: l_header_id NUMBER := 0;
3778: l_line_rec OE_Order_PUB.Line_Rec_Type
3779: := OE_Order_PUB.G_MISS_LINE_REC;

Line 3778: l_line_rec OE_Order_PUB.Line_Rec_Type

3774: ,p_source_type IN VARCHAR2 := ''
3775: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3776: IS
3777: l_header_id NUMBER := 0;
3778: l_line_rec OE_Order_PUB.Line_Rec_Type
3779: := OE_Order_PUB.G_MISS_LINE_REC;
3780:
3781: /* adding component number in this cursor to fix bug 2733667 */
3782:

Line 3779: := OE_Order_PUB.G_MISS_LINE_REC;

3775: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3776: IS
3777: l_header_id NUMBER := 0;
3778: l_line_rec OE_Order_PUB.Line_Rec_Type
3779: := OE_Order_PUB.G_MISS_LINE_REC;
3780:
3781: /* adding component number in this cursor to fix bug 2733667 */
3782:
3783: CURSOR c1 IS

Line 3845: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

3841: PROCEDURE Query_ATO_Options
3842: ( p_ato_line_id IN NUMBER
3843: ,p_send_cancel_lines IN VARCHAR2 := 'N'
3844: ,p_source_type IN VARCHAR2 := ''
3845: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3846: IS
3847: l_top_model_line_id NUMBER := 0;
3848: l_header_id NUMBER := 0;
3849: l_line_rec OE_Order_PUB.Line_Rec_Type

Line 3849: l_line_rec OE_Order_PUB.Line_Rec_Type

3845: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3846: IS
3847: l_top_model_line_id NUMBER := 0;
3848: l_header_id NUMBER := 0;
3849: l_line_rec OE_Order_PUB.Line_Rec_Type
3850: := OE_Order_PUB.G_MISS_LINE_REC;
3851:
3852:
3853: CURSOR c1 IS

Line 3850: := OE_Order_PUB.G_MISS_LINE_REC;

3846: IS
3847: l_top_model_line_id NUMBER := 0;
3848: l_header_id NUMBER := 0;
3849: l_line_rec OE_Order_PUB.Line_Rec_Type
3850: := OE_Order_PUB.G_MISS_LINE_REC;
3851:
3852:
3853: CURSOR c1 IS
3854: SELECT line_id

Line 4002: , x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)

3998: PROCEDURE Query_Included_Item
3999: ( p_top_model_line_id IN NUMBER
4000: , p_component_seqeunce_id IN NUMBER
4001: , p_component_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4002: , x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)
4003: IS
4004: l_line_rec OE_ORDER_PUB.line_rec_type;
4005: --
4006: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4004: l_line_rec OE_ORDER_PUB.line_rec_type;

4000: , p_component_seqeunce_id IN NUMBER
4001: , p_component_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4002: , x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)
4003: IS
4004: l_line_rec OE_ORDER_PUB.line_rec_type;
4005: --
4006: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4007: --
4008: BEGIN

Line 4023: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

4019: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
4020: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
4021: , p_send_cancel_lines IN VARCHAR2 := 'N'
4022: , p_source_type IN VARCHAR2 := ''
4023: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
4024: IS
4025: l_top_model_line_id NUMBER := 0;
4026: l_header_id NUMBER := 0;
4027: l_line_rec OE_Order_PUB.Line_Rec_Type

Line 4027: l_line_rec OE_Order_PUB.Line_Rec_Type

4023: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
4024: IS
4025: l_top_model_line_id NUMBER := 0;
4026: l_header_id NUMBER := 0;
4027: l_line_rec OE_Order_PUB.Line_Rec_Type
4028: := OE_Order_PUB.G_MISS_LINE_REC;
4029:
4030:
4031: CURSOR c1 IS

Line 4028: := OE_Order_PUB.G_MISS_LINE_REC;

4024: IS
4025: l_top_model_line_id NUMBER := 0;
4026: l_header_id NUMBER := 0;
4027: l_line_rec OE_Order_PUB.Line_Rec_Type
4028: := OE_Order_PUB.G_MISS_LINE_REC;
4029:
4030:
4031: CURSOR c1 IS
4032: SELECT line_id

Line 4162: (p_line_rec IN OE_ORDER_PUB.line_rec_type

4158: error an exception would be raised. New variable l_default_child_line
4159: has been created.
4160: -----------------------------------------------------------------------*/
4161: FUNCTION Process_Included_Items
4162: (p_line_rec IN OE_ORDER_PUB.line_rec_type
4163: := OE_ORDER_PUB.G_MISS_LINE_REC,
4164: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
4165: p_freeze IN BOOLEAN,
4166: p_process_requests IN BOOLEAN DEFAULT FALSE)

Line 4163: := OE_ORDER_PUB.G_MISS_LINE_REC,

4159: has been created.
4160: -----------------------------------------------------------------------*/
4161: FUNCTION Process_Included_Items
4162: (p_line_rec IN OE_ORDER_PUB.line_rec_type
4163: := OE_ORDER_PUB.G_MISS_LINE_REC,
4164: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
4165: p_freeze IN BOOLEAN,
4166: p_process_requests IN BOOLEAN DEFAULT FALSE)
4167: RETURN VARCHAR2

Line 4172: l_header_rec OE_Order_PUB.Header_Rec_Type;

4168: IS
4169:
4170: -- process_order in variables
4171: l_control_rec OE_GLOBALS.Control_Rec_Type;
4172: l_header_rec OE_Order_PUB.Header_Rec_Type;
4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4176:

Line 4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

4169:
4170: -- process_order in variables
4171: l_control_rec OE_GLOBALS.Control_Rec_Type;
4172: l_header_rec OE_Order_PUB.Header_Rec_Type;
4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4176:
4177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

4170: -- process_order in variables
4171: l_control_rec OE_GLOBALS.Control_Rec_Type;
4172: l_header_rec OE_Order_PUB.Header_Rec_Type;
4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4176:
4177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4178: l_msg_count NUMBER;

Line 4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4171: l_control_rec OE_GLOBALS.Control_Rec_Type;
4172: l_header_rec OE_Order_PUB.Header_Rec_Type;
4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4176:
4177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4178: l_msg_count NUMBER;
4179: l_msg_data VARCHAR2(2000);

Line 4182: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;

4178: l_msg_count NUMBER;
4179: l_msg_data VARCHAR2(2000);
4180:
4181: -- procedure variables
4182: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;
4183: l_line_count NUMBER := 0;
4184: l_line_id NUMBER;
4185: l_component_number NUMBER;
4186: l_adjust_comp_no_flag VARCHAR2(1) := 'N';

Line 4461: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4457: WHEN OTHERS THEN
4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4459: END;
4460:
4461: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4462:
4463: OPEN new_included_items
4464: (p_top_bill_sequence_id => l_parent_component_sequence_id,
4465: p_top_model_line_id => l_parent_line_rec.top_model_line_id,

Line 4624: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4620: oe_debug_pub.add('MODEL ORDERED QUANTITY IS'
4621: || L_TOP_MODEL_QUANTITY , 2 );
4622: END IF;
4623:
4624: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4625: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4626: l_line_rec.header_id := l_parent_line_rec.header_id;
4627:
4628: OPEN update_included_items

Line 4658: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4654: IF l_debug_level > 0 THEN
4655: oe_debug_pub.add('TOP MODEL LINE:' || L_PARENT_LINE_REC.LINE_ID , 2 );
4656: END IF;
4657:
4658: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4659: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4660: l_line_rec.header_id := l_parent_line_rec.header_id;
4661:
4662: OPEN outdated_included_items

Line 4897: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

4893: -----------------------------------------------------------------------*/
4894: FUNCTION Is_ATO_Model
4895: (p_line_id IN NUMBER
4896: := FND_API.G_MISS_NUM ,
4897: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4898: := OE_ORDER_PUB.G_MISS_LINE_REC)
4899: RETURN BOOLEAN
4900: IS
4901: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 4898: := OE_ORDER_PUB.G_MISS_LINE_REC)

4894: FUNCTION Is_ATO_Model
4895: (p_line_id IN NUMBER
4896: := FND_API.G_MISS_NUM ,
4897: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4898: := OE_ORDER_PUB.G_MISS_LINE_REC)
4899: RETURN BOOLEAN
4900: IS
4901: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4902: --

Line 4901: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

4897: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4898: := OE_ORDER_PUB.G_MISS_LINE_REC)
4899: RETURN BOOLEAN
4900: IS
4901: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4902: --
4903: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4904: --
4905: BEGIN

Line 4962: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

4958: -----------------------------------------------------------------------*/
4959: FUNCTION Is_PTO_Model
4960: (p_line_id IN NUMBER
4961: := FND_API.G_MISS_NUM ,
4962: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4963: := OE_ORDER_PUB.G_MISS_LINE_REC)
4964: RETURN BOOLEAN
4965: IS
4966: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 4963: := OE_ORDER_PUB.G_MISS_LINE_REC)

4959: FUNCTION Is_PTO_Model
4960: (p_line_id IN NUMBER
4961: := FND_API.G_MISS_NUM ,
4962: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4963: := OE_ORDER_PUB.G_MISS_LINE_REC)
4964: RETURN BOOLEAN
4965: IS
4966: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4967:

Line 4966: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

4962: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4963: := OE_ORDER_PUB.G_MISS_LINE_REC)
4964: RETURN BOOLEAN
4965: IS
4966: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4967:
4968: --
4969: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4970: --

Line 5027: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5023:
5024: FUNCTION Is_Included_Option
5025: (p_line_id IN NUMBER
5026: := FND_API.G_MISS_NUM ,
5027: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5028: := OE_ORDER_PUB.G_MISS_LINE_REC)
5029: RETURN BOOLEAN
5030: IS
5031: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5028: := OE_ORDER_PUB.G_MISS_LINE_REC)

5024: FUNCTION Is_Included_Option
5025: (p_line_id IN NUMBER
5026: := FND_API.G_MISS_NUM ,
5027: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5028: := OE_ORDER_PUB.G_MISS_LINE_REC)
5029: RETURN BOOLEAN
5030: IS
5031: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5032:

Line 5031: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5027: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5028: := OE_ORDER_PUB.G_MISS_LINE_REC)
5029: RETURN BOOLEAN
5030: IS
5031: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5032:
5033: --
5034: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5035: --

Line 5090: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5086: -----------------------------------------------------------------------*/
5087: FUNCTION Is_Config_Item
5088: (p_line_id IN NUMBER
5089: := FND_API.G_MISS_NUM ,
5090: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5091: := OE_ORDER_PUB.G_MISS_LINE_REC)
5092: RETURN BOOLEAN
5093: IS
5094: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5091: := OE_ORDER_PUB.G_MISS_LINE_REC)

5087: FUNCTION Is_Config_Item
5088: (p_line_id IN NUMBER
5089: := FND_API.G_MISS_NUM ,
5090: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5091: := OE_ORDER_PUB.G_MISS_LINE_REC)
5092: RETURN BOOLEAN
5093: IS
5094: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5095:

Line 5094: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5090: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5091: := OE_ORDER_PUB.G_MISS_LINE_REC)
5092: RETURN BOOLEAN
5093: IS
5094: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5095:
5096: --
5097: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5098: --

Line 5153: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5149: -----------------------------------------------------------------------*/
5150: FUNCTION Is_ATO_Option
5151: (p_line_id IN NUMBER
5152: := FND_API.G_MISS_NUM ,
5153: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5154: := OE_ORDER_PUB.G_MISS_LINE_REC)
5155: RETURN BOOLEAN
5156: IS
5157: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5154: := OE_ORDER_PUB.G_MISS_LINE_REC)

5150: FUNCTION Is_ATO_Option
5151: (p_line_id IN NUMBER
5152: := FND_API.G_MISS_NUM ,
5153: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5154: := OE_ORDER_PUB.G_MISS_LINE_REC)
5155: RETURN BOOLEAN
5156: IS
5157: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5158:

Line 5157: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5153: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5154: := OE_ORDER_PUB.G_MISS_LINE_REC)
5155: RETURN BOOLEAN
5156: IS
5157: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5158:
5159: --
5160: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5161: --

Line 5220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5216: -----------------------------------------------------------------------*/
5217: FUNCTION Is_PTO_Option
5218: (p_line_id IN NUMBER
5219: := FND_API.G_MISS_NUM ,
5220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5221: := OE_ORDER_PUB.G_MISS_LINE_REC)
5222: RETURN BOOLEAN
5223: IS
5224: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5221: := OE_ORDER_PUB.G_MISS_LINE_REC)

5217: FUNCTION Is_PTO_Option
5218: (p_line_id IN NUMBER
5219: := FND_API.G_MISS_NUM ,
5220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5221: := OE_ORDER_PUB.G_MISS_LINE_REC)
5222: RETURN BOOLEAN
5223: IS
5224: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5225:

Line 5224: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5221: := OE_ORDER_PUB.G_MISS_LINE_REC)
5222: RETURN BOOLEAN
5223: IS
5224: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5225:
5226: --
5227: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5228: --

Line 5283: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5279: -----------------------------------------------------------------------*/
5280: FUNCTION Is_ATO_Class
5281: (p_line_id IN NUMBER
5282: := FND_API.G_MISS_NUM ,
5283: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5284: := OE_ORDER_PUB.G_MISS_LINE_REC)
5285: RETURN BOOLEAN
5286: IS
5287: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5284: := OE_ORDER_PUB.G_MISS_LINE_REC)

5280: FUNCTION Is_ATO_Class
5281: (p_line_id IN NUMBER
5282: := FND_API.G_MISS_NUM ,
5283: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5284: := OE_ORDER_PUB.G_MISS_LINE_REC)
5285: RETURN BOOLEAN
5286: IS
5287: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5288:

Line 5287: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5283: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5284: := OE_ORDER_PUB.G_MISS_LINE_REC)
5285: RETURN BOOLEAN
5286: IS
5287: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5288:
5289: --
5290: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5291: --

Line 5349: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5345: -----------------------------------------------------------------------*/
5346: FUNCTION Is_PTO_Class
5347: (p_line_id IN NUMBER
5348: := FND_API.G_MISS_NUM ,
5349: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5350: := OE_ORDER_PUB.G_MISS_LINE_REC)
5351: RETURN BOOLEAN
5352: IS
5353: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5350: := OE_ORDER_PUB.G_MISS_LINE_REC)

5346: FUNCTION Is_PTO_Class
5347: (p_line_id IN NUMBER
5348: := FND_API.G_MISS_NUM ,
5349: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5350: := OE_ORDER_PUB.G_MISS_LINE_REC)
5351: RETURN BOOLEAN
5352: IS
5353: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5354:

Line 5353: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5349: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5350: := OE_ORDER_PUB.G_MISS_LINE_REC)
5351: RETURN BOOLEAN
5352: IS
5353: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5354:
5355: --
5356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5357: --

Line 5413: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5409: -----------------------------------------------------------------------*/
5410: FUNCTION Is_ATO_Subconfig
5411: (p_line_id IN NUMBER
5412: := FND_API.G_MISS_NUM ,
5413: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5414: := OE_ORDER_PUB.G_MISS_LINE_REC)
5415: RETURN BOOLEAN
5416: IS
5417: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5414: := OE_ORDER_PUB.G_MISS_LINE_REC)

5410: FUNCTION Is_ATO_Subconfig
5411: (p_line_id IN NUMBER
5412: := FND_API.G_MISS_NUM ,
5413: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5414: := OE_ORDER_PUB.G_MISS_LINE_REC)
5415: RETURN BOOLEAN
5416: IS
5417: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5418:

Line 5417: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5413: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5414: := OE_ORDER_PUB.G_MISS_LINE_REC)
5415: RETURN BOOLEAN
5416: IS
5417: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5418:
5419: --
5420: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5421: --

Line 5479: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5475: -----------------------------------------------------------------------*/
5476: FUNCTION Is_Kit
5477: (p_line_id IN NUMBER
5478: := FND_API.G_MISS_NUM ,
5479: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5480: := OE_ORDER_PUB.G_MISS_LINE_REC)
5481: RETURN BOOLEAN
5482: IS
5483: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5480: := OE_ORDER_PUB.G_MISS_LINE_REC)

5476: FUNCTION Is_Kit
5477: (p_line_id IN NUMBER
5478: := FND_API.G_MISS_NUM ,
5479: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5480: := OE_ORDER_PUB.G_MISS_LINE_REC)
5481: RETURN BOOLEAN
5482: IS
5483: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5484:

Line 5483: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5479: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5480: := OE_ORDER_PUB.G_MISS_LINE_REC)
5481: RETURN BOOLEAN
5482: IS
5483: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5484:
5485: --
5486: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5487: --

Line 5541: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5537: -----------------------------------------------------------------------*/
5538: FUNCTION Is_Ato_Item
5539: (p_line_id IN NUMBER
5540: := FND_API.G_MISS_NUM ,
5541: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5542: := OE_ORDER_PUB.G_MISS_LINE_REC)
5543: RETURN BOOLEAN
5544: IS
5545: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5542: := OE_ORDER_PUB.G_MISS_LINE_REC)

5538: FUNCTION Is_Ato_Item
5539: (p_line_id IN NUMBER
5540: := FND_API.G_MISS_NUM ,
5541: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5542: := OE_ORDER_PUB.G_MISS_LINE_REC)
5543: RETURN BOOLEAN
5544: IS
5545: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5546:

Line 5545: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5541: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5542: := OE_ORDER_PUB.G_MISS_LINE_REC)
5543: RETURN BOOLEAN
5544: IS
5545: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5546:
5547: --
5548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5549: --

Line 5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

5607: PROCEDURE Query_Config
5608: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
5609: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5612: IS
5613: l_line_rec OE_Order_PUB.Line_Rec_Type
5614: := OE_Order_PUB.G_MISS_LINE_REC;
5615: l_top_model_line_id NUMBER;

Line 5613: l_line_rec OE_Order_PUB.Line_Rec_Type

5609: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5612: IS
5613: l_line_rec OE_Order_PUB.Line_Rec_Type
5614: := OE_Order_PUB.G_MISS_LINE_REC;
5615: l_top_model_line_id NUMBER;
5616: l_line_id NUMBER := 0;
5617: ll_line_id NUMBER := 0;

Line 5614: := OE_Order_PUB.G_MISS_LINE_REC;

5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5612: IS
5613: l_line_rec OE_Order_PUB.Line_Rec_Type
5614: := OE_Order_PUB.G_MISS_LINE_REC;
5615: l_top_model_line_id NUMBER;
5616: l_line_id NUMBER := 0;
5617: ll_line_id NUMBER := 0;
5618: l_header_id NUMBER := 0;

Line 6019: l_line_rec OE_Order_Pub.line_rec_type;

6015: PROCEDURE Match_and_Reserve
6016: ( p_line_id IN NUMBER
6017: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
6018: IS
6019: l_line_rec OE_Order_Pub.line_rec_type;
6020: l_top_model_line_id NUMBER;
6021: l_ordered_quantity NUMBER;
6022: l_order_quantity_uom VARCHAR2(3);
6023: l_config_id NUMBER;

Line 6749: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type

6745: -------------------------------------------------------------------*/
6746:
6747: PROCEDURE Notify_CTO
6748: ( p_ato_line_id IN NUMBER
6749: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6750: := OE_Order_Pub.G_MISS_REQUEST_REC
6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type

Line 6750: := OE_Order_Pub.G_MISS_REQUEST_REC

6746:
6747: PROCEDURE Notify_CTO
6748: ( p_ato_line_id IN NUMBER
6749: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6750: := OE_Order_Pub.G_MISS_REQUEST_REC
6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type

6747: PROCEDURE Notify_CTO
6748: ( p_ato_line_id IN NUMBER
6749: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6750: := OE_Order_Pub.G_MISS_REQUEST_REC
6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL
6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type

Line 6752: := OE_Order_Pub.G_MISS_REQUEST_TBL

6748: ( p_ato_line_id IN NUMBER
6749: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6750: := OE_Order_Pub.G_MISS_REQUEST_REC
6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL
6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6756: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type

6749: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6750: := OE_Order_Pub.G_MISS_REQUEST_REC
6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL
6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6756: := OE_Order_Pub.G_MISS_REQUEST_TBL
6757: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 6754: := OE_Order_Pub.G_MISS_REQUEST_TBL

6750: := OE_Order_Pub.G_MISS_REQUEST_REC
6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL
6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6756: := OE_Order_Pub.G_MISS_REQUEST_TBL
6757: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6758: IS

Line 6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type

6751: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL
6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6756: := OE_Order_Pub.G_MISS_REQUEST_TBL
6757: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6758: IS
6759: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 6756: := OE_Order_Pub.G_MISS_REQUEST_TBL

6752: := OE_Order_Pub.G_MISS_REQUEST_TBL
6753: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6754: := OE_Order_Pub.G_MISS_REQUEST_TBL
6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6756: := OE_Order_Pub.G_MISS_REQUEST_TBL
6757: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6758: IS
6759: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6760: l_msg_count NUMBER;

Line 7092: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type

7088: have different line types when order is received from upstream
7089: sales application
7090: -------------------------------------------------------------------*/
7091: PROCEDURE Default_Child_Line
7092: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
7093: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
7094: ,p_direct_save IN BOOLEAN := FALSE
7095: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
7096: IS

Line 7093: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

7089: sales application
7090: -------------------------------------------------------------------*/
7091: PROCEDURE Default_Child_Line
7092: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
7093: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
7094: ,p_direct_save IN BOOLEAN := FALSE
7095: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
7096: IS
7097: --

Line 7881: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

7877: oe_line_util.apply_attribute_changes procedure for
7878: included_items will be logged here.
7879: --------------------------------------------------------*/
7880: PROCEDURE Log_Included_Item_Requests
7881: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
7882: ,p_booked_flag IN VARCHAR2)
7883: IS
7884: I NUMBER;
7885: l_return_status VARCHAR2(1);

Line 8406: ( p_model_line_rec IN OE_Order_Pub.Line_Rec_Type := null

8402: 3 - sysdate till booking.
8403: 4 - sysdate till pick release -- #6187663
8404: --------------------------------------------------------*/
8405: PROCEDURE Get_Config_Effective_Date
8406: ( p_model_line_rec IN OE_Order_Pub.Line_Rec_Type := null
8407: ,p_model_line_id IN NUMBER := null
8408: ,x_old_behavior OUT NOCOPY VARCHAR2
8409: ,x_config_effective_date OUT NOCOPY DATE
8410: ,x_frozen_model_bill OUT NOCOPY VARCHAR2)

Line 8644: PROCEDURE Unlock_Config(p_line_rec IN OE_ORDER_PUB.line_rec_type,

8640:
8641: This API will be called before deleting or cacelling booked macd model.
8642: --------------------------------------------------------*/
8643:
8644: PROCEDURE Unlock_Config(p_line_rec IN OE_ORDER_PUB.line_rec_type,
8645: x_return_status OUT NOCOPY VARCHAR2 )
8646: IS
8647:
8648: l_top_container VARCHAR2(1);