DBA Data[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on RA_CUST_TRX_TYPES

Line 595: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

591: l_gl_date DATE;
592: l_cnf_gl_date DATE;
593: l_cnf_date DATE;
594:
595: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
596: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
597: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
598:
599: l_acctd_app_amount_to

Line 596: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;

592: l_cnf_gl_date DATE;
593: l_cnf_date DATE;
594:
595: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
596: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
597: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
598:
599: l_acctd_app_amount_to
600: ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 597: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;

593: l_cnf_date DATE;
594:
595: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
596: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
597: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
598:
599: l_acctd_app_amount_to
600: ar_receivable_applications.acctd_amount_applied_to%TYPE;
601: l_acctd_app_amount_from

Line 2805: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

2801: | |
2802: +===========================================================================*/
2803:
2804: PROCEDURE get_application_flags(
2805: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2806: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2807: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2808: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2809:

Line 2806: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,

2802: +===========================================================================*/
2803:
2804: PROCEDURE get_application_flags(
2805: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2806: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2807: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2808: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2809:
2810: BEGIN

Line 2807: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,

2803:
2804: PROCEDURE get_application_flags(
2805: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2806: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2807: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2808: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2809:
2810: BEGIN
2811:

Line 2808: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS

2804: PROCEDURE get_application_flags(
2805: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2806: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2807: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2808: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2809:
2810: BEGIN
2811:
2812: SELECT allow_overapplication_flag,

Line 2818: FROM ra_cust_trx_types

2814: creation_sign
2815: INTO p_ao_flag,
2816: p_nao_flag,
2817: p_creation_sign
2818: FROM ra_cust_trx_types
2819: WHERE cust_trx_type_id = p_cust_trx_type_id;
2820:
2821: EXCEPTION
2822: WHEN NO_DATA_FOUND THEN