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.ARP_PROCESS_CREDIT_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 567: p_parent_customer_id IN hz_cust_accounts.cust_account_id%type,

563: | 12-JUL-95 Subash Chadalavada Created |
564: | |
565: +===========================================================================*/
566: PROCEDURE get_parent_site_use(
567: p_parent_customer_id IN hz_cust_accounts.cust_account_id%type,
568: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
569: IS
570: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
571: BEGIN

Line 638: p_bill_to_customer_id IN hz_cust_accounts.cust_account_id%type,

634: | |
635: +===========================================================================*/
636:
637: PROCEDURE get_parent_customer_site(
638: p_bill_to_customer_id IN hz_cust_accounts.cust_account_id%type,
639: p_parent_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%type,
640: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
641: IS
642: l_parent_customer_id hz_cust_accounts.cust_account_id%type;

Line 639: p_parent_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%type,

635: +===========================================================================*/
636:
637: PROCEDURE get_parent_customer_site(
638: p_bill_to_customer_id IN hz_cust_accounts.cust_account_id%type,
639: p_parent_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%type,
640: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
641: IS
642: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
643: BEGIN

Line 642: l_parent_customer_id hz_cust_accounts.cust_account_id%type;

638: p_bill_to_customer_id IN hz_cust_accounts.cust_account_id%type,
639: p_parent_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%type,
640: p_parent_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%type)
641: IS
642: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
643: BEGIN
644:
645: BEGIN
646:

Line 725: hz_cust_accounts.cust_account_id%type,

721: ra_customer_trx.customer_trx_id%type,
722: p_site_use_id IN
723: hz_cust_site_uses.site_use_id%type,
724: p_parent_customer_id IN
725: hz_cust_accounts.cust_account_id%type,
726: p_parent_site_use_id IN
727: hz_cust_site_uses.site_use_id%type,
728: p_currency_code IN
729: fnd_currencies.currency_code%type,

Line 885: hz_cust_accounts.cust_account_id%type,

881: ra_customer_trx.trx_date%type,
882: p_currency_code IN
883: fnd_currencies.currency_code%type,
884: p_bill_to_customer_id IN
885: hz_cust_accounts.cust_account_id%type,
886: p_bill_to_site_use_id IN
887: hz_cust_site_uses.site_use_id%type,
888: p_parent_customer_id IN
889: hz_cust_accounts.cust_account_id%type,

Line 889: hz_cust_accounts.cust_account_id%type,

885: hz_cust_accounts.cust_account_id%type,
886: p_bill_to_site_use_id IN
887: hz_cust_site_uses.site_use_id%type,
888: p_parent_customer_id IN
889: hz_cust_accounts.cust_account_id%type,
890: p_parent_site_use_id IN
891: hz_cust_site_uses.site_use_id%type,
892: p_crtrx_cust_bank_account_id IN
893: ce_bank_accounts.bank_account_id%type,

Line 897: hz_cust_accounts.cust_account_id%type)

893: ce_bank_accounts.bank_account_id%type,
894: p_cust_bank_account_id OUT NOCOPY
895: ce_bank_accounts.bank_account_id%type,
896: p_paying_customer_id OUT NOCOPY
897: hz_cust_accounts.cust_account_id%type)
898: RETURN BOOLEAN IS
899: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
900: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
901: l_account_valid boolean := FALSE;

Line 900: l_paying_customer_id hz_cust_accounts.cust_account_id%type;

896: p_paying_customer_id OUT NOCOPY
897: hz_cust_accounts.cust_account_id%type)
898: RETURN BOOLEAN IS
899: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
900: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
901: l_account_valid boolean := FALSE;
902: BEGIN
903: /* BICHATTE removed the validation for bank account
904: PAYMENT UPTAKE */

Line 1011: hz_cust_accounts.cust_account_id%type,

1007: fnd_currencies.currency_code%type,
1008: p_cust_trx_type_id IN
1009: ra_cust_trx_types.cust_trx_type_id%type,
1010: p_ship_to_customer_id IN
1011: hz_cust_accounts.cust_account_id%type,
1012: p_ship_to_site_use_id IN
1013: hz_cust_site_uses.site_use_id%type,
1014: p_ship_to_contact_id IN
1015: hz_cust_account_roles.cust_account_role_id%type,

Line 1017: hz_cust_accounts.cust_account_id%type,

1013: hz_cust_site_uses.site_use_id%type,
1014: p_ship_to_contact_id IN
1015: hz_cust_account_roles.cust_account_role_id%type,
1016: p_bill_to_customer_id IN
1017: hz_cust_accounts.cust_account_id%type,
1018: p_bill_to_site_use_id IN
1019: hz_cust_site_uses.site_use_id%type,
1020: p_bill_to_contact_id IN
1021: hz_cust_account_roles.cust_account_role_id%type,

Line 1029: hz_cust_accounts.cust_account_id%type,

