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 HR_OWNER_DEFINITIONS

Line 12: --Cursor to determine if session id is present in hr_owner_definitions

8: select business_group_id
9: from per_business_groups
10: where name =p_BG_NAME;
11:
12: --Cursor to determine if session id is present in hr_owner_definitions
13: CURSOR csr_get_session_id IS
14: SELECT userenv('sessionid') from dual;
15:
16: cursor csr_get_hr_sess_id(p_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE) is

Line 16: cursor csr_get_hr_sess_id(p_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE) is

12: --Cursor to determine if session id is present in hr_owner_definitions
13: CURSOR csr_get_session_id IS
14: SELECT userenv('sessionid') from dual;
15:
16: cursor csr_get_hr_sess_id(p_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE) is
17: select session_id
18: from hr_owner_definitions
19: where session_id=p_session_id;
20:

Line 18: from hr_owner_definitions

14: SELECT userenv('sessionid') from dual;
15:
16: cursor csr_get_hr_sess_id(p_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE) is
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

Line 416: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%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
420: cursor csr_pba_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)

Line 417: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_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
420: cursor csr_pba_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)
421: is

Line 590: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

586: l_legislation_code PAY_BALANCE_ATTRIBUTES.LEGISLATION_CODE%TYPE;
587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;
588: l_def_bal_bg_id PAY_DEFINED_BALANCES.BUSINESS_GROUP_ID%TYPE;
589: l_owner VARCHAR2(6);
590: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
591: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
592:
593: --This cursor is used to select the attribute id
594: cursor csr_sel_attrib_id(p_ATTRIBUTE_NAME VARCHAR2,

Line 591: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;
588: l_def_bal_bg_id PAY_DEFINED_BALANCES.BUSINESS_GROUP_ID%TYPE;
589: l_owner VARCHAR2(6);
590: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
591: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
592:
593: --This cursor is used to select the attribute id
594: cursor csr_sel_attrib_id(p_ATTRIBUTE_NAME VARCHAR2,
595: p_LEGISLATION_CODE VARCHAR2,

Line 800: l_session_id HR_OWNER_DEFINITIONS.SESSION_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;
798: l_dim_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
799: l_owner VARCHAR2(6);
800: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
801: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
802:
803: --This cursor is used to select the balance dimension id
804: cursor csr_sel_bal_dim_id(p_DIMENSION_NAME VARCHAR2,

Line 801: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

797: l_cat_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
798: l_dim_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
799: l_owner VARCHAR2(6);
800: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
801: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
802:
803: --This cursor is used to select the balance dimension id
804: cursor csr_sel_bal_dim_id(p_DIMENSION_NAME VARCHAR2,
805: p_LEGISLATION_CODE VARCHAR2,