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 PA_PROJECT_PARTIES

Line 188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY

184: -- if x_err_code > 0, then assign
185: -- zero to x_err_code.
186: -- 17-JUL-2000 Mohnish
187: -- added code for ROLE BASED SECURITY:
188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes
191: --
192: -- 24-Sep-02 msundare Added additional parameter x_security_level

Line 189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes

185: -- zero to x_err_code.
186: -- 17-JUL-2000 Mohnish
187: -- added code for ROLE BASED SECURITY:
188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes
191: --
192: -- 24-Sep-02 msundare Added additional parameter x_security_level
193: -- 18-DEC-02 gjain For bug 2588244 Added logic in copy_project to copy the

Line 190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes

186: -- 17-JUL-2000 Mohnish
187: -- added code for ROLE BASED SECURITY:
188: -- added the call to PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
189: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
190: -- 15-AUG-2000 Sakthi Modified 'PROJECTS' TO 'PA_PROJECTS' in PA_PROJECT_PARTIES_PUB API changes
191: --
192: -- 24-Sep-02 msundare Added additional parameter x_security_level
193: -- 18-DEC-02 gjain For bug 2588244 Added logic in copy_project to copy the
194: -- default calendar from the organization specified in quick entry

Line 1844: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';

1840: rollback to copy_project;
1841: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1842: x_err_code := 102;
1843: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_SUBTEAM');
1844: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';
1845: return;
1846: END IF;
1847: END LOOP;
1848: CLOSE get_subteams_csr; --Bug 3905797

Line 2039: FROM pa_project_parties_v p

2035: , decode(r_delta, null, x_start_date, -- case B-2
2036: start_date_active + r_delta) start_date_active -- A,C,D,B-1
2037: , decode(r_delta, null, x_completion_date, -- case B-2
2038: end_date_active + r_delta) end_date_active -- A,C,D,B-1
2039: FROM pa_project_parties_v p
2040: WHERE p.project_id = r_project_id
2041: AND p.party_type not in ('ORGANIZATION');
2042: Corrected the spelling of organization in the above csr for bug 2689578
2043:

Line 2053: FROM pa_project_parties_v p

2049: , decode(r_delta, null, x_start_date,
2050: start_date_active + r_delta) start_date_active
2051: , decode(r_delta, null, x_completion_date,
2052: end_date_active + r_delta) end_date_active
2053: FROM pa_project_parties_v p
2054: WHERE p.project_id = r_project_id
2055: AND p.party_type not in ('ORGANIZATION')
2056: AND p.project_role_type not in
2057: (select distinct

Line 2074: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2070: , decode(r_delta, null, x_start_date, -- case B-2
2071: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2072: , decode(r_delta, null, x_completion_date, -- case B-2
2073: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2074: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2075: WHERE p.project_id = r_project_id
2076: AND p.project_role_id = r.project_role_id
2077: AND r.role_party_class = 'PERSON';
2078: /*Corrected the spelling of organization in the above csr for bug 2689578*/

Line 2090: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2086: , decode(r_delta, null, x_start_date,
2087: p.start_date_active + r_delta) start_date_active
2088: , decode(r_delta, null, x_completion_date,
2089: p.end_date_active + r_delta) end_date_active
2090: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2091: WHERE p.project_id = r_project_id
2092: AND p.project_role_id = r.project_role_id
2093: AND r.role_party_class = 'PERSON'
2094: AND r.project_role_type not in

Line 2157: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

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(
2158: p_api_version => 1.0 -- p_api_version
2159: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2160: , p_commit => FND_API.G_FALSE -- p_commit
2161: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 2199: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2195: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2196: x_err_code := 125;
2197: -- x_err_stage := 'PA_NO_PROJ_CREATED'; --commented by ansari
2198: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2199: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2200: return;
2201: END IF;
2202: END IF; --bug 2778730
2203: EXCEPTION WHEN OTHERS THEN

Line 2208: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||

2204: x_err_code := 125;
2205: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2206: -- IF x_err_stage IS NULL
2207: -- THEN
2208: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2209: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2210: -- END IF;
2211: rollback to copy_project;
2212: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 2270: select min(start_date_active) into tmp_min_strt_dt from pa_project_parties where project_id = x_orig_project_id;

2266:
2267: elsif (x_start_date is not null and x_orig_start_date is null) then
2268:
2269: if (x_delta is null) then
2270: select min(start_date_active) into tmp_min_strt_dt from pa_project_parties where project_id = x_orig_project_id;
2271: x_delta_1 := x_start_date - tmp_min_strt_dt;
2272: select p.start_date_active + x_delta_1 into l_tmp_start_date_active from pa_project_parties p where p.project_party_id=c_role_based_loop_rec_2.project_party_id;
2273:
2274: end if;

Line 2272: select p.start_date_active + x_delta_1 into l_tmp_start_date_active from pa_project_parties p where p.project_party_id=c_role_based_loop_rec_2.project_party_id;

2268:
2269: if (x_delta is null) then
2270: select min(start_date_active) into tmp_min_strt_dt from pa_project_parties where project_id = x_orig_project_id;
2271: x_delta_1 := x_start_date - tmp_min_strt_dt;
2272: select p.start_date_active + x_delta_1 into l_tmp_start_date_active from pa_project_parties p where p.project_party_id=c_role_based_loop_rec_2.project_party_id;
2273:
2274: end if;
2275:
2276: if(l_tmp_start_date_active < x_start_date or l_tmp_start_date_active > x_completion_date) then

Line 2282: FROM pa_project_parties p,

2278: end if;
2279:
2280: SELECT p.end_date_active + x_delta_1
2281: INTO role_end_date
2282: FROM pa_project_parties p,
2283: pa_project_role_types_b r
2284: WHERE p.project_id = x_orig_project_id
2285: AND p.project_role_id = r.project_role_id
2286: AND r.role_party_class = 'PERSON'

Line 2314: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2310:
2311: -- End bug#5859329
2312: /* Bug 7482391 changes end here*/
2313: if (f_flag = 'Y') then -- Bug 7482391
2314: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2315: p_api_version => 1.0 -- p_api_version
2316: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2317: , p_commit => FND_API.G_FALSE -- p_commit
2318: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 2358: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2354:
2355: x_err_code := 125;
2356: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2357: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2358: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2359: return;
2360: END IF;
2361: END IF; -- Bug 7482391
2362: END IF; --bug 2778730

Line 2368: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

2364: x_err_code := 125;
2365: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2366: -- IF x_err_stage IS NULL
2367: -- THEN
2368: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2369: -- END IF;
2370: rollback to copy_project;
2371: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2372: return;

Line 2396: FROM pa_project_parties_v p

2392: , decode(r_delta, null, x_start_date, -- case B-2
2393: start_date_active + r_delta) start_date_active -- A,C,D,B-1
2394: , decode(r_delta, null, x_completion_date, -- case B-2
2395: end_date_active + r_delta) end_date_active -- A,C,D,B-1
2396: FROM pa_project_parties_v p
2397: WHERE p.project_id = r_project_id
2398: AND p.party_type = 'ORGANIZATION';
2399:
2400: cursor c_role_based_loop_csr_2(r_project_id IN NUMBER, r_delta IN NUMBER) is

Line 2409: FROM pa_project_parties_v p

2405: , decode(r_delta, null, x_start_date,
2406: start_date_active + r_delta) start_date_active
2407: , decode(r_delta, null, x_completion_date,
2408: end_date_active + r_delta) end_date_active
2409: FROM pa_project_parties_v p
2410: WHERE p.project_id = r_project_id
2411: AND p.party_type = 'ORGANIZATION'
2412: AND p.project_role_type not in
2413: (select distinct

Line 2430: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2426: , decode(r_delta, null, x_start_date, -- case B-2
2427: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2428: , decode(r_delta, null, x_completion_date, -- case B-2
2429: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2430: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2431: WHERE p.project_id = r_project_id
2432: AND p.project_role_id = r.project_role_id
2433: AND r.role_party_class <> 'PERSON';
2434:

Line 2444: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R

2440: , decode(r_delta, null, x_start_date,
2441: p.start_date_active + r_delta) start_date_active
2442: , decode(r_delta, null, x_completion_date,
2443: p.end_date_active + r_delta) end_date_active
2444: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R
2445: WHERE p.project_id = r_project_id
2446: AND p.project_role_id = r.project_role_id
2447: AND r.role_party_class <> 'PERSON'
2448: AND r.project_role_type not in

Line 2493: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2489:
2490: -- Don't want to copy over those project organizations that were created along with
2491: -- a customer billing account
2492: if c_cust_created_org_csr%NOTFOUND then
2493: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2494: p_api_version => 1.0
2495: , p_init_msg_list => FND_API.G_TRUE
2496: , p_commit => FND_API.G_FALSE
2497: , p_validate_only => FND_API.G_FALSE

Line 2528: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2524: rollback to copy_project;
2525: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2526: x_err_code := 125;
2527: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2528: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2529: return;
2530: END IF;
2531: END IF;
2532:

Line 2539: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||

2535: x_err_code := 125;
2536: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2537: -- IF x_err_stage IS NULL
2538: -- THEN
2539: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2540: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2541: -- END IF;
2542: rollback to copy_project;
2543: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 2559: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2555:
2556: -- Don't want to copy over those project organizations that were created along with
2557: -- a customer billing account
2558: if c_cust_created_org_csr%NOTFOUND then
2559: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2560: p_api_version => 1.0
2561: , p_init_msg_list => FND_API.G_TRUE
2562: , p_commit => FND_API.G_FALSE
2563: , p_validate_only => FND_API.G_FALSE

Line 2596: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

2592: rollback to copy_project;
2593: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2594: x_err_code := 125;
2595: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2596: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2597: return;
2598: END IF;
2599: END IF;
2600:

Line 2607: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

2603: x_err_code := 125;
2604: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2605: -- IF x_err_stage IS NULL
2606: -- THEN
2607: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2608: -- END IF;
2609: rollback to copy_project;
2610: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2611: return;

Line 3025: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

3021: CLOSE l_check_org_csr;
3022:
3023: if l_party_id is not null then
3024:
3025: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3026: p_validate_only => FND_API.G_FALSE
3027: , p_object_id => x_new_project_id
3028: , p_OBJECT_TYPE => 'PA_PROJECTS'
3029: , p_project_role_id => 100

Line 3054: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

3050: rollback to copy_project;
3051: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3052: x_err_code := 167;
3053: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3054: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3055: return;
3056: END IF;
3057:
3058: -- Add the new project party ID to the customers row

Line 3072: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

3068: x_err_code := 167;
3069: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3070: -- IF x_err_stage IS NULL
3071: -- THEN
3072: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3073: -- END IF;
3074: rollback to copy_project;
3075: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3076: return;

Line 3745: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

3741: CLOSE l_check_org_csr;
3742:
3743: if l_party_id is not null then
3744:
3745: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3746: p_validate_only => FND_API.G_FALSE
3747: , p_object_id => x_new_project_id
3748: , p_OBJECT_TYPE => 'PA_PROJECTS'
3749: , p_project_role_id => 100

Line 3774: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';

3770: rollback to copy_project;
3771: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3772: x_err_code := 168;
3773: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3774: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3775: return;
3776: END IF;
3777:
3778: -- Add the new project party ID to the customers row

Line 3793: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);

3789: x_err_code := 168;
3790: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3791: -- IF x_err_stage IS NULL
3792: -- THEN
3793: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3794: -- END IF;
3795: rollback to copy_project;
3796: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3797: return;