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

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

24: last_update_date,
25: last_updated_by,
26: last_update_login
27: ) values (
28: DECODE ( px_benft_status_map_id,FND_API.g_miss_num,NULL,px_benft_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_benft_status_map_id,FND_API.g_miss_num,NULL,px_benft_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_benft_status_map_id,FND_API.g_miss_num,NULL,px_benft_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),

27: ) values (
28: DECODE ( px_benft_status_map_id,FND_API.g_miss_num,NULL,px_benft_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),

28: DECODE ( px_benft_status_map_id,FND_API.g_miss_num,NULL,px_benft_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
32: DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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:

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:
41: end INSERT_ROW;

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

95: p_last_update_login IN NUMBER
96: ) is
97: begin
98: UPDATE pv_benft_status_maps SET
99: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
100: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),

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

96: ) is
97: begin
98: UPDATE pv_benft_status_maps SET
99: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
100: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
104: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),

Line 101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),

97: begin
98: UPDATE pv_benft_status_maps SET
99: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
100: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
104: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
105: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)

Line 102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),

98: UPDATE pv_benft_status_maps SET
99: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
100: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
104: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
105: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
106: WHERE benft_status_map_id = p_benft_status_map_id;

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

99: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
100: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
104: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
105: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
106: WHERE benft_status_map_id = p_benft_status_map_id;
107:

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

100: benefit_type = DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
104: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
105: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
106: WHERE benft_status_map_id = p_benft_status_map_id;
107:
108: IF (SQL%NOTFOUND) THEN

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

101: vendor_status_code = DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
102: partner_status_code = DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_status_code),
103: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
104: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
105: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
106: WHERE benft_status_map_id = p_benft_status_map_id;
107:
108: IF (SQL%NOTFOUND) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
106: WHERE benft_status_map_id = p_benft_status_map_id;
107:
108: IF (SQL%NOTFOUND) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: end UPDATE_ROW;
113: