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_BAL_ATTRIBUTE_DEFINITIONS

Line 398: --This procedure is used for uploading data into PAY_BAL_ATTRIBUTE_DEFINITIONS

394: close csr_sel_bal_type_id;
395:
396: END PAY_BAL_TYPES_LOAD_ROW;
397:
398: --This procedure is used for uploading data into PAY_BAL_ATTRIBUTE_DEFINITIONS
399: --This is called from pybalade.lct configuration file
400: PROCEDURE PAY_BAL_ADE_LOAD_ROW
401: (p_ATTRIBUTE_NAME IN VARCHAR2
402: ,p_LEGISLATION_CODE IN VARCHAR2

Line 409: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;

405: ,p_user_attribute_name IN VARCHAR2
406: ,p_OWNER IN VARCHAR2
407: ) IS
408:
409: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
410: l_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_NAME%TYPE;
411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;
412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;
413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;

Line 410: l_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_NAME%TYPE;

406: ,p_OWNER IN VARCHAR2
407: ) IS
408:
409: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
410: l_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_NAME%TYPE;
411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;
412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;
413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;
414: l_owner VARCHAR2(6);

Line 411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;

407: ) IS
408:
409: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
410: l_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_NAME%TYPE;
411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;
412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;
413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;
414: l_owner VARCHAR2(6);
415: l_temp_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;

Line 412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;

408:
409: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
410: l_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_NAME%TYPE;
411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;
412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;
413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;
414: l_owner VARCHAR2(6);
415: l_temp_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
416: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

Line 413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;

409: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
410: l_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_NAME%TYPE;
411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;
412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;
413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;
414: l_owner VARCHAR2(6);
415: l_temp_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
416: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
417: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

Line 415: l_temp_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;

411: l_legislation_code PAY_BAL_ATTRIBUTE_DEFINITIONS.LEGISLATION_CODE%TYPE;
412: l_business_group_id PAY_BAL_ATTRIBUTE_DEFINITIONS.BUSINESS_GROUP_ID%TYPE;
413: l_alterable PAY_BAL_ATTRIBUTE_DEFINITIONS.ALTERABLE%TYPE;
414: l_owner VARCHAR2(6);
415: l_temp_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
416: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
417: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
418:
419: --cursors to check if child rows exist

Line 420: cursor csr_pba_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)

416: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
417: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
418:
419: --cursors to check if child rows exist
420: cursor csr_pba_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)
421: is
422: select attribute_id
423: from pay_balance_attributes
424: where attribute_id=p_attrib_id;

Line 426: cursor csr_pbad_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)

422: select attribute_id
423: from pay_balance_attributes
424: where attribute_id=p_attrib_id;
425:
426: cursor csr_pbad_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)
427: is
428: select attribute_id
429: from pay_bal_attribute_defaults
430: where attribute_id=p_attrib_id;

Line 441: FROM PAY_BAL_ATTRIBUTE_DEFINITIONS

437: attribute_name,
438: alterable,
439: legislation_code,
440: DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
441: FROM PAY_BAL_ATTRIBUTE_DEFINITIONS
442: WHERE attribute_name = p_ATTRIBUTE_NAME
443: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
444: AND (business_group_id=p_bg_id OR business_group_id is NULL);
445:

Line 513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');

509: --raise error ask to rerun the ldts after deleting the child
510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;
516:
517: open csr_pbad_id(l_attribute_id);

Line 526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');

522: --raise error ask to rerun the ldts after deleting the child
523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
529:
530: update PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 530: update PAY_BAL_ATTRIBUTE_DEFINITIONS

526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
529:
530: update PAY_BAL_ATTRIBUTE_DEFINITIONS
531: set ALTERABLE =p_ALTERABLE
532: where attribute_id=l_attribute_id;
533:
534: elsif((l_business_group_id is null and l_legislation_code is not

Line 539: update PAY_BAL_ATTRIBUTE_DEFINITIONS

535: null) AND (l_ALTERABLE ='N' and p_ALTERABLE='Y')) then
536: --updating from N to Y...since child rows dont exist can do direct
537: --update
538:
539: update PAY_BAL_ATTRIBUTE_DEFINITIONS
540: set ALTERABLE =p_ALTERABLE
541: where attribute_id=l_attribute_id;
542:
543: end if;

Line 598: from pay_bal_attribute_definitions

594: cursor csr_sel_attrib_id(p_ATTRIBUTE_NAME VARCHAR2,
595: p_LEGISLATION_CODE VARCHAR2,
596: p_bg_id NUMBER) is
597: select attribute_id
598: from pay_bal_attribute_definitions
599: where attribute_name = p_ATTRIBUTE_NAME
600: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
601: and (business_group_id =p_bg_id or business_group_id is null);
602:

Line 793: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;

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;
796: l_attr_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
797: l_cat_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 818: from pay_bal_attribute_definitions

814: cursor csr_sel_attrib_id(p_ATTRIBUTE_NAME VARCHAR2,
815: p_LEGISLATION_CODE VARCHAR2,
816: p_bg_id NUMBER) is
817: select attribute_id
818: from pay_bal_attribute_definitions
819: where attribute_name =p_ATTRIBUTE_NAME
820: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
821: and (business_group_id =p_bg_id or business_group_id is null);
822:

Line 1020: -- This procedure provides NLS support for pay_bal_attribute_definitions

1016: where installed_flag = 'B');
1017: --
1018: END translate_row_cat;
1019: --
1020: -- This procedure provides NLS support for pay_bal_attribute_definitions
1021: --
1022: procedure translate_row_attrib
1023: (p_attribute_name in varchar2
1024: ,p_user_attribute_name in varchar2

Line 1040: from pay_bal_attribute_definitions

1036: --
1037: cursor get_att_def_id(p_bg_id number)
1038: is
1039: select attribute_id
1040: from pay_bal_attribute_definitions
1041: where attribute_name = p_attribute_name
1042: and nvl(business_group_id, -1) = nvl(p_bg_id, -1)
1043: and nvl(legislation_code, 'CORE') = nvl(p_legislation_code, 'CORE');
1044: --

Line 1068: update pay_bal_attribute_definitions

1064: else
1065: hr_general2.init_fndload(800,-1);
1066: end if;
1067: --
1068: update pay_bal_attribute_definitions
1069: set user_attribute_name = p_user_attribute_name
1070: where attribute_id = l_att_def_id
1071: and userenv('LANG') = (select language_code
1072: from fnd_languages