DBA Data[Home] [Help]

APPS.AR_CM_APPLICATION_PUB dependencies on RA_CUSTOMER_TRX

Line 42: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

38: x_return_status OUT NOCOPY VARCHAR2,
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,

Line 673: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

669: x_return_status OUT NOCOPY VARCHAR2 ,
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

Line 1006: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

1002: x_return_status OUT NOCOPY VARCHAR2 ,
1003: x_msg_count OUT NOCOPY NUMBER ,
1004: x_msg_data OUT NOCOPY VARCHAR2 ,
1005: -- *** Credit Memo Info. parameters *****
1006: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1007: p_cm_trx_number IN ra_customer_trx.trx_number%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,

Line 1007: p_cm_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

1003: x_msg_count OUT NOCOPY NUMBER ,
1004: x_msg_data OUT NOCOPY VARCHAR2 ,
1005: -- *** Credit Memo Info. parameters *****
1006: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1007: p_cm_trx_number IN ra_customer_trx.trx_number%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,

Line 1008: p_app_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

1004: x_msg_data OUT NOCOPY VARCHAR2 ,
1005: -- *** Credit Memo Info. parameters *****
1006: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1007: p_cm_trx_number IN ra_customer_trx.trx_number%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,

Line 1009: p_app_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,

1005: -- *** Credit Memo Info. parameters *****
1006: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1007: p_cm_trx_number IN ra_customer_trx.trx_number%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,

Line 1022: l_cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_cm_customer_trx_id;

1018:
1019: l_api_name CONSTANT VARCHAR2(20) := 'unapply_regular_cm';
1020: l_api_version CONSTANT NUMBER := 1.0;
1021:
1022: l_cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_cm_customer_trx_id;
1023: l_cm_trx_number ra_customer_trx.trx_number%TYPE := p_cm_trx_number;
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;

Line 1023: l_cm_trx_number ra_customer_trx.trx_number%TYPE := p_cm_trx_number;

1019: l_api_name CONSTANT VARCHAR2(20) := 'unapply_regular_cm';
1020: l_api_version CONSTANT NUMBER := 1.0;
1021:
1022: l_cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_cm_customer_trx_id;
1023: l_cm_trx_number ra_customer_trx.trx_number%TYPE := p_cm_trx_number;
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;

Line 1024: l_inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_app_customer_trx_id;

1020: l_api_version CONSTANT NUMBER := 1.0;
1021:
1022: l_cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_cm_customer_trx_id;
1023: l_cm_trx_number ra_customer_trx.trx_number%TYPE := p_cm_trx_number;
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;

Line 1025: l_inv_trx_number ra_customer_trx.trx_number%TYPE := p_app_trx_number;

1021:
1022: l_cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE := p_cm_customer_trx_id;
1023: l_cm_trx_number ra_customer_trx.trx_number%TYPE := p_cm_trx_number;
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);