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,
10 p_inactive_ind IN NUMBER,
11 p_owner IN NUMBER,
12 p_old_operation IN NUMBER,
13 p_new_operation IN NUMBER,
14 p_routing_class IN VARCHAR2,
15 x_routing_id OUT NOCOPY NUMBER);
16
17 PROCEDURE create_new_operation(p_oprn_id IN NUMBER,
18 p_old_activity IN VARCHAR2,
19 p_activity IN VARCHAR2,
20 p_effective_start_date IN VARCHAR2,
21 p_effective_end_date IN VARCHAR2,
22 p_operation_class IN VARCHAR2,
23 p_inactive_ind IN NUMBER,
24 p_old_resource IN VARCHAR2,
25 p_resource IN VARCHAR2,
26 x_oprn_id OUT NOCOPY NUMBER);
27
28 PROCEDURE create_new_recipe(p_recipe_id IN NUMBER,
29 p_routing_id IN NUMBER,
30 p_formula_id IN NUMBER,
31 powner_id IN NUMBER,
32 powner_orgn_code IN VARCHAR2,
33 p_Organization_id IN NUMBER,
34 p_recipe_type IN NUMBER,
35 x_recipe_id OUT NOCOPY NUMBER);
36
37 PROCEDURE create_new_formula(p_formula_id IN NUMBER,
38 p_formula_class IN VARCHAR2,
39 p_inactive_ind IN NUMBER,
40 p_new_ingredient IN NUMBER,
41 p_old_ingredient IN NUMBER,
42 p_old_ingr_revision IN VARCHAR2,
43 p_new_ingr_revision IN VARCHAR2,
44 p_owner_id IN NUMBER,
45 x_formula_id OUT NOCOPY NUMBER,
46 x_scale_factor NUMBER DEFAULT NULL,
47 pCreate_Recipe IN NUMBER DEFAULT 0);
48
49 END gmd_search_replace_vers;