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_CUST_RESTRICTIONS_PKG dependencies on PAY_CUSTOMIZED_RESTRICTIONS

Line 9: FROM PAY_CUSTOMIZED_RESTRICTIONS

5: is
6: result varchar2(255);
7: Begin
8: SELECT count(*) INTO result
9: FROM PAY_CUSTOMIZED_RESTRICTIONS
10: WHERE UPPER(FORM_NAME) = UPPER(x_form_name)
11: and UPPER(NAME) = UPPER(x_name)
12: and BUSINESS_GROUP_ID is NULL
13: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_LEGISLATION_CODE,'~null~');

Line 41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;

37: )
38: is
39: l_proc VARCHAR2(61) := 'PAY_CUST_RESTRICTIONS_PKG.LOAD_ROW';
40: l_rowid rowid;
41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;

Line 42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;

38: is
39: l_proc VARCHAR2(61) := 'PAY_CUST_RESTRICTIONS_PKG.LOAD_ROW';
40: l_rowid rowid;
41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;

Line 43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;

39: l_proc VARCHAR2(61) := 'PAY_CUST_RESTRICTIONS_PKG.LOAD_ROW';
40: l_rowid rowid;
41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;

Line 44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;

40: l_rowid rowid;
41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
48: l_legislation_subgroup PAY_CUSTOMIZED_RESTRICTIONS.legislation_subgroup%TYPE;

Line 45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;

41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
48: l_legislation_subgroup PAY_CUSTOMIZED_RESTRICTIONS.legislation_subgroup%TYPE;
49:

Line 46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;

42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
48: l_legislation_subgroup PAY_CUSTOMIZED_RESTRICTIONS.legislation_subgroup%TYPE;
49:
50:

Line 47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;

43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;
44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
48: l_legislation_subgroup PAY_CUSTOMIZED_RESTRICTIONS.legislation_subgroup%TYPE;
49:
50:
51:

Line 48: l_legislation_subgroup PAY_CUSTOMIZED_RESTRICTIONS.legislation_subgroup%TYPE;

44: l_last_updated_by PAY_CUSTOMIZED_RESTRICTIONS.last_updated_by%TYPE := 0;
45: l_last_update_login PAY_CUSTOMIZED_RESTRICTIONS.last_update_login%TYPE := 0;
46: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
47: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
48: l_legislation_subgroup PAY_CUSTOMIZED_RESTRICTIONS.legislation_subgroup%TYPE;
49:
50:
51:
52: CURSOR C_APPL IS

Line 59: from PAY_CUSTOMIZED_RESTRICTIONS pcr

55: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
56:
57: CURSOR C1 IS
58: select customized_restriction_id,application_id,legislation_subgroup
59: from PAY_CUSTOMIZED_RESTRICTIONS pcr
60: where upper(pcr.form_name) = upper(X_FORM_NAME)
61: and upper(pcr.name) = upper(X_NAME)
62: and pcr.business_group_id is null
63: and nvl(pcr.legislation_code,'~null~') = nvl(X_LEGISLATION_CODE,'~null~');

Line 144: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;

140: X_QUERY_FORM_TITLE VARCHAR2,
141: X_STANDARD_FORM_TITLE VARCHAR2 )
142: is
143:
144: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
145:
146: CURSOR C1 IS
147: select customized_restriction_id
148: from PAY_CUSTOMIZED_RESTRICTIONS pcr

Line 148: from PAY_CUSTOMIZED_RESTRICTIONS pcr

144: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
145:
146: CURSOR C1 IS
147: select customized_restriction_id
148: from PAY_CUSTOMIZED_RESTRICTIONS pcr
149: where upper(pcr.form_name) = upper(X_FORM_NAME)
150: and upper(pcr.name) = upper(X_NAME)
151: and pcr.business_group_id is null
152: and nvl(pcr.legislation_code,'~null~') = nvl(X_LEGISLATION_CODE,'~null~') ;