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_SHIPMENT_TBL_TY

Line 2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)

2571: null;
2572: end;
2573: RETURN aPlsqlItem;
2574: END SQL_TO_PL15;
2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table

Line 2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS

2572: end;
2573: RETURN aPlsqlItem;
2574: END SQL_TO_PL15;
2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();

Line 2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;

2573: RETURN aPlsqlItem;
2574: END SQL_TO_PL15;
2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();
2581: IF aPlsqlItem.COUNT > 0 THEN

Line 2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();

2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();
2581: IF aPlsqlItem.COUNT > 0 THEN
2582: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2583: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2584: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL5(aPlsqlItem(I));

Line 2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)

2585: END LOOP;
2586: END IF;
2587: RETURN aSqlItem;
2588: END PL_TO_SQL15;
2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592: BEGIN
2593: begin

Line 2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS

2586: END IF;
2587: RETURN aSqlItem;
2588: END PL_TO_SQL15;
2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592: BEGIN
2593: begin
2594: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;

2587: RETURN aSqlItem;
2588: END PL_TO_SQL15;
2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592: BEGIN
2593: begin
2594: FOR I IN 1..aSqlItem.COUNT LOOP
2595: aPlsqlItem(I) := SQL_TO_PL4(aSqlItem(I));

Line 2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,

2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

Line 2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,

2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

Line 2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;

2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;

Line 2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;

2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;