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.AR_RECEIPT_LIB_PVT dependencies on HZ_CUST_SITE_USES

Line 36: (id hz_cust_site_uses.site_use_id%TYPE,

32: G_LEGAL_ENTITY_CACHE_SIZE BINARY_INTEGER := 1000;
33:
34: /* modified for tca uptake */
35: TYPE Site_Use_Cache_Rec_Type IS RECORD
36: (id hz_cust_site_uses.site_use_id%TYPE,
37: customer_id hz_cust_acct_sites.cust_account_id%TYPE,
38: site_use_code hz_cust_site_uses.site_use_code%TYPE,
39: location hz_cust_site_uses.location%TYPE,
40: primary_flag VARCHAR2(1)

Line 38: site_use_code hz_cust_site_uses.site_use_code%TYPE,

34: /* modified for tca uptake */
35: TYPE Site_Use_Cache_Rec_Type IS RECORD
36: (id hz_cust_site_uses.site_use_id%TYPE,
37: customer_id hz_cust_acct_sites.cust_account_id%TYPE,
38: site_use_code hz_cust_site_uses.site_use_code%TYPE,
39: location hz_cust_site_uses.location%TYPE,
40: primary_flag VARCHAR2(1)
41: );
42: TYPE Exchange_Rate_Cache_Rec_Type IS RECORD

Line 39: location hz_cust_site_uses.location%TYPE,

35: TYPE Site_Use_Cache_Rec_Type IS RECORD
36: (id hz_cust_site_uses.site_use_id%TYPE,
37: customer_id hz_cust_acct_sites.cust_account_id%TYPE,
38: site_use_code hz_cust_site_uses.site_use_code%TYPE,
39: location hz_cust_site_uses.location%TYPE,
40: primary_flag VARCHAR2(1)
41: );
42: TYPE Exchange_Rate_Cache_Rec_Type IS RECORD
43: (exchange_rate ar_cash_receipts.exchange_rate%TYPE,

Line 708: p_location IN hz_cust_site_uses.location%TYPE,

704:
705: /* modified for tca uptake */
706: PROCEDURE Add_Site_Use_To_Cache(
707: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
708: p_location IN hz_cust_site_uses.location%TYPE,
709: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
710: p_id IN hz_cust_site_uses.site_use_id%TYPE,
711: p_index IN BINARY_INTEGER
712: ) IS

Line 709: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,

705: /* modified for tca uptake */
706: PROCEDURE Add_Site_Use_To_Cache(
707: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
708: p_location IN hz_cust_site_uses.location%TYPE,
709: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
710: p_id IN hz_cust_site_uses.site_use_id%TYPE,
711: p_index IN BINARY_INTEGER
712: ) IS
713: BEGIN

Line 710: p_id IN hz_cust_site_uses.site_use_id%TYPE,

706: PROCEDURE Add_Site_Use_To_Cache(
707: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
708: p_location IN hz_cust_site_uses.location%TYPE,
709: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
710: p_id IN hz_cust_site_uses.site_use_id%TYPE,
711: p_index IN BINARY_INTEGER
712: ) IS
713: BEGIN
714:

Line 742: p_location IN hz_cust_site_uses.site_use_id%TYPE,

738:
739: /* modified for tca uptake */
740: FUNCTION Find_Site_Use_In_Cache(
741: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
742: p_location IN hz_cust_site_uses.site_use_id%TYPE,
743: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
744: p_index OUT NOCOPY BINARY_INTEGER
745: ) RETURN hz_cust_site_uses.site_use_id%TYPE IS
746:

Line 743: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,

739: /* modified for tca uptake */
740: FUNCTION Find_Site_Use_In_Cache(
741: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
742: p_location IN hz_cust_site_uses.site_use_id%TYPE,
743: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
744: p_index OUT NOCOPY BINARY_INTEGER
745: ) RETURN hz_cust_site_uses.site_use_id%TYPE IS
746:
747: l_index BINARY_INTEGER;

Line 745: ) RETURN hz_cust_site_uses.site_use_id%TYPE IS

741: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
742: p_location IN hz_cust_site_uses.site_use_id%TYPE,
743: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
744: p_index OUT NOCOPY BINARY_INTEGER
745: ) RETURN hz_cust_site_uses.site_use_id%TYPE IS
746:
747: l_index BINARY_INTEGER;
748: l_count BINARY_INTEGER;
749:

Line 801: p_location IN hz_cust_site_uses.location%TYPE,

797:
798: /* modified for tca uptake */
799: FUNCTION Get_Site_Use_Id(
800: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
801: p_location IN hz_cust_site_uses.location%TYPE,
802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
804: RETURN hz_cust_site_uses.site_use_id%type IS
805: l_cached_id hz_cust_site_uses.site_use_id%type;

Line 802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,

798: /* modified for tca uptake */
799: FUNCTION Get_Site_Use_Id(
800: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
801: p_location IN hz_cust_site_uses.location%TYPE,
802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
804: RETURN hz_cust_site_uses.site_use_id%type IS
805: l_cached_id hz_cust_site_uses.site_use_id%type;
806: l_selected_id hz_cust_site_uses.site_use_id%type;

Line 803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)

799: FUNCTION Get_Site_Use_Id(
800: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
801: p_location IN hz_cust_site_uses.location%TYPE,
802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
804: RETURN hz_cust_site_uses.site_use_id%type IS
805: l_cached_id hz_cust_site_uses.site_use_id%type;
806: l_selected_id hz_cust_site_uses.site_use_id%type;
807: l_index BINARY_INTEGER;

Line 804: RETURN hz_cust_site_uses.site_use_id%type IS

800: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
801: p_location IN hz_cust_site_uses.location%TYPE,
802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
804: RETURN hz_cust_site_uses.site_use_id%type IS
805: l_cached_id hz_cust_site_uses.site_use_id%type;
806: l_selected_id hz_cust_site_uses.site_use_id%type;
807: l_index BINARY_INTEGER;
808: BEGIN

Line 805: l_cached_id hz_cust_site_uses.site_use_id%type;

801: p_location IN hz_cust_site_uses.location%TYPE,
802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
804: RETURN hz_cust_site_uses.site_use_id%type IS
805: l_cached_id hz_cust_site_uses.site_use_id%type;
806: l_selected_id hz_cust_site_uses.site_use_id%type;
807: l_index BINARY_INTEGER;
808: BEGIN
809:

Line 806: l_selected_id hz_cust_site_uses.site_use_id%type;

802: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
803: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
804: RETURN hz_cust_site_uses.site_use_id%type IS
805: l_cached_id hz_cust_site_uses.site_use_id%type;
806: l_selected_id hz_cust_site_uses.site_use_id%type;
807: l_index BINARY_INTEGER;
808: BEGIN
809:
810: IF PG_DEBUG in ('Y', 'C') THEN

Line 833: FROM hz_cust_site_uses site_use,

829: BEGIN
830: /* modified for tca uptake */
831: SELECT site_use.site_use_id
832: INTO l_selected_id
833: FROM hz_cust_site_uses site_use,
834: hz_cust_acct_sites acct_site
835: WHERE acct_site.cust_account_id = p_customer_id
836: AND acct_site.status = 'A'
837: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 847: arp_util.debug('Get_Site_Use_Id: ' || 'No data found in the hz_cust_site_uses for the location :'||p_location);

843: AND site_use.location = p_location;
844: EXCEPTION
845: WHEN no_data_found THEN
846: IF PG_DEBUG in ('Y', 'C') THEN
847: arp_util.debug('Get_Site_Use_Id: ' || 'No data found in the hz_cust_site_uses for the location :'||p_location);
848: END IF;
849: --the error message will be raised in the validation routine.
850: null;
851: END;

Line 860: FROM hz_cust_site_uses site_use,

856: BEGIN
857: /* modified for tca uptake */
858: SELECT site_use.site_use_id
859: INTO l_selected_id
860: FROM hz_cust_site_uses site_use,
861: hz_cust_acct_sites acct_site
862: WHERE acct_site.cust_account_id = p_customer_id
863: AND acct_site.status = 'A'
864: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1755: p_location IN hz_cust_site_uses.location%type,

1751: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
1752: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1753: p_customer_name IN hz_parties.party_name%TYPE,
1754: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1755: p_location IN hz_cust_site_uses.location%type,
1756: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1757: /* 6612301 */
1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

Line 1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1766: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1767: /* 6612301 */
1768: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1769: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,

Line 3448: FROM hz_cust_site_uses site_use,

3444:
3445: /* modified for tca uptake */
3446: CURSOR get_site_use_id IS
3447: SELECT site_use_id
3448: FROM hz_cust_site_uses site_use,
3449: hz_cust_acct_sites acct_site
3450: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
3451: AND acct_site.cust_account_id = p_customer_id
3452: AND site_use.location = l_location

Line 3548: , hz_cust_site_uses su

3544: l_location
3545: FROM
3546: ra_customer_trx ct
3547: , ra_cust_trx_types ctt
3548: , hz_cust_site_uses su
3549: , ra_batch_sources bs
3550: , ar_lookups lu
3551: , hz_cust_accounts cust
3552: , ra_terms t

Line 3645: , hz_cust_site_uses su

3641: l_location
3642: FROM
3643: ra_customer_trx ct
3644: , ra_cust_trx_types ctt
3645: , hz_cust_site_uses su
3646: , ra_batch_sources bs
3647: , ar_lookups lu
3648: , hz_cust_accounts cst
3649: , ra_terms t

Line 6581: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6580: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6581: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6582: p_return_status OUT NOCOPY VARCHAR2
6583: )IS
6584: /* modified for tca uptake */
6585: -- Variables addition for Bug 1907635

Line 6597: FROM hz_cust_site_uses su,

6593: -- Build the query dynamically based on the input parameters
6594: l_sel_stmt := '
6595: SELECT ps.customer_id,
6596: ps.customer_site_use_id
6597: FROM hz_cust_site_uses su,
6598: hz_cust_accounts cust_acct,
6599: ra_cust_trx_types ctt,
6600: ar_payment_schedules ps
6601: WHERE su.site_use_id = ps.customer_site_use_id

Line 7930: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;

7926: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
7927: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7928: l_org_id ar_cash_receipts.org_id%TYPE;
7929: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
7930: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
7931: l_party_id hz_parties.party_id%TYPE;
7932: l_party_site_id hz_parties.party_id%TYPE;
7933: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
7934: BEGIN

Line 8010: hz_cust_site_uses_all csu,

8006: , loc.address1
8007: INTO p_party_site_id
8008: ,x_party_address
8009: FROM hz_cust_acct_sites_all cas,
8010: hz_cust_site_uses_all csu,
8011: hz_party_sites ps,
8012: hz_locations loc
8013: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
8014: AND csu.site_use_id = l_site_use_id