DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on FND_GLOBAL

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

446: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
447: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
448: ldets.price_adjustment_id
449: , sysdate --p_Line_Adj_rec.creation_date
450: , fnd_global.user_id --p_Line_Adj_rec.created_by
451: , sysdate --p_Line_Adj_rec.last_update_date
452: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
453: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
454: , NULL --p_Line_Adj_rec.program_application_id

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

448: ldets.price_adjustment_id
449: , sysdate --p_Line_Adj_rec.creation_date
450: , fnd_global.user_id --p_Line_Adj_rec.created_by
451: , sysdate --p_Line_Adj_rec.last_update_date
452: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
453: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
454: , NULL --p_Line_Adj_rec.program_application_id
455: , NULL --p_Line_Adj_rec.program_id
456: , NULL --p_Line_Adj_rec.program_update_date

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

449: , sysdate --p_Line_Adj_rec.creation_date
450: , fnd_global.user_id --p_Line_Adj_rec.created_by
451: , sysdate --p_Line_Adj_rec.last_update_date
452: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
453: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
454: , NULL --p_Line_Adj_rec.program_application_id
455: , NULL --p_Line_Adj_rec.program_id
456: , NULL --p_Line_Adj_rec.program_update_date
457: , NULL --p_Line_Adj_rec.request_id

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

864: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
865: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
866: ldets.price_adjustment_id
867: , sysdate --p_Line_Adj_rec.creation_date
868: , fnd_global.user_id --p_Line_Adj_rec.created_by
869: , sysdate --p_Line_Adj_rec.last_update_date
870: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
871: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
872: , NULL --p_Line_Adj_rec.program_application_id

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

866: ldets.price_adjustment_id
867: , sysdate --p_Line_Adj_rec.creation_date
868: , fnd_global.user_id --p_Line_Adj_rec.created_by
869: , sysdate --p_Line_Adj_rec.last_update_date
870: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
871: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
872: , NULL --p_Line_Adj_rec.program_application_id
873: , NULL --p_Line_Adj_rec.program_id
874: , NULL --p_Line_Adj_rec.program_update_date

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

867: , sysdate --p_Line_Adj_rec.creation_date
868: , fnd_global.user_id --p_Line_Adj_rec.created_by
869: , sysdate --p_Line_Adj_rec.last_update_date
870: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
871: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
872: , NULL --p_Line_Adj_rec.program_application_id
873: , NULL --p_Line_Adj_rec.program_id
874: , NULL --p_Line_Adj_rec.program_update_date
875: , NULL --p_Line_Adj_rec.request_id

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

1878: IF l_insert.modifier_level_code <> 'ORDER' THEN
1879: l_Line_Adj_rec.line_id := l_insert.line_id;
1880: l_Line_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
1881: l_Line_Adj_rec.creation_date := sysdate;
1882: l_Line_Adj_rec.created_by := fnd_global.user_id;
1883: l_Line_Adj_rec.last_update_date := sysdate;
1884: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
1885: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
1886: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

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

1880: l_Line_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
1881: l_Line_Adj_rec.creation_date := sysdate;
1882: l_Line_Adj_rec.created_by := fnd_global.user_id;
1883: l_Line_Adj_rec.last_update_date := sysdate;
1884: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
1885: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
1886: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
1887: l_Line_Adj_rec.automatic_flag := l_insert.auto_flag;
1888: l_Line_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;

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

1881: l_Line_Adj_rec.creation_date := sysdate;
1882: l_Line_Adj_rec.created_by := fnd_global.user_id;
1883: l_Line_Adj_rec.last_update_date := sysdate;
1884: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
1885: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
1886: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
1887: l_Line_Adj_rec.automatic_flag := l_insert.auto_flag;
1888: l_Line_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
1889: l_Line_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;

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

1961: ELSE -- modifier level code 'ORDER'
1962: --l_Header_Adj_rec.line_id := l_insert.line_id;
1963: l_Header_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
1964: l_Header_Adj_rec.creation_date := sysdate;
1965: l_Header_Adj_rec.created_by := fnd_global.user_id;
1966: l_Header_Adj_rec.last_update_date := sysdate;
1967: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
1968: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
1969: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

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

1963: l_Header_Adj_rec.price_adjustment_id := l_insert.price_adjustment_id;
1964: l_Header_Adj_rec.creation_date := sysdate;
1965: l_Header_Adj_rec.created_by := fnd_global.user_id;
1966: l_Header_Adj_rec.last_update_date := sysdate;
1967: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
1968: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
1969: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
1970: l_Header_Adj_rec.automatic_flag := l_insert.auto_flag;
1971: l_Header_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;

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

1964: l_Header_Adj_rec.creation_date := sysdate;
1965: l_Header_Adj_rec.created_by := fnd_global.user_id;
1966: l_Header_Adj_rec.last_update_date := sysdate;
1967: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
1968: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
1969: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
1970: l_Header_Adj_rec.automatic_flag := l_insert.auto_flag;
1971: l_Header_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
1972: l_Header_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;

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

2312: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2313: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2314: ldets.price_adjustment_id
2315: , sysdate --p_Line_Adj_rec.creation_date
2316: , fnd_global.user_id --p_Line_Adj_rec.created_by
2317: , sysdate --p_Line_Adj_rec.last_update_date
2318: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2319: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2320: , NULL --p_Line_Adj_rec.program_application_id

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

2314: ldets.price_adjustment_id
2315: , sysdate --p_Line_Adj_rec.creation_date
2316: , fnd_global.user_id --p_Line_Adj_rec.created_by
2317: , sysdate --p_Line_Adj_rec.last_update_date
2318: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2319: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2320: , NULL --p_Line_Adj_rec.program_application_id
2321: , NULL --p_Line_Adj_rec.program_id
2322: , NULL --p_Line_Adj_rec.program_update_date

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

2315: , sysdate --p_Line_Adj_rec.creation_date
2316: , fnd_global.user_id --p_Line_Adj_rec.created_by
2317: , sysdate --p_Line_Adj_rec.last_update_date
2318: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2319: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2320: , NULL --p_Line_Adj_rec.program_application_id
2321: , NULL --p_Line_Adj_rec.program_id
2322: , NULL --p_Line_Adj_rec.program_update_date
2323: , NULL --p_Line_Adj_rec.request_id

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

2459: )
2460: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
2461: LDET.price_adjustment_id
2462: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2463: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2464: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2465: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2466: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2467: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

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

2461: LDET.price_adjustment_id
2462: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2463: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2464: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2465: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2466: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2467: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2468: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2469: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

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

2462: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2463: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2464: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2465: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2466: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2467: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2468: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2469: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2470: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID