APPS.PA_MAPPING_PVT dependencies on PA_VALUE_MAPS

Line 6: -- Purpose : Save value map records to PA_VALUE_MAPS.

2: /* $Header: PAYMPVTB.pls 120.2 2005/08/19 17:23:27 mwasowic noship $ */
3:
4: --
5: -- Procedure : Save_value_maps
6: -- Purpose : Save value map records to PA_VALUE_MAPS.
7: --
8: --
9: PROCEDURE save_value_maps
10: ( p_value_map_def_id IN NUMBER ,

Line 128: PA_VALUE_MAPS_PKG.delete_rows(p_value_map_def_id => p_value_map_def_id,

124:
125: -- Delete all the value map records identified by p_value_map_def_id.
126: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
127: debug('Before delete_rows');
128: PA_VALUE_MAPS_PKG.delete_rows(p_value_map_def_id => p_value_map_def_id,
129: p_value_map_def_type => l_value_map_def_type,
130: p_probability_list_id => p_probability_list_id,
131: x_return_status => x_return_status,
132: x_msg_count => x_msg_count,

Line 142: PA_VALUE_MAPS_PKG.insert_rows (

138: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
139: debug('l_dest_value_arr.COUNT = '||l_dest_value_arr.COUNT);
140: IF l_dest_value_arr.COUNT > 0 THEN
141: debug('Before insert_rows');
142: PA_VALUE_MAPS_PKG.insert_rows (
143: p_value_map_def_id => p_value_map_def_id ,
144: p_source_value_arr => l_source_value_arr ,
145: p_dest_value_arr => l_dest_value_arr ,
146: p_source_value_pk1_arr => l_source_value_pk1_arr ,

Line 218: FROM pa_value_maps map, pa_value_map_defs def

214: IS
215:
216: CURSOR c1 IS
217: SELECT dest_value, dest_value_pk1, dest_value_pk2, dest_value_pk3, dest_value_pk4, dest_value_pk5
218: FROM pa_value_maps map, pa_value_map_defs def
219: WHERE map.value_map_def_id = def.value_map_def_id
220: AND def.value_map_def_type = p_value_map_def_type
221: AND def.def_subtype = p_def_subtype
222: AND map.source_value = p_source_value