APPS.PV_BENFT_USER_ROLE_MAPS_PKG dependencies on PV_BENFT_USER_ROLE_MAPS

Line 1: package body PV_BENFT_USER_ROLE_MAPS_PKG as

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

Line 17: INSERT INTO pv_benft_user_role_maps (

13: p_last_update_login IN NUMBER
14: )
15: IS
16: begin
17: INSERT INTO pv_benft_user_role_maps (
18: user_role_map_id,
19: object_version_number,
20: benefit_type,
21: user_role_code,

Line 53: FROM pv_benft_user_role_maps

49: object_version_number,
50: benefit_type,
51: user_role_code,
52: external_flag
53: FROM pv_benft_user_role_maps
54: WHERE user_role_map_id = p_user_role_map_id
55: FOR UPDATE OF user_role_map_id nowait;
56: recinfo c%rowtype;
57:

Line 95: UPDATE pv_benft_user_role_maps SET

91: p_last_updated_by IN NUMBER,
92: p_last_update_login IN NUMBER
93: ) is
94: begin
95: UPDATE pv_benft_user_role_maps SET
96: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
97: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
98: user_role_code = DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
99: external_flag = DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),

Line 118: DELETE FROM pv_benft_user_role_maps

114: p_user_role_map_id in NUMBER
115: ) is
116: begin
117:
118: DELETE FROM pv_benft_user_role_maps
119: WHERE user_role_map_id = p_user_role_map_id;
120:
121: IF (SQL%NOTFOUND) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 145: FROM pv_benft_user_role_maps

141: l_user_role_map_id number := p_user_role_map_id;
142:
143: cursor c_obj_verno is
144: SELECT object_version_number
145: FROM pv_benft_user_role_maps
146: WHERE user_role_map_id = p_user_role_map_id;
147:
148: cursor c_chk_status_exists is
149: SELECT 'x'

Line 150: FROM pv_benft_user_role_maps

146: WHERE user_role_map_id = p_user_role_map_id;
147:
148: cursor c_chk_status_exists is
149: SELECT 'x'
150: FROM pv_benft_user_role_maps
151: WHERE user_role_map_id = p_user_role_map_id;
152:
153: BEGIN
154:

Line 200: end PV_BENFT_USER_ROLE_MAPS_PKG;

196: END IF;
197: END IF;
198:
199: END LOAD_ROW;
200: end PV_BENFT_USER_ROLE_MAPS_PKG;