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

Line 182: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

178: *
179: */
180: PROCEDURE Update_Service_Dates
181: (
182: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
183: )
184: IS
185: l_return_status VARCHAR2(1);
186: l_line_rec OE_Order_Pub.Line_Rec_Type;

Line 186: l_line_rec OE_Order_Pub.Line_Rec_Type;

182: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
183: )
184: IS
185: l_return_status VARCHAR2(1);
186: l_line_rec OE_Order_Pub.Line_Rec_Type;
187: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
188: BEGIN
189:
190: IF l_debug_level > 0 THEN

Line 243: (p_line_rec IN OE_Order_Pub.Line_Rec_Type

239:
240:
241:
242: FUNCTION Return_Line
243: (p_line_rec IN OE_Order_Pub.Line_Rec_Type
244: )
245: RETURN BOOLEAN
246: IS
247: --

Line 317: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

313: End Update_header_flow_status;
314:
315:
316: FUNCTION Shipping_info_Available
317: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
318: )
319: RETURN BOOLEAN
320: IS
321: l_count NUMBER;

Line 375: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

371: END IF;
372: END Shipping_info_Available;
373:
374: FUNCTION Line_Invoiceable
375: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
376: )
377: RETURN BOOLEAN
378: IS
379: l_invoiceable_item_flag VARCHAR2(1);

Line 617: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

613: END IF;
614: END Line_Invoiceable;
615:
616: PROCEDURE Check_Invoicing_Holds
617: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
618: , p_itemtype IN VARCHAR2
619: , x_return_status OUT NOCOPY VARCHAR2
620: )
621: IS

Line 700: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

696: END IF;
697: END Check_Invoicing_Holds;
698:
699: FUNCTION Show_Detail_Discounts
700: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
701: ) RETURN BOOLEAN IS
702: l_price_adj_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
703: --
704: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 793: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

789: END IF;
790: END Rounded_Amount;
791:
792: PROCEDURE Return_Credit_Info
793: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
794: , x_credit_memo_type_id OUT NOCOPY NUMBER
795: , x_credit_creation_sign OUT NOCOPY VARCHAR2
796: )
797: IS

Line 1005: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1001: x_credit_creation_sign := NULL;
1002: END Return_Credit_Info;
1003:
1004: FUNCTION Get_Credit_Creation_Sign
1005: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1006: , p_cust_trx_type_id IN NUMBER)
1007: RETURN VARCHAR2 IS
1008: l_creation_sign VARCHAR2(30):= NULL;
1009: --

Line 1037: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1033: RETURN(NULL);
1034: END Get_Credit_Creation_Sign;
1035:
1036: PROCEDURE Get_Commitment_Info
1037: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1038: , x_commitment_applied OUT NOCOPY NUMBER
1039: , x_commitment_interfaced OUT NOCOPY NUMBER)
1040: IS
1041: --

Line 1086: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1082: x_commitment_interfaced := NULL;
1083: END Get_Commitment_Info;
1084:
1085: PROCEDURE Get_Item_Description
1086: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1087: , x_item_description OUT NOCOPY VARCHAR2
1088: ) IS
1089: l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1090: --

Line 1169: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1165: NULL;
1166: END Get_Item_Description;
1167:
1168: PROCEDURE Get_Service_Item_Description
1169: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1170: , x_item_description OUT NOCOPY VARCHAR2
1171: ) IS
1172: l_line_rec OE_Order_Pub.Line_Rec_Type;
1173: l_order_line_id NUMBER;

Line 1172: l_line_rec OE_Order_Pub.Line_Rec_Type;

1168: PROCEDURE Get_Service_Item_Description
1169: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1170: , x_item_description OUT NOCOPY VARCHAR2
1171: ) IS
1172: l_line_rec OE_Order_Pub.Line_Rec_Type;
1173: l_order_line_id NUMBER;
1174: l_return_status VARCHAR2(1);
1175: l_service_reference_line_id NUMBER;
1176: l_service_item_desc VARCHAR2(240);

Line 1333: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

1329: NULL;
1330: END Get_Service_Item_Description;
1331:
1332: FUNCTION Get_Overship_Invoice_Basis
1333: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
1334: RETURN VARCHAR2
1335: IS
1336: l_overship_invoice_basis VARCHAR2(30):= NULL;
1337: --

