APPS.PA_CUSTOMERS_CONTACTS_PVT dependencies on PA_PROJECT_CONTACTS

Line 1057: PA_PROJECT_CONTACTS_PKG.INSERT_ROW

1053: l_created_by := fnd_global.user_id;
1054: l_last_update_login := fnd_global.login_id;
1055:
1056: if p_validate_only <> FND_API.G_TRUE then
1057: PA_PROJECT_CONTACTS_PKG.INSERT_ROW
1058: ( X_Rowid => l_rowid
1059: ,X_Project_Id => p_project_id
1060: ,X_Customer_Id => p_customer_id
1061: ,X_Bill_Ship_Customer_Id => p_bill_ship_customer_id /* For Bug 2731449 */

Line 1166: FROM pa_project_contacts

1162:
1163: if p_validate_only <> FND_API.G_TRUE then
1164: BEGIN
1165: SELECT 'x' INTO l_dummy
1166: FROM pa_project_contacts
1167: WHERE rowid = p_rowid
1168: AND record_version_number = p_record_version_number
1169: FOR UPDATE OF record_version_number NOWAIT;
1170: EXCEPTION

Line 1197: FROM pa_project_contacts

1193: END;
1194: else
1195: BEGIN
1196: SELECT 'x' INTO l_dummy
1197: FROM pa_project_contacts
1198: WHERE rowid = p_rowid
1199: AND record_version_number = p_record_version_number;
1200: EXCEPTION
1201: when NO_DATA_FOUND then

Line 1256: PA_PROJECT_CONTACTS_PKG.UPDATE_ROW

1252: l_last_updated_by := fnd_global.user_id;
1253: l_last_update_login := fnd_global.login_id;
1254:
1255: if p_validate_only <> FND_API.G_TRUE then
1256: PA_PROJECT_CONTACTS_PKG.UPDATE_ROW
1257: ( X_Rowid => p_rowid
1258: ,X_Project_Id => p_project_id
1259: ,X_Customer_Id => p_customer_id
1260: ,X_Bill_Ship_Customer_Id => p_bill_ship_customer_id /* For Bug 2731449 */

Line 1341: FROM pa_project_contacts

1337:
1338: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER, c_contact_id NUMBER,
1339: c_project_contact_type_code VARCHAR2) IS
1340: SELECT rowid
1341: FROM pa_project_contacts
1342: WHERE project_id = c_project_id AND
1343: customer_id = c_customer_id AND
1344: contact_id = c_contact_id AND
1345: project_contact_type_code = c_project_contact_type_code;

Line 1362: FROM pa_project_contacts

1358:
1359: if p_validate_only <> FND_API.G_TRUE then
1360: BEGIN
1361: SELECT 'x' INTO l_dummy
1362: FROM pa_project_contacts
1363: WHERE project_id = p_project_id
1364: AND customer_id = p_customer_id
1365: AND contact_id = p_contact_id
1366: AND project_contact_type_code = p_project_contact_type_code

Line 1396: FROM pa_project_contacts

1392: END;
1393: else
1394: BEGIN
1395: SELECT 'x' INTO l_dummy
1396: FROM pa_project_contacts
1397: WHERE project_id = p_project_id
1398: AND customer_id = p_customer_id
1399: AND contact_id = p_contact_id
1400: AND project_contact_type_code = p_project_contact_type_code

Line 1432: PA_PROJECT_CONTACTS_PKG.DELETE_ROW(l_rowid, p_record_version_number);

1428: open C(p_project_id, p_customer_id, p_contact_id, p_project_contact_type_code);
1429: fetch C into l_rowid;
1430: close C;
1431:
1432: PA_PROJECT_CONTACTS_PKG.DELETE_ROW(l_rowid, p_record_version_number);
1433: end if;
1434:
1435: x_return_status := FND_API.G_RET_STS_SUCCESS;
1436:

Line 1499: FROM pa_project_contacts

1495: l_msg_data VARCHAR2(250);
1496:
1497: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER) IS
1498: SELECT contact_id, project_contact_type_code, record_version_number
1499: FROM pa_project_contacts
1500: WHERE project_id = c_project_id AND
1501: customer_id = c_customer_id;
1502: l_recinfo C%ROWTYPE;
1503: BEGIN

Line 1805: FROM pa_project_contacts

1801:
1802: CURSOR C(c_project_id NUMBER, c_customer_id NUMBER, c_contact_id NUMBER,
1803: c_project_contact_type_code VARCHAR2) IS
1804: SELECT rowid
1805: FROM pa_project_contacts
1806: WHERE project_id = c_project_id AND
1807: customer_id = c_customer_id AND
1808: contact_id = c_contact_id AND
1809: project_contact_type_code = c_project_contact_type_code;