DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_SITE_BO_PVT dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 227: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

223: l_casu_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
224: l_cap_id NUMBER;
225: l_cap_os VARCHAR2(30);
226: l_cap_osr VARCHAR2(255);
227: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
228: l_profile_id NUMBER;
229: l_party_id NUMBER;
230:
231: CURSOR get_party_id(l_ca_id NUMBER) IS

Line 519: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

515: l_casu_id NUMBER;
516: l_casu_os VARCHAR2(30);
517: l_casu_osr VARCHAR2(255);
518: l_casu_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
519: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
520: l_ovn NUMBER;
521: l_cap_ovn NUMBER;
522: l_create_update_flag VARCHAR2(1);
523: l_profile_id NUMBER;

Line 1308: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1304: l_casu_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
1305: l_cap_id NUMBER;
1306: l_cap_os VARCHAR2(30);
1307: l_cap_osr VARCHAR2(255);
1308: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1309: l_profile_id NUMBER;
1310: l_party_id NUMBER;
1311:
1312: CURSOR get_party_id(l_ca_id NUMBER) IS

Line 1601: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1597: l_casu_id NUMBER;
1598: l_casu_os VARCHAR2(30);
1599: l_casu_osr VARCHAR2(255);
1600: l_casu_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
1601: l_cap_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1602: l_ovn NUMBER;
1603: l_cap_ovn NUMBER;
1604: l_create_update_flag VARCHAR2(1);
1605: l_profile_id NUMBER;