APPS.PSA_IMPLEMENTATION SQL Statements

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

Line: 29

        SELECT status
        INTO p_enabled_flag
        FROM psa_implementation_all
        WHERE org_id    = p_org_id
        AND psa_feature = p_psa_feature;

Line: 52

        SELECT status
        INTO l_enabled_flag
        FROM psa_implementation_all
        WHERE org_id = p_org_id
        AND psa_feature = p_psa_feature;

Line: 61

            UPDATE psa_implementation_all
            SET status      = 'Y'
            WHERE org_id    = p_org_id
            AND psa_feature = p_psa_feature;

Line: 68

            INSERT INTO psa_implementation_all(psa_feature
                                              ,status
                                              ,org_id)
            VALUES (p_psa_feature
                   ,'Y'
                   ,p_org_id);

Line: 84

        SELECT status
        INTO l_enabled_flag
        FROM psa_implementation_all
        WHERE org_id    = p_org_id
        AND psa_feature = p_psa_feature;

Line: 93

            UPDATE psa_implementation_all
            SET status      = 'N'
            WHERE org_id    = p_org_id
            AND psa_feature = p_psa_feature;

Line: 101

            INSERT INTO psa_implementation_all(psa_feature
                                              ,status
                                              ,org_id)
            VALUES (p_psa_feature
                   ,'N'
                   ,p_org_id);