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 1880: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';

1876: rollback to copy_project;
1877: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1878: x_err_code := 102;
1879: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_SUBTEAM');
1880: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_SUBTEAM';
1881: return;
1882: END IF;
1883: END LOOP;
1884: CLOSE get_subteams_csr; --Bug 3905797

Line 2075: FROM pa_project_parties_v p

2071: , decode(r_delta, null, x_start_date, -- case B-2
2072: start_date_active + r_delta) start_date_active -- A,C,D,B-1
2073: , decode(r_delta, null, x_completion_date, -- case B-2
2074: end_date_active + r_delta) end_date_active -- A,C,D,B-1
2075: FROM pa_project_parties_v p
2076: WHERE p.project_id = r_project_id
2077: AND p.party_type not in ('ORGANIZATION');
2078: Corrected the spelling of organization in the above csr for bug 2689578
2079:

Line 2089: FROM pa_project_parties_v p

2085: , decode(r_delta, null, x_start_date,
2086: start_date_active + r_delta) start_date_active
2087: , decode(r_delta, null, x_completion_date,
2088: end_date_active + r_delta) end_date_active
2089: FROM pa_project_parties_v p
2090: WHERE p.project_id = r_project_id
2091: AND p.party_type not in ('ORGANIZATION')
2092: AND p.project_role_type not in
2093: (select distinct

Line 2110: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2106: , decode(r_delta, null, x_start_date, -- case B-2
2107: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2108: , decode(r_delta, null, x_completion_date, -- case B-2
2109: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2110: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2111: WHERE p.project_id = r_project_id
2112: AND p.project_role_id = r.project_role_id
2113: AND r.role_party_class = 'PERSON';
2114: /*Corrected the spelling of organization in the above csr for bug 2689578*/

Line 2127: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2123: p.start_date_active + r_delta) start_date_active
2124: , decode(r_delta, null, x_completion_date,
2125: p.end_date_active + r_delta) end_date_active
2126: , p.end_date_active source_end_date -- bug 12398459
2127: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2128: WHERE p.project_id = r_project_id
2129: AND p.project_role_id = r.project_role_id
2130: AND r.role_party_class = 'PERSON'
2131: AND r.project_role_type not in

Line 2194: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

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(
2195: p_api_version => 1.0 -- p_api_version
2196: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2197: , p_commit => FND_API.G_FALSE -- p_commit
2198: , p_validate_only => FND_API.G_FALSE -- p_validate_only

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

2232: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2233: x_err_code := 125;
2234: -- x_err_stage := 'PA_NO_PROJ_CREATED'; --commented by ansari
2235: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2236: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2237: return;
2238: END IF;
2239: END IF; --bug 2778730
2240: EXCEPTION WHEN OTHERS THEN

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

2241: x_err_code := 125;
2242: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2243: -- IF x_err_stage IS NULL
2244: -- THEN
2245: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2246: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2247: -- END IF;
2248: rollback to copy_project;
2249: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

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

2309:
2310: elsif (x_start_date is not null and x_orig_start_date is null) then
2311:
2312: if (x_delta is null) then
2313: select min(start_date_active) into tmp_min_strt_dt from pa_project_parties where project_id = x_orig_project_id;
2314: x_delta_1 := x_start_date - tmp_min_strt_dt;
2315: 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;
2316:
2317: end if;

Line 2315: 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;

2311:
2312: if (x_delta is null) then
2313: select min(start_date_active) into tmp_min_strt_dt from pa_project_parties where project_id = x_orig_project_id;
2314: x_delta_1 := x_start_date - tmp_min_strt_dt;
2315: 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;
2316:
2317: end if;
2318:
2319: if(l_tmp_start_date_active < x_start_date or l_tmp_start_date_active > x_completion_date) then

Line 2325: FROM pa_project_parties p,

2321: end if;
2322:
2323: SELECT p.end_date_active + x_delta_1
2324: INTO role_end_date
2325: FROM pa_project_parties p,
2326: pa_project_role_types_b r
2327: WHERE p.project_id = x_orig_project_id
2328: AND p.project_role_id = r.project_role_id
2329: AND r.role_party_class = 'PERSON'

Line 2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2353:
2354: -- End bug#5859329
2355: /* Bug 7482391 changes end here*/
2356: if (f_flag = 'Y') then -- Bug 7482391
2357: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2358: p_api_version => 1.0 -- p_api_version
2359: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2360: , p_commit => FND_API.G_FALSE -- p_commit
2361: , p_validate_only => FND_API.G_FALSE -- p_validate_only

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

2397:
2398: x_err_code := 125;
2399: -- x_err_stage := 'PA_NO_PROJ_CREATED';
2400: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2401: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2402: return;
2403: END IF;
2404: END IF; -- Bug 7482391
2405: END IF; --bug 2778730

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

2407: x_err_code := 125;
2408: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2409: -- IF x_err_stage IS NULL
2410: -- THEN
2411: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2412: -- END IF;
2413: rollback to copy_project;
2414: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2415: return;

Line 2439: FROM pa_project_parties_v p

2435: , decode(r_delta, null, x_start_date, -- case B-2
2436: start_date_active + r_delta) start_date_active -- A,C,D,B-1
2437: , decode(r_delta, null, x_completion_date, -- case B-2
2438: end_date_active + r_delta) end_date_active -- A,C,D,B-1
2439: FROM pa_project_parties_v p
2440: WHERE p.project_id = r_project_id
2441: AND p.party_type = 'ORGANIZATION';
2442:
2443: cursor c_role_based_loop_csr_2(r_project_id IN NUMBER, r_delta IN NUMBER) is

Line 2452: FROM pa_project_parties_v p

2448: , decode(r_delta, null, x_start_date,
2449: start_date_active + r_delta) start_date_active
2450: , decode(r_delta, null, x_completion_date,
2451: end_date_active + r_delta) end_date_active
2452: FROM pa_project_parties_v p
2453: WHERE p.project_id = r_project_id
2454: AND p.party_type = 'ORGANIZATION'
2455: AND p.project_role_type not in
2456: (select distinct

Line 2473: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2469: , decode(r_delta, null, x_start_date, -- case B-2
2470: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2471: , decode(r_delta, null, x_completion_date, -- case B-2
2472: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2473: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2474: WHERE p.project_id = r_project_id
2475: AND p.project_role_id = r.project_role_id
2476: AND r.role_party_class <> 'PERSON';
2477:

Line 2487: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R

2483: , decode(r_delta, null, x_start_date,
2484: p.start_date_active + r_delta) start_date_active
2485: , decode(r_delta, null, x_completion_date,
2486: p.end_date_active + r_delta) end_date_active
2487: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R
2488: WHERE p.project_id = r_project_id
2489: AND p.project_role_id = r.project_role_id
2490: AND r.role_party_class <> 'PERSON'
2491: AND r.project_role_type not in

Line 2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2532:
2533: -- Don't want to copy over those project organizations that were created along with
2534: -- a customer billing account
2535: if c_cust_created_org_csr%NOTFOUND then
2536: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2537: p_api_version => 1.0
2538: , p_init_msg_list => FND_API.G_TRUE
2539: , p_commit => FND_API.G_FALSE
2540: , p_validate_only => FND_API.G_FALSE

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

2567: rollback to copy_project;
2568: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2569: x_err_code := 125;
2570: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2571: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2572: return;
2573: END IF;
2574: END IF;
2575:

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

2578: x_err_code := 125;
2579: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2580: -- IF x_err_stage IS NULL
2581: -- THEN
2582: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||
2583: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2584: -- END IF;
2585: rollback to copy_project;
2586: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

2598:
2599: -- Don't want to copy over those project organizations that were created along with
2600: -- a customer billing account
2601: if c_cust_created_org_csr%NOTFOUND then
2602: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2603: p_api_version => 1.0
2604: , p_init_msg_list => FND_API.G_TRUE
2605: , p_commit => FND_API.G_FALSE
2606: , p_validate_only => FND_API.G_FALSE

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

2635: rollback to copy_project;
2636: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2637: x_err_code := 125;
2638: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
2639: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
2640: return;
2641: END IF;
2642: END IF;
2643:

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

2646: x_err_code := 125;
2647: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
2648: -- IF x_err_stage IS NULL
2649: -- THEN
2650: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT _PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
2651: -- END IF;
2652: rollback to copy_project;
2653: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
2654: return;

Line 3068: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

3064: CLOSE l_check_org_csr;
3065:
3066: if l_party_id is not null then
3067:
3068: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3069: p_validate_only => FND_API.G_FALSE
3070: , p_object_id => x_new_project_id
3071: , p_OBJECT_TYPE => 'PA_PROJECTS'
3072: , p_project_role_id => 100

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

3093: rollback to copy_project;
3094: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3095: x_err_code := 167;
3096: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3097: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3098: return;
3099: END IF;
3100:
3101: -- Add the new project party ID to the customers row

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

3111: x_err_code := 167;
3112: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3113: -- IF x_err_stage IS NULL
3114: -- THEN
3115: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3116: -- END IF;
3117: rollback to copy_project;
3118: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3119: return;

Line 3788: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

3784: CLOSE l_check_org_csr;
3785:
3786: if l_party_id is not null then
3787:
3788: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3789: p_validate_only => FND_API.G_FALSE
3790: , p_object_id => x_new_project_id
3791: , p_OBJECT_TYPE => 'PA_PROJECTS'
3792: , p_project_role_id => 100

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

3813: rollback to copy_project;
3814: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3815: x_err_code := 168;
3816: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CR_PROJ_PARTY_PUB');
3817: x_err_stack := x_err_stack||'->PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY';
3818: return;
3819: END IF;
3820:
3821: -- Add the new project party ID to the customers row

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

3832: x_err_code := 168;
3833: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
3834: -- IF x_err_stage IS NULL
3835: -- THEN
3836: x_err_stage := 'API: '||'PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY'||' SQL error message: '||SUBSTR( SQLERRM,1,1900);
3837: -- END IF;
3838: rollback to copy_project;
3839: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
3840: return;