32: -- Pre-reqs :
33: --
34: -- Standard IN Parameters :
35: -- p_api_version IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
37: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
39: --
40: -- Standard OUT Parameters :
33: --
34: -- Standard IN Parameters :
35: -- p_api_version IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
37: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
39: --
40: -- Standard OUT Parameters :
41: -- x_return_status OUT VARCHAR2 Required
34: -- Standard IN Parameters :
35: -- p_api_version IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
37: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
39: --
40: -- Standard OUT Parameters :
41: -- x_return_status OUT VARCHAR2 Required
42: -- x_msg_count OUT NUMBER Required
59: --
60: -- End of Comments --
61: PROCEDURE CREATE_PC_HEADER (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
67: x_return_status OUT NOCOPY VARCHAR2,
60: -- End of Comments --
61: PROCEDURE CREATE_PC_HEADER (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
61: PROCEDURE CREATE_PC_HEADER (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2);
76: -- Pre-reqs :
77: --
78: -- Standard IN Parameters :
79: -- p_api_version IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
81: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
83: --
84: -- Standard OUT Parameters :
77: --
78: -- Standard IN Parameters :
79: -- p_api_version IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
81: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
83: --
84: -- Standard OUT Parameters :
85: -- x_return_status OUT VARCHAR2 Required
78: -- Standard IN Parameters :
79: -- p_api_version IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
81: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
82: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
83: --
84: -- Standard OUT Parameters :
85: -- x_return_status OUT VARCHAR2 Required
86: -- x_msg_count OUT NUMBER Required
103: --
104: -- End of Comments --
105: PROCEDURE UPDATE_PC_HEADER (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
111: x_return_status OUT NOCOPY VARCHAR2,
104: -- End of Comments --
105: PROCEDURE UPDATE_PC_HEADER (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
105: PROCEDURE UPDATE_PC_HEADER (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2);
120: -- Pre-reqs : AHL_PC_NODES_PVT.VALIDATE_NODES
121: --
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127: --
128: -- Standard OUT Parameters :
121: --
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127: --
128: -- Standard OUT Parameters :
129: -- x_return_status OUT VARCHAR2 Required
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127: --
128: -- Standard OUT Parameters :
129: -- x_return_status OUT VARCHAR2 Required
130: -- x_msg_count OUT NUMBER Required
141: --
142: -- End of Comments --
143: PROCEDURE DELETE_PC_HEADER (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
149: x_return_status OUT NOCOPY VARCHAR2,
142: -- End of Comments --
143: PROCEDURE DELETE_PC_HEADER (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
143: PROCEDURE DELETE_PC_HEADER (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2);
158: -- Pre-reqs : AHL_PC_NODES_PVT.COPY_NODES
159: --
160: -- Standard IN Parameters :
161: -- p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
163: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165: --
166: -- Standard OUT Parameters :
159: --
160: -- Standard IN Parameters :
161: -- p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
163: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165: --
166: -- Standard OUT Parameters :
167: -- x_return_status OUT VARCHAR2 Required
160: -- Standard IN Parameters :
161: -- p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
163: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
164: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165: --
166: -- Standard OUT Parameters :
167: -- x_return_status OUT VARCHAR2 Required
168: -- x_msg_count OUT NUMBER Required
185: --
186: -- End of Comments --
187: PROCEDURE COPY_PC_HEADER (
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
193: x_return_status OUT NOCOPY VARCHAR2,
186: -- End of Comments --
187: PROCEDURE COPY_PC_HEADER (
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
187: PROCEDURE COPY_PC_HEADER (
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2);
202: -- Pre-reqs :
203: --
204: -- Standard IN Parameters :
205: -- p_api_version IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209: --
210: -- Standard OUT Parameters :
203: --
204: -- Standard IN Parameters :
205: -- p_api_version IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209: --
210: -- Standard OUT Parameters :
211: -- x_return_status OUT VARCHAR2 Required
204: -- Standard IN Parameters :
205: -- p_api_version IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209: --
210: -- Standard OUT Parameters :
211: -- x_return_status OUT VARCHAR2 Required
212: -- x_msg_count OUT NUMBER Required
221: --
222: -- End of Comments --
223: PROCEDURE INITIATE_PC_APPROVAL (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_default IN VARCHAR2 := FND_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
222: -- End of Comments --
223: PROCEDURE INITIATE_PC_APPROVAL (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_default IN VARCHAR2 := FND_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
223: PROCEDURE INITIATE_PC_APPROVAL (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_default IN VARCHAR2 := FND_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_default IN VARCHAR2 := FND_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC