APPS.CSI_PRICING_ATTRIBS_PVT dependencies on CSI_I_PRICING_ATTRIBS_H

Line 142: FROM csi_i_pricing_attribs_h

138: new_attribute12,
139: new_attribute13,
140: new_attribute14,
141: new_attribute15
142: FROM csi_i_pricing_attribs_h
143: WHERE pricing_attribute_id = p_pri_hist_id
144: ORDER BY creation_date;
145:
146: BEGIN

Line 411: FROM csi_i_pricing_attribs_h

407: new_attribute12,
408: new_attribute13,
409: new_attribute14,
410: new_attribute15
411: FROM csi_i_pricing_attribs_h
412: WHERE price_attrib_history_id = p_pri_att_hist_id
413: AND full_dump_flag = 'Y';
414:
415: BEGIN

Line 564: FROM csi_i_pricing_attribs_h

560:
561: CURSOR get_nearest_full_dump( p_pri_att_id IN NUMBER ,
562: p_time IN DATE ) IS
563: SELECT MAX(price_attrib_history_id)
564: FROM csi_i_pricing_attribs_h
565: WHERE creation_date <= p_time
566: AND pricing_attribute_id = p_pri_att_id
567: AND full_dump_flag = 'Y' ;
568:

Line 812: FROM csi_i_pricing_attribs_h

808: OLD_ATTRIBUTE14,
809: NEW_ATTRIBUTE14,
810: OLD_ATTRIBUTE15,
811: NEW_ATTRIBUTE15
812: FROM csi_i_pricing_attribs_h
813: WHERE creation_date <= p_time
814: AND creation_date >= p_nearest_full_dump
815: AND pricing_attribute_id = p_pri_att_id
816: ORDER BY creation_date;

Line 2239: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(

2235: -- Get a unique org_assignment number from the sequence
2236: l_pricing_attrib_h_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_h_id;
2237:
2238: -- Create a history
2239: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
2240: px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,
2241: p_PRICING_ATTRIBUTE_ID => l_pricing_attrib_id,
2242: p_TRANSACTION_ID => p_txn_rec.transaction_id,
2243: p_OLD_PRICING_CONTEXT => NULL,

Line 2583: FROM csi_i_pricing_attribs_h

2579: l_pricing_history_rec csi_datastructures_pub.pricing_history_rec;
2580:
2581: CURSOR pricing_hist_csr (p_pricing_hist_id NUMBER) IS
2582: SELECT *
2583: FROM csi_i_pricing_attribs_h
2584: WHERE csi_i_pricing_attribs_h.price_attrib_history_id = p_pricing_hist_id
2585: FOR UPDATE OF object_version_number;
2586: l_pricing_hist_id NUMBER;
2587: l_pricing_hist_csr pricing_hist_csr%ROWTYPE;

Line 2584: WHERE csi_i_pricing_attribs_h.price_attrib_history_id = p_pricing_hist_id

2580:
2581: CURSOR pricing_hist_csr (p_pricing_hist_id NUMBER) IS
2582: SELECT *
2583: FROM csi_i_pricing_attribs_h
2584: WHERE csi_i_pricing_attribs_h.price_attrib_history_id = p_pricing_hist_id
2585: FOR UPDATE OF object_version_number;
2586: l_pricing_hist_id NUMBER;
2587: l_pricing_hist_csr pricing_hist_csr%ROWTYPE;
2588: BEGIN

Line 2901: FROM csi_i_pricing_attribs_h h

2897: BEGIN
2898:
2899: SELECT price_attrib_history_id
2900: INTO l_pricing_hist_id
2901: FROM csi_i_pricing_attribs_h h
2902: WHERE h.transaction_id = p_txn_rec.transaction_id
2903: AND h.pricing_attribute_id = p_pricing_attribs_rec.pricing_attribute_id;
2904:
2905: OPEN pricing_hist_csr(l_pricing_hist_id);

Line 2914: CSI_I_PRICING_ATTRIBS_H_PKG.Update_Row(

2910:
2911: IF l_pricing_hist_csr.full_dump_flag = 'Y'
2912: THEN
2913:
2914: CSI_I_PRICING_ATTRIBS_H_PKG.Update_Row(
2915: p_PRICE_ATTRIB_HISTORY_ID => l_pricing_hist_id ,
2916: p_PRICING_ATTRIBUTE_ID => fnd_api.g_miss_num ,
2917: p_TRANSACTION_ID => fnd_api.g_miss_num ,
2918: p_OLD_PRICING_CONTEXT => fnd_api.g_miss_char ,

Line 4952: CSI_I_PRICING_ATTRIBS_H_PKG.Update_Row(

4948: l_pricing_hist_csr.new_pricing_attribute100 := p_pricing_attribs_rec.pricing_attribute100;
4949: END IF;
4950: --
4951:
4952: CSI_I_PRICING_ATTRIBS_H_PKG.Update_Row(
4953: p_price_attrib_history_id => l_pricing_hist_id ,
4954: p_pricing_attribute_id => fnd_api.g_miss_num ,
4955: p_transaction_id => fnd_api.g_miss_num ,
4956: p_old_pricing_context => l_pricing_hist_csr.old_pricing_context ,

Line 5690: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(

5686: l_temp_pricing_attribs_rec.ATTRIBUTE15 := l_pricing_attribs_rec.ATTRIBUTE15;
5687: END IF;
5688:
5689: -- Create a history
5690: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
5691: px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,
5692: p_PRICING_ATTRIBUTE_ID => l_pricing_attrib_id,
5693: p_TRANSACTION_ID => p_txn_rec.transaction_id,
5694: p_OLD_PRICING_CONTEXT => l_pricing_attribs_rec.pricing_context,

Line 7030: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(

7026: l_pricing_history_rec.new_attribute15 := p_pricing_attribs_rec.attribute15 ;
7027: END IF;
7028:
7029: -- Create a history
7030: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
7031: px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,
7032: p_PRICING_ATTRIBUTE_ID => l_pricing_attrib_id,
7033: p_TRANSACTION_ID => p_txn_rec.transaction_id,
7034: p_OLD_PRICING_CONTEXT => l_pricing_history_rec.old_pricing_context,