APPS.AR_PREPAYMENTS_PUB dependencies on AR_RECEIVABLE_APPLICATIONS

Line 115: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

111: -- ** OUT NOCOPY variables for Creating receipt
112: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
113: -- Receipt application parameters
114: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
115: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
116: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
117: p_application_ref_id IN OUT NOCOPY NUMBER ,
118: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
119: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,

Line 120: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,

116: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
117: p_application_ref_id IN OUT NOCOPY NUMBER ,
118: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
119: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
120: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
121: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
122: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
123: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
124: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 121: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

117: p_application_ref_id IN OUT NOCOPY NUMBER ,
118: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
119: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
120: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
121: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
122: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
123: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
124: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
125: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',

Line 122: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

118: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
119: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
120: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
121: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
122: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
123: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
124: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
125: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
126: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 123: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

119: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
120: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
121: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
122: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
123: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
124: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
125: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
126: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
127: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

Line 124: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

120: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
121: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
122: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
123: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
124: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
125: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
126: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
127: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
128: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 132: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

128: DEFAULT ar_receipt_api_pub.attribute_rec_const,
129: -- ******* Global Flexfield parameters *******
130: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
131: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
132: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
133: -- processor such as iPayments
134: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
135: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
136:

Line 142: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

138: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
139:
140: p_payment_response_error_code OUT NOCOPY VARCHAR2,
141: -- OUT NOCOPY parameter for the Application
142: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
143: p_payment_set_id IN OUT NOCOPY NUMBER ,
144: p_org_id IN NUMBER DEFAULT NULL,
145: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
146: ) IS

Line 397: SELECT ar_receivable_applications_s1.nextval

393: --sequence and pass to apply routine.
394: --IF payment set id is passed, then do not generate.
395: IF p_payment_set_id is null THEN
396: BEGIN
397: SELECT ar_receivable_applications_s1.nextval
398: INTO l_payment_set_id
399: FROM dual;
400: EXCEPTION
401: WHEN others THEN