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: --13724397 Start
184: ,x_return_status OUT NOCOPY VARCHAR2
185: --13724397 End
186: )

Line 189: l_line_rec OE_Order_Pub.Line_Rec_Type;

185: --13724397 End
186: )
187: IS
188: l_return_status VARCHAR2(1);
189: l_line_rec OE_Order_Pub.Line_Rec_Type;
190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
191: BEGIN
192:
193: IF l_debug_level > 0 THEN

Line 249: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type,

245: -- 8319535 start
246: /*9040537
247: PROCEDURE Update_Credit_Invoice
248: (
249: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type,
250: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
251: )
252: IS
253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 250: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type

246: /*9040537
247: PROCEDURE Update_Credit_Invoice
248: (
249: p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type,
250: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
251: )
252: IS
253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
254: l_defaulting_invoice_line_id NUMBER := NULL;

Line 294: (p_line_rec IN OE_Order_Pub.Line_Rec_Type

290: 9040537*/
291: -- 8319535 end
292:
293: FUNCTION Return_Line
294: (p_line_rec IN OE_Order_Pub.Line_Rec_Type
295: )
296: RETURN BOOLEAN
297: IS
298: --

Line 342: l_header_rec Oe_Order_Pub.Header_Rec_Type;

338: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
339:
340: -- 8541809: Start
341: l_item_key_sso NUMBER;
342: l_header_rec Oe_Order_Pub.Header_Rec_Type;
343: l_line_rec Oe_Order_Pub.Line_Rec_Type;
344: l_ret_stat Varchar2(30);
345: -- 8541809: End
346: l_existing_fsc oe_order_lines_all.flow_status_code%type; -- Bug 13870263

Line 343: l_line_rec Oe_Order_Pub.Line_Rec_Type;

339:
340: -- 8541809: Start
341: l_item_key_sso NUMBER;
342: l_header_rec Oe_Order_Pub.Header_Rec_Type;
343: l_line_rec Oe_Order_Pub.Line_Rec_Type;
344: l_ret_stat Varchar2(30);
345: -- 8541809: End
346: l_existing_fsc oe_order_lines_all.flow_status_code%type; -- Bug 13870263
347: --

Line 461: l_header_rec Oe_Order_Pub.Header_Rec_Type; -- 8541809

457: --
458: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
459: --
460: l_item_key_sso NUMBER; -- 8541809
461: l_header_rec Oe_Order_Pub.Header_Rec_Type; -- 8541809
462: --
463: Begin
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'Inside Update Header Flow Status');

Line 513: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

509: End Update_header_flow_status;
510:
511:
512: FUNCTION Shipping_info_Available
513: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
514: )
515: RETURN BOOLEAN
516: IS
517: l_count NUMBER;

Line 571: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

567: END IF;
568: END Shipping_info_Available;
569:
570: FUNCTION Line_Invoiceable
571: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
572: )
573: RETURN BOOLEAN
574: IS
575: l_invoiceable_item_flag VARCHAR2(1);

Line 823: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

819: END IF;
820: END Line_Invoiceable;
821:
822: PROCEDURE Check_Invoicing_Holds
823: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
824: , p_itemtype IN VARCHAR2
825: , x_return_status OUT NOCOPY VARCHAR2
826: )
827: IS

Line 906: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

902: END IF;
903: END Check_Invoicing_Holds;
904:
905: FUNCTION Show_Detail_Discounts
906: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
907: ) RETURN BOOLEAN IS
908: l_price_adj_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
909: --
910: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1008: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1004: END IF;
1005: END Rounded_Amount;
1006:
1007: PROCEDURE Return_Credit_Info
1008: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1009: , x_credit_memo_type_id OUT NOCOPY NUMBER
1010: , x_credit_creation_sign OUT NOCOPY VARCHAR2
1011: )
1012: IS

Line 1220: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1216: x_credit_creation_sign := NULL;
1217: END Return_Credit_Info;
1218:
1219: FUNCTION Get_Credit_Creation_Sign
1220: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1221: , p_cust_trx_type_id IN NUMBER)
1222: RETURN VARCHAR2 IS
1223: l_creation_sign VARCHAR2(30):= NULL;
1224: --

