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 388: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541

384:
385: Update oe_order_lines_all
386: Set flow_status_code = p_flow_status_code
387: , last_update_date = sysdate --BUG#9539541
388: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541
389: Where line_id = p_line_id;
390:
391: --OIP SUN ER changes
392: If p_flow_status_code = 'INVOICED' then

Line 471: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541

467:
468: Update oe_order_headers_all
469: Set flow_status_code = p_flow_status_code
470: , last_update_date = sysdate --BUG#9539541
471: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541
472: Where header_id = p_header_id;
473:
474: -- 8541809 : Start
475: IF l_debug_level > 0 THEN

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

1731: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1732: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1733: END IF ; -- end
1734:
1735: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line
1736: IF l_debug_level > 0 THEN
1737: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1738: END IF;
1739: --use cache instead of SQL for bug 4200055

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

1733: END IF ; -- end
1734:
1735: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line
1736: IF l_debug_level > 0 THEN
1737: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1738: END IF;
1739: --use cache instead of SQL for bug 4200055
1740: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1741: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;

Line 3085: ,UNIT_STANDARD_PRICE

3081: ,TRX_NUMBER
3082: ,QUANTITY
3083: ,QUANTITY_ORDERED
3084: ,UNIT_SELLING_PRICE
3085: ,UNIT_STANDARD_PRICE
3086: ,UOM_CODE
3087: ,UOM_NAME
3088: ,PRINTING_OPTION
3089: ,INTERFACE_STATUS

Line 3368: ,p_interface_line_rec.UNIT_STANDARD_PRICE

3364: ,p_interface_line_rec.TRX_NUMBER
3365: ,p_interface_line_rec.QUANTITY
3366: ,p_interface_line_rec.QUANTITY_ORDERED
3367: ,p_interface_line_rec.UNIT_SELLING_PRICE
3368: ,p_interface_line_rec.UNIT_STANDARD_PRICE
3369: ,p_interface_line_rec.UOM_CODE
3370: ,p_interface_line_rec.UOM_NAME
3371: ,p_interface_line_rec.PRINTING_OPTION
3372: ,p_interface_line_rec.INTERFACE_STATUS

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

3644: x_interface_scredit_rec.CREATION_DATE := sysdate;
3645: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3646: END IF;
3647:
3648: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3649: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3650: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3651: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3652: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

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

3645: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3646: END IF;
3647:
3648: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3649: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3650: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3651: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3652: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
3653: x_interface_scredit_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

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

3725: x_interface_scredit_rec.CREATION_DATE := sysdate;
3726: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3727: END IF;
3728:
3729: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3730: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3731: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3732: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3733: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

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

3726: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3727: END IF;
3728:
3729: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3730: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3731: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3732: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3733: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
3734: x_interface_scredit_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

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

3809: x_interface_scredit_rec.CREATION_DATE := sysdate;
3810: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3811: END IF;
3812:
3813: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3814: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3815: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3816: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3817: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

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

3810: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3811: END IF;
3812:
3813: x_interface_scredit_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3814: x_interface_scredit_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
3815: x_interface_scredit_rec.INTERFACE_SALESCREDIT_ID := NULL;
3816: x_interface_scredit_rec.INTERFACE_LINE_ID := NULL;
3817: x_interface_scredit_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
3818: x_interface_scredit_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

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

4771: END IF;
4772:
4773: -- Quantity comes with the correct creation sign from the interface_line record. No need to adjust here
4774: l_discounts_rec.Unit_Selling_Price := l_adjustments_rec.unit_discount_amount * -1;
4775: l_discounts_rec.Unit_Standard_Price := l_adjustments_rec.unit_discount_amount * -1;
4776: IF l_debug_level > 0 THEN
4777: oe_debug_pub.add( 'ORIGINAL UNIT DISCOUNT AMOUNT : '||L_ADJUSTMENTS_REC.UNIT_DISCOUNT_AMOUNT , 5 ) ;
4778: END IF;
4779: Rounded_Amount(p_currency_code => l_discounts_rec.currency_code

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

4780: ,p_unrounded_amount => (l_discounts_rec.unit_selling_price * l_discounts_rec.quantity)
4781: ,x_rounded_amount => l_discounts_rec.amount);
4782: IF l_debug_level > 0 THEN
4783: oe_debug_pub.add( 'DISCOUNT UNIT_SELLING_PRICE: '||L_DISCOUNTS_REC.UNIT_SELLING_PRICE , 5 ) ;
4784: oe_debug_pub.add( 'DISCOUNT UNIT_STANDARD_PRICE: '||L_DISCOUNTS_REC.UNIT_STANDARD_PRICE , 5 ) ;
4785: oe_debug_pub.add( 'DISCOUNT AMOUNT: '||L_DISCOUNTS_REC.AMOUNT , 5 ) ;
4786: END IF;
4787: IF l_rounding_diff_applied = 'N' THEN
4788: IF (l_discounts_rec.quantity = 0 OR l_discounts_rec.amount = 0) THEN

Line 5241: p_x_charges_rec.Unit_Standard_Price := NULL;

5237:
5238:
5239: p_x_charges_rec.Quantity_Ordered := NULL;
5240: p_x_charges_rec.Unit_Selling_Price := NULL;
5241: p_x_charges_rec.Unit_Standard_Price := NULL;
5242:
5243: Rounded_Amount(p_currency_code => p_x_charges_rec.currency_code
5244: ,p_unrounded_amount => p_x_charges_rec.amount
5245: ,x_rounded_amount => l_rounded_amount );

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

6299: END IF;
6300: END IF;
6301:
6302: -- Get information into p_x_interface_line_rec
6303: p_x_interface_line_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6304: p_x_interface_line_rec.CREATION_DATE := sysdate;
6305: p_x_interface_line_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6306: p_x_interface_line_rec.LAST_UPDATE_DATE := sysdate;
6307: -- bug 8494362 start

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

6301:
6302: -- Get information into p_x_interface_line_rec
6303: p_x_interface_line_rec.CREATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6304: p_x_interface_line_rec.CREATION_DATE := sysdate;
6305: p_x_interface_line_rec.LAST_UPDATED_BY := NVL(oe_standard_wf.g_user_id, fnd_global.user_id); -- 3169637
6306: p_x_interface_line_rec.LAST_UPDATE_DATE := sysdate;
6307: -- bug 8494362 start
6308: --p_x_interface_line_rec.INTERFACE_LINE_CONTEXT := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6309:

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

6578: END IF;
6579: END IF;
6580: END IF;
6581: END IF; -- end of commitment sequencing functionality ON
6582: p_x_interface_line_rec.Unit_Standard_Price := p_line_rec.Unit_List_Price;
6583: IF Show_Detail_Discounts(p_line_rec) THEN
6584: -- If we show detail discounts, original line selling and extended amounts should not include discount amount.
6585: p_x_interface_line_rec.Unit_Selling_Price := p_line_rec.Unit_List_Price;
6586: Rounded_Amount(p_currency_code => p_x_interface_line_rec.currency_code

Line 6597: p_x_interface_line_rec.Unit_Standard_Price := '';

6593: -- sol_ord_er #16014165
6594: elsif p_line_rec.service_bill_option_code = 'FPOM' THEN
6595: p_x_interface_line_rec.Unit_Selling_Price := '';
6596: l_unround_amt := p_line_rec.service_first_period_amount;
6597: p_x_interface_line_rec.Unit_Standard_Price := '';
6598: end if;
6599: -- sol_ord_er #16014165 end
6600: Rounded_Amount(p_currency_code => p_x_interface_line_rec.currency_code
6601: -- ,p_unrounded_amount => (p_line_rec.unit_selling_price * p_x_interface_line_rec.quantity)--sol_ord_er #16014165

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

6627: END IF;
6628:
6629: IF l_debug_level > 0 THEN
6630: oe_debug_pub.add( 'LINE UNIT SELLING PRICE: '||P_X_INTERFACE_LINE_REC.UNIT_SELLING_PRICE , 5 ) ;
6631: oe_debug_pub.add( 'LINE UNIT STANDARD PRICE: '||P_X_INTERFACE_LINE_REC.UNIT_STANDARD_PRICE , 5 ) ;
6632: oe_debug_pub.add( 'LINE AMOUNT: '||P_X_INTERFACE_LINE_REC.AMOUNT ) ;
6633: END IF;
6634:
6635: -- invoice_to_org_id is required at booking

Line 7836: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541

7832: --9040537 CREDIT_INVOICE_LINE_ID = p_line_rec.CREDIT_INVOICE_LINE_ID, --8319535
7833: CALCULATE_PRICE_FLAG = 'N',
7834: LOCK_CONTROL = LOCK_CONTROL + 1
7835: , last_update_date = sysdate --BUG#9539541
7836: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541
7837: WHERE LINE_ID = p_line_rec.line_id;
7838: --CC Reversal ER#16014135 Start
7839: IF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_line_rec.header_id) IS NOT NULL THEN
7840:

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

8129: ELSE
8130: inv_num := inv_num_base || '-' || to_char(inv_num_index);
8131: END IF;
8132: IF l_debug_level > 0 THEN
8133: oe_debug_pub.add( 'GLOBAL USER ' || NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
8134: oe_debug_pub.add( 'INV NUM INDEX ' || TO_CHAR ( INV_NUM_INDEX ) ) ;
8135: END IF;
8136: INSERT INTO OE_INVOICE_NUMBERS(
8137: INVOICE_NUMBER_ID

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

8145: ( oe_invoice_numbers_s.nextval
8146: , p_del_id
8147: , inv_num_index
8148: , SYSDATE
8149: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637
8150: , SYSDATE
8151: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
8152:
8153: IF l_debug_level > 0 THEN

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

8147: , inv_num_index
8148: , SYSDATE
8149: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id) -- 3169637
8150: , SYSDATE
8151: , NVL(oe_standard_wf.g_user_id, fnd_global.user_id)); -- 3169637
8152:
8153: IF l_debug_level > 0 THEN
8154: oe_debug_pub.add( 'DONE UPDATE_INVOICE_NUMBERS W/SUCCESS' , 5 ) ;
8155: END IF;