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

Line 112: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

108: l_sales_credit_id Number;
109:
110: /* Changed the above cursor definition to fix the bug 1822931 */
111: l_scredit_type_id number;
112: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
113: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
114: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
115: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
116: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 113: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

109:
110: /* Changed the above cursor definition to fix the bug 1822931 */
111: l_scredit_type_id number;
112: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
113: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
114: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
115: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
116: l_control_rec OE_GLOBALS.Control_Rec_Type;
117: l_return_status VARCHAR2(30);

Line 114: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

110: /* Changed the above cursor definition to fix the bug 1822931 */
111: l_scredit_type_id number;
112: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
113: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
114: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
115: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
116: l_control_rec OE_GLOBALS.Control_Rec_Type;
117: l_return_status VARCHAR2(30);
118: x_msg_count NUMBER;

Line 115: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

111: l_scredit_type_id number;
112: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
113: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
114: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
115: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
116: l_control_rec OE_GLOBALS.Control_Rec_Type;
117: l_return_status VARCHAR2(30);
118: x_msg_count NUMBER;
119: x_msg_data VARCHAR2(2000);

Line 148: ,p_request_rec IN OE_ORDER_PUB.request_rec_type)

144:
145: Procedure Cascade_Service_Scredit
146: ( x_return_status OUT NOCOPY Varchar2
147:
148: ,p_request_rec IN OE_ORDER_PUB.request_rec_type)
149: IS
150: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
151: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
152: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 150: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

146: ( x_return_status OUT NOCOPY Varchar2
147:
148: ,p_request_rec IN OE_ORDER_PUB.request_rec_type)
149: IS
150: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
151: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
152: l_control_rec OE_GLOBALS.Control_Rec_Type;
153: l_line_id NUMBER;
154: l_line_id1 NUMBER;

Line 151: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

147:
148: ,p_request_rec IN OE_ORDER_PUB.request_rec_type)
149: IS
150: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
151: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
152: l_control_rec OE_GLOBALS.Control_Rec_Type;
153: l_line_id NUMBER;
154: l_line_id1 NUMBER;
155: l_line_set_id NUMBER;

Line 341: l_Line_Scredit_tbl(l_count) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

337: -- Child.service does not have a sales credit and create the
338: -- same.
339: l_count := l_count + 1;
340:
341: l_Line_Scredit_tbl(l_count) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
342: l_Line_Scredit_tbl(l_count).Header_id := I.Header_id;
343: l_Line_Scredit_tbl(l_count).Line_id := I.Line_id;
344: l_Line_Scredit_tbl(l_count).SalesRep_Id := l_new_salesRep_id;
345: l_Line_Scredit_tbl(l_count).Sales_credit_type_id :=

Line 397: l_Line_Scredit_tbl(l_count) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

393:
394: l_count := l_count + 1;
395:
396: -- Setup new sales scredit record.
397: l_Line_Scredit_tbl(l_count) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
398: l_Line_Scredit_tbl(l_count).sales_credit_id := l_sales_credit_id;
399: l_Line_Scredit_tbl(l_count).Header_id := I.Header_id;
400: l_Line_Scredit_tbl(l_count).Line_id := I.Line_id;
401: l_Line_Scredit_tbl(l_count).SalesRep_Id := l_new_salesRep_id;

Line 415: l_Line_Scredit_tbl(l_count) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

411: ELSIF l_operation = OE_GLOBALS.G_OPR_DELETE
412: AND l_percent = l_q_percent THEN
413:
414: l_count := l_count + 1;
415: l_Line_Scredit_tbl(l_count) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
416: l_Line_Scredit_tbl(l_count).sales_credit_id := l_sales_credit_id;
417: l_Line_Scredit_tbl(l_count).Header_id := I.Header_id;
418: l_Line_Scredit_tbl(l_count).Line_id := I.Line_id;
419: l_Line_Scredit_tbl(l_count).Operation := OE_GLOBALS.G_OPR_DELETE;

