1 PACKAGE ICX_CAT_R12_UPGRADE_GRP AS
2 /* $Header: ICXG12US.pls 120.2 2006/08/24 00:36:04 sudsubra noship $*/
3
4 g_job_running_status CONSTANT VARCHAR2(1) := ICX_CAT_UTIL_PVT.g_job_running_status;
5 g_job_complete_status CONSTANT VARCHAR2(1) := ICX_CAT_UTIL_PVT.g_job_complete_status;
6 g_job_failed_status CONSTANT VARCHAR2(1) := ICX_CAT_UTIL_PVT.g_job_failed_status;
7 g_job_paused_status CONSTANT VARCHAR2(1) := ICX_CAT_UTIL_PVT.g_job_paused_status;
8
9 -- Start of comments
10 -- API name : updatePOHeaderId
11 -- * Type : Group
12 -- * Pre-reqs : None.
13 -- * Function : Takes care of populating the header id in
14 -- icx_cat_r12_upgrade. This procedure is
15 -- called by purchasing when a po_header_id is stamped
16 -- in PO_HEADERS_INTERFACE
17 -- * Parameters :
18 -- IN : p_api_version IN NUMBER Required
19 -- p_commit IN VARCHAR2 Optional
20 -- Default = FND_API.G_TRUE
21 -- p_init_msg_list IN VARCHAR2 Optional
22 -- Default = FND_API.G_FALSE
23 -- p_validation_level IN NUMBER Optional
24 -- Default = FND_API.G_VALID_LEVEL_FULL
25 -- p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
26 -- Required
27 -- Corresponds to the column INTERFACE_HEADER_ID in
28 -- the table PO_HEADERS_INTERFACE, and identifies the
29 -- interface_header_ids which has been updated with
30 -- a po_header_id.
31 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
32 -- * Version : Current version 1.0
33 -- Previous version 1.0
34 -- Initial version 1.0
35 --
36 -- Notes : None.
37 --
38 -- End of comments
39 PROCEDURE updatePOHeaderId
40 ( p_api_version IN NUMBER ,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
43 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
44 x_return_status OUT NOCOPY VARCHAR2 ,
45 p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
46 );
47
48 -- Start of comments
49 -- API name : updatePOLineId
50 -- * Type : Group
51 -- * Pre-reqs : None.
52 -- * Function : Takes care of populating the line id in
53 -- icx_cat_r12_upgrade. This procedure is
54 -- called by purchasing when a po_line_id is stamped
55 -- in PO_LINES_INTERFACE
56 -- * Parameters :
57 -- IN : p_api_version IN NUMBER Required
58 -- p_commit IN VARCHAR2 Optional
59 -- Default = FND_API.G_TRUE
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_validation_level IN NUMBER Optional
63 -- Default = FND_API.G_VALID_LEVEL_FULL
64 -- p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
65 -- Required
66 -- Corresponds to the column INTERFACE_LINE_ID in
67 -- the table PO_LINES_INTERFACE, and identifies the
68 -- interface_line_ids which has been updated with
69 -- a po_line_id.
70 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
71 -- * Version : Current version 1.0
72 -- Previous version 1.0
73 -- Initial version 1.0
74 --
75 -- Notes : None.
76 --
77 -- End of comments
78 PROCEDURE updatePOLineId
79 ( p_api_version IN NUMBER ,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
83 x_return_status OUT NOCOPY VARCHAR2 ,
84 p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
85 );
86
87 -- Start of comments
88 -- API name : createR12UpgradeJob
89 -- * Type : Group
90 -- * Pre-reqs : None.
91 -- * Function : inserts a job in icx_cat_r12_upgrade_jobs
92 -- * Parameters :
93 -- IN : p_api_version IN NUMBER Required
94 -- p_commit IN VARCHAR2 Optional
95 -- Default = FND_API.G_TRUE
96 -- p_init_msg_list IN VARCHAR2 Optional
97 -- Default = FND_API.G_FALSE
98 -- p_validation_level IN NUMBER Optional
99 -- Default = FND_API.G_VALID_LEVEL_FULL
100 -- p_job_type IN VARCHAR2 Required
101 -- Type of job to be created
102 -- p_audsid IN NUMBER Required
103 -- audsid for the job to be created
104 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
105 -- * Version : Current version 1.0
106 -- Previous version 1.0
107 -- Initial version 1.0
108 --
109 -- Notes : None.
110 --
111 -- End of comments
112 PROCEDURE createR12UpgradeJob
113 ( p_api_version IN NUMBER ,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
116 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
117 x_return_status OUT NOCOPY VARCHAR2 ,
118 p_job_type IN VARCHAR2,
119 p_audsid IN NUMBER
120 );
121
122 -- Start of comments
123 -- API name : updateR12UpgradeJob
124 -- * Type : Group
125 -- * Pre-reqs : None.
126 -- * Function : updates a job in icx_cat_r12_upgrade_jobs
127 -- * Parameters :
128 -- IN : p_api_version IN NUMBER Required
129 -- p_commit IN VARCHAR2 Optional
130 -- Default = FND_API.G_TRUE
131 -- p_init_msg_list IN VARCHAR2 Optional
132 -- Default = FND_API.G_FALSE
133 -- p_validation_level IN NUMBER Optional
134 -- Default = FND_API.G_VALID_LEVEL_FULL
135 -- p_job_status IN VARCHAR2 Required
136 -- New status of the job
137 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
138 -- * Version : Current version 1.0
139 -- Previous version 1.0
140 -- Initial version 1.0
141 --
142 -- Notes : None.
143 --
144 -- End of comments
145 PROCEDURE updateR12UpgradeJob
146 ( p_api_version IN NUMBER ,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
149 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
150 x_return_status OUT NOCOPY VARCHAR2 ,
151 p_job_status IN VARCHAR2
152 );
153
154
155
156
157
158
159 END ICX_CAT_R12_UPGRADE_GRP;