APPS.BIS_RSG_PUB_API_PKG dependencies on BIS_OBJ_PROPERTIES

Line 26: SELECT object_name FROM bis_obj_properties

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';
28:
29: v_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
30: BEGIN

Line 59: execute immediate 'select 1 from bis_obj_properties

55: x_return_status := 'Y';
56:
57: -- those with _OA attached must have already exist in RSG repository
58: BEGIN
59: execute immediate 'select 1 from bis_obj_properties
60: WHERE object_type = :1 AND object_name = :2'
61: INTO v_dummy
62: using 'PAGE', p_object_name;
63: RETURN;

Line 153: execute immediate 'insert into bis_obj_properties (

149: v_procedure_name VARCHAR2(50) := 'Create_Property';
150: BEGIN
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: execute immediate 'insert into bis_obj_properties (
154: object_type, OBJECT_NAME, OBJECT_OWNER,
155: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
156: LAST_UPDATE_LOGIN, LAST_UPDATE_DATE)
157: values(:1, :2, :3, :4, :5, :6, :7, :8)'

Line 438: execute immediate 'delete from bis_obj_properties

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
438: execute immediate 'delete from bis_obj_properties
439: where object_type = :1 and object_name = :2'
440: using p_object_type, p_object_name;
441: END IF;
442: CLOSE c_dependencies;

Line 563: -- execute immediate 'delete from bis_obj_properties

559: -- END IF;
560: -- x_msg_data := 'BIS_BIA_RSG_PAGE_NOT_EXISTS';
561: -- END IF;
562:
563: -- execute immediate 'delete from bis_obj_properties
564: -- WHERE object_name = :1 AND object_type = :2'
565: -- using l_object_name, 'PAGE';
566:
567: OPEN c_deps(l_object_name);

Line 623: execute immediate 'update bis_obj_properties

619: END IF;
620:
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: execute immediate 'update bis_obj_properties
624: set dimension_flag = :1,
625: custom_api = :2,
626: last_updated_by = :3,
627: last_update_login = :4,

Line 684: execute immediate 'update bis_obj_properties

680: END IF;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: execute immediate 'update bis_obj_properties
685: set dimension_flag = :1,
686: last_updated_by = :2,
687: last_update_login = :3,
688: last_update_date = :4

Line 732: execute immediate 'update bis_obj_properties

728: END IF;
729:
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: execute immediate 'update bis_obj_properties
733: set custom_api = :1,
734: last_updated_by = :2,
735: last_update_login = :3,
736: last_update_date = :4

Line 783: execute immediate 'update bis_obj_properties

779: END IF;
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: execute immediate 'update bis_obj_properties
784: set SNAPSHOT_LOG_SQL = :1,
785: last_updated_by = :2,
786: last_update_login = :3,
787: last_update_date = :4

Line 838: from bis_obj_properties

834:
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:
837: execute immediate 'select snapshot_log_sql
838: from bis_obj_properties
839: WHERE object_name = :1 AND object_type = :2'
840: INTO v_snapshot_log
841: using l_object_name, p_object_type;
842: