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 2103: CURSOR chk_for_hz_parties(p_person_id NUMBER) IS

2099: and field_name = 'KEY_MEMBER');
2100: /*Code addition for bug 2719670 ends*/
2101:
2102: /* Bug 3022296 : Added new cursor for checking ext. customer member existance */
2103: CURSOR chk_for_hz_parties(p_person_id NUMBER) IS
2104: SELECT 'Y'
2105: FROM hz_parties h
2106: WHERE h.party_id = p_person_id
2107: AND h.party_type = 'PERSON';

Line 2105: FROM hz_parties h

2101:
2102: /* Bug 3022296 : Added new cursor for checking ext. customer member existance */
2103: CURSOR chk_for_hz_parties(p_person_id NUMBER) IS
2104: SELECT 'Y'
2105: FROM hz_parties h
2106: WHERE h.party_id = p_person_id
2107: AND h.party_type = 'PERSON';
2108: /* End 3022296 */
2109:

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

2116: x_msg_count NUMBER;
2117: x_msg_data VARCHAR2(2000);
2118: x_project_party_id NUMBER;
2119: x_resource_id NUMBER;
2120: l_hz_parties VARCHAR(1) := 'N'; --Bug 3022296
2121:
2122: /* Added for Bug 7482391 */
2123: role_end_date date;
2124: x_delta_1 number;

Line 2141: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);

2137:
2138: --EH Changes
2139: BEGIN
2140: /* Bug 3022296 : Open cursor */
2141: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);
2142: fetch chk_for_hz_parties into l_hz_parties;
2143: close chk_for_hz_parties;
2144:
2145: --bug 2778730 and modified if through bug 3022296 Start

Line 2142: fetch chk_for_hz_parties into l_hz_parties;

2138: --EH Changes
2139: BEGIN
2140: /* Bug 3022296 : Open cursor */
2141: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);
2142: fetch chk_for_hz_parties into l_hz_parties;
2143: close chk_for_hz_parties;
2144:
2145: --bug 2778730 and modified if through bug 3022296 Start
2146: IF ( ( c_role_based_loop_rec_1.resource_type_id = 101

Line 2143: close chk_for_hz_parties;

2139: BEGIN
2140: /* Bug 3022296 : Open cursor */
2141: OPEN chk_for_hz_parties(c_role_based_loop_rec_1.resource_source_id);
2142: fetch chk_for_hz_parties into l_hz_parties;
2143: close chk_for_hz_parties;
2144:
2145: --bug 2778730 and modified if through bug 3022296 Start
2146: IF ( ( c_role_based_loop_rec_1.resource_type_id = 101
2147: AND PA_RESOURCE_UTILS.check_res_not_terminated(

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

2149: p_object_id => c_role_based_loop_rec_1.resource_source_id ,
2150: p_effective_start_date => c_role_based_loop_rec_1.start_date_active)
2151: )
2152: OR ( c_role_based_loop_rec_1.resource_type_id = 112
2153: AND nvl(l_hz_parties,'N') = 'Y')
2154: )THEN -- Bug 3022296 End
2155: --bug 2778730
2156: /* Bug 3022296 : End */
2157: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

Line 2230: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);

2226: IN c_role_based_loop_csr_2(x_orig_project_id,x_delta) LOOP
2227:
2228: BEGIN
2229: /* Bug 3022296 : Open cursor */
2230: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);
2231: fetch chk_for_hz_parties into l_hz_parties;
2232: close chk_for_hz_parties;
2233:
2234: -- Bug 7482391

Line 2231: fetch chk_for_hz_parties into l_hz_parties;

2227:
2228: BEGIN
2229: /* Bug 3022296 : Open cursor */
2230: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);
2231: fetch chk_for_hz_parties into l_hz_parties;
2232: close chk_for_hz_parties;
2233:
2234: -- Bug 7482391
2235: open new_prj_end_date_csr(x_new_project_id);

Line 2232: close chk_for_hz_parties;

2228: BEGIN
2229: /* Bug 3022296 : Open cursor */
2230: OPEN chk_for_hz_parties(c_role_based_loop_rec_2.resource_source_id);
2231: fetch chk_for_hz_parties into l_hz_parties;
2232: close chk_for_hz_parties;
2233:
2234: -- Bug 7482391
2235: open new_prj_end_date_csr(x_new_project_id);
2236: fetch new_prj_end_date_csr into new_prj_end_date;

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

2243: p_object_id => c_role_based_loop_rec_2.resource_source_id ,
2244: p_effective_start_date => c_role_based_loop_rec_2.start_date_active)
2245: )
2246: OR ( c_role_based_loop_rec_2.resource_type_id = 112
2247: AND nvl(l_hz_parties,'N') = 'Y')
2248: )THEN -- Bug 3022296
2249: /* Bug 3022296 : End */
2250: --bug 2778730
2251: