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_BALANCES_UPLOAD_PKG dependencies on PAY_BALANCE_CATEGORIES_F

Line 21: --This procedure is used for uploading data into table PAY_BALANCE_CATEGORIES_F

17: select session_id
18: from hr_owner_definitions
19: where session_id=p_session_id;
20:
21: --This procedure is used for uploading data into table PAY_BALANCE_CATEGORIES_F
22: --This procedure is called from pybalcat.lct configuration file
23: PROCEDURE PAY_BAL_CATF_LOAD_ROW
24: (p_CATEGORY_NAME IN VARCHAR2
25: ,p_EFFECTIVE_START_DATE IN VARCHAR2

Line 66: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;

62: ,p_OVN IN VARCHAR2
63: ,p_OWNER IN VARCHAR2
64: ) IS
65:
66: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;
68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;

Line 67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;

63: ,p_OWNER IN VARCHAR2
64: ) IS
65:
66: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;
68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;

Line 68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;

64: ) IS
65:
66: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;
68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;

Line 69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;

65:
66: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;
68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
73: l_ovn PAY_BALANCE_CATEGORIES_F.OBJECT_VERSION_NUMBER%TYPE;

Line 70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;

66: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;
68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
73: l_ovn PAY_BALANCE_CATEGORIES_F.OBJECT_VERSION_NUMBER%TYPE;
74: l_owner VARCHAR2(6);

Line 71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;

67: l_category_name PAY_BALANCE_CATEGORIES_F.CATEGORY_NAME%TYPE;
68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
73: l_ovn PAY_BALANCE_CATEGORIES_F.OBJECT_VERSION_NUMBER%TYPE;
74: l_owner VARCHAR2(6);
75: l_nextval NUMBER;

Line 72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;

68: l_effective_start_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_START_DATE%TYPE;
69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
73: l_ovn PAY_BALANCE_CATEGORIES_F.OBJECT_VERSION_NUMBER%TYPE;
74: l_owner VARCHAR2(6);
75: l_nextval NUMBER;
76:

Line 73: l_ovn PAY_BALANCE_CATEGORIES_F.OBJECT_VERSION_NUMBER%TYPE;

69: l_effective_end_date PAY_BALANCE_CATEGORIES_F.EFFECTIVE_END_DATE%TYPE;
70: l_legislation_code PAY_BALANCE_CATEGORIES_F.LEGISLATION_CODE%TYPE;
71: l_business_group_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
72: l_bus_grp_id PAY_BALANCE_CATEGORIES_F.BUSINESS_GROUP_ID%TYPE;
73: l_ovn PAY_BALANCE_CATEGORIES_F.OBJECT_VERSION_NUMBER%TYPE;
74: l_owner VARCHAR2(6);
75: l_nextval NUMBER;
76:
77: cursor csr_sel_bal_category_all is

Line 86: FROM PAY_BALANCE_CATEGORIES_F

82: ,legislation_code
83: ,business_group_id
84: ,object_version_number
85: ,DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
86: FROM PAY_BALANCE_CATEGORIES_F
87: WHERE category_name = p_CATEGORY_NAME
88: AND effective_start_date =to_date(p_EFFECTIVE_START_DATE,'YYYY/MM/DD')
89: AND effective_end_date =to_date(p_EFFECTIVE_END_DATE,'YYYY/MM/DD')
90: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1);

Line 101: FROM PAY_BALANCE_CATEGORIES_F

97: ,legislation_code
98: ,business_group_id
99: ,object_version_number
100: ,DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
101: FROM PAY_BALANCE_CATEGORIES_F
102: WHERE category_name = p_CATEGORY_NAME
103: AND effective_start_date =to_date(p_EFFECTIVE_START_DATE,'YYYY/MM/DD')
104: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1);
105:

Line 115: FROM PAY_BALANCE_CATEGORIES_F

111: ,legislation_code
112: ,business_group_id
113: ,object_version_number
114: ,DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
115: FROM PAY_BALANCE_CATEGORIES_F
116: WHERE category_name = p_CATEGORY_NAME
117: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1);
118:
119: BEGIN

Line 142: update pay_balance_categories_f

138: hr_general2.init_fndload(800,1);
139: else
140: hr_general2.init_fndload(800,-1);
141: end if;
142: update pay_balance_categories_f
143: set
144: save_run_balance_enabled = p_SAVE_RUN_BALANCE_ENABLED
145: ,user_category_name = p_user_category_name
146: ,pbc_information_category = p_PBC_INFORMATION_CATEGORY

