DBA Data[Home] [Help]

APPS.ASO_QUOTE_EBIZAD dependencies on ASO_QUOTE_PUB_LINE_RLTSHIP_TB

Line 2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)

2144: aPlsqlItem.RECIPROCAL_FLAG := aSqlItem.RECIPROCAL_FLAG;
2145: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2146: RETURN aPlsqlItem;
2147: END SQL_TO_PL29;
2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table

Line 2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS

2145: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2146: RETURN aPlsqlItem;
2147: END SQL_TO_PL29;
2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();

Line 2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;

2146: RETURN aPlsqlItem;
2147: END SQL_TO_PL29;
2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();
2154: IF aPlsqlItem.COUNT > 0 THEN

Line 2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();

2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();
2154: IF aPlsqlItem.COUNT > 0 THEN
2155: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2156: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2157: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL29(aPlsqlItem(I));

Line 2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)

2158: END LOOP;
2159: END IF;
2160: RETURN aSqlItem;
2161: END PL_TO_SQL11;
2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165: BEGIN
2166: begin

Line 2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS

2159: END IF;
2160: RETURN aSqlItem;
2161: END PL_TO_SQL11;
2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165: BEGIN
2166: begin
2167: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;

2160: RETURN aSqlItem;
2161: END PL_TO_SQL11;
2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165: BEGIN
2166: begin
2167: FOR I IN 1..aSqlItem.COUNT LOOP
2168: aPlsqlItem(I) := SQL_TO_PL29(aSqlItem(I));

Line 2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_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,
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,

Line 2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,

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

Line 2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_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;
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;

Line 2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_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;
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;