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.BIS_CREATE_REQUESTSET dependencies on BIS_OBJ_DEPENDENCY

Line 27: object_owner bis_obj_dependency.object_owner%TYPE,

23: g_bsc_auto_gen_exist varchar2(1);
24:
25: -- FOR PING
26: TYPE T_PING_REC IS RECORD (
27: object_owner bis_obj_dependency.object_owner%TYPE,
28: object_type bis_obj_dependency.object_type%TYPE,
29: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE,
30: HAS_DATA VARCHAR2(10));
31: TYPE T_PING_TABLE IS TABLE OF T_PING_REC;

Line 28: object_type bis_obj_dependency.object_type%TYPE,

24:
25: -- FOR PING
26: TYPE T_PING_REC IS RECORD (
27: object_owner bis_obj_dependency.object_owner%TYPE,
28: object_type bis_obj_dependency.object_type%TYPE,
29: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE,
30: HAS_DATA VARCHAR2(10));
31: TYPE T_PING_TABLE IS TABLE OF T_PING_REC;
32:

Line 29: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE,

25: -- FOR PING
26: TYPE T_PING_REC IS RECORD (
27: object_owner bis_obj_dependency.object_owner%TYPE,
28: object_type bis_obj_dependency.object_type%TYPE,
29: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE,
30: HAS_DATA VARCHAR2(10));
31: TYPE T_PING_TABLE IS TABLE OF T_PING_REC;
32:
33: g_ping_table T_PING_TABLE;

Line 36: object_type bis_obj_dependency.object_type%TYPE,

32:
33: g_ping_table T_PING_TABLE;
34:
35: TYPE object_rec is record(
36: object_type bis_obj_dependency.object_type%TYPE,
37: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE
38: );
39: TYPE object_table is table of object_rec;
40:

Line 37: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE

33: g_ping_table T_PING_TABLE;
34:
35: TYPE object_rec is record(
36: object_type bis_obj_dependency.object_type%TYPE,
37: OBJECT_NAME bis_obj_dependency.OBJECT_NAME%TYPE
38: );
39: TYPE object_table is table of object_rec;
40:
41: g_apps_schema_name varchar2(30);

Line 318: bis_obj_dependency

314: depend_object_name,
315: depend_object_type,
316: enabled_flag
317: from
318: bis_obj_dependency
319: where enabled_flag='Y'
320: and depend_object_type<>'REPORT'
321: and object_type<>'REPORT'
322: ) obj

Line 376: from bis_obj_dependency

372: ( select object_name,
373: object_type,
374: depend_object_name,
375: depend_object_type
376: from bis_obj_dependency
377: where enabled_flag='Y') dep
378: where dep.depend_object_type<>'REPORT'
379: start with dep.object_type = 'REPORT'
380: and dep.object_name=p_report_name

Line 453: bis_obj_dependency

449: depend_object_type,
450: depend_object_owner,
451: enabled_flag
452: from
453: bis_obj_dependency
454: where enabled_flag='Y' ) obj
455: start with obj.object_type =p_object_type
456: and obj.object_name = p_object_name
457: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name

Line 1023: bis_obj_dependency a

1019: a.object_type ,
1020: a.object_owner ,
1021: a.object_name
1022: from
1023: bis_obj_dependency a
1024: where enabled_flag='Y') temp
1025: start with object_type =p_object_type
1026: and object_name = p_object_name
1027: connect by prior DEPEND_OBJECT_NAME=object_name

Line 1036: bis_obj_dependency

1032: object_type,
1033: object_name,
1034: 1 mylevel
1035: from
1036: bis_obj_dependency
1037: where enabled_flag='Y'
1038: and object_type =p_object_type
1039: and object_name = p_object_name
1040: union

Line 1047: bis_obj_dependency

1043: depend_object_type object_type,
1044: depend_object_name object_name,
1045: 1 mylevel
1046: from
1047: bis_obj_dependency
1048: where enabled_flag='Y'
1049: and depend_object_type =p_object_type
1050: and depend_object_name = p_object_name
1051: union --added for bug 4648079 auto gen report with custom calendar

Line 1073: bis_obj_dependency a

1069: a.object_type ,
1070: a.object_owner ,
1071: a.object_name
1072: from
1073: bis_obj_dependency a
1074: where enabled_flag='Y') temp
1075: start with object_type=p_object_type
1076: and object_name = p_object_name
1077: connect by prior depend_object_name=object_name

Line 1129: l_objectname bis_obj_dependency.object_name%type;

1125: l_exist_stage varchar2(30);
1126: l_exist_stage_number number;
1127: l_exist_sequence number;
1128: l_max_program_seq number;
1129: l_objectname bis_obj_dependency.object_name%type;
1130: l_level number;
1131: l_set_application varchar2(30);
1132: l_setname varchar2(30);
1133: l_process_counter integer;

Line 1780: from bis_obj_dependency a

1776: select distinct
1777: depend_object_type object_type,
1778: depend_OBJECT_NAME object_name,
1779: level
1780: from bis_obj_dependency a
1781: where a.enabled_flag='Y'
1782: and a.object_type<>'VIEW'
1783: and EXISTS( Select 'Y' from bis_obj_properties b
1784: where a.depend_object_name=b.object_name

Line 1794: from bis_obj_dependency a

1790: order by level desc;
1791:
1792: cursor c_max_level is
1793: select max(level)
1794: from bis_obj_dependency a
1795: where a.enabled_flag='Y'
1796: and EXISTS ( Select 'Y' from bis_obj_properties b
1797: where a.depend_object_name=b.object_name
1798: and a.depend_object_type=b.object_type

Line 2171: from bis_obj_dependency a,

2167: select 'Y'
2168: from dual
2169: where exists
2170: (select a.depend_object_name
2171: from bis_obj_dependency a,
2172: bis_obj_properties b
2173: where a.depend_object_name=b.object_name(+)
2174: and a.depend_object_type=b.object_type(+)
2175: and a.object_name=p_object_name

Line 2356: bis_obj_dependency

2352: depend_object_type,
2353: depend_object_owner,
2354: enabled_flag
2355: from
2356: bis_obj_dependency
2357: where enabled_flag='Y' ) obj
2358: start with obj.object_type =p_object_type
2359: and obj.object_name = p_object_name
2360: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name

Line 3169: cursor c_owner is select distinct OBJECT_OWNER from bis_obj_dependency

3165: varchar2) is
3166: l_stmt VARCHAR2 (2000);
3167: l_object_owner varchar2(50):=null;
3168: l_set_app_id number;
3169: cursor c_owner is select distinct OBJECT_OWNER from bis_obj_dependency
3170: where object_type=p_object_type and object_name=p_object_name;
3171: l_module varchar2(300) := 'bis.BIS_CREATE_REQUESTSET.create_rs_objects';
3172: l_func1 varchar2(300);
3173: l_func2 varchar2(300);

Line 3960: bis_obj_dependency

3956: depend_object_type,
3957: depend_object_owner,
3958: enabled_flag
3959: from
3960: bis_obj_dependency
3961: where enabled_flag='Y' ) obj
3962: start with obj.object_type =p_object_type
3963: and obj.object_name = p_object_name
3964: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name

Line 4178: bis_obj_dependency

4174: depend_object_type,
4175: depend_object_owner,
4176: enabled_flag
4177: from
4178: bis_obj_dependency
4179: where enabled_flag='Y' ) obj
4180: start with obj.object_type =p_object_type
4181: and obj.object_name = p_object_name
4182: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name