DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_SITE_USES

Line 65: p_location IN hz_cust_site_uses.location%TYPE,

61:
62:
63: FUNCTION Get_Site_Use_Id(
64: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
65: p_location IN hz_cust_site_uses.location%TYPE,
66: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
67: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
68: p_return_status OUT NOCOPY VARCHAR2)
69: RETURN hz_cust_site_uses.site_use_id%type ;

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

62:
63: FUNCTION Get_Site_Use_Id(
64: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
65: p_location IN hz_cust_site_uses.location%TYPE,
66: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
67: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
68: p_return_status OUT NOCOPY VARCHAR2)
69: RETURN hz_cust_site_uses.site_use_id%type ;
70:

Line 67: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,

63: FUNCTION Get_Site_Use_Id(
64: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
65: p_location IN hz_cust_site_uses.location%TYPE,
66: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
67: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
68: p_return_status OUT NOCOPY VARCHAR2)
69: RETURN hz_cust_site_uses.site_use_id%type ;
70:
71: PROCEDURE Default_deposit_ids(

Line 69: RETURN hz_cust_site_uses.site_use_id%type ;

65: p_location IN hz_cust_site_uses.location%TYPE,
66: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
67: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
68: p_return_status OUT NOCOPY VARCHAR2)
69: RETURN hz_cust_site_uses.site_use_id%type ;
70:
71: PROCEDURE Default_deposit_ids(
72: x_salesrep_id IN OUT NOCOPY NUMBER,
73: p_salesrep_name IN VARCHAR2 DEFAULT NULL,

Line 81: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

77: p_batch_source_name IN ra_batch_sources.name%type,
78: x_cust_trx_type_id IN OUT NOCOPY NUMBER,
79: p_cust_trx_type IN varchar2,
80: x_bill_to_customer_id IN OUT NOCOPY NUMBER,
81: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
82: p_bill_to_customer_name IN hz_parties.party_name%TYPE,
83: p_bill_to_customer_number IN
84: hz_cust_accounts.account_number%TYPE,
85: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

Line 85: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

81: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
82: p_bill_to_customer_name IN hz_parties.party_name%TYPE,
83: p_bill_to_customer_number IN
84: hz_cust_accounts.account_number%TYPE,
85: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
86: x_bill_to_contact_id IN OUT NOCOPY NUMBER,
87: p_bill_to_contact_first_name IN VARCHAR2,
88: p_bill_to_contact_last_name IN VARCHAR2,
89: x_ship_to_customer_id IN OUT NOCOPY NUMBER,

Line 90: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

86: x_bill_to_contact_id IN OUT NOCOPY NUMBER,
87: p_bill_to_contact_first_name IN VARCHAR2,
88: p_bill_to_contact_last_name IN VARCHAR2,
89: x_ship_to_customer_id IN OUT NOCOPY NUMBER,
90: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
91: p_ship_to_customer_name IN hz_parties.party_name%TYPE,
92: p_ship_to_customer_number IN
93: hz_cust_accounts.account_number%TYPE,
94: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

Line 94: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,

90: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
91: p_ship_to_customer_name IN hz_parties.party_name%TYPE,
92: p_ship_to_customer_number IN
93: hz_cust_accounts.account_number%TYPE,
94: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
95: x_ship_to_contact_id IN OUT NOCOPY NUMBER,
96: p_ship_to_contact_first_name IN VARCHAR2,
97: p_ship_to_contact_last_name IN VARCHAR2,
98: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,

Line 110: x_paying_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

106: x_sold_to_customer_id IN OUT NOCOPY NUMBER,
107: p_sold_to_customer_name IN VARCHAR2,
108: p_sold_to_customer_number IN VARCHAR2,
109: x_paying_customer_id IN OUT NOCOPY NUMBER ,
110: x_paying_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
111: p_paying_customer_name IN VARCHAR2,
112: p_paying_customer_number IN VARCHAR2,
113: p_paying_location IN VARCHAR2,
114: x_receipt_method_id IN OUT NOCOPY NUMBER ,