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 711: p_location IN hz_cust_site_uses.location%TYPE,

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

Line 712: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,

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

Line 713: p_id IN hz_cust_site_uses.site_use_id%TYPE,

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

Line 745: p_location IN hz_cust_site_uses.site_use_id%TYPE,

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

Line 746: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,

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

Line 748: ) RETURN hz_cust_site_uses.site_use_id%TYPE IS

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

Line 804: p_location IN hz_cust_site_uses.location%TYPE,

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

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

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

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

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

Line 807: RETURN hz_cust_site_uses.site_use_id%type IS

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

Line 808: l_cached_id hz_cust_site_uses.site_use_id%type;

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

Line 809: l_selected_id hz_cust_site_uses.site_use_id%type;

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

Line 836: FROM hz_cust_site_uses site_use,

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

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

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

Line 863: FROM hz_cust_site_uses site_use,

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

Line 1762: p_location IN hz_cust_site_uses.location%type,

1758: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
1759: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1760: p_customer_name IN hz_parties.party_name%TYPE,
1761: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1762: p_location IN hz_cust_site_uses.location%type,
1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

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

1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1773: p_receipt_method_id IN OUT NOCOPY ar_cash_receipts.receipt_method_id%TYPE,
1774: /* 6612301 */
1775: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1776: p_customer_bank_branch_id IN OUT NOCOPY ar_cash_receipts.customer_bank_branch_id%TYPE,

Line 3633: FROM hz_cust_site_uses site_use,

3629:
3630: /* modified for tca uptake */
3631: CURSOR get_site_use_id IS
3632: SELECT site_use_id
3633: FROM hz_cust_site_uses site_use,
3634: hz_cust_acct_sites acct_site
3635: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
3636: AND acct_site.cust_account_id = p_customer_id
3637: AND site_use.location = l_location

Line 3733: , hz_cust_site_uses su

3729: l_location
3730: FROM
3731: ra_customer_trx ct
3732: , ra_cust_trx_types ctt
3733: , hz_cust_site_uses su
3734: , ra_batch_sources bs
3735: , ar_lookups lu
3736: , hz_cust_accounts cust
3737: , ra_terms t

Line 3830: , hz_cust_site_uses su

3826: l_location
3827: FROM
3828: ra_customer_trx ct
3829: , ra_cust_trx_types ctt
3830: , hz_cust_site_uses su
3831: , ra_batch_sources bs
3832: , ar_lookups lu
3833: , hz_cust_accounts cst
3834: , ra_terms t

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

6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
6869: p_customer_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
6870: p_return_status OUT NOCOPY VARCHAR2
6871: )IS
6872: /* modified for tca uptake */
6873: -- Variables addition for Bug 1907635

Line 6885: FROM hz_cust_site_uses su,

6881: -- Build the query dynamically based on the input parameters
6882: l_sel_stmt := '
6883: SELECT ps.customer_id,
6884: ps.customer_site_use_id
6885: FROM hz_cust_site_uses su,
6886: hz_cust_accounts cust_acct,
6887: ra_cust_trx_types ctt,
6888: ar_payment_schedules ps
6889: WHERE su.site_use_id = ps.customer_site_use_id

Line 8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;

8225: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
8226: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
8227: l_org_id ar_cash_receipts.org_id%TYPE;
8228: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
8230: l_party_id hz_parties.party_id%TYPE;
8231: l_party_site_id hz_parties.party_id%TYPE;
8232: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
8233: BEGIN

Line 8309: hz_cust_site_uses_all csu,

8305: , loc.address1
8306: INTO p_party_site_id
8307: ,x_party_address
8308: FROM hz_cust_acct_sites_all cas,
8309: hz_cust_site_uses_all csu,
8310: hz_party_sites ps,
8311: hz_locations loc
8312: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
8313: AND csu.site_use_id = l_site_use_id