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_QUOTE_PARTY_TBL

Line 1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)

1596: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1597: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1598: RETURN aPlsqlItem;
1599: END SQL_TO_PL26;
1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table

Line 1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS

1597: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1598: RETURN aPlsqlItem;
1599: END SQL_TO_PL26;
1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();

Line 1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;

1598: RETURN aPlsqlItem;
1599: END SQL_TO_PL26;
1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();
1606: IF aPlsqlItem.COUNT > 0 THEN

Line 1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();

1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();
1606: IF aPlsqlItem.COUNT > 0 THEN
1607: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1608: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1609: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL26(aPlsqlItem(I));

Line 1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)

1610: END LOOP;
1611: END IF;
1612: RETURN aSqlItem;
1613: END PL_TO_SQL10;
1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617: BEGIN
1618: BEGIN

Line 1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS

1611: END IF;
1612: RETURN aSqlItem;
1613: END PL_TO_SQL10;
1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617: BEGIN
1618: BEGIN
1619:

Line 1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;

1612: RETURN aSqlItem;
1613: END PL_TO_SQL10;
1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617: BEGIN
1618: BEGIN
1619:
1620: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

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

Line 2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

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

Line 2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

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,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,

Line 2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,

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

Line 2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_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;
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;

Line 2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_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;
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;

Line 2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_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;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;

Line 2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_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;
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);