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 3189: from pa_project_contacts contact

3185: select contact.customer_id,
3186: contact.contact_id,
3187: contact.project_contact_type_code,
3188: contact.bill_ship_customer_id
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

Line 3207: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;

3203: and field_name = 'CUSTOMER_NAME';
3204: /** Code Change for Bug 3110489 ends **/
3205: l_cur_cust_info cur_cust_info%rowtype;
3206: l_cur_contact_info cur_contact_info%rowtype;
3207: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3208: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3209: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3210: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3211: l_dummy VARCHAR2(1); --Added for BUg 3110489

Line 3208: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;

3204: /** Code Change for Bug 3110489 ends **/
3205: l_cur_cust_info cur_cust_info%rowtype;
3206: l_cur_contact_info cur_contact_info%rowtype;
3207: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3208: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3209: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3210: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3211: l_dummy VARCHAR2(1); --Added for BUg 3110489
3212:

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

3205: l_cur_cust_info cur_cust_info%rowtype;
3206: l_cur_contact_info cur_contact_info%rowtype;
3207: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3208: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3209: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3210: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3211: l_dummy VARCHAR2(1); --Added for BUg 3110489
3212:
3213:

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

3206: l_cur_contact_info cur_contact_info%rowtype;
3207: l_bill_to_contact_id pa_project_contacts.contact_id%TYPE;
3208: l_ship_to_contact_id pa_project_contacts.contact_id%TYPE;
3209: l_copy_bill_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3210: l_copy_ship_to_contact_id pa_project_contacts.contact_id%TYPE; --Added for BUg 3110489
3211: l_dummy VARCHAR2(1); --Added for BUg 3110489
3212:
3213:
3214: /*The following parameter is_contact_present_flag is added for Bug#4770535 for get_customer_info not

Line 3806: INSERT INTO pa_project_contacts (

3802: if ( x_use_override_flag = 'N' ) then
3803:
3804: x_err_stage := 'copying all billing contacts ';
3805:
3806: INSERT INTO pa_project_contacts (
3807: project_id
3808: , customer_id
3809: , contact_id
3810: , project_contact_type_code

Line 3833: pa_project_contacts c

3829: , 1
3830: -- Customer Account relationships
3831: , c.bill_ship_customer_id
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);

Line 3845: /* INSERT INTO pa_project_contacts (

3841: -- Bug 2984536 - Commenting the following piece of code. The billing contacts are
3842: -- copied along with the creation of the project customers. This is commented here
3843: -- so as not to copy wrong contact details, if the bill to customer gets changed due to the
3844: -- relationship code.
3845: /* INSERT INTO pa_project_contacts (
3846: project_id
3847: , customer_id
3848: , contact_id
3849: , project_contact_type_code

Line 3875: pa_project_contacts c

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
3879: where project_id = x_new_project_id)