Line 1387: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1383:
1384: END Get_Overship_Invoice_Basis;
1385:
1386: FUNCTION Get_Invoice_Source
1387: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1388: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
1389: )
1390: RETURN VARCHAR2
1391: IS

Line 1470: l_line_rec OE_Order_Pub.Line_Rec_Type;

1466: ) RETURN NUMBER IS
1467: l_inv_cust_trx_type_id NUMBER;
1468: l_cust_trx_type_id NUMBER;
1469: l_creation_sign VARCHAR2(30);
1470: l_line_rec OE_Order_Pub.Line_Rec_Type;
1471: --
1472: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1473: --
1474: BEGIN

Line 1498: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1494: return(0);
1495: END Get_Customer_Transaction_Type;
1496:
1497: FUNCTION Get_Customer_Transaction_Type
1498: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1499: ) RETURN NUMBER IS
1500: l_inv_cust_trx_type_id NUMBER;
1501: l_cust_trx_type_id NUMBER;
1502: l_creation_sign VARCHAR2(30);

Line 1648: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1644: return(0);
1645: END Get_Customer_Transaction_Type;
1646:
1647: PROCEDURE Get_Credit_Method_Code
1648: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1649: , x_accting_credit_method_code OUT NOCOPY VARCHAR2
1650: , x_invcing_credit_method_code OUT NOCOPY VARCHAR2
1651: ) IS
1652: l_accting_credit_method_code VARCHAR2(30):= NULL;

Line 1689: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

1685: END Get_Credit_Method_Code;
1686:
1687: -- PTO RFR handling starts here
1688: FUNCTION Is_PTO
1689: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
1690: RETURN BOOLEAN
1691: IS
1692: --
1693: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1868: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

1864: RETURN FALSE;
1865: END Is_RFR;
1866:
1867: FUNCTION Something_To_Invoice
1868: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
1869: RETURN BOOLEAN IS
1870: l_rfr_child_flag VARCHAR2(1);
1871: l_rfr_sibling_flag VARCHAR2(1);
1872: l_rfr_children_tbl Id_Tbl_Type;

Line 1874: l_child_rec OE_Order_Pub.Line_Rec_type;

1870: l_rfr_child_flag VARCHAR2(1);
1871: l_rfr_sibling_flag VARCHAR2(1);
1872: l_rfr_children_tbl Id_Tbl_Type;
1873: l_rfr_sibling_tbl Id_Tbl_Type;
1874: l_child_rec OE_Order_Pub.Line_Rec_type;
1875: l_sibling_rec OE_Order_Pub.Line_Rec_type;
1876: l_ratio NUMBER;
1877: max_to_invoice NUMBER;
1878: qty_to_invoice NUMBER;

Line 1875: l_sibling_rec OE_Order_Pub.Line_Rec_type;

1871: l_rfr_sibling_flag VARCHAR2(1);
1872: l_rfr_children_tbl Id_Tbl_Type;
1873: l_rfr_sibling_tbl Id_Tbl_Type;
1874: l_child_rec OE_Order_Pub.Line_Rec_type;
1875: l_sibling_rec OE_Order_Pub.Line_Rec_type;
1876: l_ratio NUMBER;
1877: max_to_invoice NUMBER;
1878: qty_to_invoice NUMBER;
1879: x_qty_to_invoice NUMBER;

Line 2029: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

2025: END IF;
2026: END Something_To_Invoice;
2027:
2028: PROCEDURE Get_Regular_Qty_To_Invoice
2029: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
2030: , x_regular_qty_to_invoice OUT NOCOPY NUMBER
2031: )
2032: IS
2033: l_overship_invoice_basis VARCHAR2(30);

Line 2154: (p_line_rec IN OE_Order_Pub.Line_Rec_Type

2150: END IF;
2151: END Get_Regular_Qty_To_Invoice;
2152: -- new OUT parameter x_return_code
2153: PROCEDURE Get_Qty_To_Invoice
2154: (p_line_rec IN OE_Order_Pub.Line_Rec_Type
2155: , x_qty_to_invoice OUT NOCOPY NUMBER
2156: , x_result_code OUT NOCOPY VARCHAR2
2157: )
2158: IS

Line 2163: l_line_rec OE_Order_Pub.Line_Rec_Type;

2159: l_rfr_child_flag VARCHAR2(1);
2160: l_rfr_sibling_flag VARCHAR2(1);
2161: l_rfr_children_tbl Id_Tbl_Type;
2162: l_rfr_sibling_tbl Id_Tbl_Type;
2163: l_line_rec OE_Order_Pub.Line_Rec_Type;
2164: l_child_rec OE_Order_Pub.Line_Rec_Type;
2165: l_sibling_rec OE_Order_Pub.Line_Rec_Type;
2166: l_ratio NUMBER;
2167: max_to_invoice NUMBER := 0;

Line 2164: l_child_rec OE_Order_Pub.Line_Rec_Type;

2160: l_rfr_sibling_flag VARCHAR2(1);
2161: l_rfr_children_tbl Id_Tbl_Type;
2162: l_rfr_sibling_tbl Id_Tbl_Type;
2163: l_line_rec OE_Order_Pub.Line_Rec_Type;
2164: l_child_rec OE_Order_Pub.Line_Rec_Type;
2165: l_sibling_rec OE_Order_Pub.Line_Rec_Type;
2166: l_ratio NUMBER;
2167: max_to_invoice NUMBER := 0;
2168: qty_to_invoice NUMBER := 0;

Line 2165: l_sibling_rec OE_Order_Pub.Line_Rec_Type;

2161: l_rfr_children_tbl Id_Tbl_Type;
2162: l_rfr_sibling_tbl Id_Tbl_Type;
2163: l_line_rec OE_Order_Pub.Line_Rec_Type;
2164: l_child_rec OE_Order_Pub.Line_Rec_Type;
2165: l_sibling_rec OE_Order_Pub.Line_Rec_Type;
2166: l_ratio NUMBER;
2167: max_to_invoice NUMBER := 0;
2168: qty_to_invoice NUMBER := 0;
2169: l_child_inventory_item_id NUMBER := 0;

Line 2385: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

2381: END IF;
2382: END Get_Qty_To_Invoice;
2383:
2384: FUNCTION Validate_Required_Attributes
2385: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
2386: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
2387: )
2388: RETURN BOOLEAN
2389: IS

Line 2524: , x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type

2520:
2521: PROCEDURE Query_Line_Scredits
2522: ( p_line_id IN NUMBER
2523: , p_quota_flag IN VARCHAR2
2524: , x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
2525: , x_total_percent OUT NOCOPY NUMBER --FP bug 3872166
2526: ) IS
2527: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2528: CURSOR l_Line_Scredit_csr IS

Line 2527: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2523: , p_quota_flag IN VARCHAR2
2524: , x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
2525: , x_total_percent OUT NOCOPY NUMBER --FP bug 3872166
2526: ) IS
2527: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2528: CURSOR l_Line_Scredit_csr IS
2529: SELECT SC.ATTRIBUTE1
2530: , SC.ATTRIBUTE10
2531: , SC.ATTRIBUTE11

Line 2643: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type

2639:
2640: PROCEDURE Query_Header_Scredits
2641: ( p_header_id IN NUMBER
2642: , p_quota_flag IN VARCHAR2
2643: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
2644: ) IS
2645: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2646: CURSOR l_Header_Scredit_csr IS
2647: SELECT SC.ATTRIBUTE1

Line 2645: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2641: ( p_header_id IN NUMBER
2642: , p_quota_flag IN VARCHAR2
2643: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
2644: ) IS
2645: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2646: CURSOR l_Header_Scredit_csr IS
2647: SELECT SC.ATTRIBUTE1
2648: , SC.ATTRIBUTE10
2649: , SC.ATTRIBUTE11

