[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,
755:
756: FUNCTION Query_Price_Adj_Rows (
757: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
758: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
759: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
760: IS
761: CURSOR c_price_adj_hdr IS
762: SELECT
763: PRICE_ADJUSTMENT_ID,
956: WHERE quote_header_id = p_qte_header_id
957: AND quote_line_id IS NOT NULL
958: AND quote_line_id = p_qte_line_id;
959:
960: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
961: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
962: BEGIN
963: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
964: FOR price_adj_rec IN c_price_adj_hdr LOOP
957: AND quote_line_id IS NOT NULL
958: AND quote_line_id = p_qte_line_id;
959:
960: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
961: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
962: BEGIN
963: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
964: FOR price_adj_rec IN c_price_adj_hdr LOOP
965: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1159:
1160: FUNCTION Query_Price_Adj_NonPRG_Rows (
1161: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1162: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1163: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1164: IS
1165: CURSOR c_price_adj_hdr IS
1166: SELECT
1167: PRICE_ADJUSTMENT_ID,
1361: AND quote_line_id IS NOT NULL
1362: AND quote_line_id = p_qte_line_id
1363: AND modifier_line_type_code <> 'PRG';
1364:
1365: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1366: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1367: BEGIN
1368: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1369: FOR price_adj_rec IN c_price_adj_hdr LOOP
1362: AND quote_line_id = p_qte_line_id
1363: AND modifier_line_type_code <> 'PRG';
1364:
1365: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1366: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1367: BEGIN
1368: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1369: FOR price_adj_rec IN c_price_adj_hdr LOOP
1370: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1565: /************Commenting it out for performance fix*****************************************************
1566: FUNCTION Query_Price_Adj_NonPRG_Rows (
1567: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1568: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1569: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1570: IS
1571: CURSOR c_price_adj IS
1572: SELECT
1573: PRICE_ADJUSTMENT_ID,
1666: (quote_line_id = p_qte_line_id OR
1667: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
1668: AND modifier_line_type_code <> 'PRG';
1669:
1670: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1671: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1672:
1673: BEGIN
1674: FOR price_adj_rec IN c_price_adj LOOP
1667: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
1668: AND modifier_line_type_code <> 'PRG';
1669:
1670: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
1671: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1672:
1673: BEGIN
1674: FOR price_adj_rec IN c_price_adj LOOP
1675: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
1768: ************************************************************************************************************/
1769:
1770:
1771: FUNCTION Query_Price_Adj_Attr_Rows (
1772: p_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1773: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1774: IS
1775: CURSOR c_price_adj_attr (c_price_adj_id NUMBER) IS
1776: SELECT
1769:
1770:
1771: FUNCTION Query_Price_Adj_Attr_Rows (
1772: p_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
1773: ) RETURN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
1774: IS
1775: CURSOR c_price_adj_attr (c_price_adj_id NUMBER) IS
1776: SELECT
1777: PRICE_ADJ_ATTRIB_ID,
1793: FLEX_TITLE,
1794: OBJECT_VERSION_NUMBER
1795: FROM ASO_PRICE_ADJ_ATTRIBS
1796: WHERE PRICE_ADJUSTMENT_ID = c_price_adj_id;
1797: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_rec_Type;
1798: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1799: BEGIN
1800: FOR i IN 1..P_price_adj_tbl.count LOOP
1801: FOR price_adj_attr_rec IN c_price_adj_attr(P_price_adj_tbl(i).PRICE_ADJUSTMENT_ID) LOOP
1794: OBJECT_VERSION_NUMBER
1795: FROM ASO_PRICE_ADJ_ATTRIBS
1796: WHERE PRICE_ADJUSTMENT_ID = c_price_adj_id;
1797: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_rec_Type;
1798: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1799: BEGIN
1800: FOR i IN 1..P_price_adj_tbl.count LOOP
1801: FOR price_adj_attr_rec IN c_price_adj_attr(P_price_adj_tbl(i).PRICE_ADJUSTMENT_ID) LOOP
1802: l_price_adj_attr_rec.PRICE_ADJ_ATTRIB_ID :=
1828:
1829: FUNCTION Query_Payment_Rows (
1830: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1831: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1832: ) RETURN ASO_QUOTE_PUB.Payment_Tbl_Type
1833: IS
1834: CURSOR c_payment IS
1835: SELECT
1836: PAYMENT_ID,
1885: FROM ASO_PAYMENTS
1886: WHERE quote_header_id = p_qte_header_id AND
1887: (quote_line_id = p_qte_line_id OR
1888: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
1889: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1890: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1891: BEGIN
1892: FOR payment_rec IN c_payment LOOP
1893: l_payment_rec.PAYMENT_ID := payment_rec.PAYMENT_ID;
1886: WHERE quote_header_id = p_qte_header_id AND
1887: (quote_line_id = p_qte_line_id OR
1888: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
1889: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
1890: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1891: BEGIN
1892: FOR payment_rec IN c_payment LOOP
1893: l_payment_rec.PAYMENT_ID := payment_rec.PAYMENT_ID;
1894: l_payment_rec.CREATION_DATE := payment_rec.CREATION_DATE;
1952:
1953: FUNCTION Query_Tax_Detail_Rows (
1954: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1955: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1956: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1957: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1958: IS
1959: CURSOR c_tax1 IS
1960: SELECT
1953: FUNCTION Query_Tax_Detail_Rows (
1954: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1955: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1956: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
1957: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1958: IS
1959: CURSOR c_tax1 IS
1960: SELECT
1961: TAX_DETAIL_ID,
2059: and quote_header_id = p_qte_header_id
2060: and quote_line_id IS NOT NULL
2061: AND quote_line_id = p_qte_line_id;
2062:
2063: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2064: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2065: BEGIN
2066: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2067:
2060: and quote_line_id IS NOT NULL
2061: AND quote_line_id = p_qte_line_id;
2062:
2063: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2064: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2065: BEGIN
2066: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2067:
2068: FOR tax_rec IN c_tax1 LOOP
2170: END Query_Tax_Detail_Rows;
2171:
2172: FUNCTION Query_shipment_Row (
2173: P_shipment_Id IN NUMBER
2174: ) RETURN ASO_QUOTE_PUB.shipment_rec_Type
2175: IS
2176: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_Type;
2177: BEGIN
2178: Select
2172: FUNCTION Query_shipment_Row (
2173: P_shipment_Id IN NUMBER
2174: ) RETURN ASO_QUOTE_PUB.shipment_rec_Type
2175: IS
2176: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_Type;
2177: BEGIN
2178: Select
2179: SHIPMENT_ID,
2180: CREATION_DATE,
2311:
2312: FUNCTION Query_Shipment_Rows (
2313: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2314: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2315: ) RETURN ASO_QUOTE_PUB.Shipment_Tbl_Type
2316: IS
2317: CURSOR c_shipment_hdr IS
2318: SELECT
2319: SHIPMENT_ID,
2447: WHERE quote_header_id = p_qte_header_id
2448: AND quote_line_id IS NOT NULL
2449: AND quote_line_id = p_qte_line_id;
2450:
2451: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2452: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2453: BEGIN
2454: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2455: FOR shipment_rec IN c_shipment_hdr LOOP
2448: AND quote_line_id IS NOT NULL
2449: AND quote_line_id = p_qte_line_id;
2450:
2451: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2452: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2453: BEGIN
2454: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
2455: FOR shipment_rec IN c_shipment_hdr LOOP
2456: l_shipment_rec.SHIPMENT_ID := shipment_rec.SHIPMENT_ID;
2586:
2587: FUNCTION Query_Line_Shipment_Row_atp (
2588: P_Qte_Header_Id IN NUMBER,
2589: P_Qte_Line_Id IN NUMBER
2590: ) RETURN ASO_QUOTE_PUB.Shipment_Rec_Type
2591: IS
2592: CURSOR c_shipment IS
2593: SELECT
2594: SHIPMENT_ID,
2655: FROM ASO_SHIPMENTS
2656: WHERE quote_header_id = p_qte_header_id
2657: AND quote_line_id = p_qte_line_id;
2658:
2659: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2660: BEGIN
2661:
2662: FOR shipment_rec IN c_shipment LOOP
2663:
2727:
2728: END Query_Line_Shipment_Row_atp;
2729:
2730: FUNCTION Query_Freight_Charge_Rows (
2731: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2732: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2733: IS
2734: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
2735: SELECT
2728: END Query_Line_Shipment_Row_atp;
2729:
2730: FUNCTION Query_Freight_Charge_Rows (
2731: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
2732: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
2733: IS
2734: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
2735: SELECT
2736: FREIGHT_CHARGE_ID,
2763: ATTRIBUTE14,
2764: ATTRIBUTE15
2765: FROM ASO_FREIGHT_CHARGES
2766: WHERE quote_shipment_id = c_shipment_id;
2767: l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
2768: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2769: BEGIN
2770: FOR i IN 1..P_shipment_tbl.count LOOP
2771: FOR freight_charge_rec IN c_freight_charge(P_shipment_tbl(i).shipment_id) LOOP
2764: ATTRIBUTE15
2765: FROM ASO_FREIGHT_CHARGES
2766: WHERE quote_shipment_id = c_shipment_id;
2767: l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
2768: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2769: BEGIN
2770: FOR i IN 1..P_shipment_tbl.count LOOP
2771: FOR freight_charge_rec IN c_freight_charge(P_shipment_tbl(i).shipment_id) LOOP
2772: l_freight_charge_rec.FREIGHT_CHARGE_ID :=
2809: END Query_Freight_Charge_Rows;
2810:
2811: FUNCTION Query_Sales_Credit_Row (
2812: P_Sales_Credit_Id IN NUMBER
2813: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type
2814: IS
2815: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2816: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2817:
2811: FUNCTION Query_Sales_Credit_Row (
2812: P_Sales_Credit_Id IN NUMBER
2813: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type
2814: IS
2815: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2816: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2817:
2818: CURSOR C1 IS
2819: SELECT
2812: P_Sales_Credit_Id IN NUMBER
2813: ) RETURN ASO_QUOTE_PUB.Sales_Credit_rec_Type
2814: IS
2815: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2816: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2817:
2818: CURSOR C1 IS
2819: SELECT
2820: CREATION_DATE,
2910:
2911: FUNCTION Query_Sales_Credit_Row (
2912: P_qte_header_Id IN NUMBER,
2913: p_qte_line_id IN NUMBER
2914: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
2915: IS
2916: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2917: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2918:
2912: P_qte_header_Id IN NUMBER,
2913: p_qte_line_id IN NUMBER
2914: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
2915: IS
2916: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2917: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2918:
2919: CURSOR C1 IS
2920: SELECT
2913: p_qte_line_id IN NUMBER
2914: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
2915: IS
2916: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2917: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
2918:
2919: CURSOR C1 IS
2920: SELECT
2921: CREATION_DATE,
3014:
3015:
3016: FUNCTION Query_Quote_Party_Row (
3017: P_Quote_Party_Id IN NUMBER
3018: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type
3019: IS
3020: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3021: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3022:
3016: FUNCTION Query_Quote_Party_Row (
3017: P_Quote_Party_Id IN NUMBER
3018: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type
3019: IS
3020: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3021: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3022:
3023: CURSOR C1 is
3024: SELECT QUOTE_PARTY_ID,
3017: P_Quote_Party_Id IN NUMBER
3018: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type
3019: IS
3020: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3021: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3022:
3023: CURSOR C1 is
3024: SELECT QUOTE_PARTY_ID,
3025: CREATION_DATE,
3100:
3101: FUNCTION Query_Quote_Party_Row (
3102: P_Qte_header_Id IN NUMBER,
3103: P_Qte_line_Id IN NUMBER
3104: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
3105: IS
3106: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3107: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3108:
3102: P_Qte_header_Id IN NUMBER,
3103: P_Qte_line_Id IN NUMBER
3104: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
3105: IS
3106: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3107: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3108:
3109: CURSOR C1 is
3110: SELECT QUOTE_PARTY_ID,
3103: P_Qte_line_Id IN NUMBER
3104: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
3105: IS
3106: l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
3107: l_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
3108:
3109: CURSOR C1 is
3110: SELECT QUOTE_PARTY_ID,
3111: CREATION_DATE,
3188:
3189:
3190: FUNCTION Query_Qte_Line_Row (
3191: P_Qte_Line_Id IN NUMBER
3192: ) RETURN ASO_QUOTE_PUB.qte_line_rec_Type
3193: IS
3194: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
3195: BEGIN
3196: Select
3190: FUNCTION Query_Qte_Line_Row (
3191: P_Qte_Line_Id IN NUMBER
3192: ) RETURN ASO_QUOTE_PUB.qte_line_rec_Type
3193: IS
3194: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
3195: BEGIN
3196: Select
3197: QUOTE_LINE_ID,
3198: CREATION_DATE,
3375:
3376:
3377: FUNCTION Query_Qte_Line_Rows (
3378: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3379: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3380: IS
3381: CURSOR c_Qte_Line IS
3382: SELECT
3383: QUOTE_LINE_ID,
3465:
3466: FROM ASO_Quote_Lines_All
3467: WHERE quote_header_id = p_qte_header_id
3468: ORDER BY Line_Number;
3469: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3470: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3471: BEGIN
3472: FOR Line_rec IN c_Qte_Line LOOP
3473: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3466: FROM ASO_Quote_Lines_All
3467: WHERE quote_header_id = p_qte_header_id
3468: ORDER BY Line_Number;
3469: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3470: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3471: BEGIN
3472: FOR Line_rec IN c_Qte_Line LOOP
3473: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3474: l_qte_line_rec.CREATION_DATE := line_rec.CREATION_DATE;
3559:
3560:
3561: FUNCTION Query_Qte_Line_Rows_Submit (
3562: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3563: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3564: IS
3565: CURSOR c_Qte_Line IS
3566: SELECT
3567: QUOTE_LINE_ID,
3646: --CONFIG_MODEL_TYPE
3647: FROM ASO_Pvt_Quote_Lines_Bali_V
3648: WHERE quote_header_id = p_qte_header_id;
3649:
3650: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3651: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3652: BEGIN
3653: FOR Line_rec IN c_Qte_Line LOOP
3654: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3647: FROM ASO_Pvt_Quote_Lines_Bali_V
3648: WHERE quote_header_id = p_qte_header_id;
3649:
3650: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3651: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3652: BEGIN
3653: FOR Line_rec IN c_Qte_Line LOOP
3654: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3655: l_qte_line_rec.CREATION_DATE := line_rec.CREATION_DATE;
3738:
3739:
3740: FUNCTION Query_Qte_Line_Rows_Sort (
3741: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3742: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3743: IS
3744: CURSOR c_Qte_Line IS
3745: SELECT
3746: QUOTE_LINE_ID,
3824: --CONFIG_MODEL_TYPE
3825: FROM aso_pvt_quote_lines_sort_v
3826: WHERE quote_header_id = p_qte_header_id;
3827:
3828: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3829: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3830:
3831: BEGIN
3832: FOR Line_rec IN c_Qte_Line LOOP
3825: FROM aso_pvt_quote_lines_sort_v
3826: WHERE quote_header_id = p_qte_header_id;
3827:
3828: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3829: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
3830:
3831: BEGIN
3832: FOR Line_rec IN c_Qte_Line LOOP
3833: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
3919: END Query_Qte_Line_Rows_Sort;
3920:
3921: FUNCTION Query_Qte_Line_Rows_atp (
3922: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM
3923: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3924: IS
3925: CURSOR c_Qte_Line IS
3926: SELECT
3927: QUOTE_LINE_ID,
4006: UI_LINE_NUMBER
4007: --CONFIG_MODEL_TYPE
4008: FROM ASO_PVT_QUOTE_LINES_BALI_V
4009: WHERE quote_header_id = p_qte_header_id;
4010: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4011: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4012: BEGIN
4013: FOR Line_rec IN c_Qte_Line LOOP
4014: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
4007: --CONFIG_MODEL_TYPE
4008: FROM ASO_PVT_QUOTE_LINES_BALI_V
4009: WHERE quote_header_id = p_qte_header_id;
4010: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4011: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4012: BEGIN
4013: FOR Line_rec IN c_Qte_Line LOOP
4014: l_qte_line_rec.QUOTE_LINE_ID := line_rec.QUOTE_LINE_ID;
4015: l_qte_line_rec.CREATION_DATE := line_rec.CREATION_DATE;
4103:
4104: FUNCTION Query_Pricing_Line_Rows (
4105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4106: P_change_line_flag IN VARCHAR2 := FND_API.G_FALSE
4107: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4108: IS
4109: CURSOR c_Qte_Line IS
4110: SELECT
4111: QUOTE_LINE_ID,
4218: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4219: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4220: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4221:
4222: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4223: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4224: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4225: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4226:
4219: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4220: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4221:
4222: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4223: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4224: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4225: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4226:
4227: BEGIN
4451:
4452: FUNCTION Query_Pricing_Line_Row (
4453: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
4454: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4455: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
4456: IS
4457: CURSOR c_Qte_Line IS
4458: SELECT
4459: QUOTE_LINE_ID,
4576: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4577: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4578: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4579:
4580: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4581: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4582: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4583: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4584: BEGIN
4577: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4578: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4579:
4580: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4581: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4582: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4583: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4584: BEGIN
4585: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4773:
4774:
4775: FUNCTION Query_Line_Dtl_Rows (
4776: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
4777: ) RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
4778: IS
4779: CURSOR c_Line_Dtl IS
4780: SELECT
4781: QUOTE_LINE_DETAIL_ID,
4860: CONFIG_DELTA,
4861: CONFIG_INSTANCE_NAME
4862: FROM ASO_Quote_Line_Details
4863: WHERE quote_line_id = p_qte_line_id;
4864: l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
4865: l_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4866: BEGIN
4867: FOR Line_Dtl_rec IN c_Line_Dtl LOOP
4868: l_line_dtl_rec.QUOTE_LINE_DETAIL_ID := line_dtl_rec.QUOTE_LINE_DETAIL_ID;
4861: CONFIG_INSTANCE_NAME
4862: FROM ASO_Quote_Line_Details
4863: WHERE quote_line_id = p_qte_line_id;
4864: l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
4865: l_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4866: BEGIN
4867: FOR Line_Dtl_rec IN c_Line_Dtl LOOP
4868: l_line_dtl_rec.QUOTE_LINE_DETAIL_ID := line_dtl_rec.QUOTE_LINE_DETAIL_ID;
4869: l_line_dtl_rec.QUOTE_LINE_ID := line_dtl_rec.QUOTE_LINE_ID;
4959:
4960:
4961: FUNCTION Query_Line_Attribs_header_Rows(
4962: P_Qte_header_Id IN NUMBER := FND_API.G_MISS_NUM
4963: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
4964: IS
4965: CURSOR c_Line_Attr_Ext IS
4966: SELECT
4967: LINE_ATTRIBUTE_ID,
4987: QUOTE_SHIPMENT_ID
4988: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
4989: WHERE quote_header_id = p_qte_header_id AND
4990: quote_line_id is null;
4991: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
4992: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4993: BEGIN
4994: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
4995: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
4988: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
4989: WHERE quote_header_id = p_qte_header_id AND
4990: quote_line_id is null;
4991: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
4992: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4993: BEGIN
4994: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
4995: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
4996: l_line_attr_ext_rec.QUOTE_LINE_ID := line_attr_ext_rec.QUOTE_LINE_ID;
5020:
5021:
5022: FUNCTION Query_Line_Attribs_Ext_Rows(
5023: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5024: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
5025: IS
5026: CURSOR c_Line_Attr_Ext IS
5027: SELECT
5028: LINE_ATTRIBUTE_ID,
5047: QUOTE_HEADER_ID,
5048: QUOTE_SHIPMENT_ID
5049: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
5050: WHERE quote_line_id = p_qte_line_id;
5051: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
5052: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5053: BEGIN
5054: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
5055: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
5048: QUOTE_SHIPMENT_ID
5049: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
5050: WHERE quote_line_id = p_qte_line_id;
5051: l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
5052: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5053: BEGIN
5054: FOR Line_Attr_Ext_rec IN c_Line_Attr_Ext LOOP
5055: l_line_attr_ext_rec.LINE_ATTRIBUTE_ID := line_attr_ext_rec.LINE_ATTRIBUTE_ID;
5056: l_line_attr_ext_rec.QUOTE_LINE_ID := line_attr_ext_rec.QUOTE_LINE_ID;
5081:
5082: FUNCTION Query_Price_Attr_Rows (
5083: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
5084: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5085: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
5086: IS
5087: CURSOR c_price_attr IS
5088: SELECT
5089: PRICE_ATTRIBUTE_ID,
5225: FROM ASO_PRICE_ATTRIBUTES
5226: WHERE quote_header_id = p_qte_header_id AND
5227: (quote_line_id = p_qte_line_id OR
5228: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
5229: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
5230: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5231: BEGIN
5232: FOR price_attr_rec IN c_price_attr LOOP
5233: l_price_attr_rec.PRICE_ATTRIBUTE_ID := price_attr_rec.PRICE_ATTRIBUTE_ID;
5226: WHERE quote_header_id = p_qte_header_id AND
5227: (quote_line_id = p_qte_line_id OR
5228: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
5229: l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
5230: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5231: BEGIN
5232: FOR price_attr_rec IN c_price_attr LOOP
5233: l_price_attr_rec.PRICE_ATTRIBUTE_ID := price_attr_rec.PRICE_ATTRIBUTE_ID;
5234: l_price_attr_rec.CREATION_DATE := price_attr_rec.CREATION_DATE;
5372: END Query_Price_Attr_Rows;
5373:
5374: FUNCTION Query_Price_Adj_Rltship_Rows (
5375: P_Price_Adjustment_Id IN NUMBER := FND_API.G_MISS_NUM
5376: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5377: IS
5378: CURSOR C_Price_Adj_Rltd IS
5379: SELECT
5380: ADJ_RELATIONSHIP_ID
5395: ,OBJECT_VERSION_NUMBER
5396: FROM aso_price_adj_relationships
5397: WHERE price_adjustment_id = P_Price_Adjustment_Id;
5398:
5399: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5400: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5401:
5402: BEGIN
5403: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5396: FROM aso_price_adj_relationships
5397: WHERE price_adjustment_id = P_Price_Adjustment_Id;
5398:
5399: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5400: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5401:
5402: BEGIN
5403: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5404: l_price_adj_rltd_rec.ADJ_RELATIONSHIP_ID := C_Price_Adj_Rltd_Rec.ADJ_RELATIONSHIP_ID;
5422:
5423:
5424: FUNCTION Query_Price_Adj_Rltn_Rows (
5425: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM
5426: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
5427: IS
5428: CURSOR C_Price_Adj_Rltd IS
5429: SELECT
5430: ADJ_RELATIONSHIP_ID
5445: ,OBJECT_VERSION_NUMBER
5446: FROM aso_price_adj_relationships
5447: WHERE quote_line_id = P_Quote_Line_Id;
5448:
5449: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5450: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5451:
5452: BEGIN
5453: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5446: FROM aso_price_adj_relationships
5447: WHERE quote_line_id = P_Quote_Line_Id;
5448:
5449: l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
5450: l_price_adj_rltd_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
5451:
5452: BEGIN
5453: FOR C_Price_Adj_Rltd_Rec IN C_Price_Adj_Rltd LOOP
5454: l_price_adj_rltd_rec.ADJ_RELATIONSHIP_ID := C_Price_Adj_Rltd_Rec.ADJ_RELATIONSHIP_ID;
5522:
5523: end Get_Profile_Obsolete_Status;
5524:
5525:
5526: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE
5527: IS
5528: TMP_REC ASO_QUOTE_PUB.Control_REC_TYPE;
5529: BEGIN
5530: RETURN TMP_REC;
5524:
5525:
5526: FUNCTION GET_Control_Rec RETURN ASO_QUOTE_PUB.Control_Rec_TYPE
5527: IS
5528: TMP_REC ASO_QUOTE_PUB.Control_REC_TYPE;
5529: BEGIN
5530: RETURN TMP_REC;
5531: END GET_Control_Rec;
5532:
5529: BEGIN
5530: RETURN TMP_REC;
5531: END GET_Control_Rec;
5532:
5533: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE
5534: IS
5535: TMP_REC ASO_QUOTE_PUB.Qte_Header_REC_TYPE;
5536: BEGIN
5537: RETURN TMP_REC;
5531: END GET_Control_Rec;
5532:
5533: FUNCTION GET_Qte_Header_Rec RETURN ASO_QUOTE_PUB.Qte_Header_Rec_TYPE
5534: IS
5535: TMP_REC ASO_QUOTE_PUB.Qte_Header_REC_TYPE;
5536: BEGIN
5537: RETURN TMP_REC;
5538: END GET_Qte_Header_Rec;
5539:
5536: BEGIN
5537: RETURN TMP_REC;
5538: END GET_Qte_Header_Rec;
5539:
5540: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE
5541: IS
5542: TMP_REC ASO_QUOTE_PUB.Qte_Sort_REC_TYPE;
5543: BEGIN
5544: RETURN TMP_REC;
5538: END GET_Qte_Header_Rec;
5539:
5540: FUNCTION GET_Qte_Sort_Rec RETURN ASO_QUOTE_PUB.Qte_Sort_Rec_TYPE
5541: IS
5542: TMP_REC ASO_QUOTE_PUB.Qte_Sort_REC_TYPE;
5543: BEGIN
5544: RETURN TMP_REC;
5545: END GET_Qte_Sort_Rec;
5546:
5543: BEGIN
5544: RETURN TMP_REC;
5545: END GET_Qte_Sort_Rec;
5546:
5547: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE
5548: IS
5549: TMP_REC ASO_QUOTE_PUB.Qte_Line_REC_TYPE;
5550: BEGIN
5551: RETURN TMP_REC;
5545: END GET_Qte_Sort_Rec;
5546:
5547: FUNCTION GET_Qte_Line_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Rec_TYPE
5548: IS
5549: TMP_REC ASO_QUOTE_PUB.Qte_Line_REC_TYPE;
5550: BEGIN
5551: RETURN TMP_REC;
5552: END GET_Qte_Line_Rec;
5553:
5550: BEGIN
5551: RETURN TMP_REC;
5552: END GET_Qte_Line_Rec;
5553:
5554: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE
5555: IS
5556: TMP_REC ASO_QUOTE_PUB.Qte_Line_sort_REC_TYPE;
5557: BEGIN
5558: RETURN TMP_REC;
5552: END GET_Qte_Line_Rec;
5553:
5554: FUNCTION GET_Qte_Line_sort_Rec RETURN ASO_QUOTE_PUB.Qte_Line_sort_Rec_TYPE
5555: IS
5556: TMP_REC ASO_QUOTE_PUB.Qte_Line_sort_REC_TYPE;
5557: BEGIN
5558: RETURN TMP_REC;
5559: END GET_Qte_Line_sort_Rec;
5560:
5557: BEGIN
5558: RETURN TMP_REC;
5559: END GET_Qte_Line_sort_Rec;
5560:
5561: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE
5562: IS
5563: TMP_REC ASO_QUOTE_PUB.Qte_Line_Dtl_REC_TYPE;
5564: BEGIN
5565: RETURN TMP_REC;
5559: END GET_Qte_Line_sort_Rec;
5560:
5561: FUNCTION GET_Qte_Line_Dtl_Rec RETURN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_TYPE
5562: IS
5563: TMP_REC ASO_QUOTE_PUB.Qte_Line_Dtl_REC_TYPE;
5564: BEGIN
5565: RETURN TMP_REC;
5566: END GET_Qte_Line_Dtl_Rec;
5567:
5565: RETURN TMP_REC;
5566: END GET_Qte_Line_Dtl_Rec;
5567:
5568: FUNCTION GET_Price_Attributes_Rec
5569: RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE
5570: IS
5571: TMP_REC ASO_QUOTE_PUB.Price_Attributes_REC_TYPE;
5572: BEGIN
5573: RETURN TMP_REC;
5567:
5568: FUNCTION GET_Price_Attributes_Rec
5569: RETURN ASO_QUOTE_PUB.Price_Attributes_Rec_TYPE
5570: IS
5571: TMP_REC ASO_QUOTE_PUB.Price_Attributes_REC_TYPE;
5572: BEGIN
5573: RETURN TMP_REC;
5574: END GET_Price_Attributes_Rec;
5575:
5572: BEGIN
5573: RETURN TMP_REC;
5574: END GET_Price_Attributes_Rec;
5575:
5576: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE
5577: IS
5578: TMP_REC ASO_QUOTE_PUB.Price_Adj_REC_TYPE;
5579: BEGIN
5580: RETURN TMP_REC;
5574: END GET_Price_Attributes_Rec;
5575:
5576: FUNCTION GET_Price_Adj_Rec RETURN ASO_QUOTE_PUB.Price_Adj_Rec_TYPE
5577: IS
5578: TMP_REC ASO_QUOTE_PUB.Price_Adj_REC_TYPE;
5579: BEGIN
5580: RETURN TMP_REC;
5581: END GET_Price_Adj_Rec;
5582:
5580: RETURN TMP_REC;
5581: END GET_Price_Adj_Rec;
5582:
5583: FUNCTION GET_PRICE_ADJ_ATTR_Rec
5584: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE
5585: IS
5586: TMP_REC ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
5587: BEGIN
5588: RETURN TMP_REC;
5582:
5583: FUNCTION GET_PRICE_ADJ_ATTR_Rec
5584: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_TYPE
5585: IS
5586: TMP_REC ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
5587: BEGIN
5588: RETURN TMP_REC;
5589: END GET_PRICE_ADJ_ATTR_Rec;
5590:
5589: END GET_PRICE_ADJ_ATTR_Rec;
5590:
5591:
5592: FUNCTION GET_Price_Adj_Rltship_Rec
5593: RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE
5594: IS
5595: TMP_REC ASO_QUOTE_PUB.Price_Adj_Rltship_REC_TYPE;
5596: BEGIN
5597: RETURN TMP_REC;
5591:
5592: FUNCTION GET_Price_Adj_Rltship_Rec
5593: RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_TYPE
5594: IS
5595: TMP_REC ASO_QUOTE_PUB.Price_Adj_Rltship_REC_TYPE;
5596: BEGIN
5597: RETURN TMP_REC;
5598: END GET_Price_Adj_Rltship_Rec;
5599:
5597: RETURN TMP_REC;
5598: END GET_Price_Adj_Rltship_Rec;
5599:
5600: FUNCTION GET_Sales_Credit_Rec
5601: RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE
5602: IS
5603: TMP_REC ASO_QUOTE_PUB.Sales_Credit_REC_TYPE;
5604: BEGIN
5605: RETURN TMP_REC;
5599:
5600: FUNCTION GET_Sales_Credit_Rec
5601: RETURN ASO_QUOTE_PUB.Sales_Credit_Rec_TYPE
5602: IS
5603: TMP_REC ASO_QUOTE_PUB.Sales_Credit_REC_TYPE;
5604: BEGIN
5605: RETURN TMP_REC;
5606: END GET_Sales_Credit_Rec;
5607:
5604: BEGIN
5605: RETURN TMP_REC;
5606: END GET_Sales_Credit_Rec;
5607:
5608: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE
5609: IS
5610: TMP_REC ASO_QUOTE_PUB.Payment_REC_TYPE;
5611: BEGIN
5612: RETURN TMP_REC;
5606: END GET_Sales_Credit_Rec;
5607:
5608: FUNCTION GET_Payment_Rec RETURN ASO_QUOTE_PUB.Payment_Rec_TYPE
5609: IS
5610: TMP_REC ASO_QUOTE_PUB.Payment_REC_TYPE;
5611: BEGIN
5612: RETURN TMP_REC;
5613: END GET_Payment_Rec;
5614:
5611: BEGIN
5612: RETURN TMP_REC;
5613: END GET_Payment_Rec;
5614:
5615: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE
5616: IS
5617: TMP_REC ASO_QUOTE_PUB.Shipment_REC_TYPE;
5618: BEGIN
5619: RETURN TMP_REC;
5613: END GET_Payment_Rec;
5614:
5615: FUNCTION GET_Shipment_Rec RETURN ASO_QUOTE_PUB.Shipment_Rec_TYPE
5616: IS
5617: TMP_REC ASO_QUOTE_PUB.Shipment_REC_TYPE;
5618: BEGIN
5619: RETURN TMP_REC;
5620: END GET_Shipment_Rec;
5621:
5620: END GET_Shipment_Rec;
5621:
5622:
5623: FUNCTION GET_Freight_Charge_Rec
5624: RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE
5625: IS
5626: TMP_REC ASO_QUOTE_PUB.Freight_Charge_REC_TYPE;
5627: BEGIN
5628: RETURN TMP_REC;
5622:
5623: FUNCTION GET_Freight_Charge_Rec
5624: RETURN ASO_QUOTE_PUB.Freight_Charge_Rec_TYPE
5625: IS
5626: TMP_REC ASO_QUOTE_PUB.Freight_Charge_REC_TYPE;
5627: BEGIN
5628: RETURN TMP_REC;
5629: END GET_Freight_Charge_Rec;
5630:
5627: BEGIN
5628: RETURN TMP_REC;
5629: END GET_Freight_Charge_Rec;
5630:
5631: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE
5632: IS
5633: TMP_REC ASO_QUOTE_PUB.Tax_Detail_REC_TYPE;
5634: BEGIN
5635: RETURN TMP_REC;
5629: END GET_Freight_Charge_Rec;
5630:
5631: FUNCTION GET_Tax_Detail_Rec RETURN ASO_QUOTE_PUB.Tax_Detail_Rec_TYPE
5632: IS
5633: TMP_REC ASO_QUOTE_PUB.Tax_Detail_REC_TYPE;
5634: BEGIN
5635: RETURN TMP_REC;
5636: END GET_Tax_Detail_Rec;
5637:
5642: RETURN TMP_REC;
5643: END GET_Tax_Control_Rec;
5644:
5645: FUNCTION GET_Header_Rltship_Rec
5646: RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE
5647: IS
5648: TMP_REC ASO_QUOTE_PUB.Header_Rltship_REC_TYPE;
5649: BEGIN
5650: RETURN TMP_REC;
5644:
5645: FUNCTION GET_Header_Rltship_Rec
5646: RETURN ASO_QUOTE_PUB.Header_Rltship_Rec_TYPE
5647: IS
5648: TMP_REC ASO_QUOTE_PUB.Header_Rltship_REC_TYPE;
5649: BEGIN
5650: RETURN TMP_REC;
5651: END GET_Header_Rltship_Rec;
5652:
5650: RETURN TMP_REC;
5651: END GET_Header_Rltship_Rec;
5652:
5653:
5654: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE
5655: IS
5656: TMP_REC ASO_QUOTE_PUB.Line_Rltship_REC_TYPE;
5657: BEGIN
5658: RETURN TMP_REC;
5652:
5653:
5654: FUNCTION GET_Line_Rltship_Rec RETURN ASO_QUOTE_PUB.Line_Rltship_Rec_TYPE
5655: IS
5656: TMP_REC ASO_QUOTE_PUB.Line_Rltship_REC_TYPE;
5657: BEGIN
5658: RETURN TMP_REC;
5659: END GET_Line_Rltship_Rec;
5660:
5657: BEGIN
5658: RETURN TMP_REC;
5659: END GET_Line_Rltship_Rec;
5660:
5661: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE
5662: IS
5663: TMP_REC ASO_QUOTE_PUB.PARTY_RLTSHIP_REC_TYPE;
5664: BEGIN
5665: RETURN TMP_REC;
5659: END GET_Line_Rltship_Rec;
5660:
5661: FUNCTION GET_PARTY_RLTSHIP_Rec RETURN ASO_QUOTE_PUB.PARTY_RLTSHIP_Rec_TYPE
5662: IS
5663: TMP_REC ASO_QUOTE_PUB.PARTY_RLTSHIP_REC_TYPE;
5664: BEGIN
5665: RETURN TMP_REC;
5666: END GET_PARTY_RLTSHIP_Rec;
5667:
5665: RETURN TMP_REC;
5666: END GET_PARTY_RLTSHIP_Rec;
5667:
5668: FUNCTION GET_Related_Object_Rec
5669: RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE
5670: IS
5671: TMP_REC ASO_QUOTE_PUB.Related_Object_REC_TYPE;
5672: BEGIN
5673: RETURN TMP_REC;
5667:
5668: FUNCTION GET_Related_Object_Rec
5669: RETURN ASO_QUOTE_PUB.Related_Object_Rec_TYPE
5670: IS
5671: TMP_REC ASO_QUOTE_PUB.Related_Object_REC_TYPE;
5672: BEGIN
5673: RETURN TMP_REC;
5674: END GET_Related_Object_Rec;
5675:
5672: BEGIN
5673: RETURN TMP_REC;
5674: END GET_Related_Object_Rec;
5675:
5676: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE
5677: IS
5678: TMP_REC ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
5679: BEGIN
5680: RETURN TMP_REC;
5674: END GET_Related_Object_Rec;
5675:
5676: FUNCTION GET_RELATED_OBJ_Rec RETURN ASO_QUOTE_PUB.RELATED_OBJ_Rec_TYPE
5677: IS
5678: TMP_REC ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
5679: BEGIN
5680: RETURN TMP_REC;
5681: END GET_RELATED_OBJ_Rec;
5682:
5680: RETURN TMP_REC;
5681: END GET_RELATED_OBJ_Rec;
5682:
5683: FUNCTION GET_Line_Attribs_Ext_Rec
5684: RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE
5685: IS
5686: TMP_REC ASO_QUOTE_PUB.Line_Attribs_Ext_REC_TYPE;
5687: BEGIN
5688: RETURN TMP_REC;
5682:
5683: FUNCTION GET_Line_Attribs_Ext_Rec
5684: RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_TYPE
5685: IS
5686: TMP_REC ASO_QUOTE_PUB.Line_Attribs_Ext_REC_TYPE;
5687: BEGIN
5688: RETURN TMP_REC;
5689: END GET_Line_Attribs_Ext_Rec;
5690:
5687: BEGIN
5688: RETURN TMP_REC;
5689: END GET_Line_Attribs_Ext_Rec;
5690:
5691: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE
5692: IS
5693: TMP_REC ASO_QUOTE_PUB.Order_Header_REC_TYPE;
5694: BEGIN
5695: RETURN TMP_REC;
5689: END GET_Line_Attribs_Ext_Rec;
5690:
5691: FUNCTION GET_Order_Header_Rec RETURN ASO_QUOTE_PUB.Order_Header_Rec_TYPE
5692: IS
5693: TMP_REC ASO_QUOTE_PUB.Order_Header_REC_TYPE;
5694: BEGIN
5695: RETURN TMP_REC;
5696: END GET_Order_Header_Rec;
5697:
5694: BEGIN
5695: RETURN TMP_REC;
5696: END GET_Order_Header_Rec;
5697:
5698: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type
5699: IS
5700: TMP_REC ASO_QUOTE_PUB.Submit_Control_Rec_Type;
5701: BEGIN
5702: RETURN TMP_REC;
5696: END GET_Order_Header_Rec;
5697:
5698: FUNCTION GET_SUBMIT_CONTROL_REC RETURN ASO_QUOTE_PUB.Submit_Control_Rec_Type
5699: IS
5700: TMP_REC ASO_QUOTE_PUB.Submit_Control_Rec_Type;
5701: BEGIN
5702: RETURN TMP_REC;
5703: END Get_Submit_Control_Rec;
5704:
5702: RETURN TMP_REC;
5703: END Get_Submit_Control_Rec;
5704:
5705:
5706: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type
5707: IS
5708: TMP_REC ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
5709: BEGIN
5710: RETURN TMP_REC;
5704:
5705:
5706: FUNCTION GET_Sales_Alloc_Control_Rec RETURN ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type
5707: IS
5708: TMP_REC ASO_QUOTE_PUB.Sales_Alloc_Control_Rec_Type;
5709: BEGIN
5710: RETURN TMP_REC;
5711: END Get_Sales_Alloc_Control_Rec;
5712:
6192: END IF;
6193: END print_login_info;
6194:
6195:
6196: FUNCTION Tax_Rec_Exists( p_tax_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type ) RETURN BOOLEAN
6197: IS
6198:
6199: BEGIN
6200: IF aso_debug_pub.g_debug_flag = 'Y' THEN