APPS.BIS_IMPL_DEV_PKG dependencies on BIS_OBJ_PROG_LINKAGES

Line 77: insert into bis_obj_prog_linkages (

73: IF FND_API.to_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: insert into bis_obj_prog_linkages (
78: OBJECT_TYPE,
79: OBJECT_OWNER,
80: OBJECT_NAME,
81: CONC_PROGRAM_NAME,

Line 248: update bis_obj_prog_linkages

244: FND_MSG_PUB.initialize;
245: END IF;
246:
247: if (P_ROWID is not null) then
248: update bis_obj_prog_linkages
249: set enabled_flag = P_ENABLED_FLAG,
250: conc_program_name = P_CONC_PROGRAM_NAME,
251: conc_app_id = P_CONC_APP_ID,
252: conc_app_short_name = P_CONC_APP_SHORT_NAME,

Line 259: UPDATE BIS_OBJ_PROG_LINKAGES

255: last_update_login = l_last_update_login,
256: last_update_date = l_last_update_date
257: where rowid = P_ROWID;
258: else
259: UPDATE BIS_OBJ_PROG_LINKAGES
260: SET
261: ENABLED_FLAG = P_ENABLED_FLAG,
262: REFRESH_MODE = P_REFRESH_MODE,
263: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,

Line 363: delete from bis_obj_prog_linkages

359: P_ROWID in ROWID
360: ) IS
361: BEGIN
362:
363: delete from bis_obj_prog_linkages
364: where rowid = P_ROWID;
365: If (SQL%NOTFOUND) then
366: RAISE NO_DATA_FOUND;
367: End If;

Line 551: -- bis_obj_prog_linkages object

547: AND NOT exists (SELECT 1 FROM bis_obj_dependency dep
548: WHERE dep.object_type = d.depend_object_type
549: AND dep.object_name = d.depend_object_name))
550: UNION ALL
551: -- bis_obj_prog_linkages object
552: (SELECT DISTINCT l.object_name
553: FROM bis_obj_prog_linkages l
554: WHERE bis_impl_dev_pkg.get_user_object_name(l.object_type, l.object_name) = p_user_object_name
555: AND l.object_type = p_object_type

Line 553: FROM bis_obj_prog_linkages l

549: AND dep.object_name = d.depend_object_name))
550: UNION ALL
551: -- bis_obj_prog_linkages object
552: (SELECT DISTINCT l.object_name
553: FROM bis_obj_prog_linkages l
554: WHERE bis_impl_dev_pkg.get_user_object_name(l.object_type, l.object_name) = p_user_object_name
555: AND l.object_type = p_object_type
556: AND NOT exists (SELECT 1 FROM bis_obj_properties prop
557: WHERE prop.object_type = l.object_type

Line 593: -- bis_obj_prog_linkages object

589: AND NOT exists (SELECT 1 FROM bis_obj_dependency dep
590: WHERE dep.object_type = d.depend_object_type
591: AND dep.object_name = d.depend_object_name))
592: UNION ALL
593: -- bis_obj_prog_linkages object
594: (SELECT DISTINCT l.object_name
595: FROM bis_obj_prog_linkages l
596: WHERE bis_impl_dev_pkg.get_user_object_name(l.object_type, l.object_name) = p_user_object_name
597: AND l.object_type = p_object_type

Line 595: FROM bis_obj_prog_linkages l

591: AND dep.object_name = d.depend_object_name))
592: UNION ALL
593: -- bis_obj_prog_linkages object
594: (SELECT DISTINCT l.object_name
595: FROM bis_obj_prog_linkages l
596: WHERE bis_impl_dev_pkg.get_user_object_name(l.object_type, l.object_name) = p_user_object_name
597: AND l.object_type = p_object_type
598: AND l.object_name = p_object_name
599: AND NOT exists (SELECT 1 FROM bis_obj_properties prop

Line 873: from bis_obj_prog_linkages

869: P_OBJECT_NAME in VARCHAR2) RETURN VARCHAR2
870: IS
871: Cursor C_Program(P_OBJECT_TYPE VARCHAR2, P_OBJECT_NAME VARCHAR2) IS
872: select distinct conc_program_name
873: from bis_obj_prog_linkages
874: where object_type = P_OBJECT_TYPE
875: and object_name = P_OBJECT_NAME
876: and enabled_flag = 'Y';
877:

Line 1190: execute immediate 'update bis_obj_prog_linkages set object_owner = :1

1186: execute immediate 'update bis_obj_properties set object_owner = :1
1187: WHERE object_type = :2 AND object_name = :3'
1188: using P_DEPEND_OBJECT_OWNER, P_DEPEND_OBJECT_TYPE, P_DEPEND_OBJECT_NAME;
1189:
1190: execute immediate 'update bis_obj_prog_linkages set object_owner = :1
1191: WHERE object_type = :2 AND object_name = :3'
1192: using P_DEPEND_OBJECT_OWNER, P_DEPEND_OBJECT_TYPE, P_DEPEND_OBJECT_NAME;
1193:
1194: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1889: execute immediate 'update bis_obj_prog_linkages set object_owner = :1

1885: execute immediate 'update bis_obj_properties set object_owner = :1
1886: WHERE object_type = :2 AND object_name = :3'
1887: using p_obj_owner, p_obj_type, p_obj_name;
1888:
1889: execute immediate 'update bis_obj_prog_linkages set object_owner = :1
1890: WHERE object_type = :2 AND object_name = :3'
1891: using p_obj_owner, p_obj_type, p_obj_name;
1892: EXCEPTION
1893: WHEN OTHERS THEN

Line 1913: select CREATED_BY from bis_obj_prog_linkages

1909: where DEPEND_OBJECT_NAME = l_obj_name and depend_OBJECT_TYPE = l_obj_type;
1910:
1911:
1912: cursor c_obj_prog(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is
1913: select CREATED_BY from bis_obj_prog_linkages
1914: where OBJECT_NAME = l_obj_name and OBJECT_TYPE = l_obj_type;
1915:
1916: cursor c_obj_prop(l_obj_name VARCHAR2, l_obj_type VARCHAR2) is
1917: select CREATED_BY from bis_obj_properties