APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_RBS_VERSIONS_B

Line 2151: l_rbs_header_id PA_RBS_VERSIONS_B.rbs_header_id%TYPE; -- Added for Bug#6145813 by vvjoshi

2147:
2148: PROCEDURE CREATE_EVENT( p_event_rec IN OUT NOCOPY pa_pji_proj_events_log%ROWTYPE) IS
2149: -- l_event_rec pa_pji_proj_events_log%ROWTYPE;
2150: event_already_exists VARCHAR2(1) := 'N'; -- Added for Bug#6145813 by vvjoshi
2151: l_rbs_header_id PA_RBS_VERSIONS_B.rbs_header_id%TYPE; -- Added for Bug#6145813 by vvjoshi
2152: l_return_status VARCHAR2(1);
2153: BEGIN
2154:
2155: -- l_event_rec := p_event_rec;

Line 2179: pa_rbs_versions_b b

2175: from (select attribute2
2176: from pa_pji_proj_events_log
2177: where event_type = 'RBS_PUSH'
2178: )a ,
2179: pa_rbs_versions_b b
2180: where to_number(a.attribute2) = b.rbs_version_id
2181: and b.rbs_header_id =
2182: (select rbs_header_id
2183: from pa_rbs_versions_b

Line 2183: from pa_rbs_versions_b

2179: pa_rbs_versions_b b
2180: where to_number(a.attribute2) = b.rbs_version_id
2181: and b.rbs_header_id =
2182: (select rbs_header_id
2183: from pa_rbs_versions_b
2184: where rbs_version_id = p_event_rec.attribute2)
2185: and rownum = 1;
2186: exception
2187: when NO_DATA_FOUND then

Line 2197: from pa_rbs_versions_b

2193: IF event_already_exists = 'Y' THEN
2194:
2195: select rbs_header_id
2196: into l_rbs_header_id
2197: from pa_rbs_versions_b
2198: where rbs_version_id = to_number(p_event_rec.attribute2);
2199:
2200: UPDATE pa_pji_proj_events_log
2201: SET event_object = p_event_rec.event_object,

Line 2206: from pa_rbs_versions_b

2202: last_update_date = p_event_rec.last_update_date,
2203: last_updated_by = p_event_rec.last_updated_by
2204: WHERE event_type = 'RBS_PUSH'
2205: AND attribute2 in (select rbs_version_id
2206: from pa_rbs_versions_b
2207: where rbs_header_id = l_rbs_header_id);
2208:
2209: ELSE
2210: /* Added for Bug#6145813 by vvjoshi - END*/