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 1807: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 1808: := OE_Order_Pub.G_MISS_REQUEST_TBL,

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

Line 1809: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 1810: := OE_Order_Pub.G_MISS_REQUEST_TBL,

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

Line 1817: l_updated_options_tbl OE_Order_PUB.request_tbl_type;

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

Line 1818: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;

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

Line 1823: l_req_rec OE_Order_Pub.Request_Rec_Type;

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

Line 1973: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 1974: := OE_Order_Pub.G_MISS_REQUEST_TBL

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

Line 1975: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 1976: := OE_Order_Pub.G_MISS_REQUEST_TBL

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

Line 1983: l_req_rec OE_Order_Pub.Request_Rec_Type;

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

Line 1984: l_deleted_options_tbl OE_Order_PUB.request_tbl_type

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

Line 2638: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 2639: := OE_Order_Pub.G_MISS_REQUEST_TBL,

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

Line 2640: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 2641: := OE_Order_Pub.G_MISS_REQUEST_TBL,

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

Line 2863: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 2864: := OE_Order_Pub.G_MISS_REQUEST_TBL,

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

Line 2865: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

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

Line 2866: := OE_Order_Pub.G_MISS_REQUEST_TBL,

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

Line 2877: l_req_rec OE_Order_Pub.Request_Rec_Type;

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

Line 3256: l_model_line_rec OE_Order_Pub.Line_Rec_Type;

3252: param_value param_value_type;
3253:
3254: l_rec_index BINARY_INTEGER;
3255:
3256: l_model_line_rec OE_Order_Pub.Line_Rec_Type;
3257:
3258: -- SPC specific params
3259: l_database_id VARCHAR2(100);
3260: l_save_config_behavior VARCHAR2(30):= 'new_revision';

Line 3781: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

3777: PROCEDURE Query_Options
3778: (p_top_model_line_id IN NUMBER
3779: ,p_send_cancel_lines IN VARCHAR2 := 'N'
3780: ,p_source_type IN VARCHAR2 := ''
3781: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3782: IS
3783: l_header_id NUMBER := 0;
3784: l_line_rec OE_Order_PUB.Line_Rec_Type
3785: := OE_Order_PUB.G_MISS_LINE_REC;

Line 3784: l_line_rec OE_Order_PUB.Line_Rec_Type

3780: ,p_source_type IN VARCHAR2 := ''
3781: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3782: IS
3783: l_header_id NUMBER := 0;
3784: l_line_rec OE_Order_PUB.Line_Rec_Type
3785: := OE_Order_PUB.G_MISS_LINE_REC;
3786:
3787: /* adding component number in this cursor to fix bug 2733667 */
3788:

Line 3785: := OE_Order_PUB.G_MISS_LINE_REC;

3781: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3782: IS
3783: l_header_id NUMBER := 0;
3784: l_line_rec OE_Order_PUB.Line_Rec_Type
3785: := OE_Order_PUB.G_MISS_LINE_REC;
3786:
3787: /* adding component number in this cursor to fix bug 2733667 */
3788:
3789: CURSOR c1 IS

Line 3851: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

3847: PROCEDURE Query_ATO_Options
3848: ( p_ato_line_id IN NUMBER
3849: ,p_send_cancel_lines IN VARCHAR2 := 'N'
3850: ,p_source_type IN VARCHAR2 := ''
3851: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3852: IS
3853: l_top_model_line_id NUMBER := 0;
3854: l_header_id NUMBER := 0;
3855: l_line_rec OE_Order_PUB.Line_Rec_Type

Line 3855: l_line_rec OE_Order_PUB.Line_Rec_Type

3851: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
3852: IS
3853: l_top_model_line_id NUMBER := 0;
3854: l_header_id NUMBER := 0;
3855: l_line_rec OE_Order_PUB.Line_Rec_Type
3856: := OE_Order_PUB.G_MISS_LINE_REC;
3857:
3858:
3859: CURSOR c1 IS

Line 3856: := OE_Order_PUB.G_MISS_LINE_REC;

3852: IS
3853: l_top_model_line_id NUMBER := 0;
3854: l_header_id NUMBER := 0;
3855: l_line_rec OE_Order_PUB.Line_Rec_Type
3856: := OE_Order_PUB.G_MISS_LINE_REC;
3857:
3858:
3859: CURSOR c1 IS
3860: SELECT line_id

Line 4008: , x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)

4004: PROCEDURE Query_Included_Item
4005: ( p_top_model_line_id IN NUMBER
4006: , p_component_seqeunce_id IN NUMBER
4007: , p_component_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4008: , x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)
4009: IS
4010: l_line_rec OE_ORDER_PUB.line_rec_type;
4011: --
4012: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4010: l_line_rec OE_ORDER_PUB.line_rec_type;

4006: , p_component_seqeunce_id IN NUMBER
4007: , p_component_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4008: , x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type)
4009: IS
4010: l_line_rec OE_ORDER_PUB.line_rec_type;
4011: --
4012: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4013: --
4014: BEGIN

Line 4029: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

4025: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
4026: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
4027: , p_send_cancel_lines IN VARCHAR2 := 'N'
4028: , p_source_type IN VARCHAR2 := ''
4029: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
4030: IS
4031: l_top_model_line_id NUMBER := 0;
4032: l_header_id NUMBER := 0;
4033: l_line_rec OE_Order_PUB.Line_Rec_Type

Line 4033: l_line_rec OE_Order_PUB.Line_Rec_Type

4029: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
4030: IS
4031: l_top_model_line_id NUMBER := 0;
4032: l_header_id NUMBER := 0;
4033: l_line_rec OE_Order_PUB.Line_Rec_Type
4034: := OE_Order_PUB.G_MISS_LINE_REC;
4035:
4036:
4037: CURSOR c1 IS

Line 4034: := OE_Order_PUB.G_MISS_LINE_REC;

4030: IS
4031: l_top_model_line_id NUMBER := 0;
4032: l_header_id NUMBER := 0;
4033: l_line_rec OE_Order_PUB.Line_Rec_Type
4034: := OE_Order_PUB.G_MISS_LINE_REC;
4035:
4036:
4037: CURSOR c1 IS
4038: SELECT line_id

Line 4168: (p_line_rec IN OE_ORDER_PUB.line_rec_type

4164: error an exception would be raised. New variable l_default_child_line
4165: has been created.
4166: -----------------------------------------------------------------------*/
4167: FUNCTION Process_Included_Items
4168: (p_line_rec IN OE_ORDER_PUB.line_rec_type
4169: := OE_ORDER_PUB.G_MISS_LINE_REC,
4170: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
4171: p_freeze IN BOOLEAN,
4172: p_process_requests IN BOOLEAN DEFAULT FALSE)

Line 4169: := OE_ORDER_PUB.G_MISS_LINE_REC,

4165: has been created.
4166: -----------------------------------------------------------------------*/
4167: FUNCTION Process_Included_Items
4168: (p_line_rec IN OE_ORDER_PUB.line_rec_type
4169: := OE_ORDER_PUB.G_MISS_LINE_REC,
4170: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
4171: p_freeze IN BOOLEAN,
4172: p_process_requests IN BOOLEAN DEFAULT FALSE)
4173: RETURN VARCHAR2

Line 4178: l_header_rec OE_Order_PUB.Header_Rec_Type;

4174: IS
4175:
4176: -- process_order in variables
4177: l_control_rec OE_GLOBALS.Control_Rec_Type;
4178: l_header_rec OE_Order_PUB.Header_Rec_Type;
4179: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4180: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4181: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4182:

Line 4179: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

4175:
4176: -- process_order in variables
4177: l_control_rec OE_GLOBALS.Control_Rec_Type;
4178: l_header_rec OE_Order_PUB.Header_Rec_Type;
4179: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4180: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4181: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4182:
4183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 4180: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

4176: -- process_order in variables
4177: l_control_rec OE_GLOBALS.Control_Rec_Type;
4178: l_header_rec OE_Order_PUB.Header_Rec_Type;
4179: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4180: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4181: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4182:
4183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4184: l_msg_count NUMBER;

Line 4181: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4177: l_control_rec OE_GLOBALS.Control_Rec_Type;
4178: l_header_rec OE_Order_PUB.Header_Rec_Type;
4179: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4180: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4181: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4182:
4183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4184: l_msg_count NUMBER;
4185: l_msg_data VARCHAR2(2000);

Line 4188: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;

4184: l_msg_count NUMBER;
4185: l_msg_data VARCHAR2(2000);
4186:
4187: -- procedure variables
4188: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;
4189: l_line_count NUMBER := 0;
4190: l_line_id NUMBER;
4191: l_component_number NUMBER;
4192: l_adjust_comp_no_flag VARCHAR2(1) := 'N';

Line 4467: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4463: WHEN OTHERS THEN
4464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4465: END;
4466:
4467: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4468:
4469: OPEN new_included_items
4470: (p_top_bill_sequence_id => l_parent_component_sequence_id,
4471: p_top_model_line_id => l_parent_line_rec.top_model_line_id,

Line 4630: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4626: oe_debug_pub.add('MODEL ORDERED QUANTITY IS'
4627: || L_TOP_MODEL_QUANTITY , 2 );
4628: END IF;
4629:
4630: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4631: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4632: l_line_rec.header_id := l_parent_line_rec.header_id;
4633:
4634: OPEN update_included_items

Line 4664: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4660: IF l_debug_level > 0 THEN
4661: oe_debug_pub.add('TOP MODEL LINE:' || L_PARENT_LINE_REC.LINE_ID , 2 );
4662: END IF;
4663:
4664: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4665: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4666: l_line_rec.header_id := l_parent_line_rec.header_id;
4667:
4668: OPEN outdated_included_items

Line 4903: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

4899: -----------------------------------------------------------------------*/
4900: FUNCTION Is_ATO_Model
4901: (p_line_id IN NUMBER
4902: := FND_API.G_MISS_NUM ,
4903: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4904: := OE_ORDER_PUB.G_MISS_LINE_REC)
4905: RETURN BOOLEAN
4906: IS
4907: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 4904: := OE_ORDER_PUB.G_MISS_LINE_REC)

4900: FUNCTION Is_ATO_Model
4901: (p_line_id IN NUMBER
4902: := FND_API.G_MISS_NUM ,
4903: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4904: := OE_ORDER_PUB.G_MISS_LINE_REC)
4905: RETURN BOOLEAN
4906: IS
4907: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4908: --

Line 4907: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

4903: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4904: := OE_ORDER_PUB.G_MISS_LINE_REC)
4905: RETURN BOOLEAN
4906: IS
4907: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4908: --
4909: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4910: --
4911: BEGIN

Line 4968: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

4964: -----------------------------------------------------------------------*/
4965: FUNCTION Is_PTO_Model
4966: (p_line_id IN NUMBER
4967: := FND_API.G_MISS_NUM ,
4968: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4969: := OE_ORDER_PUB.G_MISS_LINE_REC)
4970: RETURN BOOLEAN
4971: IS
4972: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 4969: := OE_ORDER_PUB.G_MISS_LINE_REC)

4965: FUNCTION Is_PTO_Model
4966: (p_line_id IN NUMBER
4967: := FND_API.G_MISS_NUM ,
4968: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4969: := OE_ORDER_PUB.G_MISS_LINE_REC)
4970: RETURN BOOLEAN
4971: IS
4972: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4973:

Line 4972: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

4968: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4969: := OE_ORDER_PUB.G_MISS_LINE_REC)
4970: RETURN BOOLEAN
4971: IS
4972: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
4973:
4974: --
4975: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4976: --

Line 5033: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5029:
5030: FUNCTION Is_Included_Option
5031: (p_line_id IN NUMBER
5032: := FND_API.G_MISS_NUM ,
5033: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5034: := OE_ORDER_PUB.G_MISS_LINE_REC)
5035: RETURN BOOLEAN
5036: IS
5037: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5034: := OE_ORDER_PUB.G_MISS_LINE_REC)

5030: FUNCTION Is_Included_Option
5031: (p_line_id IN NUMBER
5032: := FND_API.G_MISS_NUM ,
5033: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5034: := OE_ORDER_PUB.G_MISS_LINE_REC)
5035: RETURN BOOLEAN
5036: IS
5037: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5038:

Line 5037: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5033: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5034: := OE_ORDER_PUB.G_MISS_LINE_REC)
5035: RETURN BOOLEAN
5036: IS
5037: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5038:
5039: --
5040: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5041: --

Line 5096: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5092: -----------------------------------------------------------------------*/
5093: FUNCTION Is_Config_Item
5094: (p_line_id IN NUMBER
5095: := FND_API.G_MISS_NUM ,
5096: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5097: := OE_ORDER_PUB.G_MISS_LINE_REC)
5098: RETURN BOOLEAN
5099: IS
5100: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5097: := OE_ORDER_PUB.G_MISS_LINE_REC)

5093: FUNCTION Is_Config_Item
5094: (p_line_id IN NUMBER
5095: := FND_API.G_MISS_NUM ,
5096: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5097: := OE_ORDER_PUB.G_MISS_LINE_REC)
5098: RETURN BOOLEAN
5099: IS
5100: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5101:

Line 5100: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5096: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5097: := OE_ORDER_PUB.G_MISS_LINE_REC)
5098: RETURN BOOLEAN
5099: IS
5100: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5101:
5102: --
5103: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5104: --

Line 5159: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5155: -----------------------------------------------------------------------*/
5156: FUNCTION Is_ATO_Option
5157: (p_line_id IN NUMBER
5158: := FND_API.G_MISS_NUM ,
5159: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5160: := OE_ORDER_PUB.G_MISS_LINE_REC)
5161: RETURN BOOLEAN
5162: IS
5163: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5160: := OE_ORDER_PUB.G_MISS_LINE_REC)

5156: FUNCTION Is_ATO_Option
5157: (p_line_id IN NUMBER
5158: := FND_API.G_MISS_NUM ,
5159: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5160: := OE_ORDER_PUB.G_MISS_LINE_REC)
5161: RETURN BOOLEAN
5162: IS
5163: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5164:

Line 5163: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5159: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5160: := OE_ORDER_PUB.G_MISS_LINE_REC)
5161: RETURN BOOLEAN
5162: IS
5163: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5164:
5165: --
5166: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5167: --

Line 5226: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5222: -----------------------------------------------------------------------*/
5223: FUNCTION Is_PTO_Option
5224: (p_line_id IN NUMBER
5225: := FND_API.G_MISS_NUM ,
5226: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5227: := OE_ORDER_PUB.G_MISS_LINE_REC)
5228: RETURN BOOLEAN
5229: IS
5230: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5227: := OE_ORDER_PUB.G_MISS_LINE_REC)

5223: FUNCTION Is_PTO_Option
5224: (p_line_id IN NUMBER
5225: := FND_API.G_MISS_NUM ,
5226: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5227: := OE_ORDER_PUB.G_MISS_LINE_REC)
5228: RETURN BOOLEAN
5229: IS
5230: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5231:

Line 5230: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5226: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5227: := OE_ORDER_PUB.G_MISS_LINE_REC)
5228: RETURN BOOLEAN
5229: IS
5230: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5231:
5232: --
5233: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5234: --

Line 5289: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5285: -----------------------------------------------------------------------*/
5286: FUNCTION Is_ATO_Class
5287: (p_line_id IN NUMBER
5288: := FND_API.G_MISS_NUM ,
5289: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5290: := OE_ORDER_PUB.G_MISS_LINE_REC)
5291: RETURN BOOLEAN
5292: IS
5293: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5290: := OE_ORDER_PUB.G_MISS_LINE_REC)

5286: FUNCTION Is_ATO_Class
5287: (p_line_id IN NUMBER
5288: := FND_API.G_MISS_NUM ,
5289: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5290: := OE_ORDER_PUB.G_MISS_LINE_REC)
5291: RETURN BOOLEAN
5292: IS
5293: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5294:

Line 5293: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5289: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5290: := OE_ORDER_PUB.G_MISS_LINE_REC)
5291: RETURN BOOLEAN
5292: IS
5293: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5294:
5295: --
5296: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5297: --

Line 5355: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5351: -----------------------------------------------------------------------*/
5352: FUNCTION Is_PTO_Class
5353: (p_line_id IN NUMBER
5354: := FND_API.G_MISS_NUM ,
5355: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5356: := OE_ORDER_PUB.G_MISS_LINE_REC)
5357: RETURN BOOLEAN
5358: IS
5359: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5356: := OE_ORDER_PUB.G_MISS_LINE_REC)

5352: FUNCTION Is_PTO_Class
5353: (p_line_id IN NUMBER
5354: := FND_API.G_MISS_NUM ,
5355: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5356: := OE_ORDER_PUB.G_MISS_LINE_REC)
5357: RETURN BOOLEAN
5358: IS
5359: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5360:

Line 5359: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5355: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5356: := OE_ORDER_PUB.G_MISS_LINE_REC)
5357: RETURN BOOLEAN
5358: IS
5359: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5360:
5361: --
5362: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5363: --

Line 5419: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5415: -----------------------------------------------------------------------*/
5416: FUNCTION Is_ATO_Subconfig
5417: (p_line_id IN NUMBER
5418: := FND_API.G_MISS_NUM ,
5419: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5420: := OE_ORDER_PUB.G_MISS_LINE_REC)
5421: RETURN BOOLEAN
5422: IS
5423: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5420: := OE_ORDER_PUB.G_MISS_LINE_REC)

5416: FUNCTION Is_ATO_Subconfig
5417: (p_line_id IN NUMBER
5418: := FND_API.G_MISS_NUM ,
5419: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5420: := OE_ORDER_PUB.G_MISS_LINE_REC)
5421: RETURN BOOLEAN
5422: IS
5423: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5424:

Line 5423: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5419: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5420: := OE_ORDER_PUB.G_MISS_LINE_REC)
5421: RETURN BOOLEAN
5422: IS
5423: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5424:
5425: --
5426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5427: --

Line 5485: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5481: -----------------------------------------------------------------------*/
5482: FUNCTION Is_Kit
5483: (p_line_id IN NUMBER
5484: := FND_API.G_MISS_NUM ,
5485: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5486: := OE_ORDER_PUB.G_MISS_LINE_REC)
5487: RETURN BOOLEAN
5488: IS
5489: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5486: := OE_ORDER_PUB.G_MISS_LINE_REC)

5482: FUNCTION Is_Kit
5483: (p_line_id IN NUMBER
5484: := FND_API.G_MISS_NUM ,
5485: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5486: := OE_ORDER_PUB.G_MISS_LINE_REC)
5487: RETURN BOOLEAN
5488: IS
5489: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5490:

Line 5489: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5485: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5486: := OE_ORDER_PUB.G_MISS_LINE_REC)
5487: RETURN BOOLEAN
5488: IS
5489: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5490:
5491: --
5492: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5493: --

Line 5547: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

5543: -----------------------------------------------------------------------*/
5544: FUNCTION Is_Ato_Item
5545: (p_line_id IN NUMBER
5546: := FND_API.G_MISS_NUM ,
5547: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5548: := OE_ORDER_PUB.G_MISS_LINE_REC)
5549: RETURN BOOLEAN
5550: IS
5551: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

Line 5548: := OE_ORDER_PUB.G_MISS_LINE_REC)

5544: FUNCTION Is_Ato_Item
5545: (p_line_id IN NUMBER
5546: := FND_API.G_MISS_NUM ,
5547: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5548: := OE_ORDER_PUB.G_MISS_LINE_REC)
5549: RETURN BOOLEAN
5550: IS
5551: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5552:

Line 5551: l_line_rec OE_Order_PUB.LINE_REC_TYPE;

5547: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5548: := OE_ORDER_PUB.G_MISS_LINE_REC)
5549: RETURN BOOLEAN
5550: IS
5551: l_line_rec OE_Order_PUB.LINE_REC_TYPE;
5552:
5553: --
5554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5555: --

Line 5618: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

5614: PROCEDURE Query_Config
5615: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
5616: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5617: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5618: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5619: IS
5620: l_line_rec OE_Order_PUB.Line_Rec_Type
5621: := OE_Order_PUB.G_MISS_LINE_REC;
5622: l_top_model_line_id NUMBER;

Line 5620: l_line_rec OE_Order_PUB.Line_Rec_Type

5616: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5617: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5618: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5619: IS
5620: l_line_rec OE_Order_PUB.Line_Rec_Type
5621: := OE_Order_PUB.G_MISS_LINE_REC;
5622: l_top_model_line_id NUMBER;
5623: l_line_id NUMBER := 0;
5624: ll_line_id NUMBER := 0;

Line 5621: := OE_Order_PUB.G_MISS_LINE_REC;

5617: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5618: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5619: IS
5620: l_line_rec OE_Order_PUB.Line_Rec_Type
5621: := OE_Order_PUB.G_MISS_LINE_REC;
5622: l_top_model_line_id NUMBER;
5623: l_line_id NUMBER := 0;
5624: ll_line_id NUMBER := 0;
5625: l_header_id NUMBER := 0;

Line 6026: l_line_rec OE_Order_Pub.line_rec_type;

6022: PROCEDURE Match_and_Reserve
6023: ( p_line_id IN NUMBER
6024: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
6025: IS
6026: l_line_rec OE_Order_Pub.line_rec_type;
6027: l_top_model_line_id NUMBER;
6028: l_ordered_quantity NUMBER;
6029: l_order_quantity_uom VARCHAR2(3);
6030: l_config_id NUMBER;

Line 6756: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type

6752: -------------------------------------------------------------------*/
6753:
6754: PROCEDURE Notify_CTO
6755: ( p_ato_line_id IN NUMBER
6756: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6757: := OE_Order_Pub.G_MISS_REQUEST_REC
6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type

Line 6757: := OE_Order_Pub.G_MISS_REQUEST_REC

6753:
6754: PROCEDURE Notify_CTO
6755: ( p_ato_line_id IN NUMBER
6756: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6757: := OE_Order_Pub.G_MISS_REQUEST_REC
6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type

6754: PROCEDURE Notify_CTO
6755: ( p_ato_line_id IN NUMBER
6756: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6757: := OE_Order_Pub.G_MISS_REQUEST_REC
6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL
6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type

Line 6759: := OE_Order_Pub.G_MISS_REQUEST_TBL

6755: ( p_ato_line_id IN NUMBER
6756: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6757: := OE_Order_Pub.G_MISS_REQUEST_REC
6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL
6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6763: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type

6756: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
6757: := OE_Order_Pub.G_MISS_REQUEST_REC
6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL
6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6763: := OE_Order_Pub.G_MISS_REQUEST_TBL
6764: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 6761: := OE_Order_Pub.G_MISS_REQUEST_TBL

6757: := OE_Order_Pub.G_MISS_REQUEST_REC
6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL
6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6763: := OE_Order_Pub.G_MISS_REQUEST_TBL
6764: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6765: IS

Line 6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type

6758: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL
6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6763: := OE_Order_Pub.G_MISS_REQUEST_TBL
6764: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6765: IS
6766: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 6763: := OE_Order_Pub.G_MISS_REQUEST_TBL

6759: := OE_Order_Pub.G_MISS_REQUEST_TBL
6760: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
6761: := OE_Order_Pub.G_MISS_REQUEST_TBL
6762: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6763: := OE_Order_Pub.G_MISS_REQUEST_TBL
6764: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6765: IS
6766: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6767: l_msg_count NUMBER;

Line 7099: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type

7095: have different line types when order is received from upstream
7096: sales application
7097: -------------------------------------------------------------------*/
7098: PROCEDURE Default_Child_Line
7099: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
7100: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
7101: ,p_direct_save IN BOOLEAN := FALSE
7102: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
7103: IS

Line 7100: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

7096: sales application
7097: -------------------------------------------------------------------*/
7098: PROCEDURE Default_Child_Line
7099: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
7100: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
7101: ,p_direct_save IN BOOLEAN := FALSE
7102: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
7103: IS
7104: --

Line 7995: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

7991: oe_line_util.apply_attribute_changes procedure for
7992: included_items will be logged here.
7993: --------------------------------------------------------*/
7994: PROCEDURE Log_Included_Item_Requests
7995: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
7996: ,p_booked_flag IN VARCHAR2)
7997: IS
7998: I NUMBER;
7999: l_return_status VARCHAR2(1);

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

8529: 3 - sysdate till booking.
8530: 4 - sysdate till pick release -- #6187663
8531: --------------------------------------------------------*/
8532: PROCEDURE Get_Config_Effective_Date
8533: ( p_model_line_rec IN OE_Order_Pub.Line_Rec_Type := null
8534: ,p_model_line_id IN NUMBER := null
8535: ,x_old_behavior OUT NOCOPY VARCHAR2
8536: ,x_config_effective_date OUT NOCOPY DATE
8537: ,x_frozen_model_bill OUT NOCOPY VARCHAR2)

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

8810:
8811: This API will be called before deleting or cacelling booked macd model.
8812: --------------------------------------------------------*/
8813:
8814: PROCEDURE Unlock_Config(p_line_rec IN OE_ORDER_PUB.line_rec_type,
8815: x_return_status OUT NOCOPY VARCHAR2 )
8816: IS
8817:
8818: l_top_container VARCHAR2(1);

Line 8911: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;

8907: ) IS
8908: --
8909: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
8910: l_cursor_query VARCHAR2(4000);
8911: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;
8912: l_included_item_tbl OE_Order_PUB.Line_Tbl_Type;
8913: l_included_item_rec OE_Order_PUB.Line_Rec_Type;
8914: l_explosion_date DATE;
8915: l_validation_org NUMBER;

Line 8912: l_included_item_tbl OE_Order_PUB.Line_Tbl_Type;

8908: --
8909: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
8910: l_cursor_query VARCHAR2(4000);
8911: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;
8912: l_included_item_tbl OE_Order_PUB.Line_Tbl_Type;
8913: l_included_item_rec OE_Order_PUB.Line_Rec_Type;
8914: l_explosion_date DATE;
8915: l_validation_org NUMBER;
8916: l_item_check BOOLEAN := FALSE;

Line 8913: l_included_item_rec OE_Order_PUB.Line_Rec_Type;

8909: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
8910: l_cursor_query VARCHAR2(4000);
8911: l_parent_line_rec OE_Order_PUB.Line_Rec_Type;
8912: l_included_item_tbl OE_Order_PUB.Line_Tbl_Type;
8913: l_included_item_rec OE_Order_PUB.Line_Rec_Type;
8914: l_explosion_date DATE;
8915: l_validation_org NUMBER;
8916: l_item_check BOOLEAN := FALSE;
8917: l_validation_status BOOLEAN := FALSE;