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: --
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: );
62: TYPE Customer_Rec IS RECORD

Line 63: (customer_id ar_cash_receipts.pay_from_customer%TYPE,

59: state ar_receipt_classes.creation_status%TYPE,
60: remit_flag ar_receipt_classes.remit_flag%TYPE
61: );
62: TYPE Customer_Rec IS RECORD
63: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
64: /* 6612301 */
65: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
66: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,
67: site_use_id ar_cash_receipts.customer_site_use_id%TYPE

Line 65: bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,

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

Line 66: bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE,

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

Line 67: site_use_id ar_cash_receipts.customer_site_use_id%TYPE

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

Line 80: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,

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

Line 81: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

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

Line 83: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

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

Line 86: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

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

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

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

Line 88: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,

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

Line 89: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

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

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

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

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

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

Line 94: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,

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

Line 95: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

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

Line 96: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

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

Line 97: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

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

Line 98: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

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

Line 99: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

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

Line 100: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

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