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 STANDARD

Line 1518: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line

1514: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1515: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1516: END IF ; -- end
1517:
1518: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1521: END IF;
1522: --use cache instead of SQL for bug 4200055

Line 1520: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;

1516: END IF ; -- end
1517:
1518: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1521: END IF;
1522: --use cache instead of SQL for bug 4200055
1523: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1524: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;

Line 2857: ,UNIT_STANDARD_PRICE

2853: ,TRX_NUMBER
2854: ,QUANTITY
2855: ,QUANTITY_ORDERED
2856: ,UNIT_SELLING_PRICE
2857: ,UNIT_STANDARD_PRICE
2858: ,UOM_CODE
2859: ,UOM_NAME
2860: ,PRINTING_OPTION
2861: ,INTERFACE_STATUS

Line 3139: ,p_interface_line_rec.UNIT_STANDARD_PRICE

3135: ,p_interface_line_rec.TRX_NUMBER
3136: ,p_interface_line_rec.QUANTITY
3137: ,p_interface_line_rec.QUANTITY_ORDERED
3138: ,p_interface_line_rec.UNIT_SELLING_PRICE
3139: ,p_interface_line_rec.UNIT_STANDARD_PRICE
3140: ,p_interface_line_rec.UOM_CODE
3141: ,p_interface_line_rec.UOM_NAME
3142: ,p_interface_line_rec.PRINTING_OPTION
3143: ,p_interface_line_rec.INTERFACE_STATUS

Line 3419: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

3415: x_interface_scredit_rec.CREATION_DATE := sysdate;
3416: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3417: END IF;
3418:
3419: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3420: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3421: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3422: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3423: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

Line 3420: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

3416: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3417: END IF;
3418:
3419: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3420: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3421: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3422: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3423: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
3424: x_interface_scredit_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

Line 3500: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

3496: x_interface_scredit_rec.CREATION_DATE := sysdate;
3497: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3498: END IF;
3499:
3500: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3501: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3502: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3503: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3504: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

Line 3501: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

3497: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3498: END IF;
3499:
3500: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3501: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3502: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3503: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3504: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
3505: x_interface_scredit_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

Line 3584: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

3580: x_interface_scredit_rec.CREATION_DATE := sysdate;
3581: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3582: END IF;
3583:
3584: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3585: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3586: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3587: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3588: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

Line 3585: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

3581: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3582: END IF;
3583:
3584: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3585: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3586: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3587: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3588: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
3589: x_interface_scredit_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

Line 4544: l_discounts_rec.Unit_Standard_Price := l_adjustments_rec.unit_discount_amount * -1;

4540: END IF;
4541:
4542: -- Quantity comes with the correct creation sign from the interface_line record. No need to adjust here
4543: l_discounts_rec.Unit_Selling_Price := l_adjustments_rec.unit_discount_amount * -1;
4544: l_discounts_rec.Unit_Standard_Price := l_adjustments_rec.unit_discount_amount * -1;
4545: IF l_debug_level > 0 THEN
4546: oe_debug_pub.add( 'ORIGINAL UNIT DISCOUNT AMOUNT : '||L_ADJUSTMENTS_REC.UNIT_DISCOUNT_AMOUNT , 5 ) ;
4547: END IF;
4548: Rounded_Amount(p_currency_code => l_discounts_rec.currency_code

Line 4553: oe_debug_pub.add( 'DISCOUNT UNIT_STANDARD_PRICE: '||L_DISCOUNTS_REC.UNIT_STANDARD_PRICE , 5 ) ;

4549: ,p_unrounded_amount => (l_discounts_rec.unit_selling_price * l_discounts_rec.quantity)
4550: ,x_rounded_amount => l_discounts_rec.amount);
4551: IF l_debug_level > 0 THEN
4552: oe_debug_pub.add( 'DISCOUNT UNIT_SELLING_PRICE: '||L_DISCOUNTS_REC.UNIT_SELLING_PRICE , 5 ) ;
4553: oe_debug_pub.add( 'DISCOUNT UNIT_STANDARD_PRICE: '||L_DISCOUNTS_REC.UNIT_STANDARD_PRICE , 5 ) ;
4554: oe_debug_pub.add( 'DISCOUNT AMOUNT: '||L_DISCOUNTS_REC.AMOUNT , 5 ) ;
4555: END IF;
4556: IF l_rounding_diff_applied = 'N' THEN
4557: IF (l_discounts_rec.quantity = 0 OR l_discounts_rec.amount = 0) THEN

Line 4997: p_x_charges_rec.Unit_Standard_Price := NULL;

4993:
4994: p_x_charges_rec.Quantity := NULL;
4995: p_x_charges_rec.Quantity_Ordered := NULL;
4996: p_x_charges_rec.Unit_Selling_Price := NULL;
4997: p_x_charges_rec.Unit_Standard_Price := NULL;
4998:
4999: Rounded_Amount(p_currency_code => p_x_charges_rec.currency_code
5000: ,p_unrounded_amount => p_x_charges_rec.amount
5001: ,x_rounded_amount => l_rounded_amount );

Line 6058: p_x_interface_line_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

6054: END IF;
6055: END IF;
6056:
6057: -- Get information into p_x_interface_line_rec
6058: p_x_interface_line_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6059: p_x_interface_line_rec.CREATION_DATE := sysdate;
6060: p_x_interface_line_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6061: p_x_interface_line_rec.LAST_UPDATE_DATE := sysdate;
6062: p_x_interface_line_rec.INTERFACE_LINE_CONTEXT := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 6060: p_x_interface_line_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637

6056:
6057: -- Get information into p_x_interface_line_rec
6058: p_x_interface_line_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6059: p_x_interface_line_rec.CREATION_DATE := sysdate;
6060: p_x_interface_line_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6061: p_x_interface_line_rec.LAST_UPDATE_DATE := sysdate;
6062: p_x_interface_line_rec.INTERFACE_LINE_CONTEXT := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6063: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1 := to_char(p_header_rec.order_number);
6064:

Line 6319: p_x_interface_line_rec.Unit_Standard_Price := p_line_rec.Unit_List_Price;

6315: END IF;
6316: END IF;
6317: END IF;
6318: END IF; -- end of commitment sequencing functionality ON
6319: p_x_interface_line_rec.Unit_Standard_Price := p_line_rec.Unit_List_Price;
6320: IF Show_Detail_Discounts(p_line_rec) THEN
6321: -- If we show detail discounts, original line selling and extended amounts should not include discount amount.
6322: p_x_interface_line_rec.Unit_Selling_Price := p_line_rec.Unit_List_Price;
6323: Rounded_Amount(p_currency_code => p_x_interface_line_rec.currency_code

Line 6358: oe_debug_pub.add( 'LINE UNIT STANDARD PRICE: '||P_X_INTERFACE_LINE_REC.UNIT_STANDARD_PRICE , 5 ) ;

6354: END IF;
6355:
6356: IF l_debug_level > 0 THEN
6357: oe_debug_pub.add( 'LINE UNIT SELLING PRICE: '||P_X_INTERFACE_LINE_REC.UNIT_SELLING_PRICE , 5 ) ;
6358: oe_debug_pub.add( 'LINE UNIT STANDARD PRICE: '||P_X_INTERFACE_LINE_REC.UNIT_STANDARD_PRICE , 5 ) ;
6359: oe_debug_pub.add( 'LINE AMOUNT: '||P_X_INTERFACE_LINE_REC.AMOUNT ) ;
6360: END IF;
6361:
6362: -- invoice_to_org_id is required at booking

Line 7749: oe_debug_pub.add( 'GLOBAL USER ' || NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637

7745: ELSE
7746: inv_num := inv_num_base || '-' || to_char(inv_num_index);
7747: END IF;
7748: IF l_debug_level > 0 THEN
7749: oe_debug_pub.add( 'GLOBAL USER ' || NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
7750: oe_debug_pub.add( 'INV NUM INDEX ' || TO_CHAR ( INV_NUM_INDEX ) ) ;
7751: END IF;
7752: INSERT INTO OE_INVOICE_NUMBERS(
7753: INVOICE_NUMBER_ID

Line 7765: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637

7761: ( oe_invoice_numbers_s.nextval
7762: , p_del_id
7763: , inv_num_index
7764: , SYSDATE
7765: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637
7766: , SYSDATE
7767: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
7768:
7769: IF l_debug_level > 0 THEN

Line 7767: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637

7763: , inv_num_index
7764: , SYSDATE
7765: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637
7766: , SYSDATE
7767: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
7768:
7769: IF l_debug_level > 0 THEN
7770: oe_debug_pub.add( 'DONE UPDATE_INVOICE_NUMBERS W/SUCCESS' , 5 ) ;
7771: END IF;