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_REFERRAL_STATUS_MAPS_PKG dependencies on FND_API

Line 28: DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_map_id),

24: last_update_date,
25: last_updated_by,
26: last_update_login
27: ) values (
28: DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_map_id),
29: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
30: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
31: DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
32: DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),

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

25: last_updated_by,
26: last_update_login
27: ) values (
28: DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_map_id),
29: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
30: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
31: DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
32: DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
33: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),

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

26: last_update_login
27: ) values (
28: DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_map_id),
29: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
30: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
31: DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
32: DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
33: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
34: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),

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

27: ) values (
28: DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_map_id),
29: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
30: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
31: DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
32: DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
33: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
34: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
35: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),

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

28: DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_map_id),
29: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
30: DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
31: DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
32: DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
33: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
34: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
35: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
36: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),

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

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

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

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

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

31: DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
32: DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
33: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
34: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
35: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
36: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
37: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
38:
39:

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

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

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

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

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

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

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

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

Line 99: status_code = DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),

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

Line 100: map_status_code = DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),

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

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

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

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

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

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

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

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
169: END IF;
170: end DELETE_ROW;
171:
172: procedure LOAD_ROW (