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_CUSTOMERS

Line 2504: FROM pa_project_customers

2500: SELECT 'Y'
2501: FROM DUAL
2502: WHERE EXISTS
2503: (SELECT customer_id
2504: FROM pa_project_customers
2505: WHERE project_id = c_project_id
2506: AND project_party_id = c_project_party_id);
2507:
2508: c_role_based_loop_rec_1 c_role_based_loop_csr_1%ROWTYPE ;

Line 2948: --customer values need to be taken care of in the insert for pa_project_customers

2944: END;
2945: END IF;-- IF x_use_override_flag = 'N' OR x_customer_id is null
2946: --Bug 3279981
2947: --If the customer at top task flag has been changed, the customer bill split and default top task
2948: --customer values need to be taken care of in the insert for pa_project_customers
2949:
2950: if ( x_use_override_flag = 'N' ) then
2951:
2952: -- Copy all project customers from original project

Line 2955: INSERT INTO pa_project_customers (

2951:
2952: -- Copy all project customers from original project
2953: x_err_stage := 'copying project customers not using override';
2954:
2955: INSERT INTO pa_project_customers (
2956: project_id
2957: , customer_id
2958: , last_update_date
2959: , last_updated_by

Line 3021: pa_project_customers cust

3017: 'N','N',
3018: cust.default_top_task_cust_flag
3019: )
3020: FROM
3021: pa_project_customers cust
3022: WHERE cust.project_id = x_orig_project_id;
3023:
3024: -- anlee org role changes
3025: -- create a project party if the added customer is an organization

Line 3042: FROM PA_PROJECT_CUSTOMERS

3038: l_customer_id NUMBER;
3039:
3040: CURSOR l_customers_csr (c_project_id IN NUMBER) IS
3041: SELECT customer_id
3042: FROM PA_PROJECT_CUSTOMERS
3043: WHERE project_id = c_project_id;
3044:
3045: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS
3046: SELECT PARTY_ID

Line 3102: UPDATE PA_PROJECT_CUSTOMERS

3098: return;
3099: END IF;
3100:
3101: -- Add the new project party ID to the customers row
3102: UPDATE PA_PROJECT_CUSTOMERS
3103: SET project_party_id = l_project_party_id
3104: WHERE project_id = x_new_project_id
3105: AND customer_id = l_customer_id;
3106: end if;

Line 3133: INSERT INTO pa_project_customers (

3129: x_err_stage := 'copying project customers using override';
3130:
3131: /* Commented for bug 2984536. Need to do processing for each of the customer before copying
3132: into the target project.
3133: INSERT INTO pa_project_customers (
3134: project_id
3135: , customer_id
3136: , last_update_date
3137: , last_updated_by

Line 3183: pa_project_customers cust

3179: , cust.bill_to_customer_id
3180: , cust.ship_to_customer_id
3181: ---Customer Account Relationship
3182: FROM
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

Line 3216: pa_project_customers cust

3212: , cust.bill_to_customer_id
3213: , cust.ship_to_customer_id
3214: , cust.default_top_task_cust_flag
3215: FROM
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

Line 3226: c_customer_id pa_project_customers.customer_id%TYPE)

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,
3225: c_created_from_proj_id pa_projects_all.project_id%TYPE,
3226: c_customer_id pa_project_customers.customer_id%TYPE)
3227: IS
3228: select contact.customer_id,
3229: contact.contact_id,
3230: contact.project_contact_type_code,

Line 3754: FROM PA_PROJECT_CUSTOMERS

3750: l_customer_id NUMBER;
3751:
3752: CURSOR l_customers_csr (c_project_id IN NUMBER) IS
3753: SELECT customer_id
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

Line 3822: UPDATE PA_PROJECT_CUSTOMERS

3818: return;
3819: END IF;
3820:
3821: -- Add the new project party ID to the customers row
3822: UPDATE PA_PROJECT_CUSTOMERS
3823: SET project_party_id = l_project_party_id
3824: WHERE project_id = x_new_project_id
3825: AND customer_id = l_customer_id;
3826: end if;

Line 3879: (select customer_id from pa_project_customers

3875: FROM
3876: pa_project_contacts c
3877: WHERE c.project_id = x_orig_project_id
3878: and c.customer_id in
3879: (select customer_id from pa_project_customers
3880: where project_id = x_new_project_id);
3881: else
3882:
3883: x_err_stage := 'copying billing contacts using overrides';

Line 3921: pa_project_customers cust,

3917: -- Customer Account relationships
3918: , c.bill_ship_customer_id
3919:
3920: FROM
3921: pa_project_customers cust,
3922: pa_project_contacts c
3923: WHERE c.project_id = x_orig_project_id
3924: and c.project_contact_type_code NOT IN ('BILLING','SHIPPING') -- added for bug 8415966
3925: and c.customer_id in

Line 3926: (select customer_id from pa_project_customers

3922: pa_project_contacts c
3923: WHERE c.project_id = x_orig_project_id
3924: and c.project_contact_type_code NOT IN ('BILLING','SHIPPING') -- added for bug 8415966
3925: and c.customer_id in
3926: (select customer_id from pa_project_customers
3927: where project_id = x_new_project_id)
3928: and c.project_id = cust.project_id
3929: and c.customer_id = cust.customer_id
3930: and not exists