APPS.BSC_MIGREATION_UI dependencies on BSC_RESPONSIBILITY_VL

Line 93: l_src_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;

89: TYPE CurTyp IS REF CURSOR;
90: cv CurTyp;
91: l_stmt varchar2(2000);
92:
93: l_src_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
94: l_src_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
95: l_tar_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
96: l_tar_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
97:

Line 94: l_src_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

90: cv CurTyp;
91: l_stmt varchar2(2000);
92:
93: l_src_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
94: l_src_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
95: l_tar_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
96: l_tar_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
97:
98: BEGIN

Line 95: l_tar_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;

91: l_stmt varchar2(2000);
92:
93: l_src_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
94: l_src_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
95: l_tar_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
96: l_tar_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
97:
98: BEGIN
99:

Line 96: l_tar_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

92:
93: l_src_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
94: l_src_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
95: l_tar_resp_id BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE;
96: l_tar_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
97:
98: BEGIN
99:
100: l_stmt:= null;

Line 117: FROM bsc_db_loader_control,BSC_RESPONSIBILITY_VL@'||p_dblink_name||

113: (SELECT INPUT_TABLE_NAME,
114: substr(INPUT_TABLE_NAME,3,INSTR(INPUT_TABLE_NAME,''_'',1,1)-3) ROW_COUNT,
115: RESPONSIBILITY_ID,
116: RESPONSIBILITY_NAME
117: FROM bsc_db_loader_control,BSC_RESPONSIBILITY_VL@'||p_dblink_name||
118: ' SRC_RESP WHERE PROCESS_ID = :1 AND INPUT_TABLE_NAME LIKE ''SR%''
119: AND SRC_RESP.RESPONSIBILITY_ID = substr(INPUT_TABLE_NAME,INSTR(INPUT_TABLE_NAME,''_'',1,1)+1)) SRC_RLIST,
120: (SELECT INPUT_TABLE_NAME,
121: substr(INPUT_TABLE_NAME,3,INSTR(INPUT_TABLE_NAME,''_'',1,1)-3) ROW_COUNT,

Line 124: FROM bsc_db_loader_control,BSC_RESPONSIBILITY_VL TAR_RESP

120: (SELECT INPUT_TABLE_NAME,
121: substr(INPUT_TABLE_NAME,3,INSTR(INPUT_TABLE_NAME,''_'',1,1)-3) ROW_COUNT,
122: RESPONSIBILITY_ID,
123: RESPONSIBILITY_NAME
124: FROM bsc_db_loader_control,BSC_RESPONSIBILITY_VL TAR_RESP
125: WHERE PROCESS_ID =:2 AND INPUT_TABLE_NAME LIKE ''TR%''
126: AND TAR_RESP.RESPONSIBILITY_ID = substr(INPUT_TABLE_NAME,INSTR(INPUT_TABLE_NAME,''_'',1,1)+1)) TAR_RLIST
127: WHERE
128: TAR_RLIST.ROW_COUNT =SRC_RLIST.ROW_COUNT';

Line 145: FROM BSC_RESPONSIBILITY_VL@'||p_dblink_name||

141: --this means there is no process on hold
142: -- fetch all the responsibilities that map by default
143: l_stmt:= 'SELECT SRC_RESP.RESPONSIBILITY_ID, SRC_RESP.RESPONSIBILITY_NAME,
144: TAR_RESP.RESPONSIBILITY_ID,TAR_RESP.RESPONSIBILITY_NAME
145: FROM BSC_RESPONSIBILITY_VL@'||p_dblink_name||
146: ' SRC_RESP, FND_RESPONSIBILITY@'||p_dblink_name||
147: ' SRC_FND_RESP, BSC_RESPONSIBILITY_VL TAR_RESP,
148: FND_RESPONSIBILITY TAR_FND_RESP
149: WHERE SRC_RESP.RESPONSIBILITY_ID IN

Line 147: ' SRC_FND_RESP, BSC_RESPONSIBILITY_VL TAR_RESP,

143: l_stmt:= 'SELECT SRC_RESP.RESPONSIBILITY_ID, SRC_RESP.RESPONSIBILITY_NAME,
144: TAR_RESP.RESPONSIBILITY_ID,TAR_RESP.RESPONSIBILITY_NAME
145: FROM BSC_RESPONSIBILITY_VL@'||p_dblink_name||
146: ' SRC_RESP, FND_RESPONSIBILITY@'||p_dblink_name||
147: ' SRC_FND_RESP, BSC_RESPONSIBILITY_VL TAR_RESP,
148: FND_RESPONSIBILITY TAR_FND_RESP
149: WHERE SRC_RESP.RESPONSIBILITY_ID IN
150: (SELECT RESPONSIBILITY_ID FROM BSC_USER_KPI_ACCESS@'||p_dblink_name||
151: ' UNION SELECT RESPONSIBILITY_ID FROM BSC_USER_TAB_ACCESS@'||p_dblink_name||