4: PROCEDURE update_pa_status_regions IS
5:
6: CURSOR c_proj_status IS
7: SELECT COLUMN_PROMPT, Column_ORDER
8: FROM PA_STATUS_COLUMN_SETUP
9: WHERE FOLDER_CODE='P'
10: AND COLUMN_PROMPT IS NOT NULL;
11:
12:
11:
12:
13: CURSOR c_task_status IS
14: SELECT COLUMN_PROMPT, Column_ORDER
15: FROM PA_STATUS_COLUMN_SETUP
16: WHERE FOLDER_CODE='T'
17: AND COLUMN_PROMPT IS NOT NULL;
18:
19: CURSOR c_rsrc_status IS
17: AND COLUMN_PROMPT IS NOT NULL;
18:
19: CURSOR c_rsrc_status IS
20: SELECT COLUMN_PROMPT, Column_ORDER
21: FROM PA_STATUS_COLUMN_SETUP
22: WHERE FOLDER_CODE='R'
23: AND COLUMN_PROMPT IS NOT NULL;
24:
25: var_column_prompt pa_status_column_setup.column_prompt%TYPE;
21: FROM PA_STATUS_COLUMN_SETUP
22: WHERE FOLDER_CODE='R'
23: AND COLUMN_PROMPT IS NOT NULL;
24:
25: var_column_prompt pa_status_column_setup.column_prompt%TYPE;
26: var_column_order pa_status_column_setup.column_order%TYPE;
27:
28: BEGIN
29:
22: WHERE FOLDER_CODE='R'
23: AND COLUMN_PROMPT IS NOT NULL;
24:
25: var_column_prompt pa_status_column_setup.column_prompt%TYPE;
26: var_column_order pa_status_column_setup.column_order%TYPE;
27:
28: BEGIN
29:
30: UPDATE ak_region_items