DBA Data[Home] [Help]

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_I_PRICING_ATTRIBS_H

Line 577: select CSI_I_PRICING_ATTRIBS_H_S.nextval

573: ,p_pricing_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
574: ) IS
575: BEGIN
576: FOR i in p_pricing_tbl.FIRST .. p_pricing_tbl.LAST LOOP
577: select CSI_I_PRICING_ATTRIBS_H_S.nextval
578: into p_pricing_hist_tbl(i) from dual;
579: --
580: p_pricing_rec_tab.pricing_attribute_id(i) := p_pricing_tbl(i).pricing_attribute_id;
581: p_pricing_rec_tab.instance_id(i) := p_pricing_tbl(i).instance_id;

Line 2309: INSERT INTO CSI_I_PRICING_ATTRIBS_H(

2305: --
2306: -- Insert into History
2307: log('Before Inserting into Pricing Attribs history');
2308: FORALL i in 1 .. l_pricing_rec_tab.pricing_attribute_id.count
2309: INSERT INTO CSI_I_PRICING_ATTRIBS_H(
2310: PRICE_ATTRIB_HISTORY_ID,
2311: PRICING_ATTRIBUTE_ID,
2312: TRANSACTION_ID,
2313: NEW_ACTIVE_START_DATE,