APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_FINANCIAL_NUMBERS

Line 16922: FROM hz_financial_numbers hfr

16918: ) IS
16919:
16920: CURSOR c_dup_financial_number_id (p_financial_report_id IN NUMBER) IS
16921: SELECT 'Y'
16922: FROM hz_financial_numbers hfr
16923: WHERE hfr.financial_number_id = financial_number_id;
16924:
16925: CURSOR c_unique_financial_number_rec ( p_financial_report_id IN NUMBER,
16926: p_financial_number_name IN VARCHAR2) IS

Line 16928: FROM hz_financial_numbers

16924:
16925: CURSOR c_unique_financial_number_rec ( p_financial_report_id IN NUMBER,
16926: p_financial_number_name IN VARCHAR2) IS
16927: SELECT 'Y'
16928: FROM hz_financial_numbers
16929: WHERE financial_report_id = p_financial_report_id
16930: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16931:
16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;

Line 16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;

16928: FROM hz_financial_numbers
16929: WHERE financial_report_id = p_financial_report_id
16930: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16931:
16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16933: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16934: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16935: l_status hz_financial_numbers.status%TYPE;
16936: l_created_by_module hz_financial_numbers.created_by_module%TYPE;

Line 16933: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;

16929: WHERE financial_report_id = p_financial_report_id
16930: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16931:
16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16933: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16934: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16935: l_status hz_financial_numbers.status%TYPE;
16936: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16937: l_dummy VARCHAR2(1);

Line 16934: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;

16930: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16931:
16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16933: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16934: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16935: l_status hz_financial_numbers.status%TYPE;
16936: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16937: l_dummy VARCHAR2(1);
16938: l_debug_prefix VARCHAR2(30) := '';

Line 16935: l_status hz_financial_numbers.status%TYPE;

16931:
16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16933: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16934: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16935: l_status hz_financial_numbers.status%TYPE;
16936: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16937: l_dummy VARCHAR2(1);
16938: l_debug_prefix VARCHAR2(30) := '';
16939:

Line 16936: l_created_by_module hz_financial_numbers.created_by_module%TYPE;

16932: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16933: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16934: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16935: l_status hz_financial_numbers.status%TYPE;
16936: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16937: l_dummy VARCHAR2(1);
16938: l_debug_prefix VARCHAR2(30) := '';
16939:
16940: BEGIN

Line 16967: FROM HZ_FINANCIAL_NUMBERS

16963: l_financial_report_id,
16964: l_financial_number_name,
16965: l_status,
16966: l_created_by_module
16967: FROM HZ_FINANCIAL_NUMBERS
16968: WHERE ROWID = p_rowid;
16969: END IF;
16970:
16971: -------------------------------------