APPS.QA_CHAR_UPDATE_PKG dependencies on QA_PLAN_CHARS

Line 241: TYPE result_column_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE

237:
238: l_api_name CONSTANT VARCHAR2(30) := 'update_results';
239:
240: TYPE number_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
241: TYPE result_column_tab IS TABLE OF qa_plan_chars.result_column_name%TYPE
242: INDEX BY BINARY_INTEGER;
243:
244: l_plan_ids number_tab;
245: l_result_columns result_column_tab;

Line 269: qa_plan_chars qpc,

265: BULK COLLECT INTO
266: l_plan_ids,
267: l_result_columns
268: FROM qa_chars qc,
269: qa_plan_chars qpc,
270: qa_plans qp
271: WHERE qc.hardcoded_column IS NULL
272: AND qc.char_id = qpc.char_id
273: AND qpc.char_id = p_char_id

Line 378: UPDATE QA_PLAN_CHARS

374: )
375: IS
376: l_api_name CONSTANT VARCHAR2(30) := 'update_plan_chars';
377: BEGIN
378: UPDATE QA_PLAN_CHARS
379: SET default_value = p_new_value
380: WHERE char_id = p_char_id
381: AND default_value = p_old_value;
382:

Line 388: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHARS.default_value for char_id: ' || p_char_id

384: FND_LOG.string
385: (
386: FND_LOG.level_statement,
387: g_pkg_name || '.' || l_api_name,
388: 'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHARS.default_value for char_id: ' || p_char_id
389: );
390: END IF;
391: END update_plan_chars;
392:

Line 474: FROM QA_PLAN_CHARS

470: AND low_value_other = p_old_value
471: AND plan_id IN
472: (
473: SELECT DISTINCT plan_id
474: FROM QA_PLAN_CHARS
475: WHERE char_id = p_char_id
476: );
477:
478: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 494: FROM QA_PLAN_CHARS

490: AND high_value_other = p_old_value
491: AND plan_id IN
492: (
493: SELECT DISTINCT plan_id
494: FROM QA_PLAN_CHARS
495: WHERE char_id = p_char_id
496: );
497:
498: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 526: QA_PLAN_CHARS qpc

522: AND plan_transaction_id IN
523: (
524: SELECT qpt.plan_transaction_id
525: FROM QA_PLAN_TRANSACTIONS qpt,
526: QA_PLAN_CHARS qpc
527: WHERE qpt.plan_id = qpc.plan_id
528: AND qpc.char_id = p_char_id
529: );
530:

Line 548: QA_PLAN_CHARS qpc

544: AND plan_transaction_id IN
545: (
546: SELECT qpt.plan_transaction_id
547: FROM QA_PLAN_TRANSACTIONS qpt,
548: QA_PLAN_CHARS qpc
549: WHERE qpt.plan_id = qpc.plan_id
550: AND qpc.char_id = p_char_id
551: );
552:

Line 582: QA_PLAN_CHARS qpc

578: (
579: SELECT qch.criteria_id
580: FROM QA_CRITERIA_HEADERS qch,
581: QA_PLANS qp,
582: QA_PLAN_CHARS qpc
583: WHERE qch.organization_id = qp.organization_id
584: AND qp.plan_id = qpc.plan_id
585: AND qpc.char_id = p_char_id
586: );

Line 606: QA_PLAN_CHARS qpc

602: (
603: SELECT qch.criteria_id
604: FROM QA_CRITERIA_HEADERS qch,
605: QA_PLANS qp,
606: QA_PLAN_CHARS qpc
607: WHERE qch.organization_id = qp.organization_id
608: AND qp.plan_id = qpc.plan_id
609: AND qpc.char_id = p_char_id
610: );

Line 640: QA_PLAN_CHARS qpc

636: AND plan_relationship_id IN
637: (
638: SELECT qppr.plan_relationship_id
639: FROM QA_PC_PLAN_RELATIONSHIP qppr,
640: QA_PLAN_CHARS qpc
641: WHERE qppr.parent_plan_id = qpc.plan_id
642: AND qpc.char_id = p_char_id
643: );
644:

Line 662: QA_PLAN_CHARS qpc

658: AND plan_relationship_id IN
659: (
660: SELECT qppr.plan_relationship_id
661: FROM QA_PC_PLAN_RELATIONSHIP qppr,
662: QA_PLAN_CHARS qpc
663: WHERE qppr.parent_plan_id = qpc.plan_id
664: AND qpc.char_id = p_char_id
665: );
666:

Line 724: FROM QA_PLAN_CHARS qpc,

720: l_api_version CONSTANT NUMBER := 1.0;
721:
722: CURSOR plan_cur IS
723: SELECT 'Y'
724: FROM QA_PLAN_CHARS qpc,
725: QA_PLANS qp
726: WHERE qpc.char_id = p_char_id
727: AND qpc.plan_id = qp.plan_id
728: AND qp.organization_id <> 0;