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_UCI_BUS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 30: , pay_user_column_instances_f uci

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_user_column_instances_f uci
31: where uci.user_column_instance_id = p_user_column_instance_id
32: and pbg.business_group_id = uci.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pay_user_column_instances_f uci

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_user_column_instances_f uci
95: where uci.user_column_instance_id = p_user_column_instance_id
96: and pbg.business_group_id (+) = uci.business_group_id;
97: --
98: -- Declare local variables

Line 536: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.LEGISLATION_CODE'

532: --
533: exception
534: when app_exception.application_exception then
535: if hr_multi_message.exception_add
536: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.LEGISLATION_CODE'
537: ) then
538: raise;
539: end if;
540: when others then

Line 642: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'

638:
639: exception
640: when app_exception.application_exception then
641: if hr_multi_message.exception_add
642: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
643: ) then
644: raise;
645: end if;
646: when others then

Line 740: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'

736:
737: exception
738: when app_exception.application_exception then
739: if hr_multi_message.exception_add
740: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
741: ) then
742: raise;
743: end if;
744: when others then

Line 757: -- Validates that there may only one row in PAY_USER_COLUMN_INSTANCES_F

753: -- |------------------------< chk_row_column_id >-----------------------------|
754: -- ----------------------------------------------------------------------------
755: --
756: -- Description:
757: -- Validates that there may only one row in PAY_USER_COLUMN_INSTANCES_F
758: -- with the combination of USER_ROW_ID and USER_COLUMN_ID for the life time
759: -- of the row being insert for the specified and in a particular business
760: -- group or legislation.
761: --

Line 797: from pay_user_column_instances_f uci

793: ) is
794: --
795: cursor csr_row_column_id is
796: select null
797: from pay_user_column_instances_f uci
798: where uci.user_row_id = p_user_row_id
799: and uci.user_column_id = p_user_column_id
800: and ( p_business_group_id is null
801: or ( p_business_group_id is not null and p_business_group_id = uci.business_group_id )

Line 823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'

819:
820: hr_utility.set_location('Entering:'|| l_proc, 10);
821:
822: if hr_multi_message.no_exclusive_error
823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
825: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
826: ,p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
827: ) then

Line 824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'

820: hr_utility.set_location('Entering:'|| l_proc, 10);
821:
822: if hr_multi_message.no_exclusive_error
823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
825: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
826: ,p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
827: ) then
828: --

Line 825: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'

821:
822: if hr_multi_message.no_exclusive_error
823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
825: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
826: ,p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
827: ) then
828: --
829: open csr_row_column_id;

Line 826: ,p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'

822: if hr_multi_message.no_exclusive_error
823: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
824: ,p_check_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
825: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID'
826: ,p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
827: ) then
828: --
829: open csr_row_column_id;
830: fetch csr_row_column_id into l_exists;

Line 847: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID',

843: exception
844:
845: when app_exception.application_exception then
846: if hr_multi_message.exception_add
847: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID',
848: p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID') then
849: raise;
850: end if;
851:

Line 848: p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID') then

844:
845: when app_exception.application_exception then
846: if hr_multi_message.exception_add
847: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_ROW_ID',
848: p_associated_column2 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID') then
849: raise;
850: end if;
851:
852: when others then

Line 908: l_min_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;

904: ) is
905: --
906:
907: l_formula_id PAY_USER_COLUMNS.FORMULA_ID%TYPE;
908: l_min_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
909: l_max_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
910:
911: l_version_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
912: l_version_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;

Line 909: l_max_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;

905: --
906:
907: l_formula_id PAY_USER_COLUMNS.FORMULA_ID%TYPE;
908: l_min_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
909: l_max_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
910:
911: l_version_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
912: l_version_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
913:

Line 911: l_version_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;

907: l_formula_id PAY_USER_COLUMNS.FORMULA_ID%TYPE;
908: l_min_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
909: l_max_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
910:
911: l_version_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
912: l_version_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
913:
914: l_proc varchar2(72) := g_package||'chk_value';
915: l_formula_status varchar2(10);

Line 912: l_version_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;

908: l_min_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
909: l_max_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
910:
911: l_version_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
912: l_version_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
913:
914: l_proc varchar2(72) := g_package||'chk_value';
915: l_formula_status varchar2(10);
916: l_formula_message fnd_new_messages.message_text%type;

Line 945: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'

941: hr_utility.set_location(' Entering:'||l_proc, 10);
942: --
943:
944: if hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
946: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE'
947: ) and (
948: not pay_uci_shd.api_updating
949: (p_user_column_instance_id => p_user_column_instance_id

Line 946: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE'

942: --
943:
944: if hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID'
946: ,p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE'
947: ) and (
948: not pay_uci_shd.api_updating
949: (p_user_column_instance_id => p_user_column_instance_id
950: ,p_effective_date => p_effective_date

Line 1060: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE') then

1056:
1057: Exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 => 'PAY_USER_COLUMN_INSTANCES_F.VALUE') then
1061: raise;
1062: end if;
1063:
1064: when others then