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_ACCESS_TBL_

Line 2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)

2700: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2701: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2702: RETURN aPlsqlItem;
2703: END SQL_TO_PL33;
2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table

Line 2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS

2701: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2702: RETURN aPlsqlItem;
2703: END SQL_TO_PL33;
2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();

Line 2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;

2702: RETURN aPlsqlItem;
2703: END SQL_TO_PL33;
2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();
2710: IF aPlsqlItem.COUNT > 0 THEN

Line 2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();

2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();
2710: IF aPlsqlItem.COUNT > 0 THEN
2711: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2712: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2713: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL33(aPlsqlItem(I));

Line 2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)

2714: END LOOP;
2715: END IF;
2716: RETURN aSqlItem;
2717: END PL_TO_SQL16;
2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721: BEGIN
2722: BEGIN

Line 2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS

2715: END IF;
2716: RETURN aSqlItem;
2717: END PL_TO_SQL16;
2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721: BEGIN
2722: BEGIN
2723: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;

2716: RETURN aSqlItem;
2717: END PL_TO_SQL16;
2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721: BEGIN
2722: BEGIN
2723: FOR I IN 1..aSqlItem.COUNT LOOP
2724: aPlsqlItem(I) := SQL_TO_PL33(aSqlItem(I));

Line 2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,

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,
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,

Line 2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,

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,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2915: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2916: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_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;
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;

Line 2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_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;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975: x_msg_data_temp VARCHAR2(2000);
2976: lx_msg_index_out NUMBER;