DBA Data[Home] [Help]

APPS.BEN_PLAN_COPY_LOADER dependencies on FND_GLOBAL

Line 235: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

231: or p_DISPLAY_NAME = 'GHR_TSP_CATCHUP_SEED_PROGRAM_DESIGN'
232: then
233: l_business_group_id := 0;
234: else
235: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
236: end if;
237: --
238: open c2 ;
239: hr_utility.set_location(' Step 30 ',30);

Line 280: l_last_updated_by := fnd_global.user_id;

276: --
277: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_TXNS
278: -- Set WHO columns
279: l_last_update_date := sysdate;
280: l_last_updated_by := fnd_global.user_id;
281: l_last_update_login := fnd_global.login_id;
282: l_created_by := fnd_global.user_id;
283: l_creation_date := sysdate;
284: --

Line 281: l_last_update_login := fnd_global.login_id;

277: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_TXNS
278: -- Set WHO columns
279: l_last_update_date := sysdate;
280: l_last_updated_by := fnd_global.user_id;
281: l_last_update_login := fnd_global.login_id;
282: l_created_by := fnd_global.user_id;
283: l_creation_date := sysdate;
284: --
285: else

Line 282: l_created_by := fnd_global.user_id;

278: -- Set WHO columns
279: l_last_update_date := sysdate;
280: l_last_updated_by := fnd_global.user_id;
281: l_last_update_login := fnd_global.login_id;
282: l_created_by := fnd_global.user_id;
283: l_creation_date := sysdate;
284: --
285: else
286: --

Line 503: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

499: /* For seeded FHR copy process, set context_business_group_id to 0 */
500: if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then
501: l_business_group_id := 0;
502: else
503: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
504: end if;
505: --
506: if g_perf_transaction_category_id is null then
507: open c2 ;

Line 532: l_last_updated_by := fnd_global.user_id;

528: --
529: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_ATTRIBS
530: -- Set WHO columns
531: l_last_update_date := sysdate;
532: l_last_updated_by := fnd_global.user_id;
533: l_last_update_login := fnd_global.login_id;
534: l_created_by := fnd_global.user_id;
535: l_creation_date := sysdate;
536: --

Line 533: l_last_update_login := fnd_global.login_id;

529: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_ATTRIBS
530: -- Set WHO columns
531: l_last_update_date := sysdate;
532: l_last_updated_by := fnd_global.user_id;
533: l_last_update_login := fnd_global.login_id;
534: l_created_by := fnd_global.user_id;
535: l_creation_date := sysdate;
536: --
537: else

Line 534: l_created_by := fnd_global.user_id;

530: -- Set WHO columns
531: l_last_update_date := sysdate;
532: l_last_updated_by := fnd_global.user_id;
533: l_last_update_login := fnd_global.login_id;
534: l_created_by := fnd_global.user_id;
535: l_creation_date := sysdate;
536: --
537: else
538: --

Line 956: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

952: /* For seeded FHR copy process, set context_business_group_id to 0 */
953: if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then
954: l_business_group_id := 0;
955: else
956: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
957: end if;
958: --
959: if g_perf_transaction_category_id is null then
960: open c2 ;

Line 998: l_last_updated_by := fnd_global.user_id;

994: --
995: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_RESULTS
996: -- Set WHO columns
997: l_last_update_date := sysdate;
998: l_last_updated_by := fnd_global.user_id;
999: l_last_update_login := fnd_global.login_id;
1000: l_created_by := fnd_global.user_id;
1001: l_creation_date := sysdate;
1002: --

Line 999: l_last_update_login := fnd_global.login_id;

995: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_RESULTS
996: -- Set WHO columns
997: l_last_update_date := sysdate;
998: l_last_updated_by := fnd_global.user_id;
999: l_last_update_login := fnd_global.login_id;
1000: l_created_by := fnd_global.user_id;
1001: l_creation_date := sysdate;
1002: --
1003: else

Line 1000: l_created_by := fnd_global.user_id;

996: -- Set WHO columns
997: l_last_update_date := sysdate;
998: l_last_updated_by := fnd_global.user_id;
999: l_last_update_login := fnd_global.login_id;
1000: l_created_by := fnd_global.user_id;
1001: l_creation_date := sysdate;
1002: --
1003: else
1004: --

Line 1904: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;

1900: /* For seeded FHR copy process, set context_business_group_id to 0 */
1901: if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then
1902: l_business_group_id := 0;
1903: else
1904: l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
1905: end if;
1906: --
1907: if p_mode = 'BEGIN' then
1908:

Line 2051: l_last_updated_by := fnd_global.user_id;

2047: --
2048: -- WHO Trigger is not defined on the table BEN_COPY_ENTITY_RESULTS
2049: -- Set WHO columns
2050: l_last_update_date := sysdate;
2051: l_last_updated_by := fnd_global.user_id;
2052: l_last_update_login := fnd_global.login_id;
2053: l_created_by := fnd_global.user_id;
2054: l_creation_date := sysdate;
2055: --

Line 2052: l_last_update_login := fnd_global.login_id;

2048: -- WHO Trigger is not defined on the table BEN_COPY_ENTITY_RESULTS
2049: -- Set WHO columns
2050: l_last_update_date := sysdate;
2051: l_last_updated_by := fnd_global.user_id;
2052: l_last_update_login := fnd_global.login_id;
2053: l_created_by := fnd_global.user_id;
2054: l_creation_date := sysdate;
2055: --
2056: else

Line 2053: l_created_by := fnd_global.user_id;

2049: -- Set WHO columns
2050: l_last_update_date := sysdate;
2051: l_last_updated_by := fnd_global.user_id;
2052: l_last_update_login := fnd_global.login_id;
2053: l_created_by := fnd_global.user_id;
2054: l_creation_date := sysdate;
2055: --
2056: else
2057: --