APPS.BIS_RSG_PUB_API_PKG dependencies on BIS_OBJ_PROG_LINKAGES

Line 1013: execute immediate 'insert into bis_obj_prog_linkages (

1009: using p_appl_short_name;
1010:
1011: --dbms_output.put_line('7');
1012:
1013: execute immediate 'insert into bis_obj_prog_linkages (
1014: OBJECT_TYPE, OBJECT_OWNER, OBJECT_NAME,
1015: CONC_PROGRAM_NAME, CONC_APP_ID, CONC_APP_SHORT_NAME,
1016: ENABLED_FLAG, REFRESH_MODE,
1017: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 1093: execute immediate 'update bis_obj_prog_linkages

1089: --dbms_output.put_line('2');
1090:
1091: x_return_status := FND_API.G_RET_STS_SUCCESS;
1092:
1093: execute immediate 'update bis_obj_prog_linkages
1094: set enabled_flag = :1,
1095: refresh_mode = :2,
1096: last_updated_by = :3,
1097: last_update_login = :4,

Line 1152: execute immediate 'update bis_obj_prog_linkages

1148: END IF;
1149:
1150: x_return_status := FND_API.G_RET_STS_SUCCESS;
1151:
1152: execute immediate 'update bis_obj_prog_linkages
1153: set enabled_flag = :1,
1154: last_updated_by = :2,
1155: last_update_login = :3,
1156: last_update_date = :4

Line 1206: execute immediate 'update bis_obj_prog_linkages

1202: END IF;
1203:
1204: x_return_status := FND_API.G_RET_STS_SUCCESS;
1205:
1206: execute immediate 'update bis_obj_prog_linkages
1207: set refresh_mode = :1,
1208: last_updated_by = :2,
1209: last_update_login = :3,
1210: last_update_date = :4

Line 1246: execute immediate 'delete from bis_obj_prog_linkages

1242: BEGIN
1243: FND_MSG_PUB.initialize;
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245:
1246: execute immediate 'delete from bis_obj_prog_linkages
1247: WHERE object_name = :1 AND object_type = :2
1248: AND conc_program_name = :3 AND conc_app_short_name = :4'
1249: using p_object_name, p_object_type,
1250: p_conc_prog_name, p_appl_short_name;

Line 1283: from bis_obj_prog_linkages where rowid = rid;

1279: l_conc_prog_name VARCHAR2(30);
1280: l_appl_short_name VARCHAR2(50);
1281: cursor get_names(rid varchar2) is
1282: select object_name,object_type,conc_program_name,conc_app_short_name
1283: from bis_obj_prog_linkages where rowid = rid;
1284: BEGIN
1285: open get_names(P_ROWID);
1286: fetch get_names into l_object_name,l_object_type,l_conc_prog_name,l_appl_short_name;
1287: if get_names%NOTFOUND then

Line 1312: execute immediate 'delete from bis_obj_prog_linkages

1308: BEGIN
1309: FND_MSG_PUB.initialize;
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311:
1312: execute immediate 'delete from bis_obj_prog_linkages
1313: WHERE object_name = :1 AND object_type = :2'
1314: using p_object_name, p_object_type;
1315:
1316: --IF (SQL%notfound) THEN