APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on PA_PROJECT_CONTACTS

Line 1596: l_project_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;

1592: l_site_use_code VARCHAR2(30);
1593: l_validate Number;
1594:
1595: l_contact_id NUMBER;
1596: l_project_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
1597: l_return_status VARCHAR2(1);
1598: l_error_msg_code VARCHAR2(250);
1599: l_msg_count NUMBER;
1600: l_msg_data VARCHAR2(250);

Line 1961: l_project_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;

1957: l_site_use_code VARCHAR2(30);
1958: l_validate NUMBER;
1959:
1960: l_contact_id NUMBER;
1961: l_project_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
1962: l_return_status VARCHAR2(1);
1963: l_error_msg_code VARCHAR2(250);
1964: l_msg_count NUMBER;
1965: l_msg_data VARCHAR2(250);

Line 2451: FROM pa_project_contacts

2447: l_msg_data VARCHAR2(250);
2448:
2449: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER, c_bill_ship_customer_id NUMBER, c_project_contact_type_code VARCHAR2) IS
2450: SELECT contact_id, record_version_number
2451: FROM pa_project_contacts
2452: WHERE project_id = c_project_id AND
2453: customer_id = c_customer_id AND
2454: bill_ship_customer_id = c_bill_ship_customer_id AND
2455: project_contact_type_code = c_project_contact_type_code;