APPS.PV_REFERRAL_STATUS_MAPS_PKG dependencies on PV_REFERRAL_STATUS_MAPS

Line 1: package body PV_REFERRAL_STATUS_MAPS_PKG as

1: package body PV_REFERRAL_STATUS_MAPS_PKG as
2: /* $Header: pvxtrfmb.pls 120.1 2011/03/25 21:37:37 hekkiral ship $ */
3: procedure INSERT_ROW (
4: px_referral_status_map_id IN OUT NOCOPY NUMBER,
5: px_object_version_number IN OUT NOCOPY NUMBER,

Line 16: INSERT INTO pv_referral_status_maps (

12: p_last_updated_by IN NUMBER,
13: p_last_update_login IN NUMBER
14: ) is
15: begin
16: INSERT INTO pv_referral_status_maps (
17: referral_status_map_id,
18: object_version_number,
19: benefit_type,
20: status_code,

Line 54: from PV_REFERRAL_STATUS_MAPS

50: OBJECT_VERSION_NUMBER,
51: BENEFIT_TYPE,
52: STATUS_CODE,
53: MAP_STATUS_CODE
54: from PV_REFERRAL_STATUS_MAPS
55: where REFERRAL_STATUS_MAP_ID = p_REFERRAL_STATUS_MAP_ID
56: for update of REFERRAL_STATUS_MAP_ID nowait;
57: recinfo c%rowtype;
58:

Line 96: UPDATE pv_referral_status_maps SET

92: p_last_updated_by IN NUMBER,
93: p_last_update_login IN NUMBER
94: ) is
95: begin
96: UPDATE pv_referral_status_maps SET
97: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
98: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
99: status_code = DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
100: map_status_code = DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),

Line 127: FROM pv_referral_status_maps

123:
124: CURSOR c_updated_by
125: IS
126: SELECT last_updated_by
127: FROM pv_referral_status_maps
128: WHERE referral_status_map_id = p_referral_status_map_id;
129:
130: l_last_updated_by NUMBER;
131:

Line 164: delete from PV_REFERRAL_STATUS_MAPS

160: p_REFERRAL_STATUS_MAP_ID in NUMBER
161: ) is
162: begin
163:
164: delete from PV_REFERRAL_STATUS_MAPS
165: where REFERRAL_STATUS_MAP_ID = p_REFERRAL_STATUS_MAP_ID;
166:
167: IF (SQL%NOTFOUND) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 191: FROM pv_referral_status_maps

187: l_referral_status_map_id number := p_referral_status_map_id;
188:
189: cursor c_obj_verno is
190: SELECT object_version_number
191: FROM pv_referral_status_maps
192: WHERE referral_status_map_id = p_referral_status_map_id;
193:
194: cursor c_chk_status_exists is
195: SELECT 'x'

Line 196: FROM pv_referral_status_maps

192: WHERE referral_status_map_id = p_referral_status_map_id;
193:
194: cursor c_chk_status_exists is
195: SELECT 'x'
196: FROM pv_referral_status_maps
197: WHERE referral_status_map_id = p_referral_status_map_id;
198:
199: BEGIN
200:

Line 245: end PV_REFERRAL_STATUS_MAPS_PKG;

241: END IF;
242: END IF;
243:
244: END LOAD_ROW;
245: end PV_REFERRAL_STATUS_MAPS_PKG;