Line 3399: ( p_line_scredit_rec IN OE_Order_Pub.Line_Scredit_Rec_Type

3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3396: END Insert_Line;
3397:
3398: PROCEDURE Prepare_Salescredit_rec
3399: ( p_line_scredit_rec IN OE_Order_Pub.Line_Scredit_Rec_Type
3400: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
3401: , x_interface_scredit_rec OUT NOCOPY RA_Interface_Scredits_Rec_Type
3402: ) IS
3403: --

Line 3480: ( p_header_scredit_rec IN OE_Order_Pub.Header_Scredit_Rec_Type

3476: END IF;
3477: END Prepare_Salescredit_rec;
3478:
3479: PROCEDURE Prepare_Salescredit_rec
3480: ( p_header_scredit_rec IN OE_Order_Pub.Header_Scredit_Rec_Type
3481: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
3482: , x_interface_scredit_rec OUT NOCOPY RA_Interface_Scredits_Rec_Type
3483: ) IS
3484: --

Line 3836: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

3832: END IF;
3833: END Insert_Salescredit;
3834:
3835: PROCEDURE Interface_SalesCredits
3836: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
3837: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
3838: , x_return_status OUT NOCOPY VARCHAR2
3839: )
3840: IS

Line 3842: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;

3838: , x_return_status OUT NOCOPY VARCHAR2
3839: )
3840: IS
3841: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
3842: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
3843: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
3844: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
3845: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
3846: l_line_credits NUMBER := 0 ;

Line 3843: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;

3839: )
3840: IS
3841: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
3842: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
3843: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
3844: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
3845: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
3846: l_line_credits NUMBER := 0 ;
3847: l_header_credits NUMBER := 0 ;

Line 3844: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;

3840: IS
3841: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
3842: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
3843: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
3844: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
3845: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
3846: l_line_credits NUMBER := 0 ;
3847: l_header_credits NUMBER := 0 ;
3848: Insert_Header_Scredits_flag VARCHAR2(1);

Line 3845: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;

3841: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
3842: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
3843: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
3844: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
3845: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
3846: l_line_credits NUMBER := 0 ;
3847: l_header_credits NUMBER := 0 ;
3848: Insert_Header_Scredits_flag VARCHAR2(1);
3849: service_grand_parent_id NUMBER := 0;

Line 4064: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

4060: END IF;
4061: END Interface_SalesCredits;
4062:
4063: PROCEDURE Interface_scredits_for_freight
4064: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
4065: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4066: , p_line_level_charge IN VARCHAR2
4067: ) IS
4068: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 4068: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4064: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
4065: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4066: , p_line_level_charge IN VARCHAR2
4067: ) IS
4068: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4069: l_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4070: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4071: l_cr_srep_for_freight VARCHAR2(30); --moac moving the initialization to the body
4072: l_return_status VARCHAR2(30);

Line 4069: l_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

4065: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4066: , p_line_level_charge IN VARCHAR2
4067: ) IS
4068: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4069: l_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4070: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4071: l_cr_srep_for_freight VARCHAR2(30); --moac moving the initialization to the body
4072: l_return_status VARCHAR2(30);
4073: --

Line 4129: FUNCTION Line_Rejected(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type) RETURN BOOLEAN IS

4125: );
4126: END IF;
4127: END Interface_scredits_for_freight;
4128: --Customer Acceptance
4129: FUNCTION Line_Rejected(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type) RETURN BOOLEAN IS
4130: BEGIN
4131:
4132: IF p_line_rec.line_category_code= 'ORDER' THEN
4133: IF (p_line_rec.flow_status_code='PRE-BILLING_ACCEPTANCE' OR

Line 4157: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4153: END IF;
4154: END Line_Rejected;
4155:
4156: PROCEDURE Prepare_Contingency_rec
4157: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4158: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4159: , x_interface_conts_rec IN OUT NOCOPY RA_Interface_Conts_Rec_Type
4160: ) IS
4161: l_revrec_event_code VARCHAR2(30);

Line 4317: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4313:
4314: --This procedure interfaces the contingency record by preparing it and inserting into AR_INTERFACE_CONTS_ALL
4315:
4316: PROCEDURE Interface_Contingencies
4317: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4318: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4319: , x_return_status OUT NOCOPY VARCHAR2
4320: )
4321: IS

Line 4377: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4373: END Interface_Contingencies;
4374: --customer acceptance
4375: -- 3685479 Changed the signature of the procedure with extra parameter p_adjustments_tbl
4376: PROCEDURE Get_Rounding_Diff
4377: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4378: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4379: , p_adjustments_tbl IN OE_Header_Adj_Util.Line_Adjustments_Tab_Type
4380: , x_rounding_diff OUT NOCOPY NUMBER
4381: ) IS

Line 4384: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4380: , x_rounding_diff OUT NOCOPY NUMBER
4381: ) IS
4382: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4383: l_adjustments_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4384: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4385: l_line_tot_amount NUMBER;
4386: l_ind_line_tot NUMBER;
4387: l_ind_disc_tot NUMBER;
4388: l_comb_ind_line_tots NUMBER;

Line 4464: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4460: END IF;
4461: END Get_Rounding_Diff;
4462:
4463: PROCEDURE Interface_Detail_Discounts
4464: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4465: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4466: , x_return_status OUT NOCOPY VARCHAR2
4467: ) IS
4468: l_discounts_rec RA_Interface_Lines_Rec_Type;

Line 4471: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4467: ) IS
4468: l_discounts_rec RA_Interface_Lines_Rec_Type;
4469: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4470: l_adjustments_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4471: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4472: l_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4473: l_return_status VARCHAR2(30);
4474: l_rounding_diff NUMBER;
4475: l_rounding_diff_applied VARCHAR2(1) :='N';

Line 4472: l_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

4468: l_discounts_rec RA_Interface_Lines_Rec_Type;
4469: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4470: l_adjustments_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4471: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4472: l_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4473: l_return_status VARCHAR2(30);
4474: l_rounding_diff NUMBER;
4475: l_rounding_diff_applied VARCHAR2(1) :='N';
4476: l_reference_line_id NUMBER;

Line 4720: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4716: , p_adjusted_amount IN NUMBER
4717: , p_invoiced_amount IN NUMBER
4718: , x_return_status OUT NOCOPY VARCHAR2
4719: ) IS
4720: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4721: l_Old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4722: l_return_status VARCHAR2(30);
4723: l_notify_index NUMBER; -- jolin
4724:

Line 4721: l_Old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4717: , p_invoiced_amount IN NUMBER
4718: , x_return_status OUT NOCOPY VARCHAR2
4719: ) IS
4720: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4721: l_Old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4722: l_return_status VARCHAR2(30);
4723: l_notify_index NUMBER; -- jolin
4724:
4725: --

Line 4869: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4865: END IF;
4866: END Update_Invoiced_Flag;
4867:
4868: PROCEDURE Prepare_Freight_Charges_Rec
4869: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4870: , p_x_charges_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
4871: ) IS
4872: -- l_vat_flag VARCHAR2(1);
4873: l_freight_as_line VARCHAR2(1);

Line 5111: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5107: END IF;
5108: END Prepare_Freight_Charges_Rec;
5109:
5110: PROCEDURE Interface_Freight_Charges
5111: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5112: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
5113: , x_return_status OUT NOCOPY VARCHAR2
5114: ) IS
5115: l_charges_rec RA_Interface_Lines_Rec_Type;

Line 5117: l_line_rec OE_Order_Pub.Line_Rec_Type;

5113: , x_return_status OUT NOCOPY VARCHAR2
5114: ) IS
5115: l_charges_rec RA_Interface_Lines_Rec_Type;
5116: l_return_status VARCHAR2(30);
5117: l_line_rec OE_Order_Pub.Line_Rec_Type;
5118: config_line_id NUMBER;
5119: l_invoiced_amount NUMBER;
5120: l_charge_amount NUMBER;
5121: l_count1 NUMBER := 0;

Line 5624: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5620: END IF;
5621: END Interface_Freight_Charges;
5622:
5623: PROCEDURE Prepare_Interface_Line_Rec
5624: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5625: , p_header_rec IN OE_Order_Pub.Header_Rec_Type
5626: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
5627: , x_result_code OUT NOCOPY VARCHAR2
5628: ) IS

Line 5625: , p_header_rec IN OE_Order_Pub.Header_Rec_Type

5621: END Interface_Freight_Charges;
5622:
5623: PROCEDURE Prepare_Interface_Line_Rec
5624: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5625: , p_header_rec IN OE_Order_Pub.Header_Rec_Type
5626: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
5627: , x_result_code OUT NOCOPY VARCHAR2
5628: ) IS
5629: l_creation_sign VARCHAR2(30);

Line 7451: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

7447: END IF;
7448: END Prepare_Interface_Line_Rec;
7449:
7450: PROCEDURE Update_Invoice_Attributes
7451: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
7452: , p_interface_line_rec IN RA_interface_Lines_Rec_Type
7453: , p_invoice_interface_status IN VARCHAR2
7454: , x_return_status OUT NOCOPY VARCHAR2
7455: ) IS

Line 7457: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;

7453: , p_invoice_interface_status IN VARCHAR2
7454: , x_return_status OUT NOCOPY VARCHAR2
7455: ) IS
7456: l_invoiced_quantity NUMBER;
7457: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7458: l_Old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7459: l_return_status VARCHAR2(30);
7460: l_flow_status_code VARCHAR2(30);
7461: err_msg VARCHAR2(240);

Line 7458: l_Old_Line_tbl OE_Order_PUB.Line_Tbl_Type;

7454: , x_return_status OUT NOCOPY VARCHAR2
7455: ) IS
7456: l_invoiced_quantity NUMBER;
7457: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7458: l_Old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7459: l_return_status VARCHAR2(30);
7460: l_flow_status_code VARCHAR2(30);
7461: err_msg VARCHAR2(240);
7462: l_notify_index NUMBER; -- jolin

Line 7964: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

7960: END IF;
7961: END Update_Numbers;
7962:
7963: PROCEDURE Interface_Single_Line
7964: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
7965: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
7966: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
7967: , x_return_status OUT NOCOPY VARCHAR2
7968: , x_result_out OUT NOCOPY VARCHAR2

Line 7965: , p_header_rec IN OE_Order_PUB.Header_Rec_Type

7961: END Update_Numbers;
7962:
7963: PROCEDURE Interface_Single_Line
7964: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
7965: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
7966: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
7967: , x_return_status OUT NOCOPY VARCHAR2
7968: , x_result_out OUT NOCOPY VARCHAR2
7969: ) IS

Line 7985: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;

7981: WHERE (Line.line_id = p_line_rec.link_to_line_id)
7982: AND invoice_interface_status_code = 'RFR-PENDING';
7983:
7984: l_pending_line_id NUMBER;
7985: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;
7986:
7987: l_result_code VARCHAR2(240);
7988: l_return_status VARCHAR2(30);
7989: --Customer Acceptance

Line 8429: l_line_rec OE_Order_Pub.Line_Rec_Type;

8425: , x_result_out OUT NOCOPY VARCHAR2
8426: , x_return_status OUT NOCOPY VARCHAR2
8427: ) IS
8428: l_interface_line_rec RA_Interface_Lines_Rec_Type;
8429: l_line_rec OE_Order_Pub.Line_Rec_Type;
8430: l_header_rec OE_Order_Pub.Header_Rec_Type;
8431: l_dummy VARCHAR2(240);
8432: l_delivery_line_id NUMBER := NULL;
8433: l_line_delivery_id NUMBER := NULL;

Line 8430: l_header_rec OE_Order_Pub.Header_Rec_Type;

8426: , x_return_status OUT NOCOPY VARCHAR2
8427: ) IS
8428: l_interface_line_rec RA_Interface_Lines_Rec_Type;
8429: l_line_rec OE_Order_Pub.Line_Rec_Type;
8430: l_header_rec OE_Order_Pub.Header_Rec_Type;
8431: l_dummy VARCHAR2(240);
8432: l_delivery_line_id NUMBER := NULL;
8433: l_line_delivery_id NUMBER := NULL;
8434: l_line_id NUMBER;

Line 8438: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;

8434: l_line_id NUMBER;
8435: l_interface_status_code VARCHAR2(30);
8436: l_old_interface_status_code VARCHAR2(30);
8437: l_pending_line_id NUMBER;
8438: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;
8439: del_line_ready_flag VARCHAR2(1) := NULL;
8440: interface_this_line VARCHAR2(1) := 'Y';
8441: l_result_code VARCHAR2(240);
8442: generate_invoice_number VARCHAR2(1) := 'N';

Line 8453: l_invoice_rec OE_Order_Pub.Line_Rec_Type;

8449: /* START Enhancement Request# 1915736 */
8450: l_freight_count NUMBER;
8451: /* END Enhancement Request# 1915736 */
8452: -- Fix for bug 2224248
8453: l_invoice_rec OE_Order_Pub.Line_Rec_Type;
8454: --Customer Acceptance
8455: l_line_invoiceable BOOLEAN;
8456: l_line_rejected BOOLEAN;
8457: