eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on HZ_CUST_ACCT_SITES

Line 1383: x_cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE;

1379: l_api_version NUMBER := 1.0;
1380: l_api_name VARCHAR2(50) := 'create_cust_acc_site_and_usage';
1381: l_progress NUMBER;
1382: l_cust_acct_site_rec hz_cust_account_site_v2pub.CUST_ACCT_SITE_REC_TYPE;
1383: x_cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE;
1384: l_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1385: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1386: l_create_profile VARCHAR2(1) := FND_API.G_TRUE;
1387: l_create_profile_amt VARCHAR2(1) := FND_API.G_TRUE;

Line 1514: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;

1510: l_org_return_status VARCHAR2(1);
1511: l_found BOOLEAN;
1512: l_emd_transactions_info pon_emd_trx_rec;
1513: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
1514: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
1515: x_party_name hz_parties.party_name%TYPE := NULL;
1516: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
1517: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;
1518: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;

Line 2166: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;

2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2164:
2165: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2166: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
2167: x_party_name hz_parties.party_name%TYPE := NULL;
2168: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
2169: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;
2170: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;

Line 2791: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;

2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2789:
2790: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2791: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
2792: x_party_name hz_parties.party_name%TYPE := NULL;
2793: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
2794: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;
2795: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;

Line 3452: FROM HZ_CUST_ACCT_SITES_ALL site,

3448: SELECT site.cust_acct_site_id,
3449: USE.site_use_id
3450: INTO x_cust_acct_site_id,
3451: x_site_use_id
3452: FROM HZ_CUST_ACCT_SITES_ALL site,
3453: HZ_CUST_SITE_USES_ALL use
3454: WHERE cust_account_id = x_cust_account_id
3455: AND site.org_id = p_org_id
3456: AND site.party_site_id = x_party_site_id