Line 194: update pay_balance_categories_f

190: hr_general2.init_fndload(800,1);
191: else
192: hr_general2.init_fndload(800,-1);
193: end if;
194: update pay_balance_categories_f
195: set
196: effective_end_date = to_date(p_EFFECTIVE_END_DATE,'YYYY/MM/DD')
197: ,save_run_balance_enabled = p_SAVE_RUN_BALANCE_ENABLED
198: ,user_category_name = p_user_category_name

Line 240: pay_balance_categories_f(balance_category_id,category_name,

236: else
237: hr_general2.init_fndload(800,-1);
238: end if;
239: insert into
240: pay_balance_categories_f(balance_category_id,category_name,
241: effective_start_date,effective_end_date,legislation_code,
242: business_group_id,save_run_balance_enabled,user_category_name,
243: pbc_information_category,pbc_information1,pbc_information2,
244: pbc_information3,pbc_information4,pbc_information5,

Line 284: pay_balance_categories_f(balance_category_id,category_name,

280: hr_general2.init_fndload(800,-1);
281: end if;
282:
283: insert into
284: pay_balance_categories_f(balance_category_id,category_name,
285: effective_start_date,effective_end_date,legislation_code,
286: business_group_id,save_run_balance_enabled,user_category_name,
287: pbc_information_category,
288: pbc_information1,pbc_information2,pbc_information3,pbc_information4,

Line 339: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;

335: l_legislation_code PAY_BALANCE_TYPES.LEGISLATION_CODE%TYPE;
336: l_business_group_id PAY_BALANCE_TYPES.BUSINESS_GROUP_ID%TYPE;
337: l_ovn PAY_BALANCE_TYPES.object_version_number%TYPE;
338: l_owner VARCHAR2(6);
339: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
340:
341: --This cursor is used to select the balance type id
342: cursor csr_sel_bal_type_id(p_BALANCE_NAME VARCHAR2,
343: p_LEGISLATION_CODE VARCHAR2,

Line 358: from pay_balance_categories_f

354: p_EED VARCHAR2,
355: p_LEGISLATION_CODE VARCHAR2, --Bug 5044079
356: p_bg_id NUMBER) is --Bug 5044079
357: select balance_category_id
358: from pay_balance_categories_f
359: where category_name =p_CATEGORY_NAME
360: and effective_start_date =to_date(p_ESD,'YYYY/MM/DD')
361: and effective_end_date =to_date(p_EED,'YYYY/MM/DD')
362: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1) --Bug 5044079

Line 791: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;

787: )IS
788:
789: l_bal_attribute_default_id
790: PAY_BAL_ATTRIBUTE_DEFAULTS.BAL_ATTRIBUTE_DEFAULT_ID%TYPE;
791: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
792: l_legislation_code PAY_BAL_ATTRIBUTE_DEFAULTS.LEGISLATION_CODE%TYPE;
793: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
794: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
795: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 829: from pay_balance_categories_f

825: p_ESD VARCHAR2,
826: p_EED VARCHAR2,
827: p_LEGISLATION_CODE VARCHAR2) is
828: select balance_category_id
829: from pay_balance_categories_f
830: where category_name =p_CATEGORY_NAME
831: and effective_start_date =to_date(p_ESD,'YYYY/MM/DD')
832: and effective_end_date =to_date(p_EED,'YYYY/MM/DD')
833: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1);

Line 963: -- This procedure provides NLS support for pay_balance_categories_f

959: END;
960:
961: END PAY_BAL_ADF_LOAD_ROW;
962: --
963: -- This procedure provides NLS support for pay_balance_categories_f
964: --
965: procedure translate_row_cat
966: (p_category_name in varchar2
967: ,p_user_category_name in varchar2

Line 983: from pay_balance_categories_f

979: --
980: cursor get_bal_cat_id(p_bg_id number)
981: is
982: select balance_category_id
983: from pay_balance_categories_f
984: where category_name = p_category_name
985: and nvl(business_group_id, -1) = nvl(p_bg_id, -1)
986: and nvl(legislation_code, 'CORE') = nvl(p_legislation_code, 'CORE');
987: --

Line 1011: update pay_balance_categories_f

1007: else
1008: hr_general2.init_fndload(800,-1);
1009: end if;
1010: --
1011: update pay_balance_categories_f
1012: set user_category_name = p_user_category_name
1013: where balance_category_id = l_bal_cat_id
1014: and userenv('LANG') = (select language_code
1015: from fnd_languages