DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on FND_GLOBAL

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

7005: p_x_interface_line_rec.customer_bank_account_id := l_bank_acct_id;
7006: p_x_interface_line_rec.customer_bank_account_name
7007: := p_header_rec.credit_card_holder_name;
7008: /* Fix FP Bug # 3647389: Get the Current Context Values */
7009: l_cur_user_id := fnd_global.user_id;
7010: fnd_profile.get('RESP_ID',l_cur_resp_id);
7011: fnd_profile.get('RESP_APPL_ID',l_cur_appl_id);
7012:
7013: /* Fix FP Bug # 3647389: Set the Context using Original Values */

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

7010: fnd_profile.get('RESP_ID',l_cur_resp_id);
7011: fnd_profile.get('RESP_APPL_ID',l_cur_appl_id);
7012:
7013: /* Fix FP Bug # 3647389: Set the Context using Original Values */
7014: fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);
7015:
7016: -- Call Get Primary Pay Method to get the method id
7017: IF l_debug_level > 0 THEN
7018: oe_debug_pub.add( 'GETTING PRIMAY PAYMENT METHOD' , 5 ) ;

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

7024: oe_debug_pub.add( 'AFTER GETTING PRIMARY PAYMENT METHOD' , 5 ) ;
7025: END IF;
7026:
7027: /* Fix FP Bug # 3647389: Reset the Context using Current Values */
7028: fnd_global.apps_initialize(l_cur_user_id, l_cur_resp_id, l_cur_appl_id);
7029:
7030: -- Check if a Valid Pay Method Id returned
7031: IF NVL(l_pay_method_id, 0) > 0 THEN
7032: IF l_debug_level > 0 THEN

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;