DBA Data[Home] [Help]

APPS.ASO_PARTY_RLTSHIP_PVT dependencies on FND_API

Line 53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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.

Line 55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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: --

Line 64: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 65: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 66: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 97: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 98: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 132: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 233: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 253: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 273: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 293: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 313: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 333: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 353: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 373: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 393: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 433: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 453: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 454: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,