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
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;
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
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:
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
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:
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,
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