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 FND_GLOBAL

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 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 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 6310: l_cur_user_id := fnd_global.user_id;

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:
6310: l_cur_user_id := fnd_global.user_id;
6311: l_cur_resp_id := fnd_global.RESP_ID;
6312: l_cur_appl_id := fnd_global.RESP_APPL_ID;
6313:
6314:

Line 6311: l_cur_resp_id := fnd_global.RESP_ID;

6307: -- bug 8494362 start
6308: --p_x_interface_line_rec.INTERFACE_LINE_CONTEXT := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6309:
6310: l_cur_user_id := fnd_global.user_id;
6311: l_cur_resp_id := fnd_global.RESP_ID;
6312: l_cur_appl_id := fnd_global.RESP_APPL_ID;
6313:
6314:
6315:

Line 6312: l_cur_appl_id := fnd_global.RESP_APPL_ID;

6308: --p_x_interface_line_rec.INTERFACE_LINE_CONTEXT := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6309:
6310: l_cur_user_id := fnd_global.user_id;
6311: l_cur_resp_id := fnd_global.RESP_ID;
6312: l_cur_appl_id := fnd_global.RESP_APPL_ID;
6313:
6314:
6315:
6316: p_x_interface_line_rec.INTERFACE_LINE_CONTEXT := fnd_profile.value_specific('ONT_SOURCE_CODE',l_cur_user_id,l_cur_resp_id,l_cur_appl_id,null,null);

Line 7294: l_cur_user_id := fnd_global.user_id;

7290: p_x_interface_line_rec.customer_bank_account_id := l_bank_acct_id;
7291: p_x_interface_line_rec.customer_bank_account_name
7292: := p_header_rec.credit_card_holder_name;
7293: /* Fix FP Bug # 3647389: Get the Current Context Values */
7294: l_cur_user_id := fnd_global.user_id;
7295: fnd_profile.get('RESP_ID',l_cur_resp_id);
7296: fnd_profile.get('RESP_APPL_ID',l_cur_appl_id);
7297:
7298: /* Fix FP Bug # 3647389: Set the Context using Original Values */

Line 7299: fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);

7295: fnd_profile.get('RESP_ID',l_cur_resp_id);
7296: fnd_profile.get('RESP_APPL_ID',l_cur_appl_id);
7297:
7298: /* Fix FP Bug # 3647389: Set the Context using Original Values */
7299: fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);
7300:
7301: -- Call Get Primary Pay Method to get the method id
7302: IF l_debug_level > 0 THEN
7303: oe_debug_pub.add( 'GETTING PRIMAY PAYMENT METHOD' , 5 ) ;

Line 7313: fnd_global.apps_initialize(l_cur_user_id, l_cur_resp_id, l_cur_appl_id);

7309: oe_debug_pub.add( 'AFTER GETTING PRIMARY PAYMENT METHOD' , 5 ) ;
7310: END IF;
7311:
7312: /* Fix FP Bug # 3647389: Reset the Context using Current Values */
7313: fnd_global.apps_initialize(l_cur_user_id, l_cur_resp_id, l_cur_appl_id);
7314:
7315: -- Check if a Valid Pay Method Id returned
7316: IF NVL(l_pay_method_id, 0) > 0 THEN
7317: IF l_debug_level > 0 THEN

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;