[Home] [Help]
963: FOR i in 1..l_price_adj_attr_tbl.count LOOP
964: -- BC4J Fix
965: --x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID := NULL;
966: l_sysdate := sysdate;
967: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
968: px_PRICE_ADJ_ATTRIB_ID => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
969: p_CREATION_DATE => SYSDATE,
970: p_CREATED_BY => G_USER_ID,
971: p_LAST_UPDATE_DATE => l_sysdate,
2158: -- BC4J Fix
2159: --x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID := NULL;
2160: x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2161:
2162: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
2163: px_PRICE_ADJ_ATTRIB_ID => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
2164: p_CREATION_DATE => SYSDATE,
2165: p_CREATED_BY => G_USER_ID,
2166: p_LAST_UPDATE_DATE => l_sysdate,
2185: x_price_adj_attr_tbl(i) := l_price_adj_attr_tbl(i);
2186: --l_price_adj_attr_rec := l_price_adj_attr_tbl(i);
2187: x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2188:
2189: ASO_PRICE_ADJ_ATTRIBS_PKG.Update_Row(
2190: p_PRICE_ADJ_ATTRIB_ID => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
2191: p_CREATION_DATE => l_price_adj_attr_tbl(i).creation_date,
2192: p_CREATED_BY => G_USER_ID,
2193: p_LAST_UPDATE_DATE => l_sysdate,
2205: p_COMPARISON_OPERATOR => l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
2206: p_FLEX_TITLE => l_price_adj_attr_tbl(i).FLEX_TITLE,
2207: p_OBJECT_VERSION_NUMBER => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER);
2208: ELSIF l_Price_Adj_Attr_Tbl(i).operation_code = 'DELETE' THEN
2209: ASO_PRICE_ADJ_ATTRIBS_PKG.Delete_Row(
2210: p_PRICE_ADJ_ATTRIB_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID);
2211: END IF;
2212: END LOOP;
2213: