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.

[Home] [Help]

APPS.ASO_QUOTE_EBIZAD dependencies on ASO_QUOTE_PUB_QTE_LINE_TBL_TY

Line 1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)

1841: aPlsqlItem.PRICING_QUANTITY := aSqlItem.PRICING_QUANTITY;
1842: aPlsqlItem.CONFIG_MODEL_TYPE := aSqlItem.CONFIG_MODEL_TYPE;
1843: RETURN aPlsqlItem;
1844: END SQL_TO_PL27;
1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table

Line 1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS

1842: aPlsqlItem.CONFIG_MODEL_TYPE := aSqlItem.CONFIG_MODEL_TYPE;
1843: RETURN aPlsqlItem;
1844: END SQL_TO_PL27;
1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();

Line 1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;

1843: RETURN aPlsqlItem;
1844: END SQL_TO_PL27;
1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();
1851: IF aPlsqlItem.COUNT > 0 THEN

Line 1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();

1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();
1851: IF aPlsqlItem.COUNT > 0 THEN
1852: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1853: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1854: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL27(aPlsqlItem(I));

Line 1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)

1855: END LOOP;
1856: END IF;
1857: RETURN aSqlItem;
1858: END PL_TO_SQL1;
1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862: BEGIN
1863: begin

Line 1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS

1856: END IF;
1857: RETURN aSqlItem;
1858: END PL_TO_SQL1;
1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862: BEGIN
1863: begin
1864: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

1857: RETURN aSqlItem;
1858: END PL_TO_SQL1;
1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862: BEGIN
1863: begin
1864: FOR I IN 1..aSqlItem.COUNT LOOP
1865: aPlsqlItem(I) := SQL_TO_PL27(aSqlItem(I));

Line 2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,

2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,

Line 2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,

2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,

Line 2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;

Line 2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;