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.PA_PROJECT_CORE1 dependencies on HZ_PARTIES

Line 2140: CURSOR chk_for_hz_parties(p_person_id NUMBER) IS

2136: and field_name = 'KEY_MEMBER');
2137: /*Code addition for bug 2719670 ends*/
2138:
2139: /* Bug 3022296 : Added new cursor for checking ext. customer member existance */
2140: CURSOR chk_for_hz_parties(p_person_id NUMBER) IS
2141: SELECT 'Y'
2142: FROM hz_parties h
2143: WHERE h.party_id = p_person_id
2144: AND h.party_type = 'PERSON';

Line 2142: FROM hz_parties h

2138:
2139: /* Bug 3022296 : Added new cursor for checking ext. customer member existance */
2140: CURSOR chk_for_hz_parties(p_person_id NUMBER) IS
2141: SELECT 'Y'
2142: FROM hz_parties h
2143: WHERE h.party_id = p_person_id
2144: AND h.party_type = 'PERSON';
2145: /* End 3022296 */
2146:

Line 2157: l_hz_parties VARCHAR(1) := 'N'; --Bug 3022296

2153: x_msg_count NUMBER;
2154: x_msg_data VARCHAR2(2000);
2155: x_project_party_id NUMBER;
2156: x_resource_id NUMBER;
2157: l_hz_parties VARCHAR(1) := 'N'; --Bug 3022296
2158:
2159: /* Added for Bug 7482391 */
2160: role_end_date date;
2161: x_delta_1 number;

Line 2178: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);

2174:
2175: --EH Changes
2176: BEGIN
2177: /* Bug 3022296 : Open cursor */
2178: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);
2179: fetch chk_for_hz_parties into l_hz_parties;
2180: close chk_for_hz_parties;
2181:
2182: --bug 2778730 and modified if through bug 3022296 Start

Line 2179: fetch chk_for_hz_parties into l_hz_parties;

2175: --EH Changes
2176: BEGIN
2177: /* Bug 3022296 : Open cursor */
2178: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);
2179: fetch chk_for_hz_parties into l_hz_parties;
2180: close chk_for_hz_parties;
2181:
2182: --bug 2778730 and modified if through bug 3022296 Start
2183: IF ( ( c_role_based_loop_rec_1.resource_type_id = 101

Line 2180: close chk_for_hz_parties;

2176: BEGIN
2177: /* Bug 3022296 : Open cursor */
2178: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);
2179: fetch chk_for_hz_parties into l_hz_parties;
2180: close chk_for_hz_parties;
2181:
2182: --bug 2778730 and modified if through bug 3022296 Start
2183: IF ( ( c_role_based_loop_rec_1.resource_type_id = 101
2184: AND PA_RESOURCE_UTILS.check_res_not_terminated(

Line 2190: AND nvl(l_hz_parties,'N') = 'Y')

2186: p_object_id => c_role_based_loop_rec_1.resource_source_id ,
2187: p_effective_start_date => c_role_based_loop_rec_1.start_date_active)
2188: )
2189: OR ( c_role_based_loop_rec_1.resource_type_id = 112
2190: AND nvl(l_hz_parties,'N') = 'Y')
2191: )THEN -- Bug 3022296 End
2192: --bug 2778730
2193: /* Bug 3022296 : End */
2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

Line 2267: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);

2263: IN c_role_based_loop_csr_2(x_orig_project_id,x_delta) LOOP
2264:
2265: BEGIN
2266: /* Bug 3022296 : Open cursor */
2267: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);
2268: fetch chk_for_hz_parties into l_hz_parties;
2269: close chk_for_hz_parties;
2270:
2271: -- Bug 7482391

Line 2268: fetch chk_for_hz_parties into l_hz_parties;

2264:
2265: BEGIN
2266: /* Bug 3022296 : Open cursor */
2267: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);
2268: fetch chk_for_hz_parties into l_hz_parties;
2269: close chk_for_hz_parties;
2270:
2271: -- Bug 7482391
2272: open new_prj_end_date_csr(x_new_project_id);

Line 2269: close chk_for_hz_parties;

2265: BEGIN
2266: /* Bug 3022296 : Open cursor */
2267: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);
2268: fetch chk_for_hz_parties into l_hz_parties;
2269: close chk_for_hz_parties;
2270:
2271: -- Bug 7482391
2272: open new_prj_end_date_csr(x_new_project_id);
2273: fetch new_prj_end_date_csr into new_prj_end_date;

Line 2284: AND nvl(l_hz_parties,'N') = 'Y')

2280: p_object_id => c_role_based_loop_rec_2.resource_source_id ,
2281: p_effective_start_date => c_role_based_loop_rec_2.start_date_active)
2282: )
2283: OR ( c_role_based_loop_rec_2.resource_type_id = 112
2284: AND nvl(l_hz_parties,'N') = 'Y')
2285: )THEN -- Bug 3022296
2286: /* Bug 3022296 : End */
2287: --bug 2778730
2288: