DBA Data[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on RA_CUST_TRX_TYPES

Line 612: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

608: l_gl_date DATE;
609: l_cnf_gl_date DATE;
610: l_cnf_date DATE;
611:
612: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
613: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
614: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
615:
616: l_acctd_app_amount_to

Line 613: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;

609: l_cnf_gl_date DATE;
610: l_cnf_date DATE;
611:
612: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
613: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
614: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
615:
616: l_acctd_app_amount_to
617: ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 614: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;

610: l_cnf_date DATE;
611:
612: l_ao_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
613: l_nao_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
614: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
615:
616: l_acctd_app_amount_to
617: ar_receivable_applications.acctd_amount_applied_to%TYPE;
618: l_acctd_app_amount_from

Line 2822: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

2818: | |
2819: +===========================================================================*/
2820:
2821: PROCEDURE get_application_flags(
2822: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2823: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2824: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2825: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2826:

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

2819: +===========================================================================*/
2820:
2821: PROCEDURE get_application_flags(
2822: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2823: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2824: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2825: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2826:
2827: BEGIN

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

2820:
2821: PROCEDURE get_application_flags(
2822: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2823: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2824: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2825: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2826:
2827: BEGIN
2828:

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

2821: PROCEDURE get_application_flags(
2822: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2823: p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
2824: p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
2825: p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE) IS
2826:
2827: BEGIN
2828:
2829: SELECT allow_overapplication_flag,

Line 2835: FROM ra_cust_trx_types

2831: creation_sign
2832: INTO p_ao_flag,
2833: p_nao_flag,
2834: p_creation_sign
2835: FROM ra_cust_trx_types
2836: WHERE cust_trx_type_id = p_cust_trx_type_id;
2837:
2838: EXCEPTION
2839: WHEN NO_DATA_FOUND THEN