DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on FND_GLOBAL

Line 518: , fnd_global.user_id --p_Line_Adj_rec.created_by

514: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
515: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
516: ldets.price_adjustment_id
517: , sysdate --p_Line_Adj_rec.creation_date
518: , fnd_global.user_id --p_Line_Adj_rec.created_by
519: , sysdate --p_Line_Adj_rec.last_update_date
520: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
521: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
522: , NULL --p_Line_Adj_rec.program_application_id

Line 520: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

516: ldets.price_adjustment_id
517: , sysdate --p_Line_Adj_rec.creation_date
518: , fnd_global.user_id --p_Line_Adj_rec.created_by
519: , sysdate --p_Line_Adj_rec.last_update_date
520: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
521: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
522: , NULL --p_Line_Adj_rec.program_application_id
523: , NULL --p_Line_Adj_rec.program_id
524: , NULL --p_Line_Adj_rec.program_update_date

Line 521: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

517: , sysdate --p_Line_Adj_rec.creation_date
518: , fnd_global.user_id --p_Line_Adj_rec.created_by
519: , sysdate --p_Line_Adj_rec.last_update_date
520: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
521: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
522: , NULL --p_Line_Adj_rec.program_application_id
523: , NULL --p_Line_Adj_rec.program_id
524: , NULL --p_Line_Adj_rec.program_update_date
525: , NULL --p_Line_Adj_rec.request_id

Line 1152: , fnd_global.user_id --p_Line_Adj_rec.created_by

1148: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
1149: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
1150: ldets.price_adjustment_id
1151: , sysdate --p_Line_Adj_rec.creation_date
1152: , fnd_global.user_id --p_Line_Adj_rec.created_by
1153: , sysdate --p_Line_Adj_rec.last_update_date
1154: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
1155: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
1156: , NULL --p_Line_Adj_rec.program_application_id

Line 1154: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

1150: ldets.price_adjustment_id
1151: , sysdate --p_Line_Adj_rec.creation_date
1152: , fnd_global.user_id --p_Line_Adj_rec.created_by
1153: , sysdate --p_Line_Adj_rec.last_update_date
1154: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
1155: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
1156: , NULL --p_Line_Adj_rec.program_application_id
1157: , NULL --p_Line_Adj_rec.program_id
1158: , NULL --p_Line_Adj_rec.program_update_date

Line 1155: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

1151: , sysdate --p_Line_Adj_rec.creation_date
1152: , fnd_global.user_id --p_Line_Adj_rec.created_by
1153: , sysdate --p_Line_Adj_rec.last_update_date
1154: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
1155: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
1156: , NULL --p_Line_Adj_rec.program_application_id
1157: , NULL --p_Line_Adj_rec.program_id
1158: , NULL --p_Line_Adj_rec.program_update_date
1159: , NULL --p_Line_Adj_rec.request_id

Line 2312: l_Line_Adj_rec.created_by := fnd_global.user_id;

2308: IF l_insert.modifier_level_code <> 'ORDER' THEN
2309: l_Line_Adj_rec.line_id := l_insert.line_id;
2310: l_Line_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
2311: l_Line_Adj_rec.creation_date := sysdate;
2312: l_Line_Adj_rec.created_by := fnd_global.user_id;
2313: l_Line_Adj_rec.last_update_date := sysdate;
2314: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
2315: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
2316: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

Line 2314: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;

2310: l_Line_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
2311: l_Line_Adj_rec.creation_date := sysdate;
2312: l_Line_Adj_rec.created_by := fnd_global.user_id;
2313: l_Line_Adj_rec.last_update_date := sysdate;
2314: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
2315: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
2316: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
2317: l_Line_Adj_rec.automatic_flag := l_insert.auto_flag;
2318: l_Line_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;

Line 2315: l_Line_Adj_rec.last_update_login := fnd_global.user_id;

2311: l_Line_Adj_rec.creation_date := sysdate;
2312: l_Line_Adj_rec.created_by := fnd_global.user_id;
2313: l_Line_Adj_rec.last_update_date := sysdate;
2314: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
2315: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
2316: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
2317: l_Line_Adj_rec.automatic_flag := l_insert.auto_flag;
2318: l_Line_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
2319: l_Line_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;

Line 2430: l_Header_Adj_rec.created_by := fnd_global.user_id;

2426: ELSE -- modifier level code 'ORDER'
2427: --l_Header_Adj_rec.line_id := l_insert.line_id;
2428: l_Header_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
2429: l_Header_Adj_rec.creation_date := sysdate;
2430: l_Header_Adj_rec.created_by := fnd_global.user_id;
2431: l_Header_Adj_rec.last_update_date := sysdate;
2432: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
2433: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
2434: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

Line 2432: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;

2428: l_Header_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
2429: l_Header_Adj_rec.creation_date := sysdate;
2430: l_Header_Adj_rec.created_by := fnd_global.user_id;
2431: l_Header_Adj_rec.last_update_date := sysdate;
2432: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
2433: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
2434: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
2435: l_Header_Adj_rec.automatic_flag := l_insert.auto_flag;
2436: l_Header_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;

Line 2433: l_Header_Adj_rec.last_update_login := fnd_global.user_id;

2429: l_Header_Adj_rec.creation_date := sysdate;
2430: l_Header_Adj_rec.created_by := fnd_global.user_id;
2431: l_Header_Adj_rec.last_update_date := sysdate;
2432: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
2433: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
2434: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
2435: l_Header_Adj_rec.automatic_flag := l_insert.auto_flag;
2436: l_Header_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
2437: l_Header_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;

Line 2784: , fnd_global.user_id --p_Line_Adj_rec.created_by

2780: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2781: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2782: ldets.price_adjustment_id
2783: , sysdate --p_Line_Adj_rec.creation_date
2784: , fnd_global.user_id --p_Line_Adj_rec.created_by
2785: , sysdate --p_Line_Adj_rec.last_update_date
2786: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2787: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2788: , NULL --p_Line_Adj_rec.program_application_id

Line 2786: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

2782: ldets.price_adjustment_id
2783: , sysdate --p_Line_Adj_rec.creation_date
2784: , fnd_global.user_id --p_Line_Adj_rec.created_by
2785: , sysdate --p_Line_Adj_rec.last_update_date
2786: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2787: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2788: , NULL --p_Line_Adj_rec.program_application_id
2789: , NULL --p_Line_Adj_rec.program_id
2790: , NULL --p_Line_Adj_rec.program_update_date

Line 2787: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

2783: , sysdate --p_Line_Adj_rec.creation_date
2784: , fnd_global.user_id --p_Line_Adj_rec.created_by
2785: , sysdate --p_Line_Adj_rec.last_update_date
2786: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2787: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2788: , NULL --p_Line_Adj_rec.program_application_id
2789: , NULL --p_Line_Adj_rec.program_id
2790: , NULL --p_Line_Adj_rec.program_update_date
2791: , NULL --p_Line_Adj_rec.request_id

Line 2936: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY

2932: )
2933: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
2934: LDET.price_adjustment_id
2935: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2936: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2937: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2938: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2939: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2940: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

Line 2938: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY

2934: LDET.price_adjustment_id
2935: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2936: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2937: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2938: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2939: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2940: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2941: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2942: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

Line 2939: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN

2935: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2936: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2937: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2938: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2939: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2940: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2941: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2942: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2943: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID