DBA Data[Home] [Help]

APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_BIA_RSG_PSTATE

Line 1196: AND BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> 'ANAL'

1192: SELECT 'Y', START_DATE
1193: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_CONCURRENT_REQUESTS FND
1194: WHERE OBJECTS.object_name = p_obj_name
1195: AND OBJECTS.object_type = p_obj_type
1196: AND BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> 'ANAL'
1197: AND OBJECTS.request_set_name = HISTORY.request_set_name
1198: AND HISTORY.PHASE_CODE = 'R'
1199: AND HISTORY.REQUEST_ID = FND.REQUEST_ID
1200: AND FND.STATUS_CODE <> 'X'

Line 1224: WHERE BIS_BIA_RSG_PSTATE.get_refresh_mode(RS.REQUEST_SET_NAME) <> 'ANAL'

1220: FROM bis_request_set_objects
1221: WHERE object_name = p_obj_name
1222: AND object_type IN ('REPORT','PORTLET')
1223: ) RS, BIS_RS_RUN_HISTORY HISTORY, FND_CONCURRENT_REQUESTS FND
1224: WHERE BIS_BIA_RSG_PSTATE.get_refresh_mode(RS.REQUEST_SET_NAME) <> 'ANAL'
1225: AND RS.REQUEST_SET_NAME = HISTORY.REQUEST_SET_NAME AND HISTORY.PHASE_CODE = 'R'
1226: AND HISTORY.REQUEST_ID = FND.REQUEST_ID AND FND.STATUS_CODE <> 'X'
1227: ORDER BY START_DATE;
1228: BEGIN

Line 1293: where function_name='BIS_BIA_RSG_PSTATE_REPORT';

1289: web_html_call,
1290: parameters
1291: from
1292: fnd_form_functions
1293: where function_name='BIS_BIA_RSG_PSTATE_REPORT';
1294:
1295: begin
1296:
1297: --moved the code out of if condition for enhancement 4638578