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_FREIGHT_CHARGE_

Line 1032: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)

1028: aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1029: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1030: RETURN aPlsqlItem;
1031: END SQL_TO_PL4;
1032: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
1033: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35 IS
1034: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35;
1035: BEGIN
1036: -- initialize the object

Line 1076: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS

1072: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1073: RETURN aSqlItem;
1074: END PL_TO_SQL22;
1075: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
1076: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS
1077: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
1078: BEGIN
1079: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1080: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;

Line 1077: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;

1073: RETURN aSqlItem;
1074: END PL_TO_SQL22;
1075: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
1076: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS
1077: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
1078: BEGIN
1079: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1080: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1081: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;

Line 1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)

1111: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1112: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1113: RETURN aPlsqlItem;
1114: END SQL_TO_PL22;
1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table

Line 1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS

1112: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1113: RETURN aPlsqlItem;
1114: END SQL_TO_PL22;
1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();

Line 1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;

1113: RETURN aPlsqlItem;
1114: END SQL_TO_PL22;
1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();
1121: IF aPlsqlItem.COUNT > 0 THEN

Line 1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();

1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();
1121: IF aPlsqlItem.COUNT > 0 THEN
1122: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1123: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1124: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL22(aPlsqlItem(I));

Line 1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)

1125: END LOOP;
1126: END IF;
1127: RETURN aSqlItem;
1128: END PL_TO_SQL6;
1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132: BEGIN
1133: BEGIN

Line 1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS

1126: END IF;
1127: RETURN aSqlItem;
1128: END PL_TO_SQL6;
1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132: BEGIN
1133: BEGIN
1134: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;

1127: RETURN aSqlItem;
1128: END PL_TO_SQL6;
1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132: BEGIN
1133: BEGIN
1134: FOR I IN 1..aSqlItem.COUNT LOOP
1135: aPlsqlItem(I) := SQL_TO_PL22(aSqlItem(I));

Line 2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,

2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
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,

Line 2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,

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,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,

Line 2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,

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,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

Line 2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,

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,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,

Line 2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;

2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_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;

Line 2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_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;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;

Line 2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_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;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;

Line 2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_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;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;