APPS.IMC_THREE_SIXTY_QUERY_PKG dependencies on IMC_THREE_SIXTY_QUERY_B

Line 47: insert into IMC_THREE_SIXTY_QUERY_B (

43:
44: CLOSE C2;
45: END IF;
46: begin
47: insert into IMC_THREE_SIXTY_QUERY_B (
48: QUERY_ID,
49: APPLICATION_ID,
50: QUERY_TYPE_FLAG,
51: PRODUCT_QUERY1,

Line 178: from IMC_THREE_SIXTY_QUERY_B

174: BE_CODE,
175: CATEGORY_CODE,
176: OPERATING_UNIT_FLAG,
177: OBJECT_VERSION_NUMBER
178: from IMC_THREE_SIXTY_QUERY_B
179: where QUERY_ID = X_QUERY_ID
180: for update of QUERY_ID nowait;
181: recinfo c%rowtype;
182:

Line 268: update IMC_THREE_SIXTY_QUERY_B set

264: X_OBJECT_VERSION_NUMBER in NUMBER
265: ) is
266:
267: begin
268: update IMC_THREE_SIXTY_QUERY_B set
269: APPLICATION_ID = X_APPLICATION_ID,
270: QUERY_TYPE_FLAG = X_QUERY_TYPE_FLAG,
271: PRODUCT_QUERY1 = X_PRODUCT_QUERY1,
272: PRODUCT_QUERY2 = X_PRODUCT_QUERY2,

Line 322: delete from IMC_THREE_SIXTY_QUERY_B

318: if (sql%notfound) then
319: raise no_data_found;
320: end if;
321:
322: delete from IMC_THREE_SIXTY_QUERY_B
323: where QUERY_ID = X_QUERY_ID;
324:
325: if (sql%notfound) then
326: raise no_data_found;

Line 336: from IMC_THREE_SIXTY_QUERY_B B

332: begin
333: delete from IMC_THREE_SIXTY_QUERY_TL T
334: where not exists
335: (select NULL
336: from IMC_THREE_SIXTY_QUERY_B B
337: where B.QUERY_ID = T.QUERY_ID
338: );
339:
340: update IMC_THREE_SIXTY_QUERY_TL T set (