eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_TDF_BUS dependencies on PAY_TIME_DEFINITIONS

Line 31: , pay_time_definitions tdf

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_time_definitions tdf
32: where tdf.time_definition_id = p_time_definition_id
33: and pbg.business_group_id (+) = tdf.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_time_definitions tdf

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_time_definitions tdf
102: where tdf.time_definition_id = p_time_definition_id
103: and pbg.business_group_id (+) = tdf.business_group_id;
104: --
105: -- Declare local variables

Line 390: from pay_time_definitions

386:
387:
388: Cursor csr_time_def_static is
389: select null
390: from pay_time_definitions
391: where period_time_definition_id = p_time_definition_id;
392:
393: Cursor csr_time_def_element is
394: select null

Line 543: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

539: (p_time_definition_id => p_time_definition_id
540: ,p_object_version_number => p_object_version_number);
541:
542: if hr_multi_message.no_exclusive_error
543: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
544: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS'
545: ) and (
546: not l_api_updating or
547: ( l_api_updating and nvl(p_number_of_years, hr_api.g_number) <>

Line 544: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS'

540: ,p_object_version_number => p_object_version_number);
541:
542: if hr_multi_message.no_exclusive_error
543: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
544: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS'
545: ) and (
546: not l_api_updating or
547: ( l_api_updating and nvl(p_number_of_years, hr_api.g_number) <>
548: nvl(pay_tdf_shd.g_old_rec.number_of_years, hr_api.g_number) )

Line 592: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS') then

588: exception
589:
590: when app_exception.application_exception then
591: if hr_multi_message.exception_add
592: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.NUMBER_OF_YEARS') then
593: raise;
594: end if;
595:
596: when others then

Line 661: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

657: hr_utility.trace('Day Adjustment - ' || nvl(p_day_adjustment,'null'));
658: hr_utility.trace('Period Unit - ' || nvl(p_period_unit,'null'));
659: --
660: if hr_multi_message.no_exclusive_error
661: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
662: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.CROSS_VALIDATIONS'
663: ) then
664:
665: if p_definition_type = 'S' then

Line 662: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.CROSS_VALIDATIONS'

658: hr_utility.trace('Period Unit - ' || nvl(p_period_unit,'null'));
659: --
660: if hr_multi_message.no_exclusive_error
661: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
662: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.CROSS_VALIDATIONS'
663: ) then
664:
665: if p_definition_type = 'S' then
666:

Line 719: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.CROSS_VALIDATIONS') then

715: exception
716:
717: when app_exception.application_exception then
718: if hr_multi_message.exception_add
719: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.CROSS_VALIDATIONS') then
720: raise;
721: end if;
722:
723: when others then

Line 788: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

784: (p_time_definition_id => p_time_definition_id
785: ,p_object_version_number => p_object_version_number);
786:
787: if hr_multi_message.no_exclusive_error
788: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
789: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE'
790: ) and (
791: not l_api_updating or
792: ( l_api_updating and nvl(p_period_type, hr_api.g_varchar2) <>

Line 789: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE'

785: ,p_object_version_number => p_object_version_number);
786:
787: if hr_multi_message.no_exclusive_error
788: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
789: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE'
790: ) and (
791: not l_api_updating or
792: ( l_api_updating and nvl(p_period_type, hr_api.g_varchar2) <>
793: nvl(pay_tdf_shd.g_old_rec.period_type, hr_api.g_varchar2 ) )

Line 837: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE') then

833: exception
834:
835: when app_exception.application_exception then
836: if hr_multi_message.exception_add
837: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TYPE') then
838: raise;
839: end if;
840:
841: when others then

Line 895: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

891: (p_time_definition_id => p_time_definition_id
892: ,p_object_version_number => p_object_version_number);
893:
894: if hr_multi_message.no_exclusive_error
895: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
896: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT'
897: ) and (
898: not l_api_updating or
899: ( l_api_updating and nvl(p_period_unit, hr_api.g_varchar2) <>

Line 896: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT'

892: ,p_object_version_number => p_object_version_number);
893:
894: if hr_multi_message.no_exclusive_error
895: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
896: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT'
897: ) and (
898: not l_api_updating or
899: ( l_api_updating and nvl(p_period_unit, hr_api.g_varchar2) <>
900: nvl(pay_tdf_shd.g_old_rec.period_unit, hr_api.g_varchar2) )

Line 920: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT') then

916: exception
917:
918: when app_exception.application_exception then
919: if hr_multi_message.exception_add
920: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_UNIT') then
921: raise;
922: end if;
923:
924: when others then

Line 975: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

971: (p_time_definition_id => p_time_definition_id
972: ,p_object_version_number => p_object_version_number);
973:
974: if hr_multi_message.no_exclusive_error
975: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
976: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADUSTMENT'
977: ) and (
978: not l_api_updating or
979: ( l_api_updating and nvl(p_day_adjustment, hr_api.g_varchar2) <>

Line 976: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADUSTMENT'

972: ,p_object_version_number => p_object_version_number);
973:
974: if hr_multi_message.no_exclusive_error
975: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
976: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADUSTMENT'
977: ) and (
978: not l_api_updating or
979: ( l_api_updating and nvl(p_day_adjustment, hr_api.g_varchar2) <>
980: nvl(pay_tdf_shd.g_old_rec.day_adjustment, hr_api.g_varchar2) )

Line 999: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADJUSTMENT') then

995: exception
996:
997: when app_exception.application_exception then
998: if hr_multi_message.exception_add
999: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.DAY_ADJUSTMENT') then
1000: raise;
1001: end if;
1002:
1003: when others then

Line 1054: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

1050: (p_time_definition_id => p_time_definition_id
1051: ,p_object_version_number => p_object_version_number);
1052:
1053: if hr_multi_message.no_exclusive_error
1054: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
1055: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE'
1056: ) and (
1057: not l_api_updating or
1058: ( l_api_updating and nvl(p_start_date, hr_api.g_date) <>

Line 1055: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE'

1051: ,p_object_version_number => p_object_version_number);
1052:
1053: if hr_multi_message.no_exclusive_error
1054: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
1055: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE'
1056: ) and (
1057: not l_api_updating or
1058: ( l_api_updating and nvl(p_start_date, hr_api.g_date) <>
1059: nvl(pay_tdf_shd.g_old_rec.start_date, hr_api.g_date) )

Line 1087: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE') then

1083: exception
1084:
1085: when app_exception.application_exception then
1086: if hr_multi_message.exception_add
1087: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.START_DATE') then
1088: raise;
1089: end if;
1090:
1091: when others then

Line 1141: from pay_time_definitions ptd

1137: l_exists varchar2(1);
1138:
1139: cursor csr_period_time_definition_id is
1140: select null
1141: from pay_time_definitions ptd
1142: where ptd.time_definition_id = p_period_time_definition_id
1143: and nvl(ptd.definition_type, 'P') = 'P'
1144: and (
1145: ( p_business_group_id is null and

Line 1173: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'

1169: (p_time_definition_id => p_time_definition_id
1170: ,p_object_version_number => p_object_version_number);
1171:
1172: if hr_multi_message.no_exclusive_error
1173: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
1174: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID'
1175: ) and (
1176: not l_api_updating or
1177: ( l_api_updating and nvl(p_period_time_definition_id, hr_api.g_number) <>

Line 1174: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID'

1170: ,p_object_version_number => p_object_version_number);
1171:
1172: if hr_multi_message.no_exclusive_error
1173: (p_check_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE'
1174: ,p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID'
1175: ) and (
1176: not l_api_updating or
1177: ( l_api_updating and nvl(p_period_time_definition_id, hr_api.g_number) <>
1178: nvl(pay_tdf_shd.g_old_rec.period_time_definition_id, hr_api.g_number ) )

Line 1216: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID') then

1212: exception
1213:
1214: when app_exception.application_exception then
1215: if hr_multi_message.exception_add
1216: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.PERIOD_TIME_DEFINITION_ID') then
1217: raise;
1218: end if;
1219:
1220: when others then

Line 1271: from pay_time_definitions ptd

1267: l_exists varchar2(1);
1268:
1269: cursor csr_definition_name is
1270: select null
1271: from pay_time_definitions ptd
1272: where ptd.definition_name = p_definition_name
1273: and (
1274: ( p_business_group_id is null and
1275: p_legislation_code is null and

Line 1334: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_NAME') then

1330: exception
1331:
1332: when app_exception.application_exception then
1333: if hr_multi_message.exception_add
1334: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_NAME') then
1335: raise;
1336: end if;
1337:
1338: when others then

Line 1386: from pay_time_definitions ptd

1382: l_exists varchar2(1);
1383:
1384: cursor csr_short_name is
1385: select null
1386: from pay_time_definitions ptd
1387: where ptd.short_name = p_short_name;
1388:
1389: --
1390: Begin

Line 1420: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.SHORT_NAME') then

1416: exception
1417:
1418: when app_exception.application_exception then
1419: if hr_multi_message.exception_add
1420: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.SHORT_NAME') then
1421: raise;
1422: end if;
1423:
1424: when others then

Line 1508: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE') then

1504: exception
1505:
1506: when app_exception.application_exception then
1507: if hr_multi_message.exception_add
1508: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.DEFINITION_TYPE') then
1509: raise;
1510: end if;
1511:
1512: when others then

Line 1576: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.LEGISLATION_CODE'

1572: --
1573: exception
1574: when app_exception.application_exception then
1575: if hr_multi_message.exception_add
1576: (p_associated_column1 => 'PAY_TIME_DEFINITIONS.LEGISLATION_CODE'
1577: ) then
1578: raise;
1579: end if;
1580: when others then