1: PACKAGE GMS_RES_MAP AUTHID CURRENT_USER AS
2: -- $Header: gmsfcrms.pls 115.7 2002/11/26 22:35:47 jmuthuku ship $
3: -- Standard who
4: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
5: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
1: PACKAGE GMS_RES_MAP AUTHID CURRENT_USER AS
2: -- $Header: gmsfcrms.pls 115.7 2002/11/26 22:35:47 jmuthuku ship $
3: -- Standard who
4: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
5: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
2: -- $Header: gmsfcrms.pls 115.7 2002/11/26 22:35:47 jmuthuku ship $
3: -- Standard who
4: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
5: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
10: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
3: -- Standard who
4: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
5: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
10: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
11:
4: x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
5: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
10: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
11:
12: TYPE resource_list_asgn_id_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5: x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
10: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
11:
12: TYPE resource_list_asgn_id_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
13: TYPE resource_list_id_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6: x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7: x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8: x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
9: x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
10: x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
11:
12: TYPE resource_list_asgn_id_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
13: TYPE resource_list_id_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
14: TYPE member_id_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;