APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_FINANCIAL_NUMBERS

Line 16942: FROM hz_financial_numbers hfr

16938: ) IS
16939:
16940: CURSOR c_dup_financial_number_id (p_financial_report_id IN NUMBER) IS
16941: SELECT 'Y'
16942: FROM hz_financial_numbers hfr
16943: WHERE hfr.financial_number_id = financial_number_id;
16944:
16945: CURSOR c_unique_financial_number_rec ( p_financial_report_id IN NUMBER,
16946: p_financial_number_name IN VARCHAR2) IS

Line 16948: FROM hz_financial_numbers

16944:
16945: CURSOR c_unique_financial_number_rec ( p_financial_report_id IN NUMBER,
16946: p_financial_number_name IN VARCHAR2) IS
16947: SELECT 'Y'
16948: FROM hz_financial_numbers
16949: WHERE financial_report_id = p_financial_report_id
16950: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16951:
16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;

Line 16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;

16948: FROM hz_financial_numbers
16949: WHERE financial_report_id = p_financial_report_id
16950: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16951:
16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16953: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16954: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16955: l_status hz_financial_numbers.status%TYPE;
16956: l_created_by_module hz_financial_numbers.created_by_module%TYPE;

Line 16953: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;

16949: WHERE financial_report_id = p_financial_report_id
16950: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16951:
16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16953: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16954: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16955: l_status hz_financial_numbers.status%TYPE;
16956: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16957: l_dummy VARCHAR2(1);

Line 16954: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;

16950: AND nvl(financial_number_name, 'XXX') = nvl(p_financial_number_name, 'XXX');
16951:
16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16953: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16954: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16955: l_status hz_financial_numbers.status%TYPE;
16956: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16957: l_dummy VARCHAR2(1);
16958: l_debug_prefix VARCHAR2(30) := '';

Line 16955: l_status hz_financial_numbers.status%TYPE;

16951:
16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16953: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16954: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16955: l_status hz_financial_numbers.status%TYPE;
16956: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16957: l_dummy VARCHAR2(1);
16958: l_debug_prefix VARCHAR2(30) := '';
16959:

Line 16956: l_created_by_module hz_financial_numbers.created_by_module%TYPE;

16952: l_financial_number_id hz_financial_numbers.financial_number_id%TYPE;
16953: l_financial_number_name hz_financial_numbers.financial_number_name%TYPE;
16954: l_financial_report_id hz_financial_numbers.financial_report_id%TYPE;
16955: l_status hz_financial_numbers.status%TYPE;
16956: l_created_by_module hz_financial_numbers.created_by_module%TYPE;
16957: l_dummy VARCHAR2(1);
16958: l_debug_prefix VARCHAR2(30) := '';
16959:
16960: BEGIN

Line 16987: FROM HZ_FINANCIAL_NUMBERS

16983: l_financial_report_id,
16984: l_financial_number_name,
16985: l_status,
16986: l_created_by_module
16987: FROM HZ_FINANCIAL_NUMBERS
16988: WHERE ROWID = p_rowid;
16989: END IF;
16990:
16991: -------------------------------------