Line 1252: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1248: RETURN(NULL);
1249: END Get_Credit_Creation_Sign;
1250:
1251: PROCEDURE Get_Commitment_Info
1252: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1253: , x_commitment_applied OUT NOCOPY NUMBER
1254: , x_commitment_interfaced OUT NOCOPY NUMBER)
1255: IS
1256: --

Line 1301: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1297: x_commitment_interfaced := NULL;
1298: END Get_Commitment_Info;
1299:
1300: PROCEDURE Get_Item_Description
1301: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1302: , x_item_description OUT NOCOPY VARCHAR2
1303: ) IS
1304: -- bug#12645586, l_organization_id NUMBER := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
1305: l_organization_id NUMBER := nvl(p_line_rec.ship_from_org_id,

Line 1386: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1382: NULL;
1383: END Get_Item_Description;
1384:
1385: PROCEDURE Get_Service_Item_Description
1386: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1387: , x_item_description OUT NOCOPY VARCHAR2
1388: ) IS
1389: l_line_rec OE_Order_Pub.Line_Rec_Type;
1390: l_order_line_id NUMBER;

Line 1389: l_line_rec OE_Order_Pub.Line_Rec_Type;

1385: PROCEDURE Get_Service_Item_Description
1386: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1387: , x_item_description OUT NOCOPY VARCHAR2
1388: ) IS
1389: l_line_rec OE_Order_Pub.Line_Rec_Type;
1390: l_order_line_id NUMBER;
1391: l_return_status VARCHAR2(1);
1392: l_service_reference_line_id NUMBER;
1393: l_service_item_desc VARCHAR2(240);

Line 1550: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

1546: NULL;
1547: END Get_Service_Item_Description;
1548:
1549: FUNCTION Get_Overship_Invoice_Basis
1550: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
1551: RETURN VARCHAR2
1552: IS
1553: l_overship_invoice_basis VARCHAR2(30):= NULL;
1554: --

Line 1604: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1600:
1601: END Get_Overship_Invoice_Basis;
1602:
1603: FUNCTION Get_Invoice_Source
1604: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1605: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
1606: )
1607: RETURN VARCHAR2
1608: IS

Line 1687: l_line_rec OE_Order_Pub.Line_Rec_Type;

1683: ) RETURN NUMBER IS
1684: l_inv_cust_trx_type_id NUMBER;
1685: l_cust_trx_type_id NUMBER;
1686: l_creation_sign VARCHAR2(30);
1687: l_line_rec OE_Order_Pub.Line_Rec_Type;
1688: --
1689: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1690: --
1691: BEGIN

Line 1715: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1711: return(0);
1712: END Get_Customer_Transaction_Type;
1713:
1714: FUNCTION Get_Customer_Transaction_Type
1715: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1716: ) RETURN NUMBER IS
1717: l_inv_cust_trx_type_id NUMBER;
1718: l_cust_trx_type_id NUMBER;
1719: l_creation_sign VARCHAR2(30);

Line 1865: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

1861: return(0);
1862: END Get_Customer_Transaction_Type;
1863:
1864: PROCEDURE Get_Credit_Method_Code
1865: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
1866: , x_accting_credit_method_code OUT NOCOPY VARCHAR2
1867: , x_invcing_credit_method_code OUT NOCOPY VARCHAR2
1868: ) IS
1869: l_accting_credit_method_code VARCHAR2(30):= NULL;

Line 1906: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

1902: END Get_Credit_Method_Code;
1903:
1904: -- PTO RFR handling starts here
1905: FUNCTION Is_PTO
1906: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
1907: RETURN BOOLEAN
1908: IS
1909: --
1910: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2085: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)

2081: RETURN FALSE;
2082: END Is_RFR;
2083:
2084: FUNCTION Something_To_Invoice
2085: (p_line_rec IN OE_Order_Pub.Line_Rec_Type)
2086: RETURN BOOLEAN IS
2087: l_rfr_child_flag VARCHAR2(1);
2088: l_rfr_sibling_flag VARCHAR2(1);
2089: l_rfr_children_tbl Id_Tbl_Type;

