1: PACKAGE PA_ADW_CREATE_VIEWS AUTHID CURRENT_USER AS
2: /* $Header: PAADWVWS.pls 115.0 99/07/16 13:22:38 porting ship $ */
3:
4: -- Standard who
5: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
2: /* $Header: PAADWVWS.pls 115.0 99/07/16 13:22:38 porting ship $ */
3:
4: -- Standard who
5: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
3:
4: -- Standard who
5: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
4: -- Standard who
5: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12:
5: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12:
13: -- Variable to store the dimension statuses
6: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12:
13: -- Variable to store the dimension statuses
14:
7: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12:
13: -- Variable to store the dimension statuses
14:
15: dim_project VARCHAR2(1);