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_UTILITY_PVT dependencies on FND_API

Line 106: -- if (p_validation_level = FND_API.G_VALID_LEVEL_FULL)

102: -- data. If pass in validation level is FULL, all of the validations
103: -- above will be executed automatically. As for get_currentUser and
104: -- access check, we should do the following:
105: --
106: -- if (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
107: -- then
108: -- Call get_currentUser;
109: -- Call has_xxxAccess;
110: -- end if;

Line 141: -- WHEN FND_API.G_EXC_ERROR THEN

137: --
138: -- The following is example of calling exception handling routines:
139: --
140: -- EXCEPTION
141: -- WHEN FND_API.G_EXC_ERROR THEN
142: -- ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
143: -- P_API_NAME => L_API_NAME
144: -- , P_PGK_NAME => G_PKG_NAME
145: -- , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 152: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

148: -- , X_MSG_DATA => X_MSG_DATA
149: -- , X_RETURN_STATUS => x_return_status
150: -- );
151:
152: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153: -- ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
154: -- P_API_NAME => L_API_NAME
155: -- , P_PGK_NAME => G_PKG_NAME
156: -- , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 226: col_choice NUMBER := FND_API.G_MISS_NUM,

222: -- End of Comments
223:
224: TYPE util_order_by_rec_type IS RECORD
225: (
226: col_choice NUMBER := FND_API.G_MISS_NUM,
227: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
228: );
229:
230: G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;

Line 227: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR

223:
224: TYPE util_order_by_rec_type IS RECORD
225: (
226: col_choice NUMBER := FND_API.G_MISS_NUM,
227: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
228: );
229:
230: G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;
231:

Line 246: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

242: -- End of Comments
243:
244: TYPE item_property_rec_type IS RECORD
245: (
246: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
250: default_num_val NUMBER := FND_API.G_MISS_NUM,

Line 247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR

243:
244: TYPE item_property_rec_type IS RECORD
245: (
246: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
250: default_num_val NUMBER := FND_API.G_MISS_NUM,
251: default_date_val DATE := FND_API.G_MISS_DATE

Line 248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR

244: TYPE item_property_rec_type IS RECORD
245: (
246: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
250: default_num_val NUMBER := FND_API.G_MISS_NUM,
251: default_date_val DATE := FND_API.G_MISS_DATE
252: );

Line 249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,

245: (
246: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
250: default_num_val NUMBER := FND_API.G_MISS_NUM,
251: default_date_val DATE := FND_API.G_MISS_DATE
252: );
253:

Line 250: default_num_val NUMBER := FND_API.G_MISS_NUM,

246: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
250: default_num_val NUMBER := FND_API.G_MISS_NUM,
251: default_date_val DATE := FND_API.G_MISS_DATE
252: );
253:
254: G_MISS_ITEM_PROPERTY_REC item_property_rec_type;

Line 251: default_date_val DATE := FND_API.G_MISS_DATE

247: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
248: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
249: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
250: default_num_val NUMBER := FND_API.G_MISS_NUM,
251: default_date_val DATE := FND_API.G_MISS_DATE
252: );
253:
254: G_MISS_ITEM_PROPERTY_REC item_property_rec_type;
255:

Line 272: name VARCHAR2(30) := FND_API.G_MISS_CHAR,

268: -- End of Comments
269:
270: TYPE flex_where_rec_type IS RECORD
271: (
272: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
273: value VARCHAR2(150) := FND_API.G_MISS_CHAR
274: );
275:
276: TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type

Line 273: value VARCHAR2(150) := FND_API.G_MISS_CHAR

269:
270: TYPE flex_where_rec_type IS RECORD
271: (
272: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
273: value VARCHAR2(150) := FND_API.G_MISS_CHAR
274: );
275:
276: TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type
277: INDEX BY BINARY_INTEGER;

Line 389: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

385: -- End of Comments
386: PROCEDURE Handle_Exceptions(
387: P_API_NAME IN VARCHAR2,
388: P_PKG_NAME IN VARCHAR2,
389: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
390: P_SQLCODE IN NUMBER := NULL,
391: P_SQLERRM IN VARCHAR2 := NULL,
392: P_PACKAGE_TYPE IN VARCHAR2,
393: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 428: := FND_API.G_FALSE,

424:
425: PROCEDURE Translate_OrderBy(
426: p_api_version_number IN NUMBER,
427: p_init_msg_list IN VARCHAR2
428: := FND_API.G_FALSE,
429: p_validation_level IN NUMBER
430: := FND_API.G_VALID_LEVEL_FULL,
431: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
432: x_order_by_clause OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 430: := FND_API.G_VALID_LEVEL_FULL,

426: p_api_version_number IN NUMBER,
427: p_init_msg_list IN VARCHAR2
428: := FND_API.G_FALSE,
429: p_validation_level IN NUMBER
430: := FND_API.G_VALID_LEVEL_FULL,
431: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
432: x_order_by_clause OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
433: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
434: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 474: -- p_encoded => FND_API.G_TRUE);

470: -- l_count := FND_MSG_PUB.Count_Msg;
471: -- FOR l_index IN 1..l_count LOOP
472: -- l_msg_data := FND_MSG_PUB.Get(
473: -- p_msg_index => l_index,
474: -- p_encoded => FND_API.G_TRUE);
475: -- END LOOP;
476: --
477: -- End of Comments
478:

Line 707: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

703: PROCEDURE Set_Message(
704: p_msg_level IN NUMBER,
705: p_app_name IN VARCHAR2,
706: p_msg_name IN VARCHAR2,
707: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

704: p_msg_level IN NUMBER,
705: p_app_name IN VARCHAR2,
706: p_msg_name IN VARCHAR2,
707: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

705: p_app_name IN VARCHAR2,
706: p_msg_name IN VARCHAR2,
707: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

706: p_msg_name IN VARCHAR2,
707: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

707: p_token1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

708: p_token1_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

709: p_token2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

710: p_token2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

711: p_token3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

712: p_token3_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

713: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
721: );

Line 718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

714: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
721: );
722:

Line 719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

715: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
721: );
722:
723:

Line 720: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

716: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
717: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
718: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
719: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
720: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
721: );
722:
723:
724:

Line 792: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

