eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PRICE_ADJ_RLTSHIP_PVT dependencies on FND_API

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

20: -- Pre-Req :
21: -- Parameters:
22: -- IN
23: -- p_api_version_number IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
27: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
28: --

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

21: -- Parameters:
22: -- IN
23: -- p_api_version_number IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
27: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
28: --
29: -- OUT:

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

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

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

37: -- End of Comments
38: --
39: PROCEDURE Create_price_adj_rltship(
40: P_Api_Version_Number IN NUMBER,
41: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,
45: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

38: --
39: PROCEDURE Create_price_adj_rltship(
40: P_Api_Version_Number IN NUMBER,
41: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,
45: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
46: X_ADJ_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

39: PROCEDURE Create_price_adj_rltship(
40: P_Api_Version_Number IN NUMBER,
41: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,
45: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
46: X_ADJ_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
47: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

57: -- Pre-Req :
58: -- Parameters:
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
65: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required

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

58: -- Parameters:
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
65: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
66: --

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

59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
65: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
66: --
67: -- OUT:

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

76: --
77: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78: PROCEDURE Update_price_adj_rltship(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
84: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

77: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78: PROCEDURE Update_price_adj_rltship(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
84: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

78: PROCEDURE Update_price_adj_rltship(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
84: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
86: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

94: -- Pre-Req :
95: -- Parameters:
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
102: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required

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

95: -- Parameters:
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
102: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
103: --

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

96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
102: -- P_PRICE_ADJ_RLTSHIP_Rec IN PRICE_ADJ_RLTSHIP_Rec_Type Required
103: --
104: -- OUT:

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

114: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
115: -- The Master delete procedure may not be needed depends on different business requirements.
116: PROCEDURE Delete_price_adj_rltship(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
122: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

115: -- The Master delete procedure may not be needed depends on different business requirements.
116: PROCEDURE Delete_price_adj_rltship(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
122: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
123: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

116: PROCEDURE Delete_price_adj_rltship(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
122: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
123: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
124: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

136: --
137: -- End of Comments
138:
139: PROCEDURE Validate_ADJ_RELATIONSHIP_ID (
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Validation_mode IN VARCHAR2,
142: P_ADJ_RELATIONSHIP_ID IN NUMBER,
143: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
144: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

157: --
158: -- End of Comments
159:
160: PROCEDURE Validate_PROGRAM_APPL_ID (
161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162: P_Validation_mode IN VARCHAR2,
163: P_PROGRAM_APPLICATION_ID IN NUMBER,
164: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
165: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

178: --
179: -- End of Comments
180:
181: PROCEDURE Validate_PROGRAM_ID (
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Validation_mode IN VARCHAR2,
184: P_PROGRAM_ID IN NUMBER,
185: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
186: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

199: --
200: -- End of Comments
201:
202: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Validation_mode IN VARCHAR2,
205: P_PROGRAM_UPDATE_DATE IN DATE,
206: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
207: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

220: --
221: -- End of Comments
222:
223: PROCEDURE Validate_REQUEST_ID (
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Validation_mode IN VARCHAR2,
226: P_REQUEST_ID IN NUMBER,
227: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
228: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

241: --
242: -- End of Comments
243:
244: PROCEDURE Validate_QUOTE_LINE_ID (
245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246: P_Validation_mode IN VARCHAR2,
247: P_QUOTE_LINE_ID IN NUMBER,
248: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
249: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

262: --
263: -- End of Comments
264:
265: PROCEDURE Validate_PRICE_ADJUSTMENT_ID (
266: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
267: P_Validation_mode IN VARCHAR2,
268: P_PRICE_ADJUSTMENT_ID IN NUMBER,
269: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
270: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

283: --
284: -- End of Comments
285:
286: PROCEDURE Validate_RLTD_PRICE_ADJ_ID (
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Validation_mode IN VARCHAR2,
289: P_RLTD_PRICE_ADJ_ID IN NUMBER,
290: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
291: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

304: -- 2. Developer can manually added inter-field level validation.
305: -- End of Comments
306:
307: PROCEDURE Validate_PRICE_ADJ_RLTSHIP_rec(
308: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309: P_Validation_mode IN VARCHAR2,
310: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type,
311: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
312: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

324: -- 2. We can also validate table instead of record. There will be an option for user to choose.
325: -- End of Comments
326:
327: PROCEDURE Validate_price_adj_rltship(
328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
329: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: P_Validation_mode IN VARCHAR2,
331: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type,
332: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

325: -- End of Comments
326:
327: PROCEDURE Validate_price_adj_rltship(
328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
329: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: P_Validation_mode IN VARCHAR2,
331: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type,
332: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
333: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,