APPS.QA_JRAD_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    SELECT 1
    FROM qa_plan_transactions
    WHERE plan_id = c_plan_id
    AND transaction_number = c_txn_no
    AND enabled_flag = 1;

Line: 193

        SELECT 1
        FROM qa_pc_plan_relationship
        WHERE parent_plan_id = p_plan_id
        OR child_plan_id = p_plan_id;

Line: 269

        SELECT prompt
        FROM qa_plan_chars
        WHERE plan_id = p_plan_id
        AND char_id = p_element_id;

Line: 305

    ELSIF (p_prefix = g_last_update_date_attribute) THEN
        label := fnd_message.get_string('QA','QA_SS_ENTRY_DATE');

Line: 365

   ELSIF (INSTR(p_code, g_last_update_date_attribute) <> 0) THEN
       column_name := 'LAST_UPDATE_DATE';

Line: 506

        SELECT 'TRUE'
        FROM qa_txn_collection_triggers
        WHERE transaction_number = p_txn_number
        --AND search_flag = 1
        AND enabled_flag = 1
        AND collection_trigger_id = p_element_id;

Line: 587

    x_parents.delete();

Line: 738

        SELECT 1
        FROM qa_plan_char_actions
        WHERE assigned_char_id = p_char_id
        AND plan_char_action_trigger_id
        IN (SELECT plan_char_action_trigger_id
                  FROM qa_plan_char_action_triggers
                  WHERE plan_id = p_plan_id);

Line: 812

        SELECT NAME from qa_plans
        WHERE plan_id = p_plan_id;

Line: 1243

        SELECT displayed_flag, mandatory_flag, prompt, read_only_flag
        FROM qa_plan_chars
        WHERE plan_id = p_plan_id
        AND   char_id = p_char_id;

Line: 1249

        SELECT name, datatype
        FROM qa_chars
        WHERE char_id = p_char_id;

Line: 1362

    l_update_flag               VARCHAR2(1)  DEFAULT 'Y';

Line: 1553

    IF (p_attribute_code = g_update_attribute) THEN

        -- dbms_output.put_line('Display Sequence: ' || l_display_sequence);

Line: 1559

         l_label_long := fnd_message.get_string('QA', 'QA_SS_JRAD_UPDATE');

Line: 1562

         l_image_file_name := 'updateicon_enabled.gif';

Line: 1624

    IF (p_attribute_code = g_last_update_date_attribute) THEN
        -- Assign a datatype of DATETIME to last_update_date.
        l_data_type := convert_data_type(qa_ss_const.datetime_datatype);

Line: 1669

           jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');

Line: 1670

           jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');

Line: 1671

           jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');

Line: 1712

        SELECT char_id
        FROM qa_plan_chars
        WHERE plan_id = p_plan_id
        AND enabled_flag = 1;

Line: 1858

        jdr_docbuilder.deleteDocument(l_old_doc_name);

Line: 1899

        SELECT char_id
        FROM qa_plan_chars
        WHERE plan_id = p_plan_id
        AND enabled_flag = 1
        ORDER BY PROMPT_SEQUENCE;

Line: 1984

      child1 := add_special_region_item (p_attribute_code         => g_last_update_date_attribute,
                                         p_plan_id                => p_plan_id,
                                         p_prefix                 => p_prefix,
                                         p_region_code            => l_region_code);

Line: 2007

         child1 := add_special_region_item (p_attribute_code         => g_update_attribute,
                                            p_plan_id                => p_plan_id,
                                            p_prefix                 => p_prefix,
                                            p_region_code            => l_region_code);

Line: 2050

      jdr_docbuilder.deleteDocument(l_old_doc_name);

Line: 2091

        SELECT jrad_doc_ver
        FROM QA_PLANS
        WHERE PLAN_ID = p_plan_id;

Line: 2228

        UPDATE QA_PLANS
        SET JRAD_DOC_VER = l_jrad_doc_ver
        WHERE PLAN_ID = p_plan_id;

Line: 2232

        NULL; --dont update here...calling procedure will update

Line: 2272

    SELECT jrad_upgrade_ver
    INTO   l_jrad_upgrade_ver
    FROM   qa_plans
    WHERE  plan_id = p_plan_id
    FOR UPDATE;

Line: 2278

    SELECT jrad_upgrade_ver
    INTO   l_seed_ver
    FROM   qa_plans
    WHERE  plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;

Line: 2294

    SELECT jrad_doc_ver
    INTO   l_jrad_doc_ver
    FROM   qa_plans
    WHERE  plan_id = p_plan_id;

Line: 2316

        SELECT 1
        FROM   qa_txn_collection_triggers qtct
        WHERE  qtct.transaction_number = txn_number
        AND    qtct.collection_trigger_id = element_id;