Line 2091: l_child_rec OE_Order_Pub.Line_Rec_type;

2087: l_rfr_child_flag VARCHAR2(1);
2088: l_rfr_sibling_flag VARCHAR2(1);
2089: l_rfr_children_tbl Id_Tbl_Type;
2090: l_rfr_sibling_tbl Id_Tbl_Type;
2091: l_child_rec OE_Order_Pub.Line_Rec_type;
2092: l_sibling_rec OE_Order_Pub.Line_Rec_type;
2093: l_ratio NUMBER;
2094: max_to_invoice NUMBER;
2095: qty_to_invoice NUMBER;

Line 2092: l_sibling_rec OE_Order_Pub.Line_Rec_type;

2088: l_rfr_sibling_flag VARCHAR2(1);
2089: l_rfr_children_tbl Id_Tbl_Type;
2090: l_rfr_sibling_tbl Id_Tbl_Type;
2091: l_child_rec OE_Order_Pub.Line_Rec_type;
2092: l_sibling_rec OE_Order_Pub.Line_Rec_type;
2093: l_ratio NUMBER;
2094: max_to_invoice NUMBER;
2095: qty_to_invoice NUMBER;
2096: x_qty_to_invoice NUMBER;

Line 2246: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

2242: END IF;
2243: END Something_To_Invoice;
2244:
2245: PROCEDURE Get_Regular_Qty_To_Invoice
2246: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
2247: , x_regular_qty_to_invoice OUT NOCOPY NUMBER
2248: )
2249: IS
2250: l_overship_invoice_basis VARCHAR2(30);

Line 2371: (p_line_rec IN OE_Order_Pub.Line_Rec_Type

2367: END IF;
2368: END Get_Regular_Qty_To_Invoice;
2369: -- new OUT parameter x_return_code
2370: PROCEDURE Get_Qty_To_Invoice
2371: (p_line_rec IN OE_Order_Pub.Line_Rec_Type
2372: , x_qty_to_invoice OUT NOCOPY NUMBER
2373: , x_result_code OUT NOCOPY VARCHAR2
2374: )
2375: IS

Line 2380: l_line_rec OE_Order_Pub.Line_Rec_Type;

2376: l_rfr_child_flag VARCHAR2(1);
2377: l_rfr_sibling_flag VARCHAR2(1);
2378: l_rfr_children_tbl Id_Tbl_Type;
2379: l_rfr_sibling_tbl Id_Tbl_Type;
2380: l_line_rec OE_Order_Pub.Line_Rec_Type;
2381: l_child_rec OE_Order_Pub.Line_Rec_Type;
2382: l_sibling_rec OE_Order_Pub.Line_Rec_Type;
2383: l_ratio NUMBER;
2384: max_to_invoice NUMBER := 0;

Line 2381: l_child_rec OE_Order_Pub.Line_Rec_Type;

2377: l_rfr_sibling_flag VARCHAR2(1);
2378: l_rfr_children_tbl Id_Tbl_Type;
2379: l_rfr_sibling_tbl Id_Tbl_Type;
2380: l_line_rec OE_Order_Pub.Line_Rec_Type;
2381: l_child_rec OE_Order_Pub.Line_Rec_Type;
2382: l_sibling_rec OE_Order_Pub.Line_Rec_Type;
2383: l_ratio NUMBER;
2384: max_to_invoice NUMBER := 0;
2385: qty_to_invoice NUMBER := 0;

Line 2382: l_sibling_rec OE_Order_Pub.Line_Rec_Type;

2378: l_rfr_children_tbl Id_Tbl_Type;
2379: l_rfr_sibling_tbl Id_Tbl_Type;
2380: l_line_rec OE_Order_Pub.Line_Rec_Type;
2381: l_child_rec OE_Order_Pub.Line_Rec_Type;
2382: l_sibling_rec OE_Order_Pub.Line_Rec_Type;
2383: l_ratio NUMBER;
2384: max_to_invoice NUMBER := 0;
2385: qty_to_invoice NUMBER := 0;
2386: l_child_inventory_item_id NUMBER := 0;

Line 2602: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

2598: END IF;
2599: END Get_Qty_To_Invoice;
2600:
2601: FUNCTION Validate_Required_Attributes
2602: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
2603: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
2604: )
2605: RETURN BOOLEAN
2606: IS

Line 2751: , x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type

2747:
2748: PROCEDURE Query_Line_Scredits
2749: ( p_line_id IN NUMBER
2750: , p_quota_flag IN VARCHAR2
2751: , x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
2752: , x_total_percent OUT NOCOPY NUMBER --FP bug 3872166
2753: ) IS
2754: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2755: CURSOR l_Line_Scredit_csr IS

Line 2754: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2750: , p_quota_flag IN VARCHAR2
2751: , x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
2752: , x_total_percent OUT NOCOPY NUMBER --FP bug 3872166
2753: ) IS
2754: l_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2755: CURSOR l_Line_Scredit_csr IS
2756: SELECT SC.ATTRIBUTE1
2757: , SC.ATTRIBUTE10
2758: , SC.ATTRIBUTE11

Line 2870: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type

2866:
2867: PROCEDURE Query_Header_Scredits
2868: ( p_header_id IN NUMBER
2869: , p_quota_flag IN VARCHAR2
2870: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
2871: ) IS
2872: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2873: CURSOR l_Header_Scredit_csr IS
2874: SELECT SC.ATTRIBUTE1

Line 2872: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2868: ( p_header_id IN NUMBER
2869: , p_quota_flag IN VARCHAR2
2870: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
2871: ) IS
2872: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2873: CURSOR l_Header_Scredit_csr IS
2874: SELECT SC.ATTRIBUTE1
2875: , SC.ATTRIBUTE10
2876: , SC.ATTRIBUTE11

Line 3628: ( p_line_scredit_rec IN OE_Order_Pub.Line_Scredit_Rec_Type

3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: END Insert_Line;
3626:
3627: PROCEDURE Prepare_Salescredit_rec
3628: ( p_line_scredit_rec IN OE_Order_Pub.Line_Scredit_Rec_Type
3629: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
3630: , x_interface_scredit_rec OUT NOCOPY RA_Interface_Scredits_Rec_Type
3631: ) IS
3632: --

Line 3709: ( p_header_scredit_rec IN OE_Order_Pub.Header_Scredit_Rec_Type

3705: END IF;
3706: END Prepare_Salescredit_rec;
3707:
3708: PROCEDURE Prepare_Salescredit_rec
3709: ( p_header_scredit_rec IN OE_Order_Pub.Header_Scredit_Rec_Type
3710: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
3711: , x_interface_scredit_rec OUT NOCOPY RA_Interface_Scredits_Rec_Type
3712: ) IS
3713: --

Line 4065: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4061: END IF;
4062: END Insert_Salescredit;
4063:
4064: PROCEDURE Interface_SalesCredits
4065: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4066: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4067: , x_return_status OUT NOCOPY VARCHAR2
4068: )
4069: IS

Line 4071: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;

4067: , x_return_status OUT NOCOPY VARCHAR2
4068: )
4069: IS
4070: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4071: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
4072: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
4073: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
4074: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
4075: l_line_credits NUMBER := 0 ;

Line 4072: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;

4068: )
4069: IS
4070: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4071: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
4072: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
4073: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
4074: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
4075: l_line_credits NUMBER := 0 ;
4076: l_header_credits NUMBER := 0 ;

Line 4073: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;

4069: IS
4070: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4071: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
4072: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
4073: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
4074: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
4075: l_line_credits NUMBER := 0 ;
4076: l_header_credits NUMBER := 0 ;
4077: Insert_Header_Scredits_flag VARCHAR2(1);

Line 4074: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;

4070: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4071: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
4072: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
4073: l_line_scredit_rec OE_Order_Pub.Line_Scredit_Rec_Type;
4074: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
4075: l_line_credits NUMBER := 0 ;
4076: l_header_credits NUMBER := 0 ;
4077: Insert_Header_Scredits_flag VARCHAR2(1);
4078: service_grand_parent_id NUMBER := 0;

Line 4293: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

4289: END IF;
4290: END Interface_SalesCredits;
4291:
4292: PROCEDURE Interface_scredits_for_freight
4293: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
4294: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4295: , p_line_level_charge IN VARCHAR2
4296: ) IS
4297: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 4297: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4293: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
4294: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4295: , p_line_level_charge IN VARCHAR2
4296: ) IS
4297: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4298: l_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4299: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4300: l_cr_srep_for_freight VARCHAR2(30); --moac moving the initialization to the body
4301: l_return_status VARCHAR2(30);

Line 4298: l_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

4294: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4295: , p_line_level_charge IN VARCHAR2
4296: ) IS
4297: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4298: l_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4299: l_interface_scredit_rec RA_Interface_Scredits_Rec_Type;
4300: l_cr_srep_for_freight VARCHAR2(30); --moac moving the initialization to the body
4301: l_return_status VARCHAR2(30);
4302: --

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

4354: );
4355: END IF;
4356: END Interface_scredits_for_freight;
4357: --Customer Acceptance
4358: FUNCTION Line_Rejected(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type) RETURN BOOLEAN IS
4359: BEGIN
4360:
4361: IF p_line_rec.line_category_code= 'ORDER' THEN
4362: IF (p_line_rec.flow_status_code='PRE-BILLING_ACCEPTANCE' OR

Line 4386: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4382: END IF;
4383: END Line_Rejected;
4384:
4385: PROCEDURE Prepare_Contingency_rec
4386: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4387: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4388: , x_interface_conts_rec IN OUT NOCOPY RA_Interface_Conts_Rec_Type
4389: ) IS
4390: l_revrec_event_code VARCHAR2(30);

Line 4546: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4542:
4543: --This procedure interfaces the contingency record by preparing it and inserting into AR_INTERFACE_CONTS_ALL
4544:
4545: PROCEDURE Interface_Contingencies
4546: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4547: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4548: , x_return_status OUT NOCOPY VARCHAR2
4549: )
4550: IS

Line 4606: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4602: END Interface_Contingencies;
4603: --customer acceptance
4604: -- 3685479 Changed the signature of the procedure with extra parameter p_adjustments_tbl
4605: PROCEDURE Get_Rounding_Diff
4606: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4607: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4608: , p_adjustments_tbl IN OE_Header_Adj_Util.Line_Adjustments_Tab_Type
4609: , x_rounding_diff OUT NOCOPY NUMBER
4610: ) IS

Line 4613: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4609: , x_rounding_diff OUT NOCOPY NUMBER
4610: ) IS
4611: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4612: l_adjustments_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4613: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4614: l_line_tot_amount NUMBER;
4615: l_ind_line_tot NUMBER;
4616: l_ind_disc_tot NUMBER;
4617: l_comb_ind_line_tots NUMBER;

Line 4695: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

4691: END IF;
4692: END Get_Rounding_Diff;
4693:
4694: PROCEDURE Interface_Detail_Discounts
4695: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
4696: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
4697: , x_return_status OUT NOCOPY VARCHAR2
4698: ) IS
4699: l_discounts_rec RA_Interface_Lines_Rec_Type;

Line 4702: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4698: ) IS
4699: l_discounts_rec RA_Interface_Lines_Rec_Type;
4700: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4701: l_adjustments_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4702: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4703: l_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4704: l_return_status VARCHAR2(30);
4705: l_rounding_diff NUMBER;
4706: l_rounding_diff_applied VARCHAR2(1) :='N';

Line 4703: l_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

4699: l_discounts_rec RA_Interface_Lines_Rec_Type;
4700: l_adjustments_tbl OE_Header_Adj_Util.Line_Adjustments_Tab_Type;
4701: l_adjustments_rec OE_Header_Adj_Util.Line_Adjustments_Rec_Type;
4702: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4703: l_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4704: l_return_status VARCHAR2(30);
4705: l_rounding_diff NUMBER;
4706: l_rounding_diff_applied VARCHAR2(1) :='N';
4707: l_reference_line_id NUMBER;

Line 4951: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4947: , p_adjusted_amount IN NUMBER
4948: , p_invoiced_amount IN NUMBER
4949: , x_return_status OUT NOCOPY VARCHAR2
4950: ) IS
4951: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4952: l_Old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4953: l_return_status VARCHAR2(30);
4954: l_notify_index NUMBER; -- jolin
4955:

