APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_OBJ_SET_TEMP

Line 852: from BIS_OBJ_SET_TEMP

848: cursor c_portlet_report_in_set (p_request_id number) is
849: select distinct object_type,
850: object_name,
851: object_owner
852: from BIS_OBJ_SET_TEMP
853: where request_id=p_request_id
854: and object_type in ('REPORT','PORTLET');
855:
856:

Line 862: from BIS_OBJ_SET_TEMP

858: cursor c_pages_in_set(p_request_id number) is
859: select distinct object_type,
860: object_name,
861: object_owner
862: from BIS_OBJ_SET_TEMP
863: where request_id=p_request_id
864: and object_type ='PAGE';
865:
866:

Line 1041: from BIS_OBJ_SET_TEMP

1037:
1038: cursor c_obj_with_program(p_request_id number) is
1039: select distinct object_type,
1040: object_name
1041: from BIS_OBJ_SET_TEMP
1042: where request_id=p_request_id
1043: and has_program='Y'
1044: union
1045: select distinct object_type,

Line 1047: from BIS_OBJ_SET_TEMP

1043: and has_program='Y'
1044: union
1045: select distinct object_type,
1046: object_name
1047: from BIS_OBJ_SET_TEMP
1048: where request_id=p_request_id
1049: and object_type='MV';
1050:
1051:

Line 1100: l_sql:='insert into BIS_OBJ_SET_TEMP(request_id,'||

1096: open c_obj_has_program(l_top_obj_type, l_top_obj_name);
1097: fetch c_obj_has_program into l_obj_has_program;
1098: close c_obj_has_program;
1099:
1100: l_sql:='insert into BIS_OBJ_SET_TEMP(request_id,'||
1101: 'object_name,'||
1102: 'object_type,'||
1103: 'object_owner,'||
1104: 'has_program) '||