Line 511: (p_request_rec IN oe_order_pub.request_rec_type,

507: END UPDATE_LINK_TO_LINE_ID;
508:
509: -- Procedure to Check for Duplicate Discounts
510: PROCEDURE check_duplicate
511: (p_request_rec IN oe_order_pub.request_rec_type,
512: x_return_status OUT NOCOPY VARCHAR2)
513:
514: IS
515: l_entity_code VARCHAR2(30);

Line 624: (p_request_rec IN oe_order_pub.request_rec_type,

620: END CHECK_DUPLICATE;
621:
622: --Procedure to Check Fixed price Discounts
623: PROCEDURE check_fixed_price
624: (p_request_rec IN oe_order_pub.request_rec_type,
625: x_return_status OUT NOCOPY VARCHAR2)
626:
627: IS
628: l_entity_code VARCHAR2(30);

Line 812: (p_request_rec IN oe_order_pub.request_rec_type,

808: END CHECK_FIXED_PRICE;
809:
810:
811: PROCEDURE check_percentage
812: (p_request_rec IN oe_order_pub.request_rec_type,
813: x_return_status OUT NOCOPY VARCHAR2)
814:
815: IS
816: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1038: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1034: )
1035: IS
1036: l_return_status VARCHAR2(1);
1037: l_control_rec OE_GLOBALS.Control_Rec_Type;
1038: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1039: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1040: l_line_rec OE_Order_PUB.Line_Rec_Type;
1041: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Order';
1042: l_line_id NUMBER;

Line 1039: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1035: IS
1036: l_return_status VARCHAR2(1);
1037: l_control_rec OE_GLOBALS.Control_Rec_Type;
1038: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1039: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1040: l_line_rec OE_Order_PUB.Line_Rec_Type;
1041: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Order';
1042: l_line_id NUMBER;
1043: l_component_sequence_id NUMBER;

Line 1040: l_line_rec OE_Order_PUB.Line_Rec_Type;

1036: l_return_status VARCHAR2(1);
1037: l_control_rec OE_GLOBALS.Control_Rec_Type;
1038: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1039: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1040: l_line_rec OE_Order_PUB.Line_Rec_Type;
1041: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Order';
1042: l_line_id NUMBER;
1043: l_component_sequence_id NUMBER;
1044: l_component_code VARCHAR2(1000);

Line 1050: l_config_rec OE_ORDER_PUB.line_rec_type;

1046: l_sort_order VARCHAR2(240);
1047: l_component_quantity NUMBER;
1048: l_bom_item_type VARCHAR2(30);
1049: l_top_model_line_id NUMBER;
1050: l_config_rec OE_ORDER_PUB.line_rec_type;
1051: l_select_flag VARCHAR2(1);
1052: l_bill_sequence_id NUMBER;
1053: l_top_bill_sequence_id NUMBER;
1054: l_option_number NUMBER;

Line 1055: l_request_rec OE_Order_Pub.request_rec_type;

1051: l_select_flag VARCHAR2(1);
1052: l_bill_sequence_id NUMBER;
1053: l_top_bill_sequence_id NUMBER;
1054: l_option_number NUMBER;
1055: l_request_rec OE_Order_Pub.request_rec_type;
1056: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1057: req_ind NUMBER;
1058: BEGIN
1059:

Line 1056: l_request_tbl OE_Order_Pub.Request_Tbl_Type;

1052: l_bill_sequence_id NUMBER;
1053: l_top_bill_sequence_id NUMBER;
1054: l_option_number NUMBER;
1055: l_request_rec OE_Order_Pub.request_rec_type;
1056: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1057: req_ind NUMBER;
1058: BEGIN
1059:
1060: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CREATE_CONFIG_ITEM', 1);

Line 1065: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

1061:
1062:
1063: oe_debug_pub.add('In procedure Create_Config', 2);
1064:
1065: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
1066:
1067:
1068: -- Set Control Record
1069:

Line 1237: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1233: ,x_return_status OUT NOCOPY VARCHAR2
1234:
1235: )
1236: IS
1237: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1238: l_ref_header_id NUMBER;
1239: l_ref_line_id NUMBER;
1240: l_header_id NUMBER;
1241: I NUMBER := 1;

Line 1246: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1242: I1 NUMBER := 1;
1243: I2 NUMBER := 1;
1244: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_SCREDIT_ADJUSTMENT';
1245: l_control_rec OE_GLOBALS.Control_Rec_Type;
1246: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1247: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1248: l_return_status VARCHAR2(30);
1249: l_count NUMBER := 0;
1250: l_split_by VARCHAR2(30);

Line 1247: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1243: I2 NUMBER := 1;
1244: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_SCREDIT_ADJUSTMENT';
1245: l_control_rec OE_GLOBALS.Control_Rec_Type;
1246: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1247: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1248: l_return_status VARCHAR2(30);
1249: l_count NUMBER := 0;
1250: l_split_by VARCHAR2(30);
1251: l_src_doc_type_id NUMBER; -- added for bug 6778016

Line 1457: l_line_rec OE_Order_PUB.Line_Rec_Type;

1453: l_msg_data VARCHAR2(2000);
1454: l_tax_value NUMBER := 0;
1455: l_control_rec OE_GLOBALS.Control_Rec_Type;
1456: l_tax_code VARCHAR2(50);
1457: l_line_rec OE_Order_PUB.Line_Rec_Type;
1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;

1454: l_tax_value NUMBER := 0;
1455: l_control_rec OE_GLOBALS.Control_Rec_Type;
1456: l_tax_code VARCHAR2(50);
1457: l_line_rec OE_Order_PUB.Line_Rec_Type;
1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;

1455: l_control_rec OE_GLOBALS.Control_Rec_Type;
1456: l_tax_code VARCHAR2(50);
1457: l_line_rec OE_Order_PUB.Line_Rec_Type;
1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1456: l_tax_code VARCHAR2(50);
1457: l_line_rec OE_Order_PUB.Line_Rec_Type;
1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1457: l_line_rec OE_Order_PUB.Line_Rec_Type;
1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

Line 1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1458: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1459: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1460: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

1461: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1462: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1463: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1464: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1465: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1466: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

1467: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

1468: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1469: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1470: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1471: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1472: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

1473: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1474: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

1475: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

1476: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1484: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

1477: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1484: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1485: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;

Line 1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1478: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1484: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1485: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;
1486: currency_code varchar2(30) := NULL;

Line 1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1479: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1484: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1485: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;
1486: currency_code varchar2(30) := NULL;
1487: header_org_id number;

Line 1484: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

1480: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1481: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1482: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1483: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1484: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1485: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;
1486: currency_code varchar2(30) := NULL;
1487: header_org_id number;
1488: inventory_org_id number;

Line 1491: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

1487: header_org_id number;
1488: inventory_org_id number;
1489: conversion_rate number;
1490: --serla begin
1491: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1492: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1493: --serla end
1494: l_header_rec OE_Order_PUB.Header_Rec_Type;
1495: BEGIN

Line 1492: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

1488: inventory_org_id number;
1489: conversion_rate number;
1490: --serla begin
1491: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1492: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1493: --serla end
1494: l_header_rec OE_Order_PUB.Header_Rec_Type;
1495: BEGIN
1496: x_return_status := l_return_status;

Line 1494: l_header_rec OE_Order_PUB.Header_Rec_Type;

1490: --serla begin
1491: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1492: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1493: --serla end
1494: l_header_rec OE_Order_PUB.Header_Rec_Type;
1495: BEGIN
1496: x_return_status := l_return_status;
1497:
1498: -- Get the Line record

Line 1581: l_Line_adj_tbl(l_counter+I) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;

1577:
1578: IF l_tax_rec_out_tbl(I).trx_line_id = l_line_rec.line_id
1579: THEN
1580:
1581: l_Line_adj_tbl(l_counter+I) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
1582: l_Line_adj_tbl(l_counter+I).header_id := l_line_rec.header_id;
1583: l_Line_adj_tbl(l_counter+I).line_id := l_line_rec.line_id;
1584: l_Line_adj_tbl(l_counter+I).tax_code := l_tax_rec_out_tbl(I).tax_rate_code;
1585: l_Line_Adj_tbl(l_counter+I).operand := l_tax_rec_out_tbl(I).tax_rate;

Line 1887: ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

1883: -- entity ID
1884: -------------------------------------------------------------------
1885:
1886: PROCEDURE Apply_Hold(p_validation_level IN NUMBER
1887: ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
1888: )
1889: IS
1890: l_header_id NUMBER DEFAULT NULL;
1891: l_line_id NUMBER DEFAULT NULL;

Line 1893: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;

1889: IS
1890: l_header_id NUMBER DEFAULT NULL;
1891: l_line_id NUMBER DEFAULT NULL;
1892: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
1893: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;
1894: l_return_status VARCHAR2(30);
1895: l_msg_count NUMBER := 0;
1896: l_msg_data VARCHAR2(2000) := NULL;
1897: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1897: l_line_rec OE_Order_PUB.Line_Rec_Type;

1893: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;
1894: l_return_status VARCHAR2(30);
1895: l_msg_count NUMBER := 0;
1896: l_msg_data VARCHAR2(2000) := NULL;
1897: l_line_rec OE_Order_PUB.Line_Rec_Type;
1898: BEGIN
1899:
1900: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Apply_Hold',1);
1901:

Line 2042: ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

2038: -------------------------------------------------------------------
2039:
2040: PROCEDURE Release_Hold(
2041: p_validation_level IN NUMBER
2042: ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
2043: )
2044: IS
2045: l_header_id NUMBER DEFAULT NULL;
2046: l_line_id NUMBER DEFAULT NULL;

Line 2052: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;

2048: --ER#7479609 l_entity_code VARCHAR2(1) DEFAULT NULL;
2049: --ER#7479609 l_entity_id NUMBER DEFAULT NULL;
2050: l_entity_code oe_hold_sources_all.hold_entity_code%TYPE DEFAULT NULL; --ER#7479609
2051: l_entity_id oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL; --ER#7479609
2052: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;
2053: l_return_status VARCHAR2(30);
2054: l_msg_count NUMBER := 0;
2055: l_msg_data VARCHAR2(2000) := NULL;
2056:

Line 2187: (p_request_rec IN oe_order_pub.request_rec_type,

2183: END Release_Hold;
2184:
2185:
2186: PROCEDURE Split_Set
2187: (p_request_rec IN oe_order_pub.request_rec_type,
2188: x_return_status OUT NOCOPY VARCHAR2)
2189:
2190: IS
2191: l_return_status VARCHAR2(30);

Line 2256: (p_request_rec IN oe_order_pub.request_rec_type,

2252:
2253: End Split_set;
2254:
2255: PROCEDURE Insert_Set
2256: (p_request_rec IN oe_order_pub.request_rec_type,
2257: x_return_status OUT NOCOPY VARCHAR2)
2258:
2259: IS
2260: l_return_status VARCHAR2(30);

Line 2263: p_set_request oe_order_pub.request_tbl_type;

2259: IS
2260: l_return_status VARCHAR2(30);
2261: x_msg_data varchar2(2000);
2262: x_msg_count number;
2263: p_set_request oe_order_pub.request_tbl_type;
2264: Begin
2265: p_set_request(1) := p_request_rec;
2266: OE_SET_UTIL.Insert_Into_Set
2267: (p_set_request_tbl => p_set_request,

Line 2527: ( p_update_shipping_tbl IN OE_ORDER_PUB.request_tbl_type

2523: /*----------------------------------------------------------------------
2524: PROCEDURE Update_shipping
2525: -----------------------------------------------------------------------*/
2526: PROCEDURE Update_shipping
2527: ( p_update_shipping_tbl IN OE_ORDER_PUB.request_tbl_type
2528: , p_line_id IN NUMBER
2529: , p_operation IN VARCHAR2
2530: , x_return_status OUT NOCOPY VARCHAR2)
2531:

Line 2534: l_update_lines_tbl OE_ORDER_PUB.request_tbl_type;

2530: , x_return_status OUT NOCOPY VARCHAR2)
2531:
2532: IS
2533: l_update_shipping_index NUMBER := 0;
2534: l_update_lines_tbl OE_ORDER_PUB.request_tbl_type;
2535: l_update_lines_index NUMBER := 0;
2536: BEGIN
2537:
2538: oe_debug_pub.add('Entering UTIL.Update_Shipping'||p_line_id, 1);

Line 2625: p_ship_confirmation_tbl IN OE_ORDER_PUB.request_tbl_type

2621:
2622:
2623: PROCEDURE Ship_Confirmation
2624: (
2625: p_ship_confirmation_tbl IN OE_ORDER_PUB.request_tbl_type
2626: , p_line_id IN NUMBER
2627: , p_process_type IN VARCHAR2
2628: , p_process_id IN VARCHAR2
2629: , x_return_status OUT NOCOPY VARCHAR2

Line 2747: , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

2743: The call to oe_config_util does all the work.
2744: ----------------------------------------------------*/
2745: Procedure VALIDATE_CONFIGURATION
2746: ( p_top_model_line_id IN NUMBER
2747: , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2748: , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2749: , x_return_status OUT NOCOPY VARCHAR2
2750:
2751: )

Line 2748: , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

2744: ----------------------------------------------------*/
2745: Procedure VALIDATE_CONFIGURATION
2746: ( p_top_model_line_id IN NUMBER
2747: , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2748: , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2749: , x_return_status OUT NOCOPY VARCHAR2
2750:
2751: )
2752: IS

Line 2809: ( p_request_rec IN oe_order_pub.request_rec_type

2805: END;
2806:
2807:
2808: Procedure Group_Schedule
2809: ( p_request_rec IN oe_order_pub.request_rec_type
2810: , x_return_status OUT NOCOPY VARCHAR2)
2811:
2812: IS
2813: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 2815: l_line_rec OE_ORDER_PUB.line_rec_type;

2811:
2812: IS
2813: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
2814: l_atp_tbl OE_ATP.ATP_Tbl_Type;
2815: l_line_rec OE_ORDER_PUB.line_rec_type;
2816: l_return_status VARCHAR2(1);
2817: BEGIN
2818:
2819: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Group_Schedule',1);

Line 2985: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

2981: l_number NUMBER := 0;
2982: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_OPTIONS_INCLUDED';
2983: l_control_rec OE_GLOBALS.Control_Rec_Type;
2984: l_return_status VARCHAR2(30);
2985: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
2986: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
2987: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
2988: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2989: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2986: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

2982: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_OPTIONS_INCLUDED';
2983: l_control_rec OE_GLOBALS.Control_Rec_Type;
2984: l_return_status VARCHAR2(30);
2985: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
2986: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
2987: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
2988: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2989: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2990: I NUMBER;

Line 2987: l_child_line_rec OE_Order_Pub.Line_Rec_Type;

2983: l_control_rec OE_GLOBALS.Control_Rec_Type;
2984: l_return_status VARCHAR2(30);
2985: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
2986: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
2987: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
2988: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2989: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2990: I NUMBER;
2991: l_line_id NUMBER;

Line 2988: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2984: l_return_status VARCHAR2(30);
2985: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
2986: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
2987: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
2988: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2989: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2990: I NUMBER;
2991: l_line_id NUMBER;
2992: l_reference_line_id NUMBER;

Line 2989: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

2985: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
2986: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
2987: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
2988: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2989: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2990: I NUMBER;
2991: l_line_id NUMBER;
2992: l_reference_line_id NUMBER;
2993: l_top_model_line_id NUMBER;

Line 3074: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;

3070:
3071: FOR l_child IN rma_children LOOP
3072: l_number := l_number + 1;
3073:
3074: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
3075: IF l_number = 1 THEN
3076: select oe_sets_s.nextval into l_fulfillment_set_id from dual;
3077:
3078: insert into oe_sets

Line 3263: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3259:
3260: l_number NUMBER := 0;
3261: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_LOT_SERIAL';
3262: l_control_rec OE_GLOBALS.Control_Rec_Type;
3263: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3264: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3265: l_return_status VARCHAR2(30);
3266: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3267: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

Line 3264: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3260: l_number NUMBER := 0;
3261: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_LOT_SERIAL';
3262: l_control_rec OE_GLOBALS.Control_Rec_Type;
3263: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3264: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3265: l_return_status VARCHAR2(30);
3266: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3267: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3268: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3266: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

3262: l_control_rec OE_GLOBALS.Control_Rec_Type;
3263: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3264: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3265: l_return_status VARCHAR2(30);
3266: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3267: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3268: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3269: l_line_id NUMBER;
3270: l_inventory_item_id NUMBER;

Line 3267: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

3263: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3264: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3265: l_return_status VARCHAR2(30);
3266: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3267: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3268: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3269: l_line_id NUMBER;
3270: l_inventory_item_id NUMBER;
3271: l_reference_line_id NUMBER;

Line 3268: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3264: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3265: l_return_status VARCHAR2(30);
3266: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3267: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3268: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3269: l_line_id NUMBER;
3270: l_inventory_item_id NUMBER;
3271: l_reference_line_id NUMBER;
3272: l_lot_control_flag VARCHAR2(1) := 'N';

Line 3465: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

3461: END IF;
3462:
3463: OE_DEBUG_PUB.ADD(' In LOT-SERIAL-NUMBERS cursor',1);
3464: l_number := l_number + 1;
3465: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
3466: l_lot_serial_tbl(l_number).lot_number := l_lot_serial_numbers.lot_number;
3467: l_lot_serial_tbl(l_number).from_serial_number := l_lot_serial_numbers.serial_number;
3468: l_lot_serial_tbl(l_number).quantity := 1;
3469: END LOOP;

Line 3504: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

3500: END IF;
3501:
3502: l_number := l_number + 1;
3503: OE_DEBUG_PUB.ADD(' In LOT-NUMBERS cursor',1);
3504: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
3505: l_lot_serial_tbl(l_number).lot_number := l_lot_numbers.lot_number;
3506:
3507: -- transaction quantity is negative because of sales order issue
3508: -- Removed -ve sign to fix 1643433.

Line 3532: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

3528: END IF;
3529:
3530: l_number := l_number + 1;
3531: OE_DEBUG_PUB.ADD(' In SERIAL-NUMBERS cursor',1);
3532: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
3533: l_lot_serial_tbl(l_number).from_serial_number := l_serial_numbers.serial_number;
3534: l_lot_serial_tbl(l_number).quantity := 1;
3535: END LOOP;
3536:

Line 3624: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

3620:
3621: PROCEDURE Validate_Line_Set(P_line_set_id IN NUMBER,
3622: x_return_status OUT NOCOPY VARCHAR2) IS
3623:
3624: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3625: l_item_id NUMBER;
3626: l_order_qty_uom VARCHAR2(30);
3627: l_line_type_id NUMBER;
3628: l_ship_tolerance_above NUMBER;

Line 3781: (p_adjust_tbl IN OE_ORDER_PUB.REQUEST_TBL_TYPE,

3777:
3778: END Validate_line_Set;
3779:
3780: PROCEDURE Process_Adjustments
3781: (p_adjust_tbl IN OE_ORDER_PUB.REQUEST_TBL_TYPE,
3782: x_return_status OUT NOCOPY VARCHAR2)
3783:
3784: IS
3785: l_return_status VARCHAR2(30);

Line 3788: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;

3784: IS
3785: l_return_status VARCHAR2(30);
3786: x_msg_data VARCHAR2(2000);
3787: x_msg_count NUMBER;
3788: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

3785: l_return_status VARCHAR2(30);
3786: x_msg_data VARCHAR2(2000);
3787: x_msg_count NUMBER;
3788: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

3786: x_msg_data VARCHAR2(2000);
3787: x_msg_count NUMBER;
3788: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3787: x_msg_count NUMBER;
3788: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3788: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

3789: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3790: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3791: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3792: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

3793: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3794: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3795: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3796: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3804: l_list_line_type_code VARCHAR2(30) := NULL;

Line 3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3797: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3804: l_list_line_type_code VARCHAR2(30) := NULL;
3805: l_list_line_id NUMBER;

Line 3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3798: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3804: l_list_line_type_code VARCHAR2(30) := NULL;
3805: l_list_line_id NUMBER;
3806: --serla begin

Line 3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3799: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3800: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3801: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3802: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3804: l_list_line_type_code VARCHAR2(30) := NULL;
3805: l_list_line_id NUMBER;
3806: --serla begin
3807: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3807: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3803: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3804: l_list_line_type_code VARCHAR2(30) := NULL;
3805: l_list_line_id NUMBER;
3806: --serla begin
3807: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3808: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3809: --serla end
3810: Begin
3811:

Line 3808: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3804: l_list_line_type_code VARCHAR2(30) := NULL;
3805: l_list_line_id NUMBER;
3806: --serla begin
3807: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3808: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3809: --serla end
3810: Begin
3811:
3812:

Line 3825: l_adj_rec := Oe_Order_Pub.G_MISS_LINE_ADJ_REC;

3821: Into l_list_line_type_code
3822: From qp_list_lines
3823: Where list_line_id = to_number(p_adjust_tbl(I).param3);
3824:
3825: l_adj_rec := Oe_Order_Pub.G_MISS_LINE_ADJ_REC;
3826: /* l_adj_rec.list_line_type_code := 'DIS'; */
3827: l_adj_rec.price_adjustment_id := to_number(p_adjust_tbl(I).param1);
3828: l_adj_rec.list_header_id := to_number(p_adjust_tbl(I).param2);
3829:

Line 3958: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

3954: l_number NUMBER := 0;
3955: l_api_name CONSTANT VARCHAR(30) := 'INSERT_SERVICE_FOR_OPTIONS';
3956: l_control_rec OE_GLOBALS.Control_Rec_Type;
3957: l_return_status Varchar2(30);
3958: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3959: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3960: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3961: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3962: l_line_id NUMBER;

Line 3959: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

3955: l_api_name CONSTANT VARCHAR(30) := 'INSERT_SERVICE_FOR_OPTIONS';
3956: l_control_rec OE_GLOBALS.Control_Rec_Type;
3957: l_return_status Varchar2(30);
3958: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3959: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3960: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3961: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3962: l_line_id NUMBER;
3963: l_service_reference_line_id NUMBER;

Line 3960: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3956: l_control_rec OE_GLOBALS.Control_Rec_Type;
3957: l_return_status Varchar2(30);
3958: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3959: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3960: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3961: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3962: l_line_id NUMBER;
3963: l_service_reference_line_id NUMBER;
3964: l_header_id NUMBER;

Line 3961: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

3957: l_return_status Varchar2(30);
3958: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3959: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3960: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3961: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3962: l_line_id NUMBER;
3963: l_service_reference_line_id NUMBER;
3964: l_header_id NUMBER;
3965: l_line_number NUMBER;

Line 4114: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;

4110: FETCH srv_children INTO l_child;
4111: EXIT WHEN srv_children%NOTFOUND;
4112:
4113: l_number := l_number + 1;
4114: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
4115: l_line_tbl(l_number).service_reference_type_code := 'ORDER';
4116: l_line_tbl(l_number).service_reference_line_id := l_child.line_id;
4117: -- aksingh change it not right
4118: l_line_tbl(l_number).service_reference_system_id := l_child.line_id;

Line 4290: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

4286: l_number NUMBER := 0;
4287: l_api_name CONSTANT VARCHAR(30) := 'CASCADE_SERVICE_FOR_OPTIONS';
4288: l_control_rec OE_GLOBALS.Control_Rec_Type;
4289: l_return_status Varchar2(30);
4290: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4291: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4292: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4293: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4294: --l_line_id NUMBER;

Line 4291: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

4287: l_api_name CONSTANT VARCHAR(30) := 'CASCADE_SERVICE_FOR_OPTIONS';
4288: l_control_rec OE_GLOBALS.Control_Rec_Type;
4289: l_return_status Varchar2(30);
4290: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4291: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4292: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4293: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4294: --l_line_id NUMBER;
4295: l_header_id NUMBER;

Line 4292: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4288: l_control_rec OE_GLOBALS.Control_Rec_Type;
4289: l_return_status Varchar2(30);
4290: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4291: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4292: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4293: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4294: --l_line_id NUMBER;
4295: l_header_id NUMBER;
4296: l_line_number NUMBER;

Line 4293: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

4289: l_return_status Varchar2(30);
4290: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4291: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4292: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4293: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4294: --l_line_id NUMBER;
4295: l_header_id NUMBER;
4296: l_line_number NUMBER;
4297: l_order_number NUMBER;

Line 4359: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;

4355:
4356:
4357: FOR l_child IN srv_line LOOP
4358: l_number := l_number + 1;
4359: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
4360: l_line_tbl(l_number).service_reference_type_code := 'ORDER';
4361: l_line_tbl(l_number).service_reference_line_id := l_orig_line_rec.line_id;
4362: l_line_tbl(l_number).service_reference_system_id := l_orig_line_rec.line_id;
4363: l_line_tbl(l_number).service_txn_reason_code := l_orig_line_rec.service_txn_reason_code;

Line 4600: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

4596: to the same set, this procedure is called once for all the
4597: lines of the set.
4598: -------------------------------------------------------------------*/
4599: Procedure Schedule_Line
4600: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
4601: , x_return_status OUT NOCOPY VARCHAR2)
4602:
4603: IS
4604: l_ship_set_id NUMBER := null;

Line 4606: l_request_rec OE_Order_PUB.request_rec_type;

4602:
4603: IS
4604: l_ship_set_id NUMBER := null;
4605: l_arrival_set_id NUMBER := null;
4606: l_request_rec OE_Order_PUB.request_rec_type;
4607: l_line_rec OE_ORDER_PUB.line_rec_type;
4608: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4609: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4610: l_atp_tbl OE_ATP.atp_tbl_type;

Line 4607: l_line_rec OE_ORDER_PUB.line_rec_type;

4603: IS
4604: l_ship_set_id NUMBER := null;
4605: l_arrival_set_id NUMBER := null;
4606: l_request_rec OE_Order_PUB.request_rec_type;
4607: l_line_rec OE_ORDER_PUB.line_rec_type;
4608: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4609: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4610: l_atp_tbl OE_ATP.atp_tbl_type;
4611: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 4608: l_old_line_rec OE_ORDER_PUB.line_rec_type;

4604: l_ship_set_id NUMBER := null;
4605: l_arrival_set_id NUMBER := null;
4606: l_request_rec OE_Order_PUB.request_rec_type;
4607: l_line_rec OE_ORDER_PUB.line_rec_type;
4608: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4609: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4610: l_atp_tbl OE_ATP.atp_tbl_type;
4611: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4612: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 4609: l_out_line_rec OE_ORDER_PUB.line_rec_type;

4605: l_arrival_set_id NUMBER := null;
4606: l_request_rec OE_Order_PUB.request_rec_type;
4607: l_line_rec OE_ORDER_PUB.line_rec_type;
4608: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4609: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4610: l_atp_tbl OE_ATP.atp_tbl_type;
4611: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4612: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
4613: l_group_sch_required BOOLEAN := TRUE;

Line 4624: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

4620: FOR I in 1..p_sch_set_tbl.count LOOP
4621:
4622: l_request_rec := p_sch_set_tbl(I);
4623: -- Assiging miss rec.
4624: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
4625:
4626: OE_LINE_UTIL.Lock_Row(p_line_id => l_request_rec.entity_id,
4627: p_x_line_rec => l_line_rec,
4628: x_return_status => l_return_status);

Line 5005: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

5001: new_tax_value NUMBER;
5002: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;
5003: l_tax_classification_code VARCHAR2(50);
5004: l_tax_rate_id NUMBER;
5005: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5006: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5007: v_start NUMBER;
5008: v_end NUMBER;
5009: l_tax_date DATE;

Line 5006: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

5002: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;
5003: l_tax_classification_code VARCHAR2(50);
5004: l_tax_rate_id NUMBER;
5005: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5006: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5007: v_start NUMBER;
5008: v_end NUMBER;
5009: l_tax_date DATE;
5010: l_inventory_item_id NUMBER;

Line 5052: l_line_rec OE_Order_PUB.Line_Rec_Type;

5048: l_pricing_quantity_uom oe_order_lines.pricing_quantity_uom%TYPE;
5049: l_order_quantity_uom oe_order_lines.order_quantity_uom%TYPE;
5050: l_user_item_description oe_order_lines.user_item_description%TYPE;
5051: l_global_attribute_category VARCHAR2(30);
5052: l_line_rec OE_Order_PUB.Line_Rec_Type;
5053: l_header_rec OE_Order_PUB.Header_Rec_Type;
5054: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5055: -- bug 4378531
5056: l_hold_result VARCHAR2(30);

Line 5053: l_header_rec OE_Order_PUB.Header_Rec_Type;

5049: l_order_quantity_uom oe_order_lines.order_quantity_uom%TYPE;
5050: l_user_item_description oe_order_lines.user_item_description%TYPE;
5051: l_global_attribute_category VARCHAR2(30);
5052: l_line_rec OE_Order_PUB.Line_Rec_Type;
5053: l_header_rec OE_Order_PUB.Header_Rec_Type;
5054: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5055: -- bug 4378531
5056: l_hold_result VARCHAR2(30);
5057:

Line 6019: l_request_rec OE_ORDER_PUB.REQUEST_REC_TYPE;

6015: x_return_status OUT NOCOPY VARCHAR2)
6016:
6017: IS
6018:
6019: l_request_rec OE_ORDER_PUB.REQUEST_REC_TYPE;
6020: l_header_id NUMBER;
6021: l_order_source_id NUMBER;
6022: l_orig_sys_document_ref VARCHAR2(50);
6023: l_sold_to_org_id NUMBER;