DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on AR_CASH_RECEIPTS

Line 58: bank_account_id ar_cash_receipts.remit_bank_acct_use_id%type,

54: ---- Chuan Ling 23-Sep-11 Bug 12981398 - added currency.
55:
56: TYPE Receipt_Method_Rec IS RECORD
57: (method_id ar_receipt_methods.receipt_method_id%TYPE,
58: bank_account_id ar_cash_receipts.remit_bank_acct_use_id%type,
59: state ar_receipt_classes.creation_status%TYPE,
60: remit_flag ar_receipt_classes.remit_flag%TYPE,
61: currency ce_bank_accounts.currency_code%TYPE --bug12981398
62: );

Line 64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,

60: remit_flag ar_receipt_classes.remit_flag%TYPE,
61: currency ce_bank_accounts.currency_code%TYPE --bug12981398
62: );
63: TYPE Customer_Rec IS RECORD
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE

Line 66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,

62: );
63: TYPE Customer_Rec IS RECORD
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
69: );
70:

Line 67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,

63: TYPE Customer_Rec IS RECORD
64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
69: );
70:
71: TYPE Rec_Method_Info_Tbl_Type IS TABLE OF Receipt_Method_Rec

Line 68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE

64: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
65: /* 6612301 */
66: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
67: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
68: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
69: );
70:
71: TYPE Rec_Method_Info_Tbl_Type IS TABLE OF Receipt_Method_Rec
72: INDEX BY BINARY_INTEGER;

Line 81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,

77:
78: Customer_Cache_Tbl Rec_Customer_Tbl_Type;
79:
80: PROCEDURE Validate_Cash_Receipt(
81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

Line 82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

78: Customer_Cache_Tbl Rec_Customer_Tbl_Type;
79:
80: PROCEDURE Validate_Cash_Receipt(
81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,

Line 84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

80: PROCEDURE Validate_Cash_Receipt(
81: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
82: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

Line 87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

83: p_state IN ar_receipt_classes.creation_status%TYPE,
84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */

Line 88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

84: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

Line 89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,

85: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,

Line 90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

86: p_maturity_date IN DATE,
87: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

Line 92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

88: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
89: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

Line 94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

90: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,

91: /* 6612301 */
92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

Line 96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

92: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

Line 97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

93: p_location IN hz_cust_site_uses.location%TYPE,
94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

Line 98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

94: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,

Line 99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

95: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
103: p_called_from IN VARCHAR2,

Line 100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

96: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
103: p_called_from IN VARCHAR2,
104: p_return_status OUT NOCOPY VARCHAR2);

Line 101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

97: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
100: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
101: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
102: p_doc_sequence_value IN NUMBER,
103: p_called_from IN VARCHAR2,
104: p_return_status OUT NOCOPY VARCHAR2);
105: