APPS.CRP_FORM_PK dependencies on CRP_FORM_QUERY

Line 56: INSERT INTO crp_form_query

52: 1 - Checked (yes)
53: 2 - unchecked (no)
54: ==================================*/
55: IF (arg_type = RATE_BASED) THEN
56: INSERT INTO crp_form_query
57: (query_id,
58: last_update_date,
59: last_updated_by,
60: last_update_login,

Line 93: INSERT INTO crp_form_query

89: wl.line_id = arg_line_id)
90: AND wl.organization_id = arg_org_id;
91:
92: ELSE
93: INSERT INTO crp_form_query
94: (query_id,
95: last_update_date,
96: last_updated_by,
97: last_update_login,

Line 176: update crp_form_query query

172: arg_query_id2 NUMBER,
173: arg_line_capacity NUMBER) IS
174: BEGIN
175: if arg_line_capacity = 2 then
176: update crp_form_query query
177: set (number11, number12) =
178: (select ROUND(greatest(NVL(PERIOD1,-1),
179: greatest(NVL(PERIOD2,-1),
180: greatest(NVL(PERIOD3,-1),

Line 225: update crp_form_query query

221: | THis statement has been intentionally split to avoid a PL/SQL |
222: | parser stack overflow |
223: +----------------------------------------------------------------*/
224:
225: update crp_form_query query
226: set (number11, number12) =
227: (select ROUND(greatest(NVL(query.number11,-1),
228: greatest(NVL(PERIOD19,-1),
229: greatest(NVL(PERIOD20,-1),

Line 273: update crp_form_query

269: and cap.query_id = arg_query_id1)
270: where query_id = arg_query_id2
271: and number5 is not null;
272:
273: update crp_form_query
274: set number11 = NULL
275: where query_id = arg_query_id2
276: and number11 = -1
277: and number5 is not null;

Line 279: update crp_form_query

275: where query_id = arg_query_id2
276: and number11 = -1
277: and number5 is not null;
278:
279: update crp_form_query
280: set number12 = NULL
281: where query_id = arg_query_id2
282: and number12 = 100000000
283: and number5 is not null;

Line 286: update crp_form_query query

282: and number12 = 100000000
283: and number5 is not null;
284:
285: else
286: update crp_form_query query
287: set (number7, number8) =
288: (select ROUND(greatest(NVL(PERIOD1,-1),
289: greatest(NVL(PERIOD2,-1),
290: greatest(NVL(PERIOD3,-1),

Line 333: update crp_form_query query

329: where query_id = arg_query_id2
330: and number5 is null;
331:
332:
333: update crp_form_query query
334: set (number7, number8) =
335: (select ROUND(greatest(NVL(query.number7, 0),
336: greatest(NVL(PERIOD19,-1),
337: greatest(NVL(PERIOD20,-1),

Line 381: update crp_form_query

377: and cap.query_id = arg_query_id1)
378: where query_id = arg_query_id2
379: and number5 is null;
380:
381: update crp_form_query
382: set number7 = NULL
383: where query_id = arg_query_id2
384: and number7 = -1
385: and number5 is null;

Line 387: update crp_form_query

383: where query_id = arg_query_id2
384: and number7 = -1
385: and number5 is null;
386:
387: update crp_form_query
388: set number8 = NULL
389: where query_id = arg_query_id2
390: and number8 = 100000000
391: and number5 is null;

Line 411: INSERT INTO crp_form_query(

407: rows_inserted NUMBER;
408: BEGIN
409:
410: IF (arg_type = ROUTING_BASED) then
411: INSERT INTO crp_form_query(
412: query_id,
413: last_update_date,
414: last_updated_by,
415: last_update_login,

Line 428: FROM crp_form_query query

424: SYSDATE,
425: -1,
426: number2,
427: number3
428: FROM crp_form_query query
429: WHERE not exists
430: (SELECT null
431: FROM crp_capacity_plans
432: WHERE query_id = arg_session_id

Line 439: INSERT INTO crp_form_query(

435: AND number13 = 1
436: AND query.query_id = arg_query_id1;
437: rows_inserted := SQL%ROWCOUNT;
438: ELSE
439: INSERT INTO crp_form_query(
440: query_id,
441: last_update_date,
442: last_updated_by,
443: last_update_login,

Line 454: FROM crp_form_query query

450: -1,
451: SYSDATE,
452: -1,
453: number5
454: FROM crp_form_query query
455: WHERE not exists
456: (SELECT null
457: FROM crp_capacity_plans
458: WHERE query_id = arg_session_id