DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_STANDARD_WF

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 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;