DBA Data[Home] [Help]

APPS.ASO_HEADER_RLTSHIP_PVT dependencies on FND_API

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

18: -- Pre-Req :
19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
26: --

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

19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
26: --
27: -- OUT:

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

20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
26: --
27: -- OUT:
28: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

32: -- End of Comments
33: --
34: PROCEDURE Create_header_rltship(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: P_HEADER_RLTSHIP_Rec IN ASO_QUOTE_PUB.HEADER_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_HEADER_RLTSHIP_REC,
40: X_HEADER_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

33: --
34: PROCEDURE Create_header_rltship(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: P_HEADER_RLTSHIP_Rec IN ASO_QUOTE_PUB.HEADER_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_HEADER_RLTSHIP_REC,
40: X_HEADER_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

34: PROCEDURE Create_header_rltship(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: P_HEADER_RLTSHIP_Rec IN ASO_QUOTE_PUB.HEADER_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_HEADER_RLTSHIP_REC,
40: X_HEADER_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
42: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

51: -- Pre-Req :
52: -- Parameters:
53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
59: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required

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

52: -- Parameters:
53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
59: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
60: --

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

53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
58: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
59: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
60: --
61: -- OUT:

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

66: -- End of Comments
67: --
68: PROCEDURE Update_header_rltship(
69: P_Api_Version_Number IN NUMBER,
70: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
71: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

67: --
68: PROCEDURE Update_header_rltship(
69: P_Api_Version_Number IN NUMBER,
70: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
71: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

68: PROCEDURE Update_header_rltship(
69: P_Api_Version_Number IN NUMBER,
70: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
71: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

84: -- Pre-Req :
85: -- Parameters:
86: -- IN
87: -- p_api_version_number IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
92: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required

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

85: -- Parameters:
86: -- IN
87: -- p_api_version_number IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
92: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
93: --

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

86: -- IN
87: -- p_api_version_number IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
92: -- P_HEADER_RLTSHIP_Rec IN HEADER_RLTSHIP_Rec_Type Required
93: --
94: -- OUT:

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

98: -- End of Comments
99: --
100: PROCEDURE Delete_header_rltship(
101: P_Api_Version_Number IN NUMBER,
102: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
103: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: P_HEADER_RLTSHIP_id IN NUMBER,
106: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

99: --
100: PROCEDURE Delete_header_rltship(
101: P_Api_Version_Number IN NUMBER,
102: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
103: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: P_HEADER_RLTSHIP_id IN NUMBER,
106: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

100: PROCEDURE Delete_header_rltship(
101: P_Api_Version_Number IN NUMBER,
102: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
103: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: P_HEADER_RLTSHIP_id IN NUMBER,
106: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
108: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

111:
112:
113: PROCEDURE Delete_header_rltship(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_HEADER_id IN NUMBER,
119: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

112:
113: PROCEDURE Delete_header_rltship(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_HEADER_id IN NUMBER,
119: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

113: PROCEDURE Delete_header_rltship(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_HEADER_id IN NUMBER,
119: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
121: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

133: --
134: -- End of Comments
135:
136: PROCEDURE Validate_HEADER_RLTSHIP_ID (
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Validation_mode IN VARCHAR2,
139: P_HEADER_RELATIONSHIP_ID IN NUMBER,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

149: --
150: -- End of Comments
151:
152: PROCEDURE Validate_REQUEST_ID (
153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154: P_Validation_mode IN VARCHAR2,
155: P_REQUEST_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 168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

164: --
165: -- End of Comments
166:
167: PROCEDURE Validate_PROGRAM_APPL_ID (
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Validation_mode IN VARCHAR2,
170: P_PROGRAM_APPLICATION_ID IN NUMBER,
171: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
172: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

181: --
182: -- End of Comments
183:
184: PROCEDURE Validate_PROGRAM_ID (
185: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186: P_Validation_mode IN VARCHAR2,
187: P_PROGRAM_ID IN NUMBER,
188: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
189: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

197: --
198: -- End of Comments
199:
200: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
202: P_Validation_mode IN VARCHAR2,
203: P_PROGRAM_UPDATE_DATE IN DATE,
204: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

212: --
213: -- End of Comments
214:
215: PROCEDURE Validate_QUOTE_HEADER_ID (
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Validation_mode IN VARCHAR2,
218: P_QUOTE_HEADER_ID IN NUMBER,
219: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
220: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

228: --
229: -- End of Comments
230:
231: PROCEDURE Validate_RELATED_HEADER_ID (
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Validation_mode IN VARCHAR2,
234: P_RELATED_HEADER_ID IN NUMBER,
235: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
236: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

243: -- Item level validation procedures
244: -- End of Comments
245:
246: PROCEDURE Validate_RLTSHIP_TYPE_CODE (
247: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
248: P_Validation_mode IN VARCHAR2,
249: P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
250: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

258: --
259: -- End of Comments
260:
261: PROCEDURE Validate_RECIPROCAL_FLAG (
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Validation_mode IN VARCHAR2,
264: P_RECIPROCAL_FLAG IN VARCHAR2,
265: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
266: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

271: --
272: -- End of Comments
273:
274: PROCEDURE Validate_HEADER_RLTSHIP_rec(
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Validation_mode IN VARCHAR2,
277: P_HEADER_RLTSHIP_Rec IN ASO_QUOTE_PUB.HEADER_RLTSHIP_Rec_Type,
278: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
279: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

285: --
286: -- End of Comments
287:
288: PROCEDURE Validate_header_rltship(
289: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: P_Validation_mode IN VARCHAR2,
292: P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
293: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

286: -- End of Comments
287:
288: PROCEDURE Validate_header_rltship(
289: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
290: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: P_Validation_mode IN VARCHAR2,
292: P_HEADER_RLTSHIP_Rec IN ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type,
293: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
294: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,