DBA Data[Home] [Help]

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: 374

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

        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: 596

    x_parents.delete();
Line: 768

        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: 842

        SELECT NAME from qa_plans
        WHERE plan_id = p_plan_id;
Line: 1273

        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: 1279

        SELECT name, datatype
        FROM qa_chars
        WHERE char_id = p_char_id;
Line: 1419

    l_update_flag               VARCHAR2(1)  DEFAULT 'Y';
Line: 1610

    IF (p_attribute_code = g_update_attribute) THEN

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

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

         l_image_file_name := 'updateicon_enabled.gif';
Line: 1681

    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: 1732

           jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
Line: 1733

           jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
Line: 1734

           jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
Line: 1796

        SELECT char_id
        FROM qa_plan_chars
        WHERE plan_id = p_plan_id
        AND enabled_flag = 1 ORDER BY displayed_flag, prompt_sequence;
Line: 1957

        jdr_docbuilder.deleteDocument(l_old_doc_name);
Line: 1998

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

      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: 2111

         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: 2154

      jdr_docbuilder.deleteDocument(l_old_doc_name);
Line: 2195

        SELECT jrad_doc_ver
        FROM QA_PLANS
        WHERE PLAN_ID = p_plan_id;
Line: 2332

        UPDATE QA_PLANS
        SET JRAD_DOC_VER = l_jrad_doc_ver
        WHERE PLAN_ID = p_plan_id;
Line: 2336

        NULL; --dont update here...calling procedure will update
Line: 2376

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

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

    SELECT jrad_doc_ver
    INTO   l_jrad_doc_ver
    FROM   qa_plans
    WHERE  plan_id = p_plan_id;
Line: 2420

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