1 PACKAGE ENGECOBO AS
2 /* $Header: ENGECOBS.pls 120.2 2005/10/24 05:44:48 lkasturi noship $ */
3
4 ---------------------------------------------------------------
5 -- Global constants --
6 ---------------------------------------------------------------
7 GLOBAL_CHANGE_ID NUMBER := -1;
8 GLOBAL_ORG_ID NUMBER := -1;
9
10 ---------------------------------------------------------------
11 -- Public Procedures --
12 ---------------------------------------------------------------
13
14
15 -- ****************************************************************** --
16 -- API name : Propagate_ECO --
17 -- Type : Public --
18 -- Pre-reqs : None. --
19 -- Procedure : Propagates the specified ECO --
20 -- Parameters : --
21 -- IN : --
22 -- p_change_notice VARCHAR2 Required --
23 -- p_org_hierarchy_name varchar2 --
24 -- p_org_hierarchy_level VARCHAR2 --
25 -- p_local_organization_id NUMBER := NULL --
26 -- p_calling_api NUMBER := NULL --
27 -- OUT : retcode VARCHAR2(1) --
28 -- error_buf VARCHAR2(30) --
29 -- Version : --
30 -- Current version 1.0 --
31 -- Initial version 1.0 --
32 -- --
33 -- Notes : --
34 -- if org hierarchy id is -1 then the list of orgs --
35 -- associated to the change are picked for propagation --
36 -- if p_org_hierarchy_id is null, check that the value --
37 -- local_organization_id has been specified --
38 -- Validate that the local organization id either --
39 -- belongs to the hierarchy or to the list of local --
40 -- orgs of thesource change order --
41 -- p_calling API is TTM then the change header --
42 -- relation is checked first 'TRANSFERRED_TO' --
43 -- ****************************************************************** --
44 PROCEDURE PROPAGATE_ECO
45 (
46 errbuf OUT NOCOPY VARCHAR2,
47 retcode OUT NOCOPY VARCHAR2,
48 p_change_notice IN VARCHAR2,
49 p_org_hierarchy_name IN VARCHAR2,
50 p_org_hierarchy_level IN VARCHAR2,
51 p_local_organization_id IN NUMBER := NULL -- R12
52 , p_calling_API IN VARCHAR2 := NULL --R12
53 );
54
55 -- ****************************************************************** --
56 -- API name : Propagate_ECO --
57 -- Type : Public --
58 -- Pre-reqs : None. --
59 -- Procedure : Propagates the specified ECO --
60 -- Parameters : --
61 -- IN : --
62 -- p_inventory_item_id NUMBER Required --
63 -- p_local_organization_id NUMBER --
64 -- OUT : x_return_status VARCHAR2(1) --
65 -- --
66 -- Version : --
67 -- Current version 1.0 --
68 -- Initial version 1.0 --
69 -- --
70 -- Notes : --
71 -- ****************************************************************** --
72
73 PROCEDURE Auto_Enable_Item (
74 p_api_version IN NUMBER
75 , p_init_msg_list IN VARCHAR2
76 , p_commit IN VARCHAR2
77 , x_return_status OUT NOCOPY VARCHAR2
78 , x_msg_count OUT NOCOPY NUMBER
79 , x_msg_data OUT NOCOPY VARCHAR2
80 , p_inventory_item_id IN NUMBER
81 , p_local_organization_id IN NUMBER
82 );
83 -- ****************************************************************** --
84 -- API name : PreProcess_Propagate_Request --
85 -- Type : Public --
86 -- Pre-reqs : None. --
87 -- Procedure : Adds a row into the Propagation maps table --
88 -- Parameters : --
89 -- IN : p_api_version IN NUMBER --
90 -- p_init_msg_list IN VARCHAR2 --
91 -- p_commit IN VARCHAR2 --
92 -- p_request_id IN NUMBER --
93 -- p_change_id IN VARCHAR2 --
94 -- p_org_hierarchy_name IN VARCHAR2 --
95 -- p_local_organization_id IN NUMBER --
96 -- p_calling_API IN VARCHAR2 --
97 -- --
98 -- OUT : x_msg_count OUT NOCOPY NUMBER --
99 -- x_msg_data OUT NOCOPY VARCHAR2 --
100 -- x_return_status VARCHAR2(1) --
101 -- --
102 -- Version : --
103 -- Current version 1.0 --
104 -- Initial version 1.0 --
105 -- --
106 -- Notes : --
107 -- ****************************************************************** --
108 PROCEDURE PreProcess_Propagate_Request (
109 p_api_version IN NUMBER --
110 , p_init_msg_list IN VARCHAR2 --
111 , p_commit IN VARCHAR2 --
112 , p_request_id IN NUMBER
113 , p_change_id IN VARCHAR2
114 , p_org_hierarchy_name IN VARCHAR2
115 , p_local_organization_id IN NUMBER
116 , p_calling_API IN VARCHAR2
117 , x_return_status OUT NOCOPY VARCHAR2 --
118 , x_msg_count OUT NOCOPY NUMBER --
119 , x_msg_data OUT NOCOPY VARCHAR2 --
120 );
121
122 END ENGECOBO;
123