APPS.FND_FORM_CUSTOM_RULES_PKG SQL Statements

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

Line: 3

g_function_rows_deleted  VARCHAR2(30) := 'NULL';

Line: 4

g_form_rows_deleted      VARCHAR2(30) := 'NULL';

Line: 5

g_industry_rows_deleted  VARCHAR2(30) := 'NULL';

Line: 6

  PROCEDURE  DELETE_ROWS(
                 X_FUNCTION_NAME   IN VARCHAR2) IS

    BEGIN
       if  g_function_rows_deleted = X_FUNCTION_NAME then
         RETURN;

Line: 13

         delete from fnd_form_custom_params
                where action_id in (select action_id
                                    from fnd_form_custom_actions a , fnd_form_custom_rules r
                                    where a.rule_id = r.id
                                    and r.created_by <> 1
                                    and r.function_name = X_FUNCTION_NAME
                                    and (r.rule_type = 'A'or r.rule_type is null));

Line: 20

         delete from fnd_form_custom_actions
                where rule_id in (select id
                                  from fnd_form_custom_rules r
                                  where r.created_by <> 1
                                  and r.function_name = X_FUNCTION_NAME
                                  and (r.rule_type = 'A'or r.rule_type is null));

Line: 26

         delete from fnd_form_custom_scopes
                where rule_id in (select id
                                  from fnd_form_custom_rules r
                                  where r.created_by <> 1
                                  and r.function_name = X_FUNCTION_NAME
                                  and (r.rule_type = 'A'or r.rule_type is null));

Line: 32

         delete from fnd_form_custom_rules
                where created_by <> 1
                and function_name = X_FUNCTION_NAME
                and (rule_type = 'A'or rule_type is null);

Line: 36

         g_function_rows_deleted := X_FUNCTION_NAME;

Line: 38

    END DELETE_ROWS;

Line: 40

    PROCEDURE  DELETE_FORM_ROWS(
                   X_FORM_NAME   IN VARCHAR2) IS

    BEGIN
       if  g_form_rows_deleted = X_FORM_NAME then
         RETURN;

Line: 47

         delete from fnd_form_custom_params
                where action_id in (select action_id
                                    from fnd_form_custom_actions a , fnd_form_custom_rules r
                                    where a.rule_id = r.id
                                    and r.created_by <> 1
                                    and r.form_name = X_FORM_NAME
                                    and r.rule_type = 'F');

Line: 54

         delete from fnd_form_custom_actions
                where rule_id in (select id
                                  from fnd_form_custom_rules r
                                  where r.created_by <> 1
                                  and r.form_name = X_FORM_NAME
                                  and r.rule_type = 'F');

Line: 60

         delete from fnd_form_custom_scopes
                where rule_id in (select id
                                  from fnd_form_custom_rules r
                                  where r.created_by <> 1
                                  and r.form_name = X_FORM_NAME
                                  and r.rule_type = 'F');

Line: 66

         delete from fnd_form_custom_rules
                where created_by <> 1
                and form_name = X_FORM_NAME
                and rule_type = 'F';

Line: 70

         g_form_rows_deleted := X_FORM_NAME;

Line: 72

    END DELETE_FORM_ROWS;

Line: 74

    PROCEDURE  DELETE_INDUSTRY_ROWS(
                   X_RULE_KEY    IN VARCHAR2,
                   X_FORM_NAME   IN VARCHAR2 DEFAULT NULL) IS

    BEGIN

       if  (g_form_rows_deleted = X_FORM_NAME OR X_FORM_NAME IS NULL)
           AND g_industry_rows_deleted = X_RULE_KEY then
         RETURN;

Line: 84

         delete from fnd_form_custom_params
                where action_id in (select action_id
                                    from fnd_form_custom_actions a , fnd_form_custom_rules r
                                    where a.rule_id = r.id
                                    and r.created_by =  8
                                    and r.rule_key = X_RULE_KEY
                                    and X_FORM_NAME IS NULL or (X_FORM_NAME IS NOT NULL and
                                                                r.form_name = X_FORM_NAME));

Line: 92

         delete from fnd_form_custom_actions
                where rule_id in (select id
                                  from fnd_form_custom_rules r
                                  where r.created_by = 8
                                  and r.rule_key = X_RULE_KEY
                                  and X_FORM_NAME IS NULL or (X_FORM_NAME IS NOT NULL and
                                                                r.form_name = X_FORM_NAME));

Line: 99

         delete from fnd_form_custom_scopes
                where rule_id in (select id
                                  from fnd_form_custom_rules r
                                  where r.created_by = 8
                                  and r.rule_key = X_RULE_KEY
                                  and X_FORM_NAME IS NULL or (X_FORM_NAME IS NOT NULL and
                                                               r.form_name = X_FORM_NAME));

Line: 106

         delete from fnd_form_custom_rules
                where created_by = 8
                and rule_key = X_RULE_KEY
                and X_FORM_NAME IS NULL or (X_FORM_NAME IS NOT NULL and
                                            form_name = X_FORM_NAME);

Line: 111

         g_form_rows_deleted := X_FORM_NAME;

Line: 112

         g_industry_rows_deleted := X_RULE_KEY;

Line: 114

    END DELETE_INDUSTRY_ROWS;