[Home] [Help]
510: END Get_Messages;
511:
512: FUNCTION Query_Header_Row (
513: P_Qte_Header_Id IN NUMBER
514: ) RETURN ASO_QUOTE_PUB.qte_header_rec_Type
515: IS
516: l_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_Type;
517: BEGIN
518: Select
512: FUNCTION Query_Header_Row (
513: P_Qte_Header_Id IN NUMBER
514: ) RETURN ASO_QUOTE_PUB.qte_header_rec_Type
515: IS
516: l_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_Type;
517: BEGIN
518: Select
519: quote_header_id,
520: CREATION_DATE,
764:
765: FUNCTION Query_Price_Adj_Rows (
766: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
767: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
768: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
769: IS
770: CURSOR c_price_adj_hdr IS
771: SELECT
772: PRICE_ADJUSTMENT_ID,
965: WHERE quote_header_id = p_qte_header_id
966: AND quote_line_id IS NOT NULL
967: AND quote_line_id = p_qte_line_id;
968:
969: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
970: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
971: BEGIN
972: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
973: FOR price_adj_rec IN c_price_adj_hdr LOOP
966: AND quote_line_id IS NOT NULL
967: AND quote_line_id = p_qte_line_id;
968:
969: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
970: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
971: BEGIN
972: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
973: FOR price_adj_rec IN c_price_adj_hdr LOOP
974: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1168:
1169: FUNCTION Query_Price_Adj_NonPRG_Rows (
1170: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1171: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1172: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1173: IS
1174: CURSOR c_price_adj_hdr IS
1175: SELECT
1176: PRICE_ADJUSTMENT_ID,
1370: AND quote_line_id IS NOT NULL
1371: AND quote_line_id = p_qte_line_id
1372: AND modifier_line_type_code <> 'PRG';
1373:
1374: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1375: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1376: BEGIN
1377: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1378: FOR price_adj_rec IN c_price_adj_hdr LOOP
1371: AND quote_line_id = p_qte_line_id
1372: AND modifier_line_type_code <> 'PRG';
1373:
1374: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1375: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1376: BEGIN
1377: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1378: FOR price_adj_rec IN c_price_adj_hdr LOOP
1379: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1574: /************Commenting it out for performance fix*****************************************************
1575: FUNCTION Query_Price_Adj_NonPRG_Rows (
1576: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1577: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1578: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1579: IS
1580: CURSOR c_price_adj IS
1581: SELECT
1582: PRICE_ADJUSTMENT_ID,
1675: (quote_line_id = p_qte_line_id OR
1676: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
1677: AND modifier_line_type_code <> 'PRG';
1678:
1679: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1680: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1681:
1682: BEGIN
1683: FOR price_adj_rec IN c_price_adj LOOP
1676: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
1677: AND modifier_line_type_code <> 'PRG';
1678:
1679: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1680: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1681:
1682: BEGIN
1683: FOR price_adj_rec IN c_price_adj LOOP
1684: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1777: ************************************************************************************************************/
1778:
1779:
1780: FUNCTION Query_Price_Adj_Attr_Rows (
1781: p_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1782: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1783: IS
1784: CURSOR c_price_adj_attr (c_price_adj_id NUMBER) IS
1785: SELECT
1778:
1779:
1780: FUNCTION Query_Price_Adj_Attr_Rows (
1781: p_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1782: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1783: IS
1784: CURSOR c_price_adj_attr (c_price_adj_id NUMBER) IS
1785: SELECT
1786: PRICE_ADJ_ATTRIB_ID,
1802: FLEX_TITLE,
1803: OBJECT_VERSION_NUMBER
1804: FROM ASO_PRICE_ADJ_ATTRIBS
1805: WHERE PRICE_ADJUSTMENT_ID = c_price_adj_id;
1806: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_rec_Type;
1807: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1808: BEGIN
1809: FOR i IN 1..P_price_adj_tbl.count LOOP
1810: FOR price_adj_attr_rec IN c_price_adj_attr(P_price_adj_tbl(i).PRICE_ADJUSTMENT_ID) LOOP
1803: OBJECT_VERSION_NUMBER
1804: FROM ASO_PRICE_ADJ_ATTRIBS
1805: WHERE PRICE_ADJUSTMENT_ID = c_price_adj_id;
1806: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_rec_Type;
1807: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1808: BEGIN
1809: FOR i IN 1..P_price_adj_tbl.count LOOP
1810: FOR price_adj_attr_rec IN c_price_adj_attr(P_price_adj_tbl(i).PRICE_ADJUSTMENT_ID) LOOP
1811: l_price_adj_attr_rec.PRICE_ADJ_ATTRIB_ID :=
1837:
1838: FUNCTION Query_Payment_Rows (
1839: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1840: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1841: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type
1842: IS
1843: CURSOR c_payment IS
1844: SELECT
1845: PAYMENT_ID,
1894: FROM ASO_PAYMENTS
1895: WHERE quote_header_id = p_qte_header_id AND
1896: (quote_line_id = p_qte_line_id OR
1897: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
1898: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1899: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1900: BEGIN
1901: FOR payment_rec IN c_payment LOOP
1902: l_payment_rec.PAYMENT_ID := payment_rec.PAYMENT_ID;
1895: WHERE quote_header_id = p_qte_header_id AND
1896: (quote_line_id = p_qte_line_id OR
1897: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
1898: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1899: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1900: BEGIN
1901: FOR payment_rec IN c_payment LOOP
1902: l_payment_rec.PAYMENT_ID := payment_rec.PAYMENT_ID;
1903: l_payment_rec.CREATION_DATE := payment_rec.CREATION_DATE;
1961:
1962: FUNCTION Query_Tax_Detail_Rows (
1963: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1964: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1965: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1966: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1967: IS
1968: CURSOR c_tax1 IS
1969: SELECT
1962: FUNCTION Query_Tax_Detail_Rows (
1963: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1964: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1965: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1966: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1967: IS
1968: CURSOR c_tax1 IS
1969: SELECT
1970: TAX_DETAIL_ID,
2068: and quote_header_id = p_qte_header_id
2069: and quote_line_id IS NOT NULL
2070: AND quote_line_id = p_qte_line_id;
2071:
2072: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2073: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2074: BEGIN
2075: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2076:
2069: and quote_line_id IS NOT NULL
2070: AND quote_line_id = p_qte_line_id;
2071:
2072: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2073: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2074: BEGIN
2075: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2076:
2077: FOR tax_rec IN c_tax1 LOOP
2179: END Query_Tax_Detail_Rows;
2180:
2181: FUNCTION Query_shipment_Row (
2182: P_shipment_Id IN NUMBER
2183: ) RETURN ASO_QUOTE_PUB.shipment_rec_Type
2184: IS
2185: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_Type;
2186: BEGIN
2187: Select
2181: FUNCTION Query_shipment_Row (
2182: P_shipment_Id IN NUMBER
2183: ) RETURN ASO_QUOTE_PUB.shipment_rec_Type
2184: IS
2185: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_Type;
2186: BEGIN
2187: Select
2188: SHIPMENT_ID,
2189: CREATION_DATE,
2320:
2321: FUNCTION Query_Shipment_Rows (
2322: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2323: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2324: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type
2325: IS
2326: CURSOR c_shipment_hdr IS
2327: SELECT
2328: SHIPMENT_ID,
2456: WHERE quote_header_id = p_qte_header_id
2457: AND quote_line_id IS NOT NULL
2458: AND quote_line_id = p_qte_line_id;
2459:
2460: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2461: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2462: BEGIN
2463: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2464: FOR shipment_rec IN c_shipment_hdr LOOP
2457: AND quote_line_id IS NOT NULL
2458: AND quote_line_id = p_qte_line_id;
2459:
2460: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2461: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2462: BEGIN
2463: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2464: FOR shipment_rec IN c_shipment_hdr LOOP
2465: l_shipment_rec.SHIPMENT_ID := shipment_rec.SHIPMENT_ID;
2595:
2596: FUNCTION Query_Line_Shipment_Row_atp (
2597: P_Qte_Header_Id IN NUMBER,
2598: P_Qte_Line_Id IN NUMBER
2599: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type
2600: IS
2601: CURSOR c_shipment IS
2602: SELECT
2603: SHIPMENT_ID,
2664: FROM ASO_SHIPMENTS
2665: WHERE quote_header_id = p_qte_header_id
2666: AND quote_line_id = p_qte_line_id;
2667:
2668: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2669: BEGIN
2670:
2671: FOR shipment_rec IN c_shipment LOOP
2672:
2736:
2737: END Query_Line_Shipment_Row_atp;
2738:
2739: FUNCTION Query_Freight_Charge_Rows (
2740: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2741: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2742: IS
2743: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
2744: SELECT
2737: END Query_Line_Shipment_Row_atp;
2738:
2739: FUNCTION Query_Freight_Charge_Rows (
2740: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2741: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2742: IS
2743: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
2744: SELECT
2745: FREIGHT_CHARGE_ID,
2772: ATTRIBUTE14,
2773: ATTRIBUTE15
2774: FROM ASO_FREIGHT_CHARGES
2775: WHERE quote_shipment_id = c_shipment_id;
2776: l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
2777: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2778: BEGIN
2779: FOR i IN 1..P_shipment_tbl.count LOOP
2780: FOR freight_charge_rec IN c_freight_charge(P_shipment_tbl(i).shipment_id) LOOP
2773: ATTRIBUTE15
2774: FROM ASO_FREIGHT_CHARGES
2775: WHERE quote_shipment_id = c_shipment_id;
2776: l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
2777: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2778: BEGIN
2779: FOR i IN 1..P_shipment_tbl.count LOOP
2780: FOR freight_charge_rec IN c_freight_charge(P_shipment_tbl(i).shipment_id) LOOP
2781: l_freight_charge_rec.FREIGHT_CHARGE_ID :=
2818: END Query_Freight_Charge_Rows;
2819:
2820: FUNCTION Query_Sales_Credit_Row (
2821: P_Sales_Credit_Id IN NUMBER
2822: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type
2823: IS
2824: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2825: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2826:
2820: FUNCTION Query_Sales_Credit_Row (
2821: P_Sales_Credit_Id IN NUMBER
2822: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type
2823: IS
2824: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2825: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2826:
2827: CURSOR C1 IS
2828: SELECT
2821: P_Sales_Credit_Id IN NUMBER
2822: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type
2823: IS
2824: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2825: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2826:
2827: CURSOR C1 IS
2828: SELECT
2829: CREATION_DATE,
2919:
2920: FUNCTION Query_Sales_Credit_Row (
2921: P_qte_header_Id IN NUMBER,
2922: p_qte_line_id IN NUMBER
2923: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
2924: IS
2925: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2926: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2927:
2921: P_qte_header_Id IN NUMBER,
2922: p_qte_line_id IN NUMBER
2923: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
2924: IS
2925: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2926: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2927:
2928: CURSOR C1 IS
2929: SELECT
2922: p_qte_line_id IN NUMBER
2923: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
2924: IS
2925: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2926: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2927:
2928: CURSOR C1 IS
2929: SELECT
2930: CREATION_DATE,
3023:
3024:
3025: FUNCTION Query_Quote_Party_Row (
3026: P_Quote_Party_Id IN NUMBER
3027: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type
3028: IS
3029: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3030: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3031:
3025: FUNCTION Query_Quote_Party_Row (
3026: P_Quote_Party_Id IN NUMBER
3027: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type
3028: IS
3029: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3030: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3031:
3032: CURSOR C1 is
3033: SELECT QUOTE_PARTY_ID,
3026: P_Quote_Party_Id IN NUMBER
3027: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type
3028: IS
3029: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3030: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3031:
3032: CURSOR C1 is
3033: SELECT QUOTE_PARTY_ID,
3034: CREATION_DATE,
3109:
3110: FUNCTION Query_Quote_Party_Row (
3111: P_Qte_header_Id IN NUMBER,
3112: P_Qte_line_Id IN NUMBER
3113: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
3114: IS
3115: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3116: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3117:
3111: P_Qte_header_Id IN NUMBER,
3112: P_Qte_line_Id IN NUMBER
3113: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
3114: IS
3115: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3116: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3117:
3118: CURSOR C1 is
3119: SELECT QUOTE_PARTY_ID,
3112: P_Qte_line_Id IN NUMBER
3113: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
3114: IS
3115: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3116: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3117:
3118: CURSOR C1 is
3119: SELECT QUOTE_PARTY_ID,
3120: CREATION_DATE,
3197:
3198:
3199: FUNCTION Query_Qte_Line_Row (
3200: P_Qte_Line_Id IN NUMBER
3201: ) RETURN ASO_QUOTE_PUB.qte_line_rec_Type
3202: IS
3203: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
3204: BEGIN
3205: Select
3199: FUNCTION Query_Qte_Line_Row (
3200: P_Qte_Line_Id IN NUMBER
3201: ) RETURN ASO_QUOTE_PUB.qte_line_rec_Type
3202: IS
3203: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
3204: BEGIN
3205: Select
3206: QUOTE_LINE_ID,
3207: CREATION_DATE,
3393:
3394:
3395: FUNCTION Query_Qte_Line_Rows (
3396: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3397: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3398: IS
3399: CURSOR c_Qte_Line IS
3400: SELECT
3401: QUOTE_LINE_ID,
3488:
3489: FROM ASO_Quote_Lines_All
3490: WHERE quote_header_id = p_qte_header_id
3491: ORDER BY Line_Number;
3492: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3493: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3494: BEGIN
3495: FOR Line_rec IN c_Qte_Line LOOP
3496: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3489: FROM ASO_Quote_Lines_All
3490: WHERE quote_header_id = p_qte_header_id
3491: ORDER BY Line_Number;
3492: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3493: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3494: BEGIN
3495: FOR Line_rec IN c_Qte_Line LOOP
3496: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3497: l_qte_line_rec.CREATION_DATE := line_rec.CREATION_DATE;
3586:
3587:
3588: FUNCTION Query_Qte_Line_Rows_Submit (
3589: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3590: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3591: IS
3592: CURSOR c_Qte_Line IS
3593: SELECT
3594: QUOTE_LINE_ID,
3678: */
3679: FROM ASO_Pvt_Quote_Lines_Bali_V
3680: WHERE quote_header_id = p_qte_header_id;
3681:
3682: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3683: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3684: BEGIN
3685: FOR Line_rec IN c_Qte_Line LOOP
3686: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3679: FROM ASO_Pvt_Quote_Lines_Bali_V
3680: WHERE quote_header_id = p_qte_header_id;
3681:
3682: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3683: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3684: BEGIN
3685: FOR Line_rec IN c_Qte_Line LOOP
3686: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3687: l_qte_line_rec.CREATION_DATE := line_rec.CREATION_DATE;
3773:
3774:
3775: FUNCTION Query_Qte_Line_Rows_Sort (
3776: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3777: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3778: IS
3779: CURSOR c_Qte_Line IS
3780: SELECT
3781: QUOTE_LINE_ID,
3863: TRX_BUSINESS_CATEGORY*/
3864: FROM aso_pvt_quote_lines_sort_v
3865: WHERE quote_header_id = p_qte_header_id;
3866:
3867: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3868: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3869:
3870: BEGIN
3871: FOR Line_rec IN c_Qte_Line LOOP
3864: FROM aso_pvt_quote_lines_sort_v
3865: WHERE quote_header_id = p_qte_header_id;
3866:
3867: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3868: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3869:
3870: BEGIN
3871: FOR Line_rec IN c_Qte_Line LOOP
3872: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3961: END Query_Qte_Line_Rows_Sort;
3962:
3963: FUNCTION Query_Qte_Line_Rows_atp (
3964: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3965: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3966: IS
3967: CURSOR c_Qte_Line IS
3968: SELECT
3969: QUOTE_LINE_ID,
4052: TRX_BUSINESS_CATEGORY*/
4053: --CONFIG_MODEL_TYPE
4054: FROM ASO_PVT_QUOTE_LINES_BALI_V
4055: WHERE quote_header_id = p_qte_header_id;
4056: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4057: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4058: BEGIN
4059: FOR Line_rec IN c_Qte_Line LOOP
4060: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
4053: --CONFIG_MODEL_TYPE
4054: FROM ASO_PVT_QUOTE_LINES_BALI_V
4055: WHERE quote_header_id = p_qte_header_id;
4056: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4057: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4058: BEGIN
4059: FOR Line_rec IN c_Qte_Line LOOP
4060: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
4061: l_qte_line_rec.CREATION_DATE := line_rec.CREATION_DATE;
4153:
4154: FUNCTION Query_Pricing_Line_Rows (
4155: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4156: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
4157: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4158: IS
4159: CURSOR c_Qte_Line IS
4160: SELECT
4161: QUOTE_LINE_ID,
4321: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4322: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4323: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4324:
4325: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4326: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4327: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4328: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4329:
4322: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4323: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4324:
4325: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4326: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4327: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4328: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4329:
4330: BEGIN
4692:
4693: FUNCTION Query_Pricing_Line_Row (
4694: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4695: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4696: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4697: IS
4698: CURSOR c_Qte_Line IS
4699: SELECT
4700: QUOTE_LINE_ID,
4872: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4873: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4874: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4875:
4876: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4877: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4878: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4879: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4880: BEGIN
4873: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4874: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4875:
4876: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4877: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4878: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4879: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4880: BEGIN
4881: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5224:
5225:
5226: FUNCTION Query_Line_Dtl_Rows (
5227: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5228: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
5229: IS
5230: CURSOR c_Line_Dtl IS
5231: SELECT
5232: QUOTE_LINE_DETAIL_ID,
5311: CONFIG_DELTA,
5312: CONFIG_INSTANCE_NAME
5313: FROM ASO_Quote_Line_Details
5314: WHERE quote_line_id = p_qte_line_id;
5315: l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
5316: l_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5317: BEGIN
5318: FOR Line_Dtl_rec IN c_Line_Dtl LOOP
5319: l_line_dtl_rec.QUOTE_LINE_DETAIL_ID := line_dtl_rec.QUOTE_LINE_DETAIL_ID;
5312: CONFIG_INSTANCE_NAME
5313: FROM ASO_Quote_Line_Details
5314: WHERE quote_line_id = p_qte_line_id;
5315: l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
5316: l_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5317: BEGIN
5318: FOR Line_Dtl_rec IN c_Line_Dtl LOOP
5319: l_line_dtl_rec.QUOTE_LINE_DETAIL_ID := line_dtl_rec.QUOTE_LINE_DETAIL_ID;
5320: l_line_dtl_rec.QUOTE_LINE_ID := line_dtl_rec.QUOTE_LINE_ID;
5410:
5411:
5412: FUNCTION Query_Line_Attribs_header_Rows(
5413: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM
5414: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
5415: IS
5416: CURSOR c_Line_Attr_Ext IS
5417: SELECT
5418: LINE_ATTRIBUTE_ID,
5438: QUOTE_SHIPMENT_ID
5439: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
5440: WHERE quote_header_id = p_qte_header_id AND
5441: quote_line_id is null;
5442: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
5443: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5444: BEGIN
5445: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
5446: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
5439: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
5440: WHERE quote_header_id = p_qte_header_id AND
5441: quote_line_id is null;
5442: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
5443: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5444: BEGIN
5445: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
5446: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
5447: l_line_attr_ext_rec.QUOTE_LINE_ID := line_attr_ext_rec.QUOTE_LINE_ID;
5471:
5472:
5473: FUNCTION Query_Line_Attribs_Ext_Rows(
5474: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5475: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
5476: IS
5477: CURSOR c_Line_Attr_Ext IS
5478: SELECT
5479: LINE_ATTRIBUTE_ID,
5498: QUOTE_HEADER_ID,
5499: QUOTE_SHIPMENT_ID
5500: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
5501: WHERE quote_line_id = p_qte_line_id;
5502: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
5503: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5504: BEGIN
5505: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
5506: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
5499: QUOTE_SHIPMENT_ID
5500: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
5501: WHERE quote_line_id = p_qte_line_id;
5502: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
5503: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5504: BEGIN
5505: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
5506: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
5507: l_line_attr_ext_rec.QUOTE_LINE_ID := line_attr_ext_rec.QUOTE_LINE_ID;
5532:
5533: FUNCTION Query_Price_Attr_Rows (
5534: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
5535: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5536: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
5537: IS
5538: CURSOR c_price_attr IS
5539: SELECT
5540: PRICE_ATTRIBUTE_ID,
5676: FROM ASO_PRICE_ATTRIBUTES
5677: WHERE quote_header_id = p_qte_header_id AND
5678: (quote_line_id = p_qte_line_id OR
5679: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
5680: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
5681: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5682: BEGIN
5683: FOR price_attr_rec IN c_price_attr LOOP
5684: l_price_attr_rec.PRICE_ATTRIBUTE_ID := price_attr_rec.PRICE_ATTRIBUTE_ID;
5677: WHERE quote_header_id = p_qte_header_id AND
5678: (quote_line_id = p_qte_line_id OR
5679: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
5680: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
5681: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5682: BEGIN
5683: FOR price_attr_rec IN c_price_attr LOOP
5684: l_price_attr_rec.PRICE_ATTRIBUTE_ID := price_attr_rec.PRICE_ATTRIBUTE_ID;
5685: l_price_attr_rec.CREATION_DATE := price_attr_rec.CREATION_DATE;
5823: END Query_Price_Attr_Rows;
5824:
5825: FUNCTION Query_Price_Adj_Rltship_Rows (
5826: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM
5827: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5828: IS
5829: CURSOR C_Price_Adj_Rltd IS
5830: SELECT
5831: ADJ_RELATIONSHIP_ID
5846: ,OBJECT_VERSION_NUMBER
5847: FROM aso_price_adj_relationships
5848: WHERE price_adjustment_id = P_Price_Adjustment_Id;
5849:
5850: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5851: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5852:
5853: BEGIN
5854: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5847: FROM aso_price_adj_relationships
5848: WHERE price_adjustment_id = P_Price_Adjustment_Id;
5849:
5850: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5851: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5852:
5853: BEGIN
5854: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5855: l_price_adj_rltd_rec.ADJ_RELATIONSHIP_ID := C_Price_Adj_Rltd_Rec.ADJ_RELATIONSHIP_ID;
5873:
5874:
5875: FUNCTION Query_Price_Adj_Rltn_Rows (
5876: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5877: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5878: IS
5879: CURSOR C_Price_Adj_Rltd IS
5880: SELECT
5881: ADJ_RELATIONSHIP_ID
5896: ,OBJECT_VERSION_NUMBER
5897: FROM aso_price_adj_relationships
5898: WHERE quote_line_id = P_Quote_Line_Id;
5899:
5900: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5901: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5902:
5903: BEGIN
5904: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5897: FROM aso_price_adj_relationships
5898: WHERE quote_line_id = P_Quote_Line_Id;
5899:
5900: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5901: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5902:
5903: BEGIN
5904: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5905: l_price_adj_rltd_rec.ADJ_RELATIONSHIP_ID := C_Price_Adj_Rltd_Rec.ADJ_RELATIONSHIP_ID;
5973:
5974: end Get_Profile_Obsolete_Status;
5975:
5976:
5977: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE
5978: IS
5979: TMP_REC ASO_QUOTE_PUB.Control_REC_TYPE;
5980: BEGIN
5981: RETURN TMP_REC;
5975:
5976:
5977: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE
5978: IS
5979: TMP_REC ASO_QUOTE_PUB.Control_REC_TYPE;
5980: BEGIN
5981: RETURN TMP_REC;
5982: END GET_Control_Rec;
5983:
5980: BEGIN
5981: RETURN TMP_REC;
5982: END GET_Control_Rec;
5983:
5984: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE
5985: IS
5986: TMP_REC ASO_QUOTE_PUB.Qte_Header_REC_TYPE;
5987: BEGIN
5988: RETURN TMP_REC;
5982: END GET_Control_Rec;
5983:
5984: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE
5985: IS
5986: TMP_REC ASO_QUOTE_PUB.Qte_Header_REC_TYPE;
5987: BEGIN
5988: RETURN TMP_REC;
5989: END GET_Qte_Header_Rec;
5990:
5987: BEGIN
5988: RETURN TMP_REC;
5989: END GET_Qte_Header_Rec;
5990:
5991: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE
5992: IS
5993: TMP_REC ASO_QUOTE_PUB.Qte_Sort_REC_TYPE;
5994: BEGIN
5995: RETURN TMP_REC;
5989: END GET_Qte_Header_Rec;
5990:
5991: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE
5992: IS
5993: TMP_REC ASO_QUOTE_PUB.Qte_Sort_REC_TYPE;
5994: BEGIN
5995: RETURN TMP_REC;
5996: END GET_Qte_Sort_Rec;
5997:
5994: BEGIN
5995: RETURN TMP_REC;
5996: END GET_Qte_Sort_Rec;
5997:
5998: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE
5999: IS
6000: TMP_REC ASO_QUOTE_PUB.Qte_Line_REC_TYPE;
6001: BEGIN
6002: RETURN TMP_REC;
5996: END GET_Qte_Sort_Rec;
5997:
5998: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE
5999: IS
6000: TMP_REC ASO_QUOTE_PUB.Qte_Line_REC_TYPE;
6001: BEGIN
6002: RETURN TMP_REC;
6003: END GET_Qte_Line_Rec;
6004:
6001: BEGIN
6002: RETURN TMP_REC;
6003: END GET_Qte_Line_Rec;
6004:
6005: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE
6006: IS
6007: TMP_REC ASO_QUOTE_PUB.Qte_Line_sort_REC_TYPE;
6008: BEGIN
6009: RETURN TMP_REC;
6003: END GET_Qte_Line_Rec;
6004:
6005: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE
6006: IS
6007: TMP_REC ASO_QUOTE_PUB.Qte_Line_sort_REC_TYPE;
6008: BEGIN
6009: RETURN TMP_REC;
6010: END GET_Qte_Line_sort_Rec;
6011:
6008: BEGIN
6009: RETURN TMP_REC;
6010: END GET_Qte_Line_sort_Rec;
6011:
6012: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE
6013: IS
6014: TMP_REC ASO_QUOTE_PUB.Qte_Line_Dtl_REC_TYPE;
6015: BEGIN
6016: RETURN TMP_REC;
6010: END GET_Qte_Line_sort_Rec;
6011:
6012: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE
6013: IS
6014: TMP_REC ASO_QUOTE_PUB.Qte_Line_Dtl_REC_TYPE;
6015: BEGIN
6016: RETURN TMP_REC;
6017: END GET_Qte_Line_Dtl_Rec;
6018:
6016: RETURN TMP_REC;
6017: END GET_Qte_Line_Dtl_Rec;
6018:
6019: FUNCTION GET_Price_Attributes_Rec
6020: RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE
6021: IS
6022: TMP_REC ASO_QUOTE_PUB.Price_Attributes_REC_TYPE;
6023: BEGIN
6024: RETURN TMP_REC;
6018:
6019: FUNCTION GET_Price_Attributes_Rec
6020: RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE
6021: IS
6022: TMP_REC ASO_QUOTE_PUB.Price_Attributes_REC_TYPE;
6023: BEGIN
6024: RETURN TMP_REC;
6025: END GET_Price_Attributes_Rec;
6026:
6023: BEGIN
6024: RETURN TMP_REC;
6025: END GET_Price_Attributes_Rec;
6026:
6027: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE
6028: IS
6029: TMP_REC ASO_QUOTE_PUB.Price_Adj_REC_TYPE;
6030: BEGIN
6031: RETURN TMP_REC;
6025: END GET_Price_Attributes_Rec;
6026:
6027: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE
6028: IS
6029: TMP_REC ASO_QUOTE_PUB.Price_Adj_REC_TYPE;
6030: BEGIN
6031: RETURN TMP_REC;
6032: END GET_Price_Adj_Rec;
6033:
6031: RETURN TMP_REC;
6032: END GET_Price_Adj_Rec;
6033:
6034: FUNCTION GET_PRICE_ADJ_ATTR_Rec
6035: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE
6036: IS
6037: TMP_REC ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
6038: BEGIN
6039: RETURN TMP_REC;
6033:
6034: FUNCTION GET_PRICE_ADJ_ATTR_Rec
6035: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE
6036: IS
6037: TMP_REC ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
6038: BEGIN
6039: RETURN TMP_REC;
6040: END GET_PRICE_ADJ_ATTR_Rec;
6041:
6040: END GET_PRICE_ADJ_ATTR_Rec;
6041:
6042:
6043: FUNCTION GET_Price_Adj_Rltship_Rec
6044: RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE
6045: IS
6046: TMP_REC ASO_QUOTE_PUB.Price_Adj_Rltship_REC_TYPE;
6047: BEGIN
6048: RETURN TMP_REC;
6042:
6043: FUNCTION GET_Price_Adj_Rltship_Rec
6044: RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE
6045: IS
6046: TMP_REC ASO_QUOTE_PUB.Price_Adj_Rltship_REC_TYPE;
6047: BEGIN
6048: RETURN TMP_REC;
6049: END GET_Price_Adj_Rltship_Rec;
6050:
6048: RETURN TMP_REC;
6049: END GET_Price_Adj_Rltship_Rec;
6050:
6051: FUNCTION GET_Sales_Credit_Rec
6052: RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE
6053: IS
6054: TMP_REC ASO_QUOTE_PUB.Sales_Credit_REC_TYPE;
6055: BEGIN
6056: RETURN TMP_REC;
6050:
6051: FUNCTION GET_Sales_Credit_Rec
6052: RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE
6053: IS
6054: TMP_REC ASO_QUOTE_PUB.Sales_Credit_REC_TYPE;
6055: BEGIN
6056: RETURN TMP_REC;
6057: END GET_Sales_Credit_Rec;
6058:
6055: BEGIN
6056: RETURN TMP_REC;
6057: END GET_Sales_Credit_Rec;
6058:
6059: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE
6060: IS
6061: TMP_REC ASO_QUOTE_PUB.Payment_REC_TYPE;
6062: BEGIN
6063: RETURN TMP_REC;
6057: END GET_Sales_Credit_Rec;
6058:
6059: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE
6060: IS
6061: TMP_REC ASO_QUOTE_PUB.Payment_REC_TYPE;
6062: BEGIN
6063: RETURN TMP_REC;
6064: END GET_Payment_Rec;
6065:
6062: BEGIN
6063: RETURN TMP_REC;
6064: END GET_Payment_Rec;
6065:
6066: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE
6067: IS
6068: TMP_REC ASO_QUOTE_PUB.Shipment_REC_TYPE;
6069: BEGIN
6070: RETURN TMP_REC;
6064: END GET_Payment_Rec;
6065:
6066: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE
6067: IS
6068: TMP_REC ASO_QUOTE_PUB.Shipment_REC_TYPE;
6069: BEGIN
6070: RETURN TMP_REC;
6071: END GET_Shipment_Rec;
6072:
6071: END GET_Shipment_Rec;
6072:
6073:
6074: FUNCTION GET_Freight_Charge_Rec
6075: RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE
6076: IS
6077: TMP_REC ASO_QUOTE_PUB.Freight_Charge_REC_TYPE;
6078: BEGIN
6079: RETURN TMP_REC;
6073:
6074: FUNCTION GET_Freight_Charge_Rec
6075: RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE
6076: IS
6077: TMP_REC ASO_QUOTE_PUB.Freight_Charge_REC_TYPE;
6078: BEGIN
6079: RETURN TMP_REC;
6080: END GET_Freight_Charge_Rec;
6081:
6078: BEGIN
6079: RETURN TMP_REC;
6080: END GET_Freight_Charge_Rec;
6081:
6082: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE
6083: IS
6084: TMP_REC ASO_QUOTE_PUB.Tax_Detail_REC_TYPE;
6085: BEGIN
6086: RETURN TMP_REC;
6080: END GET_Freight_Charge_Rec;
6081:
6082: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE
6083: IS
6084: TMP_REC ASO_QUOTE_PUB.Tax_Detail_REC_TYPE;
6085: BEGIN
6086: RETURN TMP_REC;
6087: END GET_Tax_Detail_Rec;
6088:
6093: RETURN TMP_REC;
6094: END GET_Tax_Control_Rec;
6095:
6096: FUNCTION GET_Header_Rltship_Rec
6097: RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE
6098: IS
6099: TMP_REC ASO_QUOTE_PUB.Header_Rltship_REC_TYPE;
6100: BEGIN
6101: RETURN TMP_REC;
6095:
6096: FUNCTION GET_Header_Rltship_Rec
6097: RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE
6098: IS
6099: TMP_REC ASO_QUOTE_PUB.Header_Rltship_REC_TYPE;
6100: BEGIN
6101: RETURN TMP_REC;
6102: END GET_Header_Rltship_Rec;
6103:
6101: RETURN TMP_REC;
6102: END GET_Header_Rltship_Rec;
6103:
6104:
6105: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE
6106: IS
6107: TMP_REC ASO_QUOTE_PUB.Line_Rltship_REC_TYPE;
6108: BEGIN
6109: RETURN TMP_REC;
6103:
6104:
6105: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE
6106: IS
6107: TMP_REC ASO_QUOTE_PUB.Line_Rltship_REC_TYPE;
6108: BEGIN
6109: RETURN TMP_REC;
6110: END GET_Line_Rltship_Rec;
6111:
6108: BEGIN
6109: RETURN TMP_REC;
6110: END GET_Line_Rltship_Rec;
6111:
6112: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE
6113: IS
6114: TMP_REC ASO_QUOTE_PUB.PARTY_RLTSHIP_REC_TYPE;
6115: BEGIN
6116: RETURN TMP_REC;
6110: END GET_Line_Rltship_Rec;
6111:
6112: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE
6113: IS
6114: TMP_REC ASO_QUOTE_PUB.PARTY_RLTSHIP_REC_TYPE;
6115: BEGIN
6116: RETURN TMP_REC;
6117: END GET_PARTY_RLTSHIP_Rec;
6118:
6116: RETURN TMP_REC;
6117: END GET_PARTY_RLTSHIP_Rec;
6118:
6119: FUNCTION GET_Related_Object_Rec
6120: RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE
6121: IS
6122: TMP_REC ASO_QUOTE_PUB.Related_Object_REC_TYPE;
6123: BEGIN
6124: RETURN TMP_REC;
6118:
6119: FUNCTION GET_Related_Object_Rec
6120: RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE
6121: IS
6122: TMP_REC ASO_QUOTE_PUB.Related_Object_REC_TYPE;
6123: BEGIN
6124: RETURN TMP_REC;
6125: END GET_Related_Object_Rec;
6126:
6123: BEGIN
6124: RETURN TMP_REC;
6125: END GET_Related_Object_Rec;
6126:
6127: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE
6128: IS
6129: TMP_REC ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
6130: BEGIN
6131: RETURN TMP_REC;
6125: END GET_Related_Object_Rec;
6126:
6127: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE
6128: IS
6129: TMP_REC ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
6130: BEGIN
6131: RETURN TMP_REC;
6132: END GET_RELATED_OBJ_Rec;
6133:
6131: RETURN TMP_REC;
6132: END GET_RELATED_OBJ_Rec;
6133:
6134: FUNCTION GET_Line_Attribs_Ext_Rec
6135: RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE
6136: IS
6137: TMP_REC ASO_QUOTE_PUB.Line_Attribs_Ext_REC_TYPE;
6138: BEGIN
6139: RETURN TMP_REC;
6133:
6134: FUNCTION GET_Line_Attribs_Ext_Rec
6135: RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE
6136: IS
6137: TMP_REC ASO_QUOTE_PUB.Line_Attribs_Ext_REC_TYPE;
6138: BEGIN
6139: RETURN TMP_REC;
6140: END GET_Line_Attribs_Ext_Rec;
6141:
6138: BEGIN
6139: RETURN TMP_REC;
6140: END GET_Line_Attribs_Ext_Rec;
6141:
6142: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE
6143: IS
6144: TMP_REC ASO_QUOTE_PUB.Order_Header_REC_TYPE;
6145: BEGIN
6146: RETURN TMP_REC;
6140: END GET_Line_Attribs_Ext_Rec;
6141:
6142: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE
6143: IS
6144: TMP_REC ASO_QUOTE_PUB.Order_Header_REC_TYPE;
6145: BEGIN
6146: RETURN TMP_REC;
6147: END GET_Order_Header_Rec;
6148:
6145: BEGIN
6146: RETURN TMP_REC;
6147: END GET_Order_Header_Rec;
6148:
6149: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type
6150: IS
6151: TMP_REC ASO_QUOTE_PUB.Submit_Control_Rec_Type;
6152: BEGIN
6153: RETURN TMP_REC;
6147: END GET_Order_Header_Rec;
6148:
6149: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type
6150: IS
6151: TMP_REC ASO_QUOTE_PUB.Submit_Control_Rec_Type;
6152: BEGIN
6153: RETURN TMP_REC;
6154: END Get_Submit_Control_Rec;
6155:
6153: RETURN TMP_REC;
6154: END Get_Submit_Control_Rec;
6155:
6156:
6157: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type
6158: IS
6159: TMP_REC ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
6160: BEGIN
6161: RETURN TMP_REC;
6155:
6156:
6157: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type
6158: IS
6159: TMP_REC ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
6160: BEGIN
6161: RETURN TMP_REC;
6162: END Get_Sales_Alloc_Control_Rec;
6163:
6643: END IF;
6644: END print_login_info;
6645:
6646:
6647: FUNCTION Tax_Rec_Exists( p_tax_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type ) RETURN BOOLEAN
6648: IS
6649:
6650: BEGIN
6651: IF aso_debug_pub.g_debug_flag = 'Y' THEN