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_COPY_OVERRIDES

Line 466: from pa_project_copy_overrides

462: x_proj_number_gen_mode VARCHAR2(30);
463: -- bug 16237696 changes start
464: cursor csr_cust_override is
465: select 1
466: from pa_project_copy_overrides
467: where project_id = x_created_from_proj_id
468: and field_name = 'CUSTOMER_NAME';
469:
470: l_customer_overrided number;

Line 1805: insert into pa_project_copy_overrides (

1801: where o.project_id = x_created_from_proj_id;
1802:
1803: x_err_stage := 'copying project copy overrides ';
1804:
1805: insert into pa_project_copy_overrides (
1806: project_id,
1807: field_name,
1808: display_name,
1809: last_update_date,

Line 1831: from pa_project_copy_overrides c

1827: c.limiting_value,
1828: c.sort_order,
1829: c.mandatory_flag,
1830: 1
1831: from pa_project_copy_overrides c
1832: where c.project_id = x_created_from_proj_id;
1833: end if;
1834:
1835: -- anlee

Line 2095: from pa_project_copy_overrides

2091: AND p.party_type not in ('ORGANIZATION')
2092: AND p.project_role_type not in
2093: (select distinct
2094: limiting_value
2095: from pa_project_copy_overrides
2096: where project_id = x_created_from_proj_id
2097: and field_name = 'KEY_MEMBER');*/
2098:
2099: /* Added the below code for bug 2719670, for performance improvement*/

Line 2134: from pa_project_copy_overrides

2130: AND r.role_party_class = 'PERSON'
2131: AND r.project_role_type not in
2132: (select distinct
2133: limiting_value
2134: from pa_project_copy_overrides
2135: where project_id = x_created_from_proj_id
2136: and field_name = 'KEY_MEMBER');
2137: /*Code addition for bug 2719670 ends*/
2138:

Line 2336: FROM pa_project_copy_overrides

2332: AND p.resource_type_id = c_role_based_loop_rec_2.resource_type_id
2333: AND r.project_role_type = c_role_based_loop_rec_2.project_role_type
2334: AND r.project_role_type NOT IN
2335: (SELECT DISTINCT limiting_value
2336: FROM pa_project_copy_overrides
2337: WHERE project_id = x_created_from_proj_id
2338: AND field_name = 'KEY_MEMBER');
2339:
2340: if (new_prj_end_date is not null and role_end_date is not null and role_end_date > new_prj_end_date) then

Line 2458: from pa_project_copy_overrides

2454: AND p.party_type = 'ORGANIZATION'
2455: AND p.project_role_type not in
2456: (select distinct
2457: limiting_value
2458: from pa_project_copy_overrides
2459: where project_id = x_created_from_proj_id
2460: and field_name = 'ORG_ROLE');*/
2461:
2462: /* Added the below code for bug 2719670*/

Line 2494: from pa_project_copy_overrides

2490: AND r.role_party_class <> 'PERSON'
2491: AND r.project_role_type not in
2492: (select distinct
2493: limiting_value
2494: from pa_project_copy_overrides
2495: where project_id = x_created_from_proj_id
2496: and field_name = 'ORG_ROLE');
2497: /*Code addition for bug 2719670 ends*/
2498:

Line 2804: from pa_project_copy_overrides

2800: pa_project_classes pc
2801: WHERE pc.project_id = x_orig_project_id
2802: and pc.class_category not in (select distinct
2803: limiting_value
2804: from pa_project_copy_overrides
2805: where project_id = x_created_from_proj_id
2806: and field_name = 'CLASSIFICATION');
2807: end if;
2808: -- anlee

Line 3187: from pa_project_copy_overrides

3183: pa_project_customers cust
3184: WHERE cust.project_id = x_orig_project_id
3185: and not exists
3186: (select null
3187: from pa_project_copy_overrides
3188: where project_id = x_created_from_proj_id
3189: and field_name = 'CUSTOMER_NAME');
3190: */
3191:

Line 3220: from pa_project_copy_overrides

3216: pa_project_customers cust
3217: WHERE cust.project_id = c_project_id
3218: and not exists -- Added the and condition for bug 3726109
3219: (select null
3220: from pa_project_copy_overrides
3221: where project_id = c_created_from_proj_id
3222: and field_name = 'CUSTOMER_NAME');
3223: --CURSORS BELOW ADDED BY ADITI for Bug 3110489 Code Change Begins
3224: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,

Line 3236: from pa_project_copy_overrides

3232: from pa_project_contacts contact
3233: where contact.project_id = c_project_id
3234: and not exists
3235: (select null
3236: from pa_project_copy_overrides
3237: where project_id = c_created_from_proj_id
3238: and field_name = 'CUSTOMER_NAME')
3239: and contact.customer_id = c_customer_id;
3240:

Line 3244: from pa_project_copy_overrides

3240:
3241: CURSOR cur_cust_override_exists (c_created_from_proj_id pa_projects_all.project_id%TYPE )
3242: IS
3243: select 'Y'
3244: from pa_project_copy_overrides
3245: where project_id = c_created_from_proj_id
3246: and field_name = 'CUSTOMER_NAME';
3247: /** Code Change for Bug 3110489 ends **/
3248: l_cur_cust_info cur_cust_info%rowtype;

Line 3758: from pa_project_copy_overrides

3754: FROM PA_PROJECT_CUSTOMERS
3755: WHERE project_id = c_project_id
3756: AND not exists
3757: (select null
3758: from pa_project_copy_overrides
3759: where project_id = x_created_from_proj_id
3760: and field_name = 'CUSTOMER_NAME');
3761:
3762: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS

Line 3932: from pa_project_copy_overrides

3928: and c.project_id = cust.project_id
3929: and c.customer_id = cust.customer_id
3930: and not exists
3931: (select null
3932: from pa_project_copy_overrides
3933: where project_id = x_created_from_proj_id
3934: and field_name = 'CUSTOMER_NAME');
3935:
3936: end if;

Line 5535: from pa_project_copy_overrides

5531:
5532: declare
5533: cursor cust is
5534: select 1
5535: from pa_project_copy_overrides
5536: where project_id = x_created_from_proj_id
5537: and field_name = 'CUSTOMER_NAME';
5538:
5539: ovr_cust number;