67: ---------------------------------------------------------------------
68:
69: PROCEDURE Process_Wf_Mapping (
70: p_api_version IN NUMBER := 1.0,
71: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
72: p_commit IN VARCHAR2 := Fnd_Api.g_false,
73: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
74: p_x_Wf_Mapping_tbl IN OUT NOCOPY Wf_Mapping_tbl,
75: x_return_status OUT NOCOPY VARCHAR2,
68:
69: PROCEDURE Process_Wf_Mapping (
70: p_api_version IN NUMBER := 1.0,
71: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
72: p_commit IN VARCHAR2 := Fnd_Api.g_false,
73: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
74: p_x_Wf_Mapping_tbl IN OUT NOCOPY Wf_Mapping_tbl,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
69: PROCEDURE Process_Wf_Mapping (
70: p_api_version IN NUMBER := 1.0,
71: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
72: p_commit IN VARCHAR2 := Fnd_Api.g_false,
73: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
74: p_x_Wf_Mapping_tbl IN OUT NOCOPY Wf_Mapping_tbl,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2
91: -- NOTES
92: -- 1. object_version_number will be set to 1.
93: -- 2. If Wf_Mapping_Id is passed in, the uniqueness will be checked.
94: -- Raise exception in case of duplicates.
95: -- 3. Please don't pass in any FND_API.g_miss_char/num/date.
96: ---------------------------------------------------------------------
97:
98: PROCEDURE Create_Wf_Mapping (
99: p_api_version IN NUMBER := 1.0,
96: ---------------------------------------------------------------------
97:
98: PROCEDURE Create_Wf_Mapping (
99: p_api_version IN NUMBER := 1.0,
100: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
101: p_commit IN VARCHAR2 := Fnd_Api.g_false,
102: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
103: p_Wf_Mapping_Rec IN Wf_Mapping_Rec_Type,
104:
97:
98: PROCEDURE Create_Wf_Mapping (
99: p_api_version IN NUMBER := 1.0,
100: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
101: p_commit IN VARCHAR2 := Fnd_Api.g_false,
102: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
103: p_Wf_Mapping_Rec IN Wf_Mapping_Rec_Type,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
98: PROCEDURE Create_Wf_Mapping (
99: p_api_version IN NUMBER := 1.0,
100: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
101: p_commit IN VARCHAR2 := Fnd_Api.g_false,
102: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
103: p_Wf_Mapping_Rec IN Wf_Mapping_Rec_Type,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
120: -- p_Wf_Mapping_rec: the record representing AHL_Wf_Mapping_V (without the ROW_ID column).
121: --
122: -- NOTES
123: -- 1. Raise exception if the object_version_number doesn't match.
124: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
125: -- that column won't be updated.
126: --------------------------------------------------------------------
127:
128: PROCEDURE Update_Wf_Mapping (
126: --------------------------------------------------------------------
127:
128: PROCEDURE Update_Wf_Mapping (
129: p_api_version IN NUMBER := 1.0,
130: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
131: p_commit IN VARCHAR2 := Fnd_Api.g_false,
132: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
133: p_Wf_Mapping_rec IN Wf_Mapping_Rec_Type,
134:
127:
128: PROCEDURE Update_Wf_Mapping (
129: p_api_version IN NUMBER := 1.0,
130: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
131: p_commit IN VARCHAR2 := Fnd_Api.g_false,
132: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
133: p_Wf_Mapping_rec IN Wf_Mapping_Rec_Type,
134:
135: x_return_status OUT NOCOPY VARCHAR2,
128: PROCEDURE Update_Wf_Mapping (
129: p_api_version IN NUMBER := 1.0,
130: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
131: p_commit IN VARCHAR2 := Fnd_Api.g_false,
132: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
133: p_Wf_Mapping_rec IN Wf_Mapping_Rec_Type,
134:
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
153: -- 1. Raise exception if the object_version_number doesn't match.
154: -------------------------------------------------------------------
155: PROCEDURE Delete_Wf_mapping (
156: p_api_version IN NUMBER := 1.0,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
158: p_commit IN VARCHAR2 := Fnd_Api.g_false,
159: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
160:
161: x_return_status OUT NOCOPY VARCHAR2,
154: -------------------------------------------------------------------
155: PROCEDURE Delete_Wf_mapping (
156: p_api_version IN NUMBER := 1.0,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
158: p_commit IN VARCHAR2 := Fnd_Api.g_false,
159: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
160:
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
155: PROCEDURE Delete_Wf_mapping (
156: p_api_version IN NUMBER := 1.0,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
158: p_commit IN VARCHAR2 := Fnd_Api.g_false,
159: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
160:
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
177: -- p_Wf_Mapping_rec: the record representing AHL_Wf_Mapping_V (without ROW_ID).
178: --
179: -- NOTES
180: -- 1. p_Wf_Mapping_rec should be the complete Wf_Mapping record. There
181: -- should not be any FND_API.g_miss_char/num/date in it.
182: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
183: -- an exception, as those values are not handled.
184: --------------------------------------------------------------------
185:
178: --
179: -- NOTES
180: -- 1. p_Wf_Mapping_rec should be the complete Wf_Mapping record. There
181: -- should not be any FND_API.g_miss_char/num/date in it.
182: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
183: -- an exception, as those values are not handled.
184: --------------------------------------------------------------------
185:
186: PROCEDURE Validate_Wf_Mapping (
184: --------------------------------------------------------------------
185:
186: PROCEDURE Validate_Wf_Mapping (
187: p_api_version IN NUMBER := 1.0,
188: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
189: p_commit IN VARCHAR2 := Fnd_Api.g_false,
190: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
185:
186: PROCEDURE Validate_Wf_Mapping (
187: p_api_version IN NUMBER := 1.0,
188: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
189: p_commit IN VARCHAR2 := Fnd_Api.g_false,
190: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
186: PROCEDURE Validate_Wf_Mapping (
187: p_api_version IN NUMBER := 1.0,
188: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
189: p_commit IN VARCHAR2 := Fnd_Api.g_false,
190: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
218: -- PROCEDURE
219: -- Init_Wf_Mapping_Rec
220: --
221: -- PURPOSE
222: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
223: ---------------------------------------------------------------------
224: /*PROCEDURE Init_Wf_Mapping_Rec (
225: x_Wf_Mapping_rec OUT NOCOPY Wf_Mapping_Rec_Type
226: );
231: -- Complete_Wf_Mapping_Rec
232: --
233: -- PURPOSE
234: -- For Update_Wf_Mapping, some attributes may be passed in as
235: -- FND_API.g_miss_char/num/date if the user doesn't want to
236: -- update those attributes. This procedure will replace the
237: -- "g_miss" attributes with current database values.
238: --
239: -- PARAMETERS
237: -- "g_miss" attributes with current database values.
238: --
239: -- PARAMETERS
240: -- p_Wf_Mapping_rec: the record which may contain attributes as
241: -- FND_API.g_miss_char/num/date
242: -- x_complete_rec: the complete record after all "g_miss" items
243: -- have been replaced by current database values
244: ---------------------------------------------------------------------
245: PROCEDURE Complete_Wf_Mapping_Rec (