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 2461: FROM pa_project_customers

2457: SELECT 'Y'
2458: FROM DUAL
2459: WHERE EXISTS
2460: (SELECT customer_id
2461: FROM pa_project_customers
2462: WHERE project_id = c_project_id
2463: AND project_party_id = c_project_party_id);
2464:
2465: c_role_based_loop_rec_1 c_role_based_loop_csr_1%ROWTYPE ;

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

2901: END;
2902: END IF;-- IF x_use_override_flag = 'N' OR x_customer_id is null
2903: --Bug 3279981
2904: --If the customer at top task flag has been changed, the customer bill split and default top task
2905: --customer values need to be taken care of in the insert for pa_project_customers
2906:
2907: if ( x_use_override_flag = 'N' ) then
2908:
2909: -- Copy all project customers from original project

Line 2912: INSERT INTO pa_project_customers (

2908:
2909: -- Copy all project customers from original project
2910: x_err_stage := 'copying project customers not using override';
2911:
2912: INSERT INTO pa_project_customers (
2913: project_id
2914: , customer_id
2915: , last_update_date
2916: , last_updated_by

Line 2978: pa_project_customers cust

2974: 'N','N',
2975: cust.default_top_task_cust_flag
2976: )
2977: FROM
2978: pa_project_customers cust
2979: WHERE cust.project_id = x_orig_project_id;
2980:
2981: -- anlee org role changes
2982: -- create a project party if the added customer is an organization

Line 2999: FROM PA_PROJECT_CUSTOMERS

2995: l_customer_id NUMBER;
2996:
2997: CURSOR l_customers_csr (c_project_id IN NUMBER) IS
2998: SELECT customer_id
2999: FROM PA_PROJECT_CUSTOMERS
3000: WHERE project_id = c_project_id;
3001:
3002: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS
3003: SELECT PARTY_ID

Line 3059: UPDATE PA_PROJECT_CUSTOMERS

3055: return;
3056: END IF;
3057:
3058: -- Add the new project party ID to the customers row
3059: UPDATE PA_PROJECT_CUSTOMERS
3060: SET project_party_id = l_project_party_id
3061: WHERE project_id = x_new_project_id
3062: AND customer_id = l_customer_id;
3063: end if;

Line 3090: INSERT INTO pa_project_customers (

3086: x_err_stage := 'copying project customers using override';
3087:
3088: /* Commented for bug 2984536. Need to do processing for each of the customer before copying
3089: into the target project.
3090: INSERT INTO pa_project_customers (
3091: project_id
3092: , customer_id
3093: , last_update_date
3094: , last_updated_by

Line 3140: pa_project_customers cust

3136: , cust.bill_to_customer_id
3137: , cust.ship_to_customer_id
3138: ---Customer Account Relationship
3139: FROM
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

Line 3173: pa_project_customers cust

3169: , cust.bill_to_customer_id
3170: , cust.ship_to_customer_id
3171: , cust.default_top_task_cust_flag
3172: FROM
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

Line 3183: c_customer_id pa_project_customers.customer_id%TYPE)

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,
3182: c_created_from_proj_id pa_projects_all.project_id%TYPE,
3183: c_customer_id pa_project_customers.customer_id%TYPE)
3184: IS
3185: select contact.customer_id,
3186: contact.contact_id,
3187: contact.project_contact_type_code,

Line 3711: FROM PA_PROJECT_CUSTOMERS

3707: l_customer_id NUMBER;
3708:
3709: CURSOR l_customers_csr (c_project_id IN NUMBER) IS
3710: SELECT customer_id
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

Line 3779: UPDATE PA_PROJECT_CUSTOMERS

3775: return;
3776: END IF;
3777:
3778: -- Add the new project party ID to the customers row
3779: UPDATE PA_PROJECT_CUSTOMERS
3780: SET project_party_id = l_project_party_id
3781: WHERE project_id = x_new_project_id
3782: AND customer_id = l_customer_id;
3783: end if;

Line 3836: (select customer_id from pa_project_customers

3832: FROM
3833: pa_project_contacts c
3834: WHERE c.project_id = x_orig_project_id
3835: and c.customer_id in
3836: (select customer_id from pa_project_customers
3837: where project_id = x_new_project_id);
3838: else
3839:
3840: x_err_stage := 'copying billing contacts using overrides';

Line 3874: pa_project_customers cust,

3870: -- Customer Account relationships
3871: , c.bill_ship_customer_id
3872:
3873: FROM
3874: pa_project_customers cust,
3875: pa_project_contacts c
3876: WHERE c.project_id = x_orig_project_id
3877: and c.customer_id in
3878: (select customer_id from pa_project_customers

Line 3878: (select customer_id from pa_project_customers

3874: pa_project_customers cust,
3875: pa_project_contacts c
3876: WHERE c.project_id = x_orig_project_id
3877: and c.customer_id in
3878: (select customer_id from pa_project_customers
3879: where project_id = x_new_project_id)
3880: and c.project_id = cust.project_id
3881: and c.customer_id = cust.customer_id
3882: and not exists