APPS.PJM_UPDATE_AK_REGION_ITEMS_PKG SQL Statements

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

Line: 14

        SELECT  COLUMN_PROMPT, Column_ORDER
        FROM    PA_STATUS_COLUMN_SETUP
        WHERE   FOLDER_CODE='T'
          AND   COLUMN_PROMPT IS NOT NULL;

Line: 20

        SELECT  COLUMN_PROMPT, Column_ORDER
        FROM    PA_STATUS_COLUMN_SETUP
        WHERE   FOLDER_CODE='R'
          AND   COLUMN_PROMPT IS NOT NULL;

Line: 30

     UPDATE ak_region_items
     SET    node_display_flag = 'N'
     WHERE  region_code in ('PJM_ALL_PROJ_STATUS',
                            'PJM_ALL_PROJ_TASK_STATUS',
                            'PJM_ALL_PROJ_RSRC_STATUS')
       AND  object_attribute_flag = 'Y';

Line: 42

        update ak_region_items
        set    node_display_flag = 'Y'
        where  region_code = 'PJM_ALL_PROJ_STATUS'
          and  substr(attribute_code,7) = to_char(var_column_order);

Line: 47

        update ak_region_items_tl
        set    attribute_label_long = substr(var_column_prompt,1,50)
        where  region_code = 'PJM_ALL_PROJ_STATUS'
          and  substr(attribute_code,7) = to_char(var_column_order);

Line: 60

        update ak_region_items
        set    node_display_flag = 'Y'
        where  region_code = 'PJM_ALL_PROJ_TASK_STATUS'
          and  substr(attribute_code,7) = to_char(var_column_order);

Line: 65

        update ak_region_items_tl
        set    attribute_label_long = substr(var_column_prompt,1,50)
        where  region_code = 'PJM_ALL_PROJ_TASK_STATUS'
          and  substr(attribute_code,7) = to_char(var_column_order);

Line: 78

        update ak_region_items
        set    node_display_flag = 'Y'
        where  region_code = 'PJM_ALL_PROJ_RSRC_STATUS'
          and  substr(attribute_code,7) = to_char(var_column_order);

Line: 83

        update ak_region_items_tl
        set    attribute_label_long = substr(var_column_prompt,1,50)
        where  region_code = 'PJM_ALL_PROJ_RSRC_STATUS'
          and  substr(attribute_code,7) = to_char(var_column_order);

Line: 95

  END UPDATE_PA_STATUS_REGIONS;

Line: 97

END PJM_UPDATE_AK_REGION_ITEMS_PKG;