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_TYPES

Line 321: --This procedure is used for uploading data into table PAY_BALANCE_TYPES

317: close csr_sel_bal_category_few;
318:
319: END PAY_BAL_CATF_LOAD_ROW;
320:
321: --This procedure is used for uploading data into table PAY_BALANCE_TYPES
322: --This is called from pybalcat.lct configuration file
323: PROCEDURE PAY_BAL_TYPES_LOAD_ROW
324: (p_CATEGORY_NAME IN VARCHAR2
325: ,p_EFFECTIVE_START_DATE IN VARCHAR2

Line 333: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;

329: ,p_BUSINESS_GROUP_NAME IN VARCHAR2
330: ,p_OWNER IN VARCHAR2 --added
331: ) IS
332:
333: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
334: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%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;

Line 334: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

330: ,p_OWNER IN VARCHAR2 --added
331: ) IS
332:
333: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
334: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%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);

Line 335: l_legislation_code PAY_BALANCE_TYPES.LEGISLATION_CODE%TYPE;

331: ) IS
332:
333: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
334: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%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;

Line 336: l_business_group_id PAY_BALANCE_TYPES.BUSINESS_GROUP_ID%TYPE;

332:
333: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
334: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%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:

Line 337: l_ovn PAY_BALANCE_TYPES.object_version_number%TYPE;

333: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
334: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%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

Line 346: FROM PAY_BALANCE_TYPES

342: cursor csr_sel_bal_type_id(p_BALANCE_NAME VARCHAR2,
343: p_LEGISLATION_CODE VARCHAR2,
344: p_bg_id NUMBER) is--added
345: SELECT balance_type_id
346: FROM PAY_BALANCE_TYPES
347: WHERE balance_name =p_BALANCE_NAME
348: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
349: and (business_group_id =p_bg_id or business_group_id is null);--added
350:

Line 388: update pay_balance_types

384: else
385: hr_general2.init_fndload(800,-1);
386: end if;
387:
388: update pay_balance_types
389: set balance_category_id =l_balance_category_id
390: where balance_type_id=l_balance_type_id;
391: end if;
392: close csr_sel_bal_cat_id;

Line 583: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;

579: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
580: l_bal_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
581: l_attr_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
582: l_attribute_id PAY_BALANCE_ATTRIBUTES.ATTRIBUTE_ID%TYPE;
583: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
584: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
585: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
586: l_legislation_code PAY_BALANCE_ATTRIBUTES.LEGISLATION_CODE%TYPE;
587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;

Line 620: from pay_balance_types

616: cursor csr_sel_bal_type_id(p_BALANCE_NAME VARCHAR2,
617: p_LEGISLATION_CODE VARCHAR2,
618: p_bg_id NUMBER) is
619: select balance_type_id
620: from pay_balance_types
621: where balance_name =p_BALANCE_NAME
622: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
623: and (business_group_id =p_bg_id or business_group_id is null);
624: