25: -- End of Comments
26:
27: TYPE camp_outcome_Rec_Type IS RECORD
28: (
29: outcome_id NUMBER := FND_API.G_MISS_NUM,
30: object_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
26:
27: TYPE camp_outcome_Rec_Type IS RECORD
28: (
29: outcome_id NUMBER := FND_API.G_MISS_NUM,
30: object_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
27: TYPE camp_outcome_Rec_Type IS RECORD
28: (
29: outcome_id NUMBER := FND_API.G_MISS_NUM,
30: object_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
28: (
29: outcome_id NUMBER := FND_API.G_MISS_NUM,
30: object_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
29: outcome_id NUMBER := FND_API.G_MISS_NUM,
30: object_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: object_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: source_code_id NUMBER := FND_API.G_MISS_NUM,
31: object_version_number NUMBER := FND_API.G_MISS_NUM,
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: source_code_id NUMBER := FND_API.G_MISS_NUM,
39: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32: created_by NUMBER := FND_API.G_MISS_NUM,
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: source_code_id NUMBER := FND_API.G_MISS_NUM,
39: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40: );
33: creation_date DATE := FND_API.G_MISS_DATE,
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: source_code_id NUMBER := FND_API.G_MISS_NUM,
39: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40: );
41:
34: last_updated_by NUMBER := FND_API.G_MISS_NUM,
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: source_code_id NUMBER := FND_API.G_MISS_NUM,
39: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40: );
41:
42: G_MISS_camp_outcome_REC camp_outcome_Rec_Type;
35: last_update_date DATE := FND_API.G_MISS_DATE,
36: last_update_login NUMBER := FND_API.G_MISS_NUM,
37: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38: source_code_id NUMBER := FND_API.G_MISS_NUM,
39: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40: );
41:
42: G_MISS_camp_outcome_REC camp_outcome_Rec_Type;
43: TYPE camp_outcome_Tbl_Type IS TABLE OF camp_outcome_Rec_Type
52: -- Pre-Req :
53: -- Parameters:
54: -- IN
55: -- p_api_version_number IN NUMBER Required
56: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
57: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
58: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
59: -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
60: --
53: -- Parameters:
54: -- IN
55: -- p_api_version_number IN NUMBER Required
56: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
57: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
58: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
59: -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
60: --
61: -- OUT:
54: -- IN
55: -- p_api_version_number IN NUMBER Required
56: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
57: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
58: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
59: -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
60: --
61: -- OUT:
62: -- x_return_status OUT VARCHAR2
72: FUNCTION get_camp_outcome_Rec RETURN AST_camp_outcome_PVT.camp_outcome_rec_type;
73:
74: PROCEDURE Create_camp_outcome(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: P_camp_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_REC,
80: X_Return_Status OUT VARCHAR2,
73:
74: PROCEDURE Create_camp_outcome(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: P_camp_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_REC,
80: X_Return_Status OUT VARCHAR2,
81: X_Msg_Count OUT NUMBER,
74: PROCEDURE Create_camp_outcome(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: P_camp_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_REC,
80: X_Return_Status OUT VARCHAR2,
81: X_Msg_Count OUT NUMBER,
82: X_Msg_Data OUT VARCHAR2
90: -- Pre-Req :
91: -- Parameters:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
98: --
91: -- Parameters:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
98: --
99: -- OUT:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
98: --
99: -- OUT:
100: -- x_return_status OUT VARCHAR2
110: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
111: -- The Master delete procedure may not be needed depends on different business requirements.
112: PROCEDURE Delete_camp_outcome(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: P_camp_outcome_Rec IN camp_outcome_Rec_Type,
118: X_Return_Status OUT VARCHAR2,
111: -- The Master delete procedure may not be needed depends on different business requirements.
112: PROCEDURE Delete_camp_outcome(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: P_camp_outcome_Rec IN camp_outcome_Rec_Type,
118: X_Return_Status OUT VARCHAR2,
119: X_Msg_Count OUT NUMBER,
112: PROCEDURE Delete_camp_outcome(
113: P_Api_Version_Number IN NUMBER,
114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: P_camp_outcome_Rec IN camp_outcome_Rec_Type,
118: X_Return_Status OUT VARCHAR2,
119: X_Msg_Count OUT NUMBER,
120: X_Msg_Data OUT VARCHAR2
128: -- Pre-Req :
129: -- Parameters:
130: -- IN
131: -- p_api_version_number IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: --
136: -- OUT:
129: -- Parameters:
130: -- IN
131: -- p_api_version_number IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: --
136: -- OUT:
137: -- x_return_status OUT VARCHAR2
130: -- IN
131: -- p_api_version_number IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: --
136: -- OUT:
137: -- x_return_status OUT VARCHAR2
138: -- x_msg_count OUT NUMBER
143: -- and basic operation, developer must manually add parameters and business logic as necessary.
144: -- End of Comments
145: PROCEDURE Save_Change(
146: P_Api_Version_Number IN NUMBER,
147: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
148: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: X_Return_Status OUT VARCHAR2,
151: X_Msg_Count OUT NUMBER,
144: -- End of Comments
145: PROCEDURE Save_Change(
146: P_Api_Version_Number IN NUMBER,
147: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
148: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: X_Return_Status OUT VARCHAR2,
151: X_Msg_Count OUT NUMBER,
152: X_Msg_Data OUT VARCHAR2
145: PROCEDURE Save_Change(
146: P_Api_Version_Number IN NUMBER,
147: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
148: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: X_Return_Status OUT VARCHAR2,
151: X_Msg_Count OUT NUMBER,
152: X_Msg_Data OUT VARCHAR2
153: );
159: -- Pre-Req :
160: -- Parameters:
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_object_id IN NUMBER
167: -- p_outcome_id IN NUMBER
160: -- Parameters:
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_object_id IN NUMBER
167: -- p_outcome_id IN NUMBER
168: -- p_result_id IN NUMBER
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_object_id IN NUMBER
167: -- p_outcome_id IN NUMBER
168: -- p_result_id IN NUMBER
169: -- p_reason_id IN NUMBER
181: -- End of Comments
182:
183: PROCEDURE Save_Defaults(
184: P_Api_Version_Number IN NUMBER,
185: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: p_object_id IN NUMBER,
189: p_outcome_id IN NUMBER,
182:
183: PROCEDURE Save_Defaults(
184: P_Api_Version_Number IN NUMBER,
185: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: p_object_id IN NUMBER,
189: p_outcome_id IN NUMBER,
190: p_result_id IN NUMBER,
183: PROCEDURE Save_Defaults(
184: P_Api_Version_Number IN NUMBER,
185: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: p_object_id IN NUMBER,
189: p_outcome_id IN NUMBER,
190: p_result_id IN NUMBER,
191: p_reason_id IN NUMBER,
205: -- Pre-Req :
206: -- Parameters:
207: -- IN
208: -- p_api_version_number IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212: --
213: -- OUT:
206: -- Parameters:
207: -- IN
208: -- p_api_version_number IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212: --
213: -- OUT:
214: -- x_return_status OUT VARCHAR2
207: -- IN
208: -- p_api_version_number IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212: --
213: -- OUT:
214: -- x_return_status OUT VARCHAR2
215: -- x_msg_count OUT NUMBER
220: --
221: -- End of Comments
222: PROCEDURE Reset_Change(
223: P_Api_Version_Number IN NUMBER,
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: X_Return_Status OUT VARCHAR2,
228: X_Msg_Count OUT NUMBER,
221: -- End of Comments
222: PROCEDURE Reset_Change(
223: P_Api_Version_Number IN NUMBER,
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: X_Return_Status OUT VARCHAR2,
228: X_Msg_Count OUT NUMBER,
229: X_Msg_Data OUT VARCHAR2
222: PROCEDURE Reset_Change(
223: P_Api_Version_Number IN NUMBER,
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: X_Return_Status OUT VARCHAR2,
228: X_Msg_Count OUT NUMBER,
229: X_Msg_Data OUT VARCHAR2
230: );