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 97: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

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

Line 98: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

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

Line 99: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

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

Line 674: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,

670: x_msg_count OUT NOCOPY NUMBER ,
671: x_msg_data OUT NOCOPY VARCHAR2 ,
672: -- *** Credit Memo Info. parameters *****
673: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
674: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
675: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
676: p_called_from IN VARCHAR2,
677: p_org_id IN NUMBER
678: ) IS

Line 675: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,

671: x_msg_data OUT NOCOPY VARCHAR2 ,
672: -- *** Credit Memo Info. parameters *****
673: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
674: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
675: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
676: p_called_from IN VARCHAR2,
677: p_org_id IN NUMBER
678: ) IS
679: l_api_name CONSTANT VARCHAR2(20) := 'Activity_unapp';

Line 696: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

692: l_org_id NUMBER;
693: l_org_return_status VARCHAR2(1);
694: l_refund_return_status VARCHAR2(1);
695: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
696: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
697:
698: BEGIN
699: /*------------------------------------+
700: | Standard start of API savepoint |

Line 803: FROM ar_receivable_applications

799:
800: /* Refunds - check for refund and cancel if refund application */
801: SELECT applied_payment_schedule_id, application_ref_id
802: INTO l_applied_ps_id, l_application_ref_id
803: FROM ar_receivable_applications
804: WHERE receivable_application_id = l_receivable_application_id;
805:
806: IF (l_applied_ps_id = -8 AND p_called_from <> 'AR_REFUNDS_GRP') THEN
807: ar_refunds_pvt.cancel_refund(

Line 1012: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

1008: p_app_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1009: p_app_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1010: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1011: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1012: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
1013: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
1014: p_called_from IN VARCHAR2 DEFAULT NULL,
1015: p_org_id IN NUMBER DEFAULT NULL
1016: )

Line 1013: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,

1009: p_app_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1010: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1011: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1012: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
1013: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
1014: p_called_from IN VARCHAR2 DEFAULT NULL,
1015: p_org_id IN NUMBER DEFAULT NULL
1016: )
1017: IS

Line 1028: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE := p_receivable_application_id;

1024: l_inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_app_customer_trx_id;
1025: l_inv_trx_number ra_customer_trx.trx_number%TYPE := p_app_trx_number;
1026: l_installment ar_payment_schedules.terms_sequence_number%TYPE := p_installment;
1027: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE := p_applied_payment_schedule_id;
1028: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE := p_receivable_application_id;
1029: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE := trunc(p_reversal_gl_date);
1030: l_apply_gl_date DATE;
1031: l_cm_gl_date DATE;
1032:

Line 1029: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE := trunc(p_reversal_gl_date);

1025: l_inv_trx_number ra_customer_trx.trx_number%TYPE := p_app_trx_number;
1026: l_installment ar_payment_schedules.terms_sequence_number%TYPE := p_installment;
1027: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE := p_applied_payment_schedule_id;
1028: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE := p_receivable_application_id;
1029: l_reversal_gl_date ar_receivable_applications.reversal_gl_date%TYPE := trunc(p_reversal_gl_date);
1030: l_apply_gl_date DATE;
1031: l_cm_gl_date DATE;
1032:
1033: l_def_ids_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;