APPS.PQP_GB_OSP_TEMPLATE dependencies on HR_API

Line 509: ,LAST_UPDATE_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE

505: ,LEGISLATION_CODE -- 'GB'
506: ,DESCRIPTION -- 'GB Absence Schemes OSP/OMP'
507: ,APPLICATION_ID -- 8303
508: ,OBJECT_VERSION_NUMBER -- 1
509: ,LAST_UPDATE_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
510: ,LAST_UPDATED_BY -- 2
511: ,LAST_UPDATE_LOGIN -- 2
512: ,CREATED_BY -- 2
513: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE

Line 513: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE

509: ,LAST_UPDATE_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
510: ,LAST_UPDATED_BY -- 2
511: ,LAST_UPDATE_LOGIN -- 2
512: ,CREATED_BY -- 2
513: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
514: )
515: SELECT
516: pqp_configuration_modules_s.nextval
517: ,'Absence Schemes'

Line 523: ,hr_api.g_sot

519: ,'GB'
520: ,'GB Absence Schemes OSP/OMP'
521: ,8303
522: ,1
523: ,hr_api.g_sot
524: ,2
525: ,2
526: ,2
527: ,hr_api.g_sot

Line 527: ,hr_api.g_sot

523: ,hr_api.g_sot
524: ,2
525: ,2
526: ,2
527: ,hr_api.g_sot
528: FROM DUAL
529: WHERE NOT EXISTS
530: ( SELECT 1 FROM pqp_configuration_modules
531: WHERE module_name = 'Absence Schemes'

Line 556: ,LAST_UPDATE_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE

552: ,PROGRAM_ID -- NULL
553: ,REQUEST_ID -- NULL
554: ,PROGRAM_UPDATE_DATE -- NULL
555: ,OBJECT_VERSION_NUMBER -- 1
556: ,LAST_UPDATE_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
557: ,LAST_UPDATED_BY -- 2
558: ,LAST_UPDATE_LOGIN -- 2
559: ,CREATED_BY -- 2
560: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE

Line 560: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE

556: ,LAST_UPDATE_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
557: ,LAST_UPDATED_BY -- 2
558: ,LAST_UPDATE_LOGIN -- 2
559: ,CREATED_BY -- 2
560: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
561: ,TOTAL_UNIQUE_COLUMNS -- NULL
562: )
563: SELECT
564: 'PQP_GB_OSP_OMP_CONFIG'

Line 576: ,hr_api.g_sot

572: ,NULL
573: ,NULL
574: ,NULL
575: ,1
576: ,hr_api.g_sot
577: ,2
578: ,2
579: ,2
580: ,hr_api.g_sot

Line 580: ,hr_api.g_sot

576: ,hr_api.g_sot
577: ,2
578: ,2
579: ,2
580: ,hr_api.g_sot
581: ,NULL
582: FROM DUAL
583: WHERE NOT EXISTS
584: ( SELECT 1 FROM pqp_configuration_types

Line 1494: ,nvl(p_ele_eff_end_date, hr_api.g_eot)

1490: )
1491: VALUES
1492: (l_user_row_id
1493: ,p_ele_eff_start_date
1494: ,nvl(p_ele_eff_end_date, hr_api.g_eot)
1495: ,p_udt_rows(i).business_group_id
1496: ,p_udt_rows(i).legislation_code
1497: ,l_user_table_id
1498: ,p_udt_rows(i).row_low_range_or_name