1025: ar_receipt_methods.receipt_method_id%type,
1026: p_customer_bank_account_id IN
1027: ce_bank_accounts.bank_account_id%type,
1028: p_paying_customer_id IN
1029: hz_cust_accounts.cust_account_id%type,
1030: p_paying_site_use_id IN
1031: hz_cust_site_uses.site_use_id%type,
1032: p_ship_via IN
1033: ra_customer_trx.ship_via%type,

Line 1063: hz_cust_accounts.cust_account_id%type,

1059: p_batch_gl_date IN
1060: ra_batches.gl_date%type,
1061: --
1062: p_crtrx_ship_to_customer_id IN
1063: hz_cust_accounts.cust_account_id%type,
1064: p_crtrx_ship_to_site_use_id IN
1065: hz_cust_site_uses.site_use_id%type,
1066: p_crtrx_ship_to_contact_id IN
1067: hz_cust_account_roles.cust_account_role_id%type,

Line 1069: hz_cust_accounts.cust_account_id%type,

1065: hz_cust_site_uses.site_use_id%type,
1066: p_crtrx_ship_to_contact_id IN
1067: hz_cust_account_roles.cust_account_role_id%type,
1068: p_crtrx_bill_to_customer_id IN
1069: hz_cust_accounts.cust_account_id%type,
1070: p_crtrx_bill_to_site_use_id IN
1071: hz_cust_site_uses.site_use_id%type,
1072: p_crtrx_bill_to_contact_id IN
1073: hz_cust_account_roles.cust_account_role_id%type,

Line 1128: hz_cust_accounts.cust_account_id%type,

1124: --
1125: p_default_gl_date OUT NOCOPY
1126: ra_cust_trx_line_gl_dist.gl_date%type,
1127: p_default_ship_to_customer_id OUT NOCOPY
1128: hz_cust_accounts.cust_account_id%type,
1129: p_default_ship_to_site_use_id OUT NOCOPY
1130: hz_cust_site_uses.site_use_id%type,
1131: p_default_ship_to_contact_id OUT NOCOPY
1132: hz_cust_account_roles.cust_account_role_id%type,

Line 1134: hz_cust_accounts.cust_account_id%type,

1130: hz_cust_site_uses.site_use_id%type,
1131: p_default_ship_to_contact_id OUT NOCOPY
1132: hz_cust_account_roles.cust_account_role_id%type,
1133: p_default_bill_to_customer_id OUT NOCOPY
1134: hz_cust_accounts.cust_account_id%type,
1135: p_default_bill_to_site_use_id OUT NOCOPY
1136: hz_cust_site_uses.site_use_id%type,
1137: p_default_bill_to_contact_id OUT NOCOPY
1138: hz_cust_account_roles.cust_account_role_id%type,

Line 1146: hz_cust_accounts.cust_account_id%type,

1142: ar_receipt_methods.receipt_method_id%type,
1143: p_default_cust_bank_account_id OUT NOCOPY
1144: ce_bank_accounts.bank_account_id%type,
1145: p_default_paying_customer_id OUT NOCOPY
1146: hz_cust_accounts.cust_account_id%type,
1147: p_default_paying_site_use_id OUT NOCOPY
1148: hz_cust_site_uses.site_use_id%type,
1149: p_default_ship_via OUT NOCOPY
1150: ra_customer_trx.ship_via%type,

Line 1172: l_bill_to_customer_id hz_cust_accounts.cust_account_id%type;

1168: l_default_printing_option_code ar_lookups.lookup_code%type;
1169: l_default_printing_option ar_lookups.meaning%type;
1170: l_default_term_id ra_terms.term_id%type;
1171: l_default_term_name ra_terms.name%type;
1172: l_bill_to_customer_id hz_cust_accounts.cust_account_id%type;
1173: l_bill_to_site_use_id hz_cust_site_uses.site_use_id%type;
1174: l_ship_to_site_use_id hz_cust_site_uses.site_use_id%type; --4766915
1175: l_ship_to_contact_id hz_cust_account_roles.cust_account_role_id%type;
1176: l_primary_salesrep_id ra_salesreps.salesrep_id%type;

Line 1186: l_paying_customer_id hz_cust_accounts.cust_account_id%type;

1182: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1183: l_defaulting_rule_used varchar2(128);
1184: l_error_message varchar2(128);
1185:
1186: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
1187: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
1188: l_paying_site_use_id hz_cust_site_uses.site_use_id%type;
1189: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
1190:

Line 1187: l_parent_customer_id hz_cust_accounts.cust_account_id%type;

1183: l_defaulting_rule_used varchar2(128);
1184: l_error_message varchar2(128);
1185:
1186: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
1187: l_parent_customer_id hz_cust_accounts.cust_account_id%type;
1188: l_paying_site_use_id hz_cust_site_uses.site_use_id%type;
1189: l_parent_site_use_id hz_cust_site_uses.site_use_id%type;
1190:
1191: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;