eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_COPY_TMPL_PUB dependencies on ASO_UTILITY_PVT

Line 628: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows ( p_qte_header_id );

624: aso_debug_pub.ADD ('Copy_Template - Header and Lines' , 1, 'N' );
625: END IF;
626:
627:
628: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows ( p_qte_header_id );
629:
630:
631: FOR i IN 1 .. l_qte_line_tbl.COUNT LOOP
632: l_line_index_link_tbl ( l_qte_line_tbl ( i ).quote_line_id ) := FND_API.G_MISS_NUM;

Line 701: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( l_qte_line_id );

697:
698: IF (l_copy_flag = 'T') then
699: IF l_line_index_link_tbl ( l_qte_line_id ) = FND_API.G_MISS_NUM THEN
700:
701: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( l_qte_line_id );
702:
703: -- for reconfigure from install base
704: IF l_qte_line_tbl(i).line_category_code = 'RETURN' THEN
705:

Line 836: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);

832: l_qte_line_tbl(i).pricing_quantity:=FND_API.G_MISS_NUM;
833:
834:
835: -- Setting the shipment data
836: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);
837: l_qte_line_tbl(i).quote_line_id := NULL;
838:
839: l_qte_line_tbl ( i ).object_version_number := FND_API.G_MISS_NUM;
840:

Line 1168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

1164:
1165: EXCEPTION
1166:
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1169: P_API_NAME => L_API_NAME
1170: , P_PKG_NAME => G_PKG_NAME
1171: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1172: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1172: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1169: P_API_NAME => L_API_NAME
1170: , P_PKG_NAME => G_PKG_NAME
1171: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1172: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1173: , X_MSG_COUNT => X_MSG_COUNT
1174: , X_MSG_DATA => X_MSG_DATA
1175: , X_RETURN_STATUS => X_RETURN_STATUS
1176: );

Line 1179: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

1175: , X_RETURN_STATUS => X_RETURN_STATUS
1176: );
1177:
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1180: P_API_NAME => L_API_NAME
1181: , P_PKG_NAME => G_PKG_NAME
1182: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1183: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1183: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1179: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1180: P_API_NAME => L_API_NAME
1181: , P_PKG_NAME => G_PKG_NAME
1182: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1183: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1184: , X_MSG_COUNT => X_MSG_COUNT
1185: , X_MSG_DATA => X_MSG_DATA
1186: , X_RETURN_STATUS => X_RETURN_STATUS
1187: );

Line 1190: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

1186: , X_RETURN_STATUS => X_RETURN_STATUS
1187: );
1188:
1189: WHEN OTHERS THEN
1190: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1191: P_API_NAME => L_API_NAME
1192: , P_PKG_NAME => G_PKG_NAME
1193: , P_SQLCODE => SQLCODE
1194: , P_SQLERRM => SQLERRM

Line 1195: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1191: P_API_NAME => L_API_NAME
1192: , P_PKG_NAME => G_PKG_NAME
1193: , P_SQLCODE => SQLCODE
1194: , P_SQLERRM => SQLERRM
1195: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1196: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1197: , X_MSG_COUNT => X_MSG_COUNT
1198: , X_MSG_DATA => X_MSG_DATA
1199: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1196: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1192: , P_PKG_NAME => G_PKG_NAME
1193: , P_SQLCODE => SQLCODE
1194: , P_SQLERRM => SQLERRM
1195: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1196: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1197: , X_MSG_COUNT => X_MSG_COUNT
1198: , X_MSG_DATA => X_MSG_DATA
1199: , X_RETURN_STATUS => X_RETURN_STATUS
1200: );

Line 1299: ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );

1295: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
1296: END IF;
1297:
1298: l_qte_line_rec :=
1299: ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );
1300:
1301: IF p_new_qte_header_id = p_qte_header_id THEN
1302:
1303: OPEN get_qte_line_number(lx_line_index_link_tbl(p_qte_line_id));

Line 1314: ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );

1310:
1311:
1312: l_qte_line_rec.quote_header_id := p_new_qte_header_id;
1313: l_qte_line_dtl_tbl :=
1314: ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );
1315:
1316: IF l_qte_line_dtl_tbl.COUNT > 0 THEN
1317:
1318: FOR k IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP

Line 1344: --l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );

1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - 2 l_service_ref_line_id ' || l_service_ref_line_id , 1 , 'Y' );
1342: END IF;
1343:
1344: --l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
1345:
1346: --l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
1347:
1348: -- l_dup_price_adj_tbl := l_price_adj_tbl;

Line 1346: --l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );

1342: END IF;
1343:
1344: --l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
1345:
1346: --l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
1347:
1348: -- l_dup_price_adj_tbl := l_price_adj_tbl;
1349:
1350: --l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );

Line 1350: --l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );

1346: --l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
1347:
1348: -- l_dup_price_adj_tbl := l_price_adj_tbl;
1349:
1350: --l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );
1351:
1352: --l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1353:
1354: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );

Line 1352: --l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );

1348: -- l_dup_price_adj_tbl := l_price_adj_tbl;
1349:
1350: --l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );
1351:
1352: --l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1353:
1354: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
1355:
1356: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );

Line 1354: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );

1350: --l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );
1351:
1352: --l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1353:
1354: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
1355:
1356: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
1357:
1358: --l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );

Line 1356: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );

1352: --l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1353:
1354: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
1355:
1356: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
1357:
1358: --l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
1359:
1360: --l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );

Line 1358: --l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );

1354: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
1355:
1356: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
1357:
1358: --l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
1359:
1360: --l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
1361:
1362: --l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

Line 1360: --l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );

1356: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
1357:
1358: --l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
1359:
1360: --l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
1361:
1362: --l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
1363:
1364: --l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );

Line 1362: --l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

1358: --l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
1359:
1360: --l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
1361:
1362: --l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
1363:
1364: --l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );
1365:
1366: l_qte_line_rec.quote_line_id := NULL;

Line 1364: --l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );

1360: --l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
1361:
1362: --l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
1363:
1364: --l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );
1365:
1366: l_qte_line_rec.quote_line_id := NULL;
1367: l_qte_line_rec.object_version_number := FND_API.G_MISS_NUM;
1368:

Line 1683: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );

1679: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1680: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
1681: END IF;
1682:
1683: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );
1684:
1685: IF p_new_qte_header_id = p_qte_header_id THEN
1686:
1687: OPEN get_old_line_id (

Line 1712: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );

1708:
1709: l_qte_line_rec.quote_header_id := p_new_qte_header_id;
1710:
1711:
1712: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );
1713:
1714: FOR k IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1715: l_qte_line_dtl_tbl ( k ).config_header_id := p_config_header_id;
1716: l_qte_line_dtl_tbl ( k ).config_revision_num := p_config_revision_num;

Line 1719: /* l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );

1715: l_qte_line_dtl_tbl ( k ).config_header_id := p_config_header_id;
1716: l_qte_line_dtl_tbl ( k ).config_revision_num := p_config_revision_num;
1717: END LOOP;
1718:
1719: /* l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
1720:
1721: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
1722: l_dup_price_adj_tbl := l_price_adj_tbl;
1723:

Line 1721: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );

1717: END LOOP;
1718:
1719: /* l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
1720:
1721: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
1722: l_dup_price_adj_tbl := l_price_adj_tbl;
1723:
1724: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
1725:

Line 1724: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);

1720:
1721: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
1722: l_dup_price_adj_tbl := l_price_adj_tbl;
1723:
1724: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
1725:
1726: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1727:
1728: */

Line 1726: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );

1722: l_dup_price_adj_tbl := l_price_adj_tbl;
1723:
1724: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
1725:
1726: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1727:
1728: */
1729:
1730: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );

Line 1730: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );

1726: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
1727:
1728: */
1729:
1730: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
1731:
1732: /*l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
1733:
1734: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );

Line 1732: /*l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );

1728: */
1729:
1730: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
1731:
1732: /*l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
1733:
1734: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
1735:
1736: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

Line 1734: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );

1730: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
1731:
1732: /*l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
1733:
1734: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
1735:
1736: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
1737:
1738: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );

Line 1736: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

1732: /*l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
1733:
1734: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
1735:
1736: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
1737:
1738: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );
1739:
1740: */

Line 1738: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );

1734: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
1735:
1736: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
1737:
1738: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );
1739:
1740: */
1741:
1742: OPEN C_Serviceable_Product ( l_qte_line_rec.organization_id , l_qte_line_rec.inventory_item_id );