Line 4952: l_Old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4948: , p_invoiced_amount IN NUMBER
4949: , x_return_status OUT NOCOPY VARCHAR2
4950: ) IS
4951: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4952: l_Old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4953: l_return_status VARCHAR2(30);
4954: l_notify_index NUMBER; -- jolin
4955:
4956: --

Line 5100: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5096: END IF;
5097: END Update_Invoiced_Flag;
5098:
5099: PROCEDURE Prepare_Freight_Charges_Rec
5100: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5101: , p_x_charges_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
5102: ) IS
5103: -- l_vat_flag VARCHAR2(1);
5104: l_freight_as_line VARCHAR2(1);

Line 5355: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5351: END IF;
5352: END Prepare_Freight_Charges_Rec;
5353:
5354: PROCEDURE Interface_Freight_Charges
5355: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5356: , p_interface_line_rec IN RA_Interface_Lines_Rec_Type
5357: , x_return_status OUT NOCOPY VARCHAR2
5358: ) IS
5359: l_charges_rec RA_Interface_Lines_Rec_Type;

Line 5361: l_line_rec OE_Order_Pub.Line_Rec_Type;

5357: , x_return_status OUT NOCOPY VARCHAR2
5358: ) IS
5359: l_charges_rec RA_Interface_Lines_Rec_Type;
5360: l_return_status VARCHAR2(30);
5361: l_line_rec OE_Order_Pub.Line_Rec_Type;
5362: config_line_id NUMBER;
5363: l_invoiced_amount NUMBER;
5364: l_charge_amount NUMBER;
5365: l_count1 NUMBER := 0;

Line 5868: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

5864: END IF;
5865: END Interface_Freight_Charges;
5866:
5867: PROCEDURE Prepare_Interface_Line_Rec
5868: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5869: , p_header_rec IN OE_Order_Pub.Header_Rec_Type
5870: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
5871: , x_result_code OUT NOCOPY VARCHAR2
5872: ) IS

Line 5869: , p_header_rec IN OE_Order_Pub.Header_Rec_Type

5865: END Interface_Freight_Charges;
5866:
5867: PROCEDURE Prepare_Interface_Line_Rec
5868: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
5869: , p_header_rec IN OE_Order_Pub.Header_Rec_Type
5870: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
5871: , x_result_code OUT NOCOPY VARCHAR2
5872: ) IS
5873: l_creation_sign VARCHAR2(30);

Line 7739: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

7735: END IF;
7736: END Prepare_Interface_Line_Rec;
7737:
7738: PROCEDURE Update_Invoice_Attributes
7739: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
7740: , p_interface_line_rec IN RA_interface_Lines_Rec_Type
7741: , p_invoice_interface_status IN VARCHAR2
7742: , x_return_status OUT NOCOPY VARCHAR2
7743: ) IS

Line 7745: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;

7741: , p_invoice_interface_status IN VARCHAR2
7742: , x_return_status OUT NOCOPY VARCHAR2
7743: ) IS
7744: l_invoiced_quantity NUMBER;
7745: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7746: l_Old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7747: l_return_status VARCHAR2(30);
7748: l_flow_status_code VARCHAR2(30);
7749: err_msg VARCHAR2(240);

Line 7746: l_Old_Line_tbl OE_Order_PUB.Line_Tbl_Type;

7742: , x_return_status OUT NOCOPY VARCHAR2
7743: ) IS
7744: l_invoiced_quantity NUMBER;
7745: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7746: l_Old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
7747: l_return_status VARCHAR2(30);
7748: l_flow_status_code VARCHAR2(30);
7749: err_msg VARCHAR2(240);
7750: l_notify_index NUMBER; -- jolin

Line 7758: l_header_rec Oe_Order_Pub.Header_Rec_Type;

7754: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7755: --
7756: -- 8541809: Start
7757: l_item_key_sso NUMBER;
7758: l_header_rec Oe_Order_Pub.Header_Rec_Type;
7759: l_ret_stat Varchar2(30);
7760: -- 8541809: End
7761: BEGIN
7762: IF l_debug_level > 0 THEN

Line 8348: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

8344: END IF;
8345: END Update_Numbers;
8346:
8347: PROCEDURE Interface_Single_Line
8348: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
8349: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
8350: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
8351: , x_return_status OUT NOCOPY VARCHAR2
8352: , x_result_out OUT NOCOPY VARCHAR2

Line 8349: , p_header_rec IN OE_Order_PUB.Header_Rec_Type

8345: END Update_Numbers;
8346:
8347: PROCEDURE Interface_Single_Line
8348: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
8349: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
8350: , p_x_interface_line_rec IN OUT NOCOPY RA_Interface_Lines_Rec_Type
8351: , x_return_status OUT NOCOPY VARCHAR2
8352: , x_result_out OUT NOCOPY VARCHAR2
8353: ) IS

Line 8369: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;

8365: WHERE (Line.line_id = p_line_rec.link_to_line_id)
8366: AND invoice_interface_status_code = 'RFR-PENDING';
8367:
8368: l_pending_line_id NUMBER;
8369: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;
8370:
8371: l_result_code VARCHAR2(240);
8372: l_return_status VARCHAR2(30);
8373: --Customer Acceptance

Line 8843: l_line_rec OE_Order_Pub.Line_Rec_Type;

8839: , x_result_out OUT NOCOPY VARCHAR2
8840: , x_return_status OUT NOCOPY VARCHAR2
8841: ) IS
8842: l_interface_line_rec RA_Interface_Lines_Rec_Type;
8843: l_line_rec OE_Order_Pub.Line_Rec_Type;
8844: l_header_rec OE_Order_Pub.Header_Rec_Type;
8845: l_dummy VARCHAR2(240);
8846: l_delivery_line_id NUMBER := NULL;
8847: l_line_delivery_id NUMBER := NULL;

Line 8844: l_header_rec OE_Order_Pub.Header_Rec_Type;

8840: , x_return_status OUT NOCOPY VARCHAR2
8841: ) IS
8842: l_interface_line_rec RA_Interface_Lines_Rec_Type;
8843: l_line_rec OE_Order_Pub.Line_Rec_Type;
8844: l_header_rec OE_Order_Pub.Header_Rec_Type;
8845: l_dummy VARCHAR2(240);
8846: l_delivery_line_id NUMBER := NULL;
8847: l_line_delivery_id NUMBER := NULL;
8848: l_line_id NUMBER;

Line 8852: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;

8848: l_line_id NUMBER;
8849: l_interface_status_code VARCHAR2(30);
8850: l_old_interface_status_code VARCHAR2(30);
8851: l_pending_line_id NUMBER;
8852: l_pending_line_rec OE_Order_Pub.Line_Rec_Type;
8853: del_line_ready_flag VARCHAR2(1) := NULL;
8854: interface_this_line VARCHAR2(1) := 'Y';
8855: l_result_code VARCHAR2(240);
8856: generate_invoice_number VARCHAR2(1) := 'N';

Line 8867: l_invoice_rec OE_Order_Pub.Line_Rec_Type;

8863: /* START Enhancement Request# 1915736 */
8864: l_freight_count NUMBER;
8865: /* END Enhancement Request# 1915736 */
8866: -- Fix for bug 2224248
8867: l_invoice_rec OE_Order_Pub.Line_Rec_Type;
8868: --Customer Acceptance
8869: l_line_invoiceable BOOLEAN;
8870: l_line_rejected BOOLEAN;
8871:

Line 8925: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

8921: v_line_id NUMBER;
8922: v_lock_control NUMBER;
8923: l_inv_stat varchar2(50) := ''; --sol_ord_er #16014165
8924: -- 16620434 start
8925: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
8926: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8927: l_global_index NUMBER;
8928: -- 16620434 end
8929: BEGIN

Line 8926: l_line_tbl OE_ORDER_PUB.line_tbl_type;

8922: v_lock_control NUMBER;
8923: l_inv_stat varchar2(50) := ''; --sol_ord_er #16014165
8924: -- 16620434 start
8925: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
8926: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8927: l_global_index NUMBER;
8928: -- 16620434 end
8929: BEGIN
8930: IF l_debug_level > 0 THEN