eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CM_APPLICATION_PUB dependencies on AR_RECEIVABLE_APPLICATIONS

Line 43: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,

39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: -- Credit Memo application parameters.
42: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
43: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
44: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
45: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
46: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
47: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 45: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default

41: -- Credit Memo application parameters.
42: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
43: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
44: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
45: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
46: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
47: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
48: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
49: p_attribute_rec IN attribute_rec_type,

Line 46: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

42: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
43: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
44: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
45: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
46: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
47: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
48: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
49: p_attribute_rec IN attribute_rec_type,
50: -- ******* Global Flexfield parameters *******

Line 47: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,

43: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
44: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
45: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
46: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
47: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
48: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
49: p_attribute_rec IN attribute_rec_type,
50: -- ******* Global Flexfield parameters *******
51: p_global_attribute_rec IN global_attribute_rec_type,

Line 48: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

44: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
45: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
46: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
47: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
48: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
49: p_attribute_rec IN attribute_rec_type,
50: -- ******* Global Flexfield parameters *******
51: p_global_attribute_rec IN global_attribute_rec_type,
52: p_comments IN ar_receivable_applications.comments%TYPE,

Line 52: p_comments IN ar_receivable_applications.comments%TYPE,

48: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
49: p_attribute_rec IN attribute_rec_type,
50: -- ******* Global Flexfield parameters *******
51: p_global_attribute_rec IN global_attribute_rec_type,
52: p_comments IN ar_receivable_applications.comments%TYPE,
53: p_chk_approval_limit_flag IN VARCHAR2,
54: p_application_ref_type IN OUT NOCOPY
55: ar_receivable_applications.application_ref_type%TYPE,
56: p_application_ref_id IN OUT NOCOPY

Line 55: ar_receivable_applications.application_ref_type%TYPE,

51: p_global_attribute_rec IN global_attribute_rec_type,
52: p_comments IN ar_receivable_applications.comments%TYPE,
53: p_chk_approval_limit_flag IN VARCHAR2,
54: p_application_ref_type IN OUT NOCOPY
55: ar_receivable_applications.application_ref_type%TYPE,
56: p_application_ref_id IN OUT NOCOPY
57: ar_receivable_applications.application_ref_id%TYPE,
58: p_application_ref_num IN OUT NOCOPY
59: ar_receivable_applications.application_ref_num%TYPE,

Line 57: ar_receivable_applications.application_ref_id%TYPE,

53: p_chk_approval_limit_flag IN VARCHAR2,
54: p_application_ref_type IN OUT NOCOPY
55: ar_receivable_applications.application_ref_type%TYPE,
56: p_application_ref_id IN OUT NOCOPY
57: ar_receivable_applications.application_ref_id%TYPE,
58: p_application_ref_num IN OUT NOCOPY
59: ar_receivable_applications.application_ref_num%TYPE,
60: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
61: p_called_from IN VARCHAR2

Line 59: ar_receivable_applications.application_ref_num%TYPE,

55: ar_receivable_applications.application_ref_type%TYPE,
56: p_application_ref_id IN OUT NOCOPY
57: ar_receivable_applications.application_ref_id%TYPE,
58: p_application_ref_num IN OUT NOCOPY
59: ar_receivable_applications.application_ref_num%TYPE,
60: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
61: p_called_from IN VARCHAR2
62: ,p_org_id IN NUMBER
63: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE

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

56: p_application_ref_id IN OUT NOCOPY
57: ar_receivable_applications.application_ref_id%TYPE,
58: p_application_ref_num IN OUT NOCOPY
59: ar_receivable_applications.application_ref_num%TYPE,
60: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
61: p_called_from IN VARCHAR2
62: ,p_org_id IN NUMBER
63: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE
64: ,p_pay_alone_flag IN VARCHAR2

Line 95: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

91: l_cm_currency_code fnd_currencies.currency_code%TYPE;
92: l_rec_app_id NUMBER;
93: l_cm_ps_id NUMBER;
94: l_cm_receipt_method_id NUMBER;
95: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
96: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
97: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
98: l_acctd_amount_applied_from NUMBER;
99: l_acctd_amount_applied_to NUMBER;

Line 96: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

92: l_rec_app_id NUMBER;
93: l_cm_ps_id NUMBER;
94: l_cm_receipt_method_id NUMBER;
95: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
96: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
97: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
98: l_acctd_amount_applied_from NUMBER;
99: l_acctd_amount_applied_to NUMBER;
100: l_msg_count NUMBER;

Line 97: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

93: l_cm_ps_id NUMBER;
94: l_cm_receipt_method_id NUMBER;
95: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
96: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
97: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
98: l_acctd_amount_applied_from NUMBER;
99: l_acctd_amount_applied_to NUMBER;
100: l_msg_count NUMBER;
101: l_msg_data VARCHAR2(2000);

Line 616: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

612: x_msg_count OUT NOCOPY NUMBER ,
613: x_msg_data OUT NOCOPY VARCHAR2 ,
614: -- *** Credit Memo Info. parameters *****
615: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
616: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
617: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
618: p_called_from IN VARCHAR2,
619: p_org_id IN NUMBER
620: ) IS

Line 617: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,

613: x_msg_data OUT NOCOPY VARCHAR2 ,
614: -- *** Credit Memo Info. parameters *****
615: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
616: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
617: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
618: p_called_from IN VARCHAR2,
619: p_org_id IN NUMBER
620: ) IS
621: l_api_name CONSTANT VARCHAR2(20) := 'Activity_unapp';

Line 638: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

634: l_org_id NUMBER;
635: l_org_return_status VARCHAR2(1);
636: l_refund_return_status VARCHAR2(1);
637: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
638: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
639:
640: BEGIN
641: /*------------------------------------+
642: | Standard start of API savepoint |

Line 745: FROM ar_receivable_applications

741:
742: /* Refunds - check for refund and cancel if refund application */
743: SELECT applied_payment_schedule_id, application_ref_id
744: INTO l_applied_ps_id, l_application_ref_id
745: FROM ar_receivable_applications
746: WHERE receivable_application_id = l_receivable_application_id;
747:
748: IF (l_applied_ps_id = -8 AND p_called_from <> 'AR_REFUNDS_GRP') THEN
749: ar_refunds_pvt.cancel_refund(