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 1769: insert into pa_project_copy_overrides (

1765: where o.project_id = x_created_from_proj_id;
1766:
1767: x_err_stage := 'copying project copy overrides ';
1768:
1769: insert into pa_project_copy_overrides (
1770: project_id,
1771: field_name,
1772: display_name,
1773: last_update_date,

Line 1795: from pa_project_copy_overrides c

1791: c.limiting_value,
1792: c.sort_order,
1793: c.mandatory_flag,
1794: 1
1795: from pa_project_copy_overrides c
1796: where c.project_id = x_created_from_proj_id;
1797: end if;
1798:
1799: -- anlee

Line 2059: from pa_project_copy_overrides

2055: AND p.party_type not in ('ORGANIZATION')
2056: AND p.project_role_type not in
2057: (select distinct
2058: limiting_value
2059: from pa_project_copy_overrides
2060: where project_id = x_created_from_proj_id
2061: and field_name = 'KEY_MEMBER');*/
2062:
2063: /* Added the below code for bug 2719670, for performance improvement*/

Line 2097: from pa_project_copy_overrides

2093: AND r.role_party_class = 'PERSON'
2094: AND r.project_role_type not in
2095: (select distinct
2096: limiting_value
2097: from pa_project_copy_overrides
2098: where project_id = x_created_from_proj_id
2099: and field_name = 'KEY_MEMBER');
2100: /*Code addition for bug 2719670 ends*/
2101:

Line 2293: FROM pa_project_copy_overrides

2289: AND p.resource_type_id = c_role_based_loop_rec_2.resource_type_id
2290: AND r.project_role_type = c_role_based_loop_rec_2.project_role_type
2291: AND r.project_role_type NOT IN
2292: (SELECT DISTINCT limiting_value
2293: FROM pa_project_copy_overrides
2294: WHERE project_id = x_created_from_proj_id
2295: AND field_name = 'KEY_MEMBER');
2296:
2297: 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 2415: from pa_project_copy_overrides

2411: AND p.party_type = 'ORGANIZATION'
2412: AND p.project_role_type not in
2413: (select distinct
2414: limiting_value
2415: from pa_project_copy_overrides
2416: where project_id = x_created_from_proj_id
2417: and field_name = 'ORG_ROLE');*/
2418:
2419: /* Added the below code for bug 2719670*/

Line 2451: from pa_project_copy_overrides

2447: AND r.role_party_class <> 'PERSON'
2448: AND r.project_role_type not in
2449: (select distinct
2450: limiting_value
2451: from pa_project_copy_overrides
2452: where project_id = x_created_from_proj_id
2453: and field_name = 'ORG_ROLE');
2454: /*Code addition for bug 2719670 ends*/
2455:

Line 2761: from pa_project_copy_overrides

2757: pa_project_classes pc
2758: WHERE pc.project_id = x_orig_project_id
2759: and pc.class_category not in (select distinct
2760: limiting_value
2761: from pa_project_copy_overrides
2762: where project_id = x_created_from_proj_id
2763: and field_name = 'CLASSIFICATION');
2764: end if;
2765: -- anlee

Line 3144: from pa_project_copy_overrides

3140: pa_project_customers cust
3141: WHERE cust.project_id = x_orig_project_id
3142: and not exists
3143: (select null
3144: from pa_project_copy_overrides
3145: where project_id = x_created_from_proj_id
3146: and field_name = 'CUSTOMER_NAME');
3147: */
3148:

Line 3177: from pa_project_copy_overrides

3173: pa_project_customers cust
3174: WHERE cust.project_id = c_project_id
3175: and not exists -- Added the and condition for bug 3726109
3176: (select null
3177: from pa_project_copy_overrides
3178: where project_id = c_created_from_proj_id
3179: and field_name = 'CUSTOMER_NAME');
3180: --CURSORS BELOW ADDED BY ADITI for Bug 3110489 Code Change Begins
3181: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,

Line 3193: from pa_project_copy_overrides

3189: from pa_project_contacts contact
3190: where contact.project_id = c_project_id
3191: and not exists
3192: (select null
3193: from pa_project_copy_overrides
3194: where project_id = c_created_from_proj_id
3195: and field_name = 'CUSTOMER_NAME')
3196: and contact.customer_id = c_customer_id;
3197:

Line 3201: from pa_project_copy_overrides

3197:
3198: CURSOR cur_cust_override_exists (c_created_from_proj_id pa_projects_all.project_id%TYPE )
3199: IS
3200: select 'Y'
3201: from pa_project_copy_overrides
3202: where project_id = c_created_from_proj_id
3203: and field_name = 'CUSTOMER_NAME';
3204: /** Code Change for Bug 3110489 ends **/
3205: l_cur_cust_info cur_cust_info%rowtype;

Line 3715: from pa_project_copy_overrides

3711: FROM PA_PROJECT_CUSTOMERS
3712: WHERE project_id = c_project_id
3713: AND not exists
3714: (select null
3715: from pa_project_copy_overrides
3716: where project_id = x_created_from_proj_id
3717: and field_name = 'CUSTOMER_NAME');
3718:
3719: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS

Line 3884: from pa_project_copy_overrides

3880: and c.project_id = cust.project_id
3881: and c.customer_id = cust.customer_id
3882: and not exists
3883: (select null
3884: from pa_project_copy_overrides
3885: where project_id = x_created_from_proj_id
3886: and field_name = 'CUSTOMER_NAME');
3887: */
3888: end if;

Line 5467: from pa_project_copy_overrides

5463:
5464: declare
5465: cursor cust is
5466: select 1
5467: from pa_project_copy_overrides
5468: where project_id = x_created_from_proj_id
5469: and field_name = 'CUSTOMER_NAME';
5470:
5471: ovr_cust number;