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