788: P_Qte_Header_Id IN NUMBER
789: ) RETURN ASO_QUOTE_PUB.qte_header_rec_Type;
790:
791: FUNCTION Query_Price_Adj_Rows (
792: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
793: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
794: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
795:
796: FUNCTION Query_Price_Adj_NonPRG_Rows (

Line 793: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

789: ) RETURN ASO_QUOTE_PUB.qte_header_rec_Type;
790:
791: FUNCTION Query_Price_Adj_Rows (
792: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
793: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
794: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
795:
796: FUNCTION Query_Price_Adj_NonPRG_Rows (
797: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 797: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

793: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
794: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
795:
796: FUNCTION Query_Price_Adj_NonPRG_Rows (
797: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
799: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
800:
801: FUNCTION Query_Price_Adj_Attr_Rows (

Line 798: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

794: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
795:
796: FUNCTION Query_Price_Adj_NonPRG_Rows (
797: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
799: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
800:
801: FUNCTION Query_Price_Adj_Attr_Rows (
802: p_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

Line 806: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

802: p_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
803: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
804:
805: FUNCTION Query_Payment_Rows (
806: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
807: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
808: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type;
809:
810: FUNCTION Query_Tax_Detail_Rows (

Line 807: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

803: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
804:
805: FUNCTION Query_Payment_Rows (
806: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
807: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
808: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type;
809:
810: FUNCTION Query_Tax_Detail_Rows (
811: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 811: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

807: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
808: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type;
809:
810: FUNCTION Query_Tax_Detail_Rows (
811: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
812: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
813: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
814: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
815:

Line 812: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

808: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type;
809:
810: FUNCTION Query_Tax_Detail_Rows (
811: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
812: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
813: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
814: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
815:
816: FUNCTION Query_Shipment_Row (

Line 817: P_Shipment_Id IN NUMBER := FND_API.G_MISS_NUM

813: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
814: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
815:
816: FUNCTION Query_Shipment_Row (
817: P_Shipment_Id IN NUMBER := FND_API.G_MISS_NUM
818: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type;
819:
820: FUNCTION Query_Shipment_Rows (
821: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 821: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

817: P_Shipment_Id IN NUMBER := FND_API.G_MISS_NUM
818: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type;
819:
820: FUNCTION Query_Shipment_Rows (
821: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
822: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
823: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type;
824:
825: FUNCTION Query_Line_Shipment_Row_atp (

Line 822: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

818: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type;
819:
820: FUNCTION Query_Shipment_Rows (
821: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
822: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
823: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type;
824:
825: FUNCTION Query_Line_Shipment_Row_atp (
826: P_Qte_Header_Id IN NUMBER,

Line 855: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

851: P_Qte_Line_Id IN NUMBER
852: ) RETURN ASO_QUOTE_PUB.qte_line_rec_Type;
853:
854: FUNCTION Query_Qte_Line_Rows (
855: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
856: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
857:
858: FUNCTION Query_Qte_Line_Rows_Submit (
859: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

Line 859: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

855: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
856: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
857:
858: FUNCTION Query_Qte_Line_Rows_Submit (
859: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
860: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
861:
862: FUNCTION Query_Qte_Line_Rows_Sort (
863: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

Line 863: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

859: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
860: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
861:
862: FUNCTION Query_Qte_Line_Rows_Sort (
863: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
864: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
865:
866: FUNCTION Query_Qte_Line_Rows_atp (
867: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

Line 867: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM

863: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
864: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
865:
866: FUNCTION Query_Qte_Line_Rows_atp (
867: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
868: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
869:
870: FUNCTION Query_Pricing_Line_Rows (
871: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 871: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

867: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
868: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
869:
870: FUNCTION Query_Pricing_Line_Rows (
871: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
872: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
873: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
874:
875: FUNCTION Query_Pricing_Line_Row (

Line 872: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE

868: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
869:
870: FUNCTION Query_Pricing_Line_Rows (
871: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
872: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
873: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
874:
875: FUNCTION Query_Pricing_Line_Row (
876: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 876: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

872: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
873: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
874:
875: FUNCTION Query_Pricing_Line_Row (
876: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
877: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
878: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
879:
880: FUNCTION Query_Line_Dtl_Rows (

Line 877: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

873: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
874:
875: FUNCTION Query_Pricing_Line_Row (
876: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
877: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
878: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
879:
880: FUNCTION Query_Line_Dtl_Rows (
881: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

Line 881: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

877: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
878: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
879:
880: FUNCTION Query_Line_Dtl_Rows (
881: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
882: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
883:
884: FUNCTION Query_Line_Attribs_Ext_Rows(
885: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

Line 885: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

881: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
882: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
883:
884: FUNCTION Query_Line_Attribs_Ext_Rows(
885: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
886: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
887:
888: FUNCTION Query_Line_Attribs_header_Rows(
889: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM

Line 889: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM

885: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
886: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
887:
888: FUNCTION Query_Line_Attribs_header_Rows(
889: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM
890: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
891:
892:
893: FUNCTION Query_Price_Attr_Rows (

Line 894: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

890: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
891:
892:
893: FUNCTION Query_Price_Attr_Rows (
894: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
895: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
896: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
897:
898:

Line 895: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

891:
892:
893: FUNCTION Query_Price_Attr_Rows (
894: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
895: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
896: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
897:
898:
899: FUNCTION Query_Price_Adj_Rltship_Rows (

Line 900: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM

896: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
897:
898:
899: FUNCTION Query_Price_Adj_Rltship_Rows (
900: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM
901: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
902:
903:
904: FUNCTION Query_Price_Adj_Rltn_Rows (

Line 905: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM

901: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
902:
903:
904: FUNCTION Query_Price_Adj_Rltn_Rows (
905: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM
906: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
907:
908:
909: FUNCTION Get_Profile_Obsolete_Status (