5: -- Global variables
6: --
7: RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
8: LDGR_ID GL_LEDGERS.LEDGER_ID%TYPE;
9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;
10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;
11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;
12: BAL_MGMT_SEG_COL_NAME VARCHAR2(2000);
13:
6: --
7: RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
8: LDGR_ID GL_LEDGERS.LEDGER_ID%TYPE;
9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;
10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;
11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;
12: BAL_MGMT_SEG_COL_NAME VARCHAR2(2000);
13:
14: -- Added under the bug 4730993
7: RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
8: LDGR_ID GL_LEDGERS.LEDGER_ID%TYPE;
9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;
10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;
11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;
12: BAL_MGMT_SEG_COL_NAME VARCHAR2(2000);
13:
14: -- Added under the bug 4730993
15: RESP_APPLICATION_ID FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
107: BEGIN
108: -- Get chart of accounts id based upon Access Set
109: SELECT chart_of_accounts_id, security_segment_code
110: INTO COA_ID, SECURITY_SEGMENT_CODE
111: FROM GL_ACCESS_SETS
112: WHERE access_set_id = ACCESS_ID;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN
115: RETURN;