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_RSG_PUB_API_PKG dependencies on BIS_OBJ_DEPENDENCY

Line 23: SELECT object_name FROM bis_obj_dependency

19: FUNCTION get_page_name_by_func (
20: p_func_name IN VARCHAR2) RETURN VARCHAR2
21: IS
22: CURSOR c_page_object_name(p_func_name VARCHAR2) IS
23: SELECT object_name FROM bis_obj_dependency
24: WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA'
25: UNION ALL
26: SELECT object_name FROM bis_obj_properties
27: WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA';

Line 29: v_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617

25: UNION ALL
26: SELECT object_name FROM bis_obj_properties
27: WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA';
28:
29: v_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
30: BEGIN
31: IF (p_func_name IS NULL OR p_func_name = '') THEN
32: RETURN NULL;
33: END IF;

Line 179: FROM bis_obj_dependency

175: p_object_type VARCHAR2) RETURN VARCHAR2 IS
176:
177: CURSOR c_obj_appl_short_name IS
178: SELECT DISTINCT object_owner
179: FROM bis_obj_dependency
180: WHERE object_name = p_object_name AND object_type = p_object_type;
181:
182: CURSOR c_depend_obj_appl_short_name IS
183: SELECT DISTINCT depend_object_owner

Line 184: FROM bis_obj_dependency

180: WHERE object_name = p_object_name AND object_type = p_object_type;
181:
182: CURSOR c_depend_obj_appl_short_name IS
183: SELECT DISTINCT depend_object_owner
184: FROM bis_obj_dependency
185: WHERE depend_object_name = p_object_name AND depend_object_type = p_object_type;
186:
187: l_obj_owner VARCHAR(50);
188: BEGIN

Line 221: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617

217: ) IS
218: v_procedure_name VARCHAR2(50) := 'Create_Dependency';
219: l_object_owner VARCHAR2(50);
220: l_depend_object_owner VARCHAR2(50);
221: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
222: BEGIN
223: FND_MSG_PUB.initialize;
224:
225: -- since page designer passes in fnd_form_function name instead of object name

Line 311: execute immediate 'insert into bis_obj_dependency (

307: END IF;
308: RETURN;
309: END IF;
310:
311: execute immediate 'insert into bis_obj_dependency (
312: OBJECT_TYPE, OBJECT_OWNER, OBJECT_NAME,
313: ENABLED_FLAG,
314: DEPEND_OBJECT_TYPE, DEPEND_OBJECT_OWNER, DEPEND_OBJECT_NAME,
315: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 367: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617

363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_data OUT NOCOPY VARCHAR2
365: ) IS
366: v_procedure_name VARCHAR2(50) := 'Update_Dependency';
367: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
368: BEGIN
369: FND_MSG_PUB.initialize;
370:
371: -- since page designer passes in fnd_form_function name instead of object name

Line 394: execute immediate 'update bis_obj_dependency

390: --dbms_output.put_line('enabled flag validated');
391:
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: execute immediate 'update bis_obj_dependency
395: set enabled_flag = :1,
396: last_updated_by = :2,
397: last_update_login = :3,
398: last_update_date = :4

Line 429: FROM bis_obj_dependency

425: P_OBJECT_NAME in VARCHAR2
426: ) IS
427: CURSOR c_dependencies (p_obj_name VARCHAR2, p_obj_type VARCHAR2) IS
428: SELECT depend_object_name
429: FROM bis_obj_dependency
430: WHERE (object_name = p_obj_name AND object_type = p_obj_type)
431: OR (depend_object_name = p_obj_name AND depend_object_type = p_obj_type);
432:
433: v_dep_obj_name bis_obj_dependency.depend_object_name%TYPE; --Enhancement 4106617

Line 433: v_dep_obj_name bis_obj_dependency.depend_object_name%TYPE; --Enhancement 4106617

429: FROM bis_obj_dependency
430: WHERE (object_name = p_obj_name AND object_type = p_obj_type)
431: OR (depend_object_name = p_obj_name AND depend_object_type = p_obj_type);
432:
433: v_dep_obj_name bis_obj_dependency.depend_object_name%TYPE; --Enhancement 4106617
434: BEGIN
435: OPEN c_dependencies(p_object_name, p_object_type);
436: FETCH c_dependencies INTO v_dep_obj_name;
437: IF (c_dependencies%notfound) THEN

Line 471: execute immediate 'delete from bis_obj_dependency

467: END IF;
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470:
471: execute immediate 'delete from bis_obj_dependency
472: WHERE object_name = :1 AND object_type = :2
473: AND depend_object_name = :3 AND depend_object_type = :4'
474: using l_object_name, p_object_type, p_depend_object_name, p_depend_object_type;
475:

Line 512: from bis_obj_dependency where rowid = rid;

508: l_depend_object_type VARCHAR2(30);
509: l_depend_object_name VARCHAR2(480);
510: cursor get_names(rid varchar2) is
511: select object_name,object_type,depend_object_name,depend_object_type
512: from bis_obj_dependency where rowid = rid;
513: BEGIN
514: open get_names(P_ROWID);
515: fetch get_names into l_object_name,l_object_type,l_depend_object_name,l_depend_object_type;
516: if get_names%NOTFOUND then

Line 536: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617

532: x_return_status OUT NOCOPY VARCHAR2,
533: x_msg_data OUT NOCOPY VARCHAR2
534: ) IS
535: v_procedure_name VARCHAR2(50) := 'Delete_Page_Dependencies';
536: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
537: CURSOR c_deps (p_page_name VARCHAR2) IS
538: SELECT object_name, object_type, depend_object_name, depend_object_type
539: FROM bis_obj_dependency
540: WHERE object_type = 'PAGE' AND object_name = p_page_name;

Line 539: FROM bis_obj_dependency

535: v_procedure_name VARCHAR2(50) := 'Delete_Page_Dependencies';
536: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
537: CURSOR c_deps (p_page_name VARCHAR2) IS
538: SELECT object_name, object_type, depend_object_name, depend_object_type
539: FROM bis_obj_dependency
540: WHERE object_type = 'PAGE' AND object_name = p_page_name;
541: v_dep c_deps%ROWTYPE;
542: BEGIN
543: FND_MSG_PUB.initialize;

Line 551: -- execute immediate 'delete from bis_obj_dependency

547: l_object_name := get_page_name_by_func(p_object_name);
548:
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550:
551: -- execute immediate 'delete from bis_obj_dependency
552: -- WHERE object_name = :1 AND object_type = :2'
553: -- using l_object_name, 'PAGE';
554:
555: -- IF (SQL%notfound) THEN

Line 1353: FROM bis_obj_dependency_v

1349:
1350: CURSOR c_parent_objs (p_dep_obj_name VARCHAR2, p_dep_obj_type VARCHAR2, p_obj_type VARCHAR2) IS
1351: SELECT object_name, user_object_name, object_owner
1352: FROM (SELECT object_name, user_object_name, object_type, object_owner, depend_object_name, depend_object_type
1353: FROM bis_obj_dependency_v
1354: -- get rid of the filter for bug 3867557, i.e., conside both enabled and disabled dependencies
1355: --WHERE enabled_flag = 'Y'
1356: )
1357: WHERE object_type = p_obj_type