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 ;
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:
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(
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,
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,
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,
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,
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,
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 ,