APPS.AHL_PRD_NONROUTINE_PVT dependencies on HZ_PARTIES

Line 769: from hz_parties

765: BEGIN
766: Select party_name
767: into
768: l_customer_name
769: from hz_parties
770: where party_id
771: = p_x_sr_task_rec.customer_id;
772:
773: IF (l_customer_name <> nvl(p_x_sr_task_rec.customer_name,l_customer_name) and

Line 805: from hz_parties

801: BEGIN
802: Select party_id
803: into
804: l_customer_id
805: from hz_parties
806: where party_name = p_x_sr_task_rec.customer_name;
807: p_x_sr_task_rec.customer_id := l_customer_id;
808:
809: EXCEPTION

Line 851: from hz_parties

847: BEGIN
848: Select party_name
849: into
850: l_contact_name
851: from hz_parties
852: where party_id
853: = p_x_sr_task_rec.contact_id;
854:
855:

Line 888: from hz_parties

884: BEGIN
885: Select party_id
886: into
887: l_contact_id
888: from hz_parties
889: where party_name = p_x_sr_task_rec.contact_name;
890:
891: p_x_sr_task_rec.contact_id := l_contact_id;
892:

Line 1153: from hz_parties

1149: BEGIN
1150: Select party_name
1151: into
1152: l_contact_name
1153: from hz_parties
1154: where party_id
1155: = p_x_sr_task_rec.contact_id;
1156:
1157: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and

Line 1190: from hz_parties

1186: BEGIN
1187: Select party_id
1188: into
1189: l_contact_id
1190: from hz_parties
1191: where party_name = p_x_sr_task_rec.contact_name;
1192:
1193: p_x_sr_task_rec.contact_id := l_contact_id;
1194:

Line 1435: FROM hz_parties

1431: WHERE user_id = fnd_global.user_id;
1432:
1433: CURSOR default_customer_type IS
1434: SELECT party_type
1435: FROM hz_parties
1436: WHERE party_id = fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1437:
1438: -- Changes made by by VSUNDARA For SR Integration
1439: CURSOR default_party_id(p_item_instance_number IN NUMBER) IS

Line 1446: FROM hz_parties

1442: WHERE instance_id = p_item_instance_number;
1443:
1444: CURSOR owner_customer_type(p_cust_id IN NUMBER) IS
1445: SELECT party_type
1446: FROM hz_parties
1447: WHERE party_id = p_cust_id;
1448:
1449: -- STHILAK PIE Integration
1450: CURSOR sr_service_type_code (p_service_type IN VARCHAR2) IS

Line 1695: from hz_parties

1691: --Just to Check
1692: Select party_name
1693: into
1694: p_x_sr_task_rec.customer_name
1695: from hz_parties
1696: where party_id = p_x_sr_task_rec.customer_id;
1697: IF ( default_party_id%NOTFOUND) THEN
1698: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1699: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);