1: PACKAGE gmd_search_replace_vers AUTHID CURRENT_USER AS
2: /* $Header: GMDSREPS.pls 120.3 2009/03/23 17:35:41 rnalla ship $ */
3:
4: P_created_by NUMBER := FND_PROFILE.VALUE('USER_ID');
5: P_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
6:
7: PROCEDURE create_new_routing(p_routing_id IN NUMBER,
8: p_effective_start_date IN VARCHAR2,
1: PACKAGE gmd_search_replace_vers AUTHID CURRENT_USER AS
2: /* $Header: GMDSREPS.pls 120.3 2009/03/23 17:35:41 rnalla ship $ */
3:
4: P_created_by NUMBER := FND_PROFILE.VALUE('USER_ID');
5: P_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
6:
7: PROCEDURE create_new_routing(p_routing_id IN NUMBER,
8: p_effective_start_date IN VARCHAR2,
9: p_effective_end_date IN VARCHAR2,