eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_BENFT_USER_ROLE_MAPS_PKG dependencies on FND_API

Line 29: DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),

25: last_update_date,
26: last_updated_by,
27: last_update_login
28: ) values (
29: DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),
30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),

Line 30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),

26: last_updated_by,
27: last_update_login
28: ) values (
29: DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),
30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),

Line 31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),

27: last_update_login
28: ) values (
29: DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),
30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),

Line 32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),

28: ) values (
29: DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),
30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),

Line 33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),

29: DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),
30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),

Line 34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),

30: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
38: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));

Line 35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),

31: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
38: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
39: end INSERT_ROW;

Line 36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),

32: DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
38: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
39: end INSERT_ROW;
40:

Line 37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),

33: DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
38: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
39: end INSERT_ROW;
40:
41: procedure LOCK_ROW (

Line 38: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));

34: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
35: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
36: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
37: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
38: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
39: end INSERT_ROW;
40:
41: procedure LOCK_ROW (
42: p_user_role_map_id IN NUMBER,

Line 96: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),

Line 97: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),

Line 98: user_role_code = DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)

Line 99: external_flag = DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
103: WHERE user_role_map_id = p_user_role_map_id;

Line 100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
103: WHERE user_role_map_id = p_user_role_map_id;
104:

Line 101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
103: WHERE user_role_map_id = p_user_role_map_id;
104:
105: IF (SQL%NOTFOUND) THEN

Line 102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)

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),
100: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
101: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
103: WHERE user_role_map_id = p_user_role_map_id;
104:
105: IF (SQL%NOTFOUND) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
103: WHERE user_role_map_id = p_user_role_map_id;
104:
105: IF (SQL%NOTFOUND) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109:
110: end UPDATE_ROW;

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
123: END IF;
124: end DELETE_ROW;
125:
126: procedure LOAD_ROW (