49: -- Pre-Req :
50: -- Parameters:
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
57: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
50: -- Parameters:
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
57: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
58: -- and basic operation, developer must manually add parameters and business logic as necessary.
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
57: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
58: -- and basic operation, developer must manually add parameters and business logic as necessary.
59: --
60: -- End of Comments
61: --
62: PROCEDURE Create_party_rltship(
63: P_Api_Version_Number IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type := ASO_quote_PUB.G_MISS_PARTY_RLTSHIP_REC,
68: X_PARTY_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
61: --
62: PROCEDURE Create_party_rltship(
63: P_Api_Version_Number IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type := ASO_quote_PUB.G_MISS_PARTY_RLTSHIP_REC,
68: X_PARTY_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62: PROCEDURE Create_party_rltship(
63: P_Api_Version_Number IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type := ASO_quote_PUB.G_MISS_PARTY_RLTSHIP_REC,
68: X_PARTY_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
79: -- Pre-Req :
80: -- Parameters:
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
87: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
80: -- Parameters:
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
87: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
88: -- Version : Current version 2.0
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
87: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
88: -- Version : Current version 2.0
89: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
93: --
94: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
95: PROCEDURE Update_party_rltship(
96: P_Api_Version_Number IN NUMBER,
97: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
98: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
94: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
95: PROCEDURE Update_party_rltship(
96: P_Api_Version_Number IN NUMBER,
97: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
98: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
95: PROCEDURE Update_party_rltship(
96: P_Api_Version_Number IN NUMBER,
97: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
98: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
101: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111: -- Pre-Req :
112: -- Parameters:
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
119: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
112: -- Parameters:
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
119: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
120: --
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
119: -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
120: --
121: -- Version : Current version 2.0
127: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
128: -- The Master delete procedure may not be needed depends on different business requirements.
129: PROCEDURE Delete_party_rltship(
130: P_Api_Version_Number IN NUMBER,
131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
135: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
128: -- The Master delete procedure may not be needed depends on different business requirements.
129: PROCEDURE Delete_party_rltship(
130: P_Api_Version_Number IN NUMBER,
131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
135: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
129: PROCEDURE Delete_party_rltship(
130: P_Api_Version_Number IN NUMBER,
131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
135: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
137: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149: --
150: -- End of Comments
151:
152: PROCEDURE Validate_PARTY_RLTSHIP_ID (
153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154: P_Validation_mode IN VARCHAR2,
155: P_PARTY_RELATIONSHIP_ID IN NUMBER,
156: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
157: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
169: --
170: -- End of Comments
171:
172: PROCEDURE Validate_REQUEST_ID (
173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
174: P_Validation_mode IN VARCHAR2,
175: P_REQUEST_ID IN NUMBER,
176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
189: --
190: -- End of Comments
191:
192: PROCEDURE Validate_PROG_APPL_ID (
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Validation_mode IN VARCHAR2,
195: P_PROGRAM_APPLICATION_ID IN NUMBER,
196: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
197: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
209: --
210: -- End of Comments
211:
212: PROCEDURE Validate_PROGRAM_ID (
213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
214: P_Validation_mode IN VARCHAR2,
215: P_PROGRAM_ID IN NUMBER,
216: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
217: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
229: --
230: -- End of Comments
231:
232: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
233: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234: P_Validation_mode IN VARCHAR2,
235: P_PROGRAM_UPDATE_DATE IN DATE,
236: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
237: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
249: --
250: -- End of Comments
251:
252: PROCEDURE Validate_QUOTE_OBJECT_TYPE (
253: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
254: P_Validation_mode IN VARCHAR2,
255: P_QUOTE_OBJECT_TYPE IN VARCHAR2,
256: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
257: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
269: --
270: -- End of Comments
271:
272: PROCEDURE Validate_QUOTE_OBJECT_ID (
273: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
274: P_Validation_mode IN VARCHAR2,
275: P_QUOTE_OBJECT_ID IN NUMBER,
276: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
277: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
289: --
290: -- End of Comments
291:
292: PROCEDURE Validate_RLTSHIP_TYPE_CODE (
293: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
294: P_Validation_mode IN VARCHAR2,
295: P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
296: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
297: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
309: --
310: -- End of Comments
311:
312: PROCEDURE Validate_RELATED_OBJ_TYPE_CODE (
313: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
314: P_Validation_mode IN VARCHAR2,
315: P_RELATED_OBJECT_TYPE_CODE IN VARCHAR2,
316: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
317: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
329: --
330: -- End of Comments
331:
332: PROCEDURE Validate_RELATED_OBJECT_ID (
333: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
334: P_Validation_mode IN VARCHAR2,
335: P_RELATED_OBJECT_ID IN NUMBER,
336: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
337: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
349: --
350: -- End of Comments
351:
352: PROCEDURE Validate_QUOTE_HEADER_ID (
353: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
354: P_Validation_mode IN VARCHAR2,
355: P_QUOTE_HEADER_ID IN NUMBER,
356: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
357: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
369: --
370: -- End of Comments
371:
372: PROCEDURE Validate_QUOTE_LINE_ID (
373: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
374: P_Validation_mode IN VARCHAR2,
375: P_QUOTE_LINE_ID IN NUMBER,
376: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
377: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
389: --
390: -- End of Comments
391:
392: PROCEDURE Validate_OBJECT_TYPE_CODE (
393: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_mode IN VARCHAR2,
395: P_OBJECT_TYPE_CODE IN VARCHAR2,
396: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
397: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
409: --
410: -- End of Comments
411:
412: PROCEDURE Validate_OBJECT_ID (
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Validation_mode IN VARCHAR2,
415: P_OBJECT_ID IN NUMBER,
416: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
417: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
429: -- 2. Developer can manually added inter-field level validation.
430: -- End of Comments
431:
432: PROCEDURE Validate_PARTY_RLTSHIP_rec(
433: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
434: P_Validation_mode IN VARCHAR2,
435: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
436: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
437: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
449: -- 2. We can also validate table instead of record. There will be an option for user to choose.
450: -- End of Comments
451:
452: PROCEDURE Validate_party_rltship(
453: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
454: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: P_Validation_mode IN VARCHAR2,
456: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
457: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
450: -- End of Comments
451:
452: PROCEDURE Validate_party_rltship(
453: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
454: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: P_Validation_mode IN VARCHAR2,
456: P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
457: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
458: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,