APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_REPORT_FORMAT_PARAMETERS

Line 835: -- This procedure uploads a single row into pay_report_format_parameters

831: -- |------------------------------< load_rfp_row >----------------------------|
832: -- ----------------------------------------------------------------------------
833: --
834: -- Description:
835: -- This procedure uploads a single row into pay_report_format_parameters
836: -- table. If the row being uploaded already exists in the table then the
837: -- row is only updated with the new values else the row is inserted.
838: --
839: -- ----------------------------------------------------------------------------

Line 850: l_object_version_number PAY_REPORT_FORMAT_PARAMETERS.OBJECT_VERSION_NUMBER%TYPE;

846: ,p_owner in varchar2 ) IS
847: --
848: l_proc varchar2(72) := g_package||'load_rfp_row';
849: l_rec PAY_RFP_SHD.G_REC_TYPE;
850: l_object_version_number PAY_REPORT_FORMAT_PARAMETERS.OBJECT_VERSION_NUMBER%TYPE;
851: l_report_format_mapping_id PAY_REPORT_FORMAT_PARAMETERS.REPORT_FORMAT_MAPPING_ID%TYPE;
852: --
853: cursor csr_exists is
854: select object_version_number

Line 851: l_report_format_mapping_id PAY_REPORT_FORMAT_PARAMETERS.REPORT_FORMAT_MAPPING_ID%TYPE;

847: --
848: l_proc varchar2(72) := g_package||'load_rfp_row';
849: l_rec PAY_RFP_SHD.G_REC_TYPE;
850: l_object_version_number PAY_REPORT_FORMAT_PARAMETERS.OBJECT_VERSION_NUMBER%TYPE;
851: l_report_format_mapping_id PAY_REPORT_FORMAT_PARAMETERS.REPORT_FORMAT_MAPPING_ID%TYPE;
852: --
853: cursor csr_exists is
854: select object_version_number
855: from pay_report_format_parameters

Line 855: from pay_report_format_parameters

851: l_report_format_mapping_id PAY_REPORT_FORMAT_PARAMETERS.REPORT_FORMAT_MAPPING_ID%TYPE;
852: --
853: cursor csr_exists is
854: select object_version_number
855: from pay_report_format_parameters
856: where report_format_mapping_id = l_report_format_mapping_id
857: and parameter_name = p_parameter_name;
858: --
859: BEGIN