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_PARTIES

Line 45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;

41: l_exchange_rate ra_customer_trx.exchange_rate%TYPE := NULL;
42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;
44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;
46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;

Line 50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;

46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;

Line 51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;

47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;

Line 53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;

49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;

Line 58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;

54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;
58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
60: l_term_id ra_terms.term_id%TYPE := NULL;
61: l_salesrep_id ra_salesreps.salesrep_id%TYPE := NULL;
62: l_term_name ra_terms.name%TYPE := NULL;

Line 59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;

55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;
58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
60: l_term_id ra_terms.term_id%TYPE := NULL;
61: l_salesrep_id ra_salesreps.salesrep_id%TYPE := NULL;
62: l_term_name ra_terms.name%TYPE := NULL;
63: l_salesrep_name ra_salesreps.NAME%TYPE := NULL;

Line 111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;

107: l_purchase_order_revision ra_customer_trx.purchase_order_revision%TYPE := NULL;
108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;

Line 114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;

110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;
117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;
118: l_receipt_method_name ar_receipt_methods.name%TYPE := NULL;

Line 467: l_customer_name hz_parties.party_name%TYPE DEFAULT NULL;

463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;
464: l_maturity_date DATE DEFAULT NULL;
465: l_postmark_date DATE DEFAULT NULL;
466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;
467: l_customer_name hz_parties.party_name%TYPE DEFAULT NULL;
468: l_customer_number hz_parties.party_number%TYPE DEFAULT NULL;
469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;
471: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL;

Line 468: l_customer_number hz_parties.party_number%TYPE DEFAULT NULL;

464: l_maturity_date DATE DEFAULT NULL;
465: l_postmark_date DATE DEFAULT NULL;
466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;
467: l_customer_name hz_parties.party_name%TYPE DEFAULT NULL;
468: l_customer_number hz_parties.party_number%TYPE DEFAULT NULL;
469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;
471: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL;
472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte

Line 821: l_party_id hz_parties.party_id%TYPE DEFAULT NULL;

817: l_delivery_channel_code ap_invoices.delivery_channel_code%TYPE DEFAULT NULL;
818: l_remittance_message1 ap_invoices.remittance_message1%TYPE DEFAULT NULL;
819: l_remittance_message2 ap_invoices.remittance_message2%TYPE DEFAULT NULL;
820: l_remittance_message3 ap_invoices.remittance_message3%TYPE DEFAULT NULL;
821: l_party_id hz_parties.party_id%TYPE DEFAULT NULL;
822: l_party_site_id hz_party_sites.party_site_id%TYPE DEFAULT NULL;
823: l_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
824: x_msg_count NUMBER;
825: x_msg_data VARCHAR2(1000);

Line 1261: x_party_number hz_parties.party_number%TYPE;

1257: l_create_profile_amt VARCHAR2(1) := FND_API.G_TRUE;
1258: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
1259: x_account_number hz_cust_accounts.account_number%TYPE;
1260: x_party_id hz_cust_accounts.party_id%TYPE;
1261: x_party_number hz_parties.party_number%TYPE;
1262: x_profile_id hz_customer_profiles.cust_account_profile_id%TYPE;
1263: l_party_rec HZ_PARTY_V2PUB.party_rec_type := HZ_PARTY_V2PUB.G_MISS_PARTY_REC;
1264: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1265: x_msg_data VARCHAR2(1000);

Line 1515: x_party_name hz_parties.party_name%TYPE := NULL;

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;
1519: x_location hz_locations.city%TYPE := NULL;

Line 1520: x_bank_id hz_parties.party_id%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;
1519: x_location hz_locations.city%TYPE := NULL;
1520: x_bank_id hz_parties.party_id%TYPE := NULL;
1521: x_branch_id hz_parties.party_id%TYPE := NULL;
1522: x_acct_id IBY_EXT_BANK_ACCOUNTS.EXT_BANK_ACCOUNT_ID%TYPE := NULL;
1523: x_account_assignment_id NUMBER;
1524: x_card_assignment_id NUMBER;

Line 1521: x_branch_id hz_parties.party_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;
1519: x_location hz_locations.city%TYPE := NULL;
1520: x_bank_id hz_parties.party_id%TYPE := NULL;
1521: x_branch_id hz_parties.party_id%TYPE := NULL;
1522: x_acct_id IBY_EXT_BANK_ACCOUNTS.EXT_BANK_ACCOUNT_ID%TYPE := NULL;
1523: x_account_assignment_id NUMBER;
1524: x_card_assignment_id NUMBER;
1525: l_instrument_assignment_id NUMBER;

Line 2167: x_party_name hz_parties.party_name%TYPE := NULL;

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;
2171: x_location hz_locations.city%TYPE := NULL;

Line 2792: x_party_name hz_parties.party_name%TYPE := NULL;

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;
2796: x_location hz_locations.city%TYPE := NULL;

Line 3381: hz_parties hp

3377: hp.party_name
3378: INTO x_cust_account_id,
3379: x_party_name
3380: FROM hz_cust_accounts hca,
3381: hz_parties hp
3382: WHERE Nvl(hca.customer_type,'I') = 'R'
3383: AND hca.party_id = hp.party_id
3384: AND hca.account_name = hp.party_name
3385: AND hca.party_id = p_party_id

Line 3393: FROM hz_parties

3389: WHEN NO_DATA_FOUND THEN
3390: x_cust_account_id := NULL;
3391: SELECT party_name
3392: INTO x_party_name
3393: FROM hz_parties
3394: WHERE party_id =p_party_id;
3395: END;
3396:
3397: print_log('After verifying existance of cust account');

Line 4001: HZ_PARTIES hzp,

3997: INTO x_instr_id,
3998: l_expiry_date,
3999: l_card_exists
4000: FROM IBY_CREDITCARD cc,
4001: HZ_PARTIES hzp,
4002: HZ_PARTY_SITES hzps,
4003: HZ_PARTY_SITE_USES hzpsu,
4004: IBY_CREDITCARD_ISSUERS_VL ccissuers
4005: WHERE ccissuers.card_issuer_code = cc.card_issuer_code