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_CONTACTS

Line 3232: from pa_project_contacts contact

3228: select contact.customer_id,
3229: contact.contact_id,
3230: contact.project_contact_type_code,
3231: contact.bill_ship_customer_id
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

Line 3250: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;

3246: and field_name = 'CUSTOMER_NAME';
3247: /** Code Change for Bug 3110489 ends **/
3248: l_cur_cust_info cur_cust_info%rowtype;
3249: l_cur_contact_info cur_contact_info%rowtype;
3250: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3251: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3252: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3253: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3254: l_dummy VARCHAR2(1); --Added for BUg 3110489

Line 3251: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;

3247: /** Code Change for Bug 3110489 ends **/
3248: l_cur_cust_info cur_cust_info%rowtype;
3249: l_cur_contact_info cur_contact_info%rowtype;
3250: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3251: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3252: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3253: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3254: l_dummy VARCHAR2(1); --Added for BUg 3110489
3255:

Line 3252: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489

3248: l_cur_cust_info cur_cust_info%rowtype;
3249: l_cur_contact_info cur_contact_info%rowtype;
3250: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3251: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3252: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3253: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3254: l_dummy VARCHAR2(1); --Added for BUg 3110489
3255:
3256:

Line 3253: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489

3249: l_cur_contact_info cur_contact_info%rowtype;
3250: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3251: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3252: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3253: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3254: l_dummy VARCHAR2(1); --Added for BUg 3110489
3255:
3256:
3257: /*The following parameter is_contact_present_flag is added for Bug#4770535 for get_customer_info not

Line 3849: INSERT INTO pa_project_contacts (

3845: if ( x_use_override_flag = 'N' ) then
3846:
3847: x_err_stage := 'copying all billing contacts ';
3848:
3849: INSERT INTO pa_project_contacts (
3850: project_id
3851: , customer_id
3852: , contact_id
3853: , project_contact_type_code

Line 3876: pa_project_contacts c

3872: , 1
3873: -- Customer Account relationships
3874: , c.bill_ship_customer_id
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);

Line 3892: INSERT INTO pa_project_contacts (

3888:
3889: -- Bug 8415966 - skkoppul uncommented the insert statement below to create
3890: -- customer contacts of types other than predefined types
3891: -- (BILLING, SHIPPING) while creating a project using 'Copy To' option.
3892: INSERT INTO pa_project_contacts (
3893: project_id
3894: , customer_id
3895: , contact_id
3896: , project_contact_type_code

Line 3922: pa_project_contacts c

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
3926: (select customer_id from pa_project_customers