785: x_msgs OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
786:
787: FUNCTION Query_Header_Row (
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
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,
798: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
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
803: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
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
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,
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
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
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,
812: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
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 (
817: P_Shipment_Id IN NUMBER := FND_API.G_MISS_NUM
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 (
817: P_Shipment_Id IN NUMBER := FND_API.G_MISS_NUM
818: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_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,
822: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
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,
827: P_Qte_Line_Id IN NUMBER
824:
825: FUNCTION Query_Line_Shipment_Row_atp (
826: P_Qte_Header_Id IN NUMBER,
827: P_Qte_Line_Id IN NUMBER
828: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type;
829:
830: FUNCTION Query_Freight_Charge_Rows (
831: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
832: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
827: P_Qte_Line_Id IN NUMBER
828: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type;
829:
830: FUNCTION Query_Freight_Charge_Rows (
831: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
832: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
833:
834: FUNCTION Query_Sales_Credit_Row (
835: P_Sales_Credit_Id IN NUMBER
828: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type;
829:
830: FUNCTION Query_Freight_Charge_Rows (
831: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
832: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
833:
834: FUNCTION Query_Sales_Credit_Row (
835: P_Sales_Credit_Id IN NUMBER
836: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type;
832: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
833:
834: FUNCTION Query_Sales_Credit_Row (
835: P_Sales_Credit_Id IN NUMBER
836: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type;
837:
838: FUNCTION Query_Sales_Credit_Row (
839: P_qte_header_Id IN NUMBER,
840: p_qte_line_id IN NUMBER
837:
838: FUNCTION Query_Sales_Credit_Row (
839: P_qte_header_Id IN NUMBER,
840: p_qte_line_id IN NUMBER
841: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
842: FUNCTION Query_Quote_Party_Row (
843: P_Qte_header_Id IN NUMBER,
844: p_qte_line_id IN NUMBER
845: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
841: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
842: FUNCTION Query_Quote_Party_Row (
843: P_Qte_header_Id IN NUMBER,
844: p_qte_line_id IN NUMBER
845: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
846: FUNCTION Query_Quote_Party_Row (
847: P_Quote_Party_Id IN NUMBER
848: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
849:
844: p_qte_line_id IN NUMBER
845: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
846: FUNCTION Query_Quote_Party_Row (
847: P_Quote_Party_Id IN NUMBER
848: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
849:
850: FUNCTION Query_Qte_Line_Row (
851: P_Qte_Line_Id IN NUMBER
852: ) RETURN ASO_QUOTE_PUB.qte_line_rec_Type;
848: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
849:
850: FUNCTION Query_Qte_Line_Row (
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;
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
860: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
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
864: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
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
868: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
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,
872: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
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,
877: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
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
882: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
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
886: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
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
890: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
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 (
894: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
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 (
900: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM
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 (
905: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM
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 (
910: p_profile_name IN VARCHAR2,
910: p_profile_name IN VARCHAR2,
911: p_application_id IN NUMBER
912: ) RETURN VARCHAR2;
913:
914: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE;
915: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
911: p_application_id IN NUMBER
912: ) RETURN VARCHAR2;
913:
914: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE;
915: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
912: ) RETURN VARCHAR2;
913:
914: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE;
915: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
913:
914: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE;
915: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
914: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE;
915: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
915: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
916: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
917: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
918: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
919: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
920: FUNCTION GET_Price_Attributes_Rec RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
921: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
922: FUNCTION GET_PRICE_ADJ_ATTR_Rec RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
923: FUNCTION GET_Price_Adj_Rltship_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
924: FUNCTION GET_Sales_Credit_Rec RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE;
925: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
926: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
927: FUNCTION GET_Freight_Charge_Rec RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
928: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE;
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
929: FUNCTION GET_Tax_Control_Rec RETURN ASO_TAX_INT.Tax_control_rec_type ;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
937: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE;
930: FUNCTION GET_Header_Rltship_Rec RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
937: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE;
938: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type;
931: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE;
932: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
937: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE;
938: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type;
939: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
933: FUNCTION GET_Related_Object_Rec RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
937: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE;
938: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type;
939: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
940:
941: FUNCTION GET_Party_Rec RETURN ASO_PARTY_INT.Party_Rec_Type;
934: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
937: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE;
938: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type;
939: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
940:
941: FUNCTION GET_Party_Rec RETURN ASO_PARTY_INT.Party_Rec_Type;
942: FUNCTION GET_Location_Rec RETURN ASO_PARTY_INT.Location_Rec_Type;
935: FUNCTION GET_Line_Attribs_Ext_Rec RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE;
936:
937: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE;
938: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type;
939: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
940:
941: FUNCTION GET_Party_Rec RETURN ASO_PARTY_INT.Party_Rec_Type;
942: FUNCTION GET_Location_Rec RETURN ASO_PARTY_INT.Location_Rec_Type;
943: FUNCTION GET_Party_Site_Rec RETURN ASO_PARTY_INT.Party_Site_Rec_Type;
990:
991: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
992: PROCEDURE PRINT_LOGIN_INFO;
993:
994: FUNCTION Tax_Rec_Exists( p_tax_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type ) RETURN BOOLEAN;
995:
996: END ASO_UTILITY_PVT;
997: