APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on HZ_PARTIES

Line 1192: CURSOR C IS SELECT party_id FROM hz_parties

1188:
1189: c_party_id number(15);
1190: c_customer_id number(15);
1191:
1192: CURSOR C IS SELECT party_id FROM hz_parties
1193: WHERE party_id = X_party_id;
1194: CURSOR C1 IS SELECT rowid FROM hz_cust_accounts
1195: WHERE cust_account_id = X_customer_id;
1196: CURSOR C2 IS SELECT customer_id FROM igi_ra_customers

Line 1399: FROM hz_cust_accounts a,hz_parties p

1395: l_object_cust_version_number NUMBER;
1396:
1397: CURSOR c_all IS
1398: SELECT nvl(a.object_version_number,fnd_api.G_NULL_NUM),a.party_id,a.cust_account_id,nvl(p.object_version_number,fnd_api.G_NULL_NUM)
1399: FROM hz_cust_accounts a,hz_parties p
1400: WHERE a.party_id = p.party_id
1401: AND a.rowid = X_rowid;
1402:
1403: BEGIN

Line 1459: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p

1455: stp_type = X_stp_type,
1456: last_update_login = X_last_update_login,
1457: last_update_date = X_last_update_date,
1458: last_updated_by = X_last_updated_by
1459: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p
1460: where a.party_id = p.party_id and a.rowid = X_rowid); -- Bug 3902175
1461:
1462: IF (SQL%NOTFOUND) THEN
1463: Raise NO_DATA_FOUND;

Line 1492: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p -- Bug 3902175

1488:
1489: CURSOR C1 IS
1490: SELECT *
1491: FROM igi_ra_customers irc
1492: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p -- Bug 3902175
1493: where a.party_id = p.party_id and a.rowid = X_rowid)
1494: FOR UPDATE OF irc.customer_id NOWAIT;
1495:
1496: RecCust1 C1%ROWTYPE;

Line 1640: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

1636: l_return_status varchar2(2000);
1637: l_msg_count NUMBER;
1638: l_msg_data VARCHAR2(2000);
1639: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1640: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1641:
1642:
1643:
1644: CURSOR C IS SELECT rowid FROM AP_SUPPLIERS

Line 1776: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

1772: l_return_status varchar2(2000);
1773: l_msg_count NUMBER;
1774: l_msg_data VARCHAR2(2000);
1775: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1776: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1777: l_object_version_number NUMBER;
1778: l_profile_id NUMBER;
1779:
1780: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;

Line 1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';

1780: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
1781: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
1782: BEGIN
1783:
1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';
1785:
1786: l_party_rec.party_id := l_party_id;
1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);