DBA Data[Home] [Help]

APPS.ASO_QUOTE_VUHK dependencies on FND_API

Line 9: G_ASO_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;

5: -- Purpose :
6: -- This package is the spec required for customer user hooks needed to
7: -- simplify the customization process. It consists of both the pre and
8: -- post processing APIs.
9: G_ASO_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR;
10: Function Get_Product_Status(p_application_id NUMBER)
11: RETURN VARCHAR2 IS
12: l_ret_val BOOLEAN;
13: l_status VARCHAR2(1);

Line 18: AND G_ASO_STATUS = FND_API.G_MISS_CHAR)

14: l_industry VARCHAR2(1);
15: BEGIN
16:
17: if (p_application_id = 279
18: AND G_ASO_STATUS = FND_API.G_MISS_CHAR)
19:
20: then
21:
22: -- Make a call to fnd_installation.get function to check for the

Line 114: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

110: l_sql_stat VARCHAR2(3000);
111: l_init_msg_list VARCHAR2(240);
112: l_commit VARCHAR2(1);
113: l_msg_count NUMBER;
114: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
115: l_msg_data VARCHAR2(2000);
116: l_return_status VARCHAR2(1);
117:
118: BEGIN

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

132: -- Pre-Req :
133: -- Parameters:
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL;
139: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
140: --

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

133: -- Parameters:
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL;
139: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
140: --
141: -- OUT:

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

233: -- Pre-Req :
234: -- Parameters:
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL;
240: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
241: --

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

234: -- Parameters:
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL;
240: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
241: --
242: -- OUT:

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

282: -- Pre-Req :
283: -- Parameters:
284: -- IN
285: -- p_api_version_number IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
287: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
288: --
289: -- OUT:
290: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

283: -- Parameters:
284: -- IN
285: -- p_api_version_number IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
287: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
288: --
289: -- OUT:
290: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
291: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 333: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

329: l_sql_stat VARCHAR2(3000);
330: l_init_msg_list VARCHAR2(240);
331: l_commit VARCHAR2(1);
332: l_msg_count NUMBER;
333: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
334: l_msg_data VARCHAR2(2000);
335: l_return_status VARCHAR2(1);
336:
337: BEGIN

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

351: -- Pre-Req :
352: -- Parameters:
353: -- IN
354: -- p_api_version_number IN NUMBER Required
355: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
356: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
357: -- OUT:
358: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

352: -- Parameters:
353: -- IN
354: -- p_api_version_number IN NUMBER Required
355: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
356: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
357: -- OUT:
358: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
360: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

398: -- Pre-Req :
399: -- Parameters:
400: -- IN
401: -- p_api_version_number IN NUMBER Required
402: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
403: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
404: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
405: -- P_quote_header_id IN NUMBER Required
406: -- P_header_last_update_date IN DATE Required

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

399: -- Parameters:
400: -- IN
401: -- p_api_version_number IN NUMBER Required
402: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
403: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
404: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
405: -- P_quote_header_id IN NUMBER Required
406: -- P_header_last_update_date IN DATE Required
407: -- P_Payment_Tbl IN Payment_Tbl_Type

Line 416: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE

412: -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
413: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
414: -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
415: -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
416: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
417:
418: -- OUT:
419: -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
420: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

547: -- Pre-Req :
548: -- Parameters:
549: -- IN
550: -- p_api_version_number IN NUMBER Required
551: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
552: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
553: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL;
554: -- P_qte_line_Rec IN qte_line_Rec_Type Required
555: -- P_quote_header_id IN NUMBER Required

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

548: -- Parameters:
549: -- IN
550: -- p_api_version_number IN NUMBER Required
551: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
552: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
553: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL;
554: -- P_qte_line_Rec IN qte_line_Rec_Type Required
555: -- P_quote_header_id IN NUMBER Required
556: -- P_header_last_update_date IN DATE Required