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 113: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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

Line 114: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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

Line 115: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 116: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 149: ,p_request_rec IN OE_ORDER_PUB.request_rec_type)

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

Line 151: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 152: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

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

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

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

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

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

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

Line 512: (p_request_rec IN oe_order_pub.request_rec_type,

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

Line 625: (p_request_rec IN oe_order_pub.request_rec_type,

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

Line 813: (p_request_rec IN oe_order_pub.request_rec_type,

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

Line 1039: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1040: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1041: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 1051: l_config_rec OE_ORDER_PUB.line_rec_type;

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

Line 1056: l_request_rec OE_Order_Pub.request_rec_type;

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

Line 1057: l_request_tbl OE_Order_Pub.Request_Tbl_Type;

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

Line 1066: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

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

Line 1238: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 1247: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 1248: l_x_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 1459: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 1460: l_old_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 1461: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;

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

Line 1462: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1463: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1464: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

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

Line 1465: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

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

Line 1466: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

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

Line 1467: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

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

Line 1468: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 1469: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

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

Line 1470: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 1471: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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

Line 1472: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 1473: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 1474: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1475: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

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

Line 1476: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

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

Line 1477: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

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

Line 1478: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 1479: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

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

Line 1480: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

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

Line 1481: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

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

Line 1482: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

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

Line 1483: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

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

Line 1484: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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

Line 1485: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

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

Line 1486: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

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

Line 1493: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

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

Line 1494: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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

Line 1496: l_header_rec OE_Order_PUB.Header_Rec_Type;

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

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

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

Line 1889: ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

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

Line 1895: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;

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

Line 1899: l_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 2045: ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

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

Line 2055: l_request_rec OE_Order_PUB.request_rec_type := x_request_rec;

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

Line 2191: (p_request_rec IN oe_order_pub.request_rec_type,

2187: END Release_Hold;
2188:
2189:
2190: PROCEDURE Split_Set
2191: (p_request_rec IN oe_order_pub.request_rec_type,
2192: x_return_status OUT NOCOPY VARCHAR2)
2193:
2194: IS
2195: l_return_status VARCHAR2(30);

Line 2260: (p_request_rec IN oe_order_pub.request_rec_type,

2256:
2257: End Split_set;
2258:
2259: PROCEDURE Insert_Set
2260: (p_request_rec IN oe_order_pub.request_rec_type,
2261: x_return_status OUT NOCOPY VARCHAR2)
2262:
2263: IS
2264: l_return_status VARCHAR2(30);

Line 2267: p_set_request oe_order_pub.request_tbl_type;

2263: IS
2264: l_return_status VARCHAR2(30);
2265: x_msg_data varchar2(2000);
2266: x_msg_count number;
2267: p_set_request oe_order_pub.request_tbl_type;
2268: Begin
2269: p_set_request(1) := p_request_rec;
2270: OE_SET_UTIL.Insert_Into_Set
2271: (p_set_request_tbl => p_set_request,

Line 2531: l_line_rec OE_ORDER_PUB.line_rec_type;

2527: p_line_id IN NUMBER DEFAULT NULL,
2528: x_return_status OUT nocopy VARCHAR2)
2529: IS
2530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2531: l_line_rec OE_ORDER_PUB.line_rec_type;
2532: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2533: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2534: l_item_type VARCHAR2(50) :='';
2535: l_curr_code varchar2(20) := '';

Line 2532: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

2528: x_return_status OUT nocopy VARCHAR2)
2529: IS
2530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2531: l_line_rec OE_ORDER_PUB.line_rec_type;
2532: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2533: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2534: l_item_type VARCHAR2(50) :='';
2535: l_curr_code varchar2(20) := '';
2536: l_sub_template NUMBER;

Line 2533: l_line_tbl OE_ORDER_PUB.line_tbl_type;

2529: IS
2530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2531: l_line_rec OE_ORDER_PUB.line_rec_type;
2532: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2533: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2534: l_item_type VARCHAR2(50) :='';
2535: l_curr_code varchar2(20) := '';
2536: l_sub_template NUMBER;
2537: l_first_period_amt NUMBER;

Line 2748: ( p_update_shipping_tbl IN OE_ORDER_PUB.request_tbl_type

2744: /*----------------------------------------------------------------------
2745: PROCEDURE Update_shipping
2746: -----------------------------------------------------------------------*/
2747: PROCEDURE Update_shipping
2748: ( p_update_shipping_tbl IN OE_ORDER_PUB.request_tbl_type
2749: , p_line_id IN NUMBER
2750: , p_operation IN VARCHAR2
2751: , x_return_status OUT NOCOPY VARCHAR2)
2752:

Line 2755: l_update_lines_tbl OE_ORDER_PUB.request_tbl_type;

2751: , x_return_status OUT NOCOPY VARCHAR2)
2752:
2753: IS
2754: l_update_shipping_index NUMBER := 0;
2755: l_update_lines_tbl OE_ORDER_PUB.request_tbl_type;
2756: l_update_lines_index NUMBER := 0;
2757: BEGIN
2758:
2759: oe_debug_pub.add('Entering UTIL.Update_Shipping'||p_line_id, 1);

Line 2846: p_ship_confirmation_tbl IN OE_ORDER_PUB.request_tbl_type

2842:
2843:
2844: PROCEDURE Ship_Confirmation
2845: (
2846: p_ship_confirmation_tbl IN OE_ORDER_PUB.request_tbl_type
2847: , p_line_id IN NUMBER
2848: , p_process_type IN VARCHAR2
2849: , p_process_id IN VARCHAR2
2850: , x_return_status OUT NOCOPY VARCHAR2

Line 2968: , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

2964: The call to oe_config_util does all the work.
2965: ----------------------------------------------------*/
2966: Procedure VALIDATE_CONFIGURATION
2967: ( p_top_model_line_id IN NUMBER
2968: , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2969: , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2970: , x_return_status OUT NOCOPY VARCHAR2
2971:
2972: )

Line 2969: , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

2965: ----------------------------------------------------*/
2966: Procedure VALIDATE_CONFIGURATION
2967: ( p_top_model_line_id IN NUMBER
2968: , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
2969: , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
2970: , x_return_status OUT NOCOPY VARCHAR2
2971:
2972: )
2973: IS

Line 3030: ( p_request_rec IN oe_order_pub.request_rec_type

3026: END;
3027:
3028:
3029: Procedure Group_Schedule
3030: ( p_request_rec IN oe_order_pub.request_rec_type
3031: , x_return_status OUT NOCOPY VARCHAR2)
3032:
3033: IS
3034: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 3036: l_line_rec OE_ORDER_PUB.line_rec_type;

3032:
3033: IS
3034: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3035: l_atp_tbl OE_ATP.ATP_Tbl_Type;
3036: l_line_rec OE_ORDER_PUB.line_rec_type;
3037: l_return_status VARCHAR2(1);
3038: BEGIN
3039:
3040: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Group_Schedule',1);

Line 3206: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

3202: l_number NUMBER := 0;
3203: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_OPTIONS_INCLUDED';
3204: l_control_rec OE_GLOBALS.Control_Rec_Type;
3205: l_return_status VARCHAR2(30);
3206: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3207: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3208: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
3209: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3210: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 3207: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

3203: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_OPTIONS_INCLUDED';
3204: l_control_rec OE_GLOBALS.Control_Rec_Type;
3205: l_return_status VARCHAR2(30);
3206: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3207: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3208: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
3209: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3210: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3211: I NUMBER;

Line 3208: l_child_line_rec OE_Order_Pub.Line_Rec_Type;

3204: l_control_rec OE_GLOBALS.Control_Rec_Type;
3205: l_return_status VARCHAR2(30);
3206: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3207: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3208: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
3209: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3210: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3211: I NUMBER;
3212: l_line_id NUMBER;

Line 3209: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3205: l_return_status VARCHAR2(30);
3206: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3207: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3208: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
3209: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3210: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3211: I NUMBER;
3212: l_line_id NUMBER;
3213: l_reference_line_id NUMBER;

Line 3210: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

3206: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3207: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3208: l_child_line_rec OE_Order_Pub.Line_Rec_Type;
3209: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3210: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
3211: I NUMBER;
3212: l_line_id NUMBER;
3213: l_reference_line_id NUMBER;
3214: l_top_model_line_id NUMBER;

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

3291:
3292: FOR l_child IN rma_children LOOP
3293: l_number := l_number + 1;
3294:
3295: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
3296: IF l_number = 1 THEN
3297: select oe_sets_s.nextval into l_fulfillment_set_id from dual;
3298:
3299: insert into oe_sets

Line 3495: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3491:
3492: l_number NUMBER := 0;
3493: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_LOT_SERIAL';
3494: l_control_rec OE_GLOBALS.Control_Rec_Type;
3495: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3496: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3497: l_return_status VARCHAR2(30);
3498: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3499: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

Line 3496: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3492: l_number NUMBER := 0;
3493: l_api_name CONSTANT VARCHAR(30) := 'INSERT_RMA_LOT_SERIAL';
3494: l_control_rec OE_GLOBALS.Control_Rec_Type;
3495: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3496: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3497: l_return_status VARCHAR2(30);
3498: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3499: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3500: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3498: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

3494: l_control_rec OE_GLOBALS.Control_Rec_Type;
3495: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3496: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3497: l_return_status VARCHAR2(30);
3498: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3499: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3500: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3501: l_line_id NUMBER;
3502: l_inventory_item_id NUMBER;

Line 3499: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

3495: l_x_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3496: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3497: l_return_status VARCHAR2(30);
3498: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3499: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3500: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3501: l_line_id NUMBER;
3502: l_inventory_item_id NUMBER;
3503: l_reference_line_id NUMBER;

Line 3500: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3496: l_x_old_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3497: l_return_status VARCHAR2(30);
3498: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
3499: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
3500: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3501: l_line_id NUMBER;
3502: l_inventory_item_id NUMBER;
3503: l_reference_line_id NUMBER;
3504: l_lot_control_flag VARCHAR2(1) := 'N';

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

3722: END IF;
3723:
3724: OE_DEBUG_PUB.ADD(' In LOT-SERIAL-NUMBERS cursor',1);
3725: l_number := l_number + 1;
3726: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
3727: l_lot_serial_tbl(l_number).lot_number := l_lot_serial_numbers.lot_number;
3728: l_lot_serial_tbl(l_number).from_serial_number := l_lot_serial_numbers.serial_number;
3729: l_lot_serial_tbl(l_number).quantity := 1;
3730: END LOOP;

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

3761: END IF;
3762:
3763: l_number := l_number + 1;
3764: OE_DEBUG_PUB.ADD(' In LOT-NUMBERS cursor',1);
3765: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
3766: l_lot_serial_tbl(l_number).lot_number := l_lot_numbers.lot_number;
3767:
3768: -- transaction quantity is negative because of sales order issue
3769: -- Removed -ve sign to fix 1643433.

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

3793: END IF;
3794:
3795: l_number := l_number + 1;
3796: OE_DEBUG_PUB.ADD(' In SERIAL-NUMBERS cursor',1);
3797: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
3798: l_lot_serial_tbl(l_number).from_serial_number := l_serial_numbers.serial_number;
3799: l_lot_serial_tbl(l_number).quantity := 1;
3800: END LOOP;
3801:

Line 3889: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

3885:
3886: PROCEDURE Validate_Line_Set(P_line_set_id IN NUMBER,
3887: x_return_status OUT NOCOPY VARCHAR2) IS
3888:
3889: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3890: l_item_id NUMBER;
3891: l_order_qty_uom VARCHAR2(30);
3892: l_line_type_id NUMBER;
3893: l_ship_tolerance_above NUMBER;

Line 4059: (p_adjust_tbl IN OE_ORDER_PUB.REQUEST_TBL_TYPE,

4055:
4056: END Validate_line_Set;
4057:
4058: PROCEDURE Process_Adjustments
4059: (p_adjust_tbl IN OE_ORDER_PUB.REQUEST_TBL_TYPE,
4060: x_return_status OUT NOCOPY VARCHAR2)
4061:
4062: IS
4063: l_return_status VARCHAR2(30);

Line 4066: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;

4062: IS
4063: l_return_status VARCHAR2(30);
4064: x_msg_data VARCHAR2(2000);
4065: x_msg_count NUMBER;
4066: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

4063: l_return_status VARCHAR2(30);
4064: x_msg_data VARCHAR2(2000);
4065: x_msg_count NUMBER;
4066: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

4064: x_msg_data VARCHAR2(2000);
4065: x_msg_count NUMBER;
4066: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4065: x_msg_count NUMBER;
4066: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4066: l_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

4067: l_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4068: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4069: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

4070: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

4071: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

4072: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

4073: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

4074: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4082: l_list_line_type_code VARCHAR2(30) := NULL;

Line 4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

4075: l_x_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4082: l_list_line_type_code VARCHAR2(30) := NULL;
4083: l_list_line_id NUMBER;

Line 4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

4076: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4082: l_list_line_type_code VARCHAR2(30) := NULL;
4083: l_list_line_id NUMBER;
4084: --serla begin

Line 4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

4077: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4078: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4079: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4080: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4082: l_list_line_type_code VARCHAR2(30) := NULL;
4083: l_list_line_id NUMBER;
4084: --serla begin
4085: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 4085: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

4081: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4082: l_list_line_type_code VARCHAR2(30) := NULL;
4083: l_list_line_id NUMBER;
4084: --serla begin
4085: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4086: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4087: --serla end
4088: Begin
4089:

Line 4086: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4082: l_list_line_type_code VARCHAR2(30) := NULL;
4083: l_list_line_id NUMBER;
4084: --serla begin
4085: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4086: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4087: --serla end
4088: Begin
4089:
4090:

Line 4103: l_adj_rec := Oe_Order_Pub.G_MISS_LINE_ADJ_REC;

4099: Into l_list_line_type_code
4100: From qp_list_lines
4101: Where list_line_id = to_number(p_adjust_tbl(I).param3);
4102:
4103: l_adj_rec := Oe_Order_Pub.G_MISS_LINE_ADJ_REC;
4104: /* l_adj_rec.list_line_type_code := 'DIS'; */
4105: l_adj_rec.price_adjustment_id := to_number(p_adjust_tbl(I).param1);
4106: l_adj_rec.list_header_id := to_number(p_adjust_tbl(I).param2);
4107:

Line 4236: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

4232: l_number NUMBER := 0;
4233: l_api_name CONSTANT VARCHAR(30) := 'INSERT_SERVICE_FOR_OPTIONS';
4234: l_control_rec OE_GLOBALS.Control_Rec_Type;
4235: l_return_status Varchar2(30);
4236: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4237: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4238: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4239: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4240: l_line_id NUMBER;

Line 4237: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

4233: l_api_name CONSTANT VARCHAR(30) := 'INSERT_SERVICE_FOR_OPTIONS';
4234: l_control_rec OE_GLOBALS.Control_Rec_Type;
4235: l_return_status Varchar2(30);
4236: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4237: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4238: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4239: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4240: l_line_id NUMBER;
4241: l_service_reference_line_id NUMBER;

Line 4238: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4234: l_control_rec OE_GLOBALS.Control_Rec_Type;
4235: l_return_status Varchar2(30);
4236: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4237: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4238: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4239: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4240: l_line_id NUMBER;
4241: l_service_reference_line_id NUMBER;
4242: l_header_id NUMBER;

Line 4239: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

4235: l_return_status Varchar2(30);
4236: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4237: l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4238: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4239: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4240: l_line_id NUMBER;
4241: l_service_reference_line_id NUMBER;
4242: l_header_id NUMBER;
4243: l_line_number NUMBER;

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

4444:
4445: --End bug7717223
4446:
4447: l_number := l_number + 1;
4448: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
4449: l_line_tbl(l_number).service_reference_type_code := 'ORDER';
4450: l_line_tbl(l_number).service_reference_line_id := l_child.line_id;
4451: -- aksingh change it not right
4452: l_line_tbl(l_number).service_reference_system_id := l_child.line_id;

Line 4635: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;

4631: l_number NUMBER := 0;
4632: l_api_name CONSTANT VARCHAR(30) := 'CASCADE_SERVICE_FOR_OPTIONS';
4633: l_control_rec OE_GLOBALS.Control_Rec_Type;
4634: l_return_status Varchar2(30);
4635: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4636: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4638: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4639: --l_line_id NUMBER;

Line 4636: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;

4632: l_api_name CONSTANT VARCHAR(30) := 'CASCADE_SERVICE_FOR_OPTIONS';
4633: l_control_rec OE_GLOBALS.Control_Rec_Type;
4634: l_return_status Varchar2(30);
4635: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4636: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4638: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4639: --l_line_id NUMBER;
4640: l_header_id NUMBER;

Line 4637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4633: l_control_rec OE_GLOBALS.Control_Rec_Type;
4634: l_return_status Varchar2(30);
4635: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4636: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4638: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4639: --l_line_id NUMBER;
4640: l_header_id NUMBER;
4641: l_line_number NUMBER;

Line 4638: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

4634: l_return_status Varchar2(30);
4635: l_orig_line_rec OE_Order_PUB.Line_Rec_Type;
4636: --l_reference_line_rec OE_Order_Pub.Line_Rec_Type;
4637: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4638: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4639: --l_line_id NUMBER;
4640: l_header_id NUMBER;
4641: l_line_number NUMBER;
4642: l_order_number NUMBER;

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

4727: oe_debug_pub.add('prg_exist flag is: ' || l_prg_exist,1);
4728:
4729: IF l_prg_exist = 'N' THEN --bug 16848168
4730: l_number := l_number + 1;
4731: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
4732: l_line_tbl(l_number).service_reference_type_code := 'ORDER';
4733: l_line_tbl(l_number).service_reference_line_id := l_orig_line_rec.line_id;
4734: l_line_tbl(l_number).service_reference_system_id := l_orig_line_rec.line_id;
4735: l_line_tbl(l_number).service_txn_reason_code := l_orig_line_rec.service_txn_reason_code;

Line 4975: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

4971: to the same set, this procedure is called once for all the
4972: lines of the set.
4973: -------------------------------------------------------------------*/
4974: Procedure Schedule_Line
4975: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
4976: , x_return_status OUT NOCOPY VARCHAR2)
4977:
4978: IS
4979: l_ship_set_id NUMBER := null;

Line 4981: l_request_rec OE_Order_PUB.request_rec_type;

4977:
4978: IS
4979: l_ship_set_id NUMBER := null;
4980: l_arrival_set_id NUMBER := null;
4981: l_request_rec OE_Order_PUB.request_rec_type;
4982: l_line_rec OE_ORDER_PUB.line_rec_type;
4983: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4984: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4985: l_atp_tbl OE_ATP.atp_tbl_type;

Line 4982: l_line_rec OE_ORDER_PUB.line_rec_type;

4978: IS
4979: l_ship_set_id NUMBER := null;
4980: l_arrival_set_id NUMBER := null;
4981: l_request_rec OE_Order_PUB.request_rec_type;
4982: l_line_rec OE_ORDER_PUB.line_rec_type;
4983: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4984: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4985: l_atp_tbl OE_ATP.atp_tbl_type;
4986: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 4983: l_old_line_rec OE_ORDER_PUB.line_rec_type;

4979: l_ship_set_id NUMBER := null;
4980: l_arrival_set_id NUMBER := null;
4981: l_request_rec OE_Order_PUB.request_rec_type;
4982: l_line_rec OE_ORDER_PUB.line_rec_type;
4983: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4984: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4985: l_atp_tbl OE_ATP.atp_tbl_type;
4986: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4987: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 4984: l_out_line_rec OE_ORDER_PUB.line_rec_type;

4980: l_arrival_set_id NUMBER := null;
4981: l_request_rec OE_Order_PUB.request_rec_type;
4982: l_line_rec OE_ORDER_PUB.line_rec_type;
4983: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4984: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4985: l_atp_tbl OE_ATP.atp_tbl_type;
4986: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4987: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
4988: l_group_sch_required BOOLEAN := TRUE;

Line 4999: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

4995: FOR I in 1..p_sch_set_tbl.count LOOP
4996:
4997: l_request_rec := p_sch_set_tbl(I);
4998: -- Assiging miss rec.
4999: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
5000:
5001: OE_LINE_UTIL.Lock_Row(p_line_id => l_request_rec.entity_id,
5002: p_x_line_rec => l_line_rec,
5003: x_return_status => l_return_status);

Line 5374: l_line_rec OE_Order_PUB.Line_Rec_Type;

5370: l_call_credit_checking VARCHAR2(30);
5371: l_tax_on_charge NUMBER;
5372: l_total_tax NUMBER;
5373: l_old_total_tax NUMBER;
5374: l_line_rec OE_Order_PUB.Line_Rec_Type;
5375: l_header_rec OE_Order_PUB.Header_Rec_Type;
5376: l_old_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5377: l_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5378: l_hold_result VARCHAR2(30);

Line 5375: l_header_rec OE_Order_PUB.Header_Rec_Type;

5371: l_tax_on_charge NUMBER;
5372: l_total_tax NUMBER;
5373: l_old_total_tax NUMBER;
5374: l_line_rec OE_Order_PUB.Line_Rec_Type;
5375: l_header_rec OE_Order_PUB.Header_Rec_Type;
5376: l_old_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5377: l_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5378: l_hold_result VARCHAR2(30);
5379: l_msg_count NUMBER := 0;

Line 5376: l_old_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061

5372: l_total_tax NUMBER;
5373: l_old_total_tax NUMBER;
5374: l_line_rec OE_Order_PUB.Line_Rec_Type;
5375: l_header_rec OE_Order_PUB.Header_Rec_Type;
5376: l_old_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5377: l_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5378: l_hold_result VARCHAR2(30);
5379: l_msg_count NUMBER := 0;
5380: l_msg_data VARCHAR2(2000);

Line 5377: l_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061

5373: l_old_total_tax NUMBER;
5374: l_line_rec OE_Order_PUB.Line_Rec_Type;
5375: l_header_rec OE_Order_PUB.Header_Rec_Type;
5376: l_old_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5377: l_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5378: l_hold_result VARCHAR2(30);
5379: l_msg_count NUMBER := 0;
5380: l_msg_data VARCHAR2(2000);
5381: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 5381: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

5377: l_line_tbl oe_order_pub.line_tbl_type; -- Bug 8825061
5378: l_hold_result VARCHAR2(30);
5379: l_msg_count NUMBER := 0;
5380: l_msg_data VARCHAR2(2000);
5381: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5382: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5383: l_l_header_adj_tbl OE_Order_PUB.header_Adj_Tbl_Type;
5384: l_return NUMBER;
5385: l_tax_index NUMBER := 0;

Line 5382: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

5378: l_hold_result VARCHAR2(30);
5379: l_msg_count NUMBER := 0;
5380: l_msg_data VARCHAR2(2000);
5381: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5382: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5383: l_l_header_adj_tbl OE_Order_PUB.header_Adj_Tbl_Type;
5384: l_return NUMBER;
5385: l_tax_index NUMBER := 0;
5386: l_tax_count NUMBER := 0;

Line 5383: l_l_header_adj_tbl OE_Order_PUB.header_Adj_Tbl_Type;

5379: l_msg_count NUMBER := 0;
5380: l_msg_data VARCHAR2(2000);
5381: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5382: l_l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5383: l_l_header_adj_tbl OE_Order_PUB.header_Adj_Tbl_Type;
5384: l_return NUMBER;
5385: l_tax_index NUMBER := 0;
5386: l_tax_count NUMBER := 0;
5387: l_index NUMBER := 0;

Line 5393: l_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

5389: l_payment_type_code VARCHAR2(30);
5390: l_match_flag VARCHAR2(1);
5391: l_tax_rate_id NUMBER;
5392: l_price_adjustment_id NUMBER;
5393: l_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5394: l_h_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; --TaxER
5395: BEGIN
5396: IF l_debug_level > 0 THEN
5397: v_start := DBMS_UTILITY.GET_TIME;

Line 5394: l_h_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; --TaxER

5390: l_match_flag VARCHAR2(1);
5391: l_tax_rate_id NUMBER;
5392: l_price_adjustment_id NUMBER;
5393: l_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
5394: l_h_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; --TaxER
5395: BEGIN
5396: IF l_debug_level > 0 THEN
5397: v_start := DBMS_UTILITY.GET_TIME;
5398: oe_debug_pub.add('Entering Process_Tax ',0.5); --debug level changed to 0.5 for bug 13435459

Line 6376: l_request_rec OE_ORDER_PUB.REQUEST_REC_TYPE;

6372: x_return_status OUT NOCOPY VARCHAR2)
6373:
6374: IS
6375:
6376: l_request_rec OE_ORDER_PUB.REQUEST_REC_TYPE;
6377: l_header_id NUMBER;
6378: l_order_source_id NUMBER;
6379: l_orig_sys_document_ref VARCHAR2(50);
6380: l_sold_to_org_id NUMBER;