eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_REPORT_PKG dependencies on PAY_JP_REPORT_PKG

Line 1: PACKAGE BODY PAY_JP_REPORT_PKG AS

1: PACKAGE BODY PAY_JP_REPORT_PKG AS
2: /* $Header: pyjprep.pkb 120.7.12000000.2 2007/05/21 08:20:55 keyazawa noship $ */
3: g_end_of_time date := hr_general.end_of_time;
4: g_meiji_from date := to_date('1868-09-08','YYYY-MM-DD');
5: g_meiji_to date := to_date('1912-07-29','YYYY-MM-DD');

Line 903: pay_jp_report_pkg.substrb2(

899: cursor csr_prev_swot(cp_date_earned DATE, cp_itax_organization_id NUMBER) is
900: select /* Removed the hint as per Bug# 4767108 */
901: decode(p_kanji_flag,
902: '1',hoi.org_information1,hoi.org_information2) EMPLOYER_NAME,
903: pay_jp_report_pkg.substrb2(
904: decode(p_kanji_flag,
905: '1',hoi.org_information6||hoi.org_information7||hoi.org_information8,
906: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
907: peev.effective_end_date PREV_SWOT_TERM_DATE

Line 962: pay_jp_report_pkg.to_era(l_prev_swot_rec.prev_swot_term_date,

958: l_prev_add := NULL;
959: l_prev_name := NULL;
960: l_prev_term := NULL;
961:
962: pay_jp_report_pkg.to_era(l_prev_swot_rec.prev_swot_term_date,
963: l_prev_term_era_code,
964: l_prev_term_year,
965: l_prev_term_month,
966: l_prev_term_day);

Line 1040: l_description := pay_jp_report_pkg.substrb2(l_description

1036: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1037: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1038: end if;
1039: end if;
1040: l_description := pay_jp_report_pkg.substrb2(l_description
1041: || l_prev_taxable_amt || l_prev_si_prem
1042: || l_prev_mutual_aid || l_prev_itax
1043: || l_prev_add_id_for_file || l_prev_add
1044: || l_prev_name_id_for_file || l_prev_name

Line 1179: pay_jp_report_pkg.to_era(l_get_entry_values_rec.pjob_term_date,

1175: l_pjob_term_date := NULL;
1176: l_pjob_addr := NULL;
1177: l_pjob_employer_name := NULL;
1178:
1179: pay_jp_report_pkg.to_era(l_get_entry_values_rec.pjob_term_date,
1180: l_era_code,
1181: l_year,
1182: l_month,
1183: l_day);

Line 1256: l_description := pay_jp_report_pkg.substrb2(l_description

1252: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1253: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1254: end if;
1255: end if;
1256: l_description := pay_jp_report_pkg.substrb2(l_description
1257: || l_pjob_taxable_amt || l_pjob_si_prem
1258: || l_pjob_mutual_aid || l_pjob_itax
1259: || l_prev_add_id_for_file || l_pjob_addr
1260: || l_prev_name_id_for_file || l_pjob_employer_name

Line 1795: if pay_jp_report_pkg.g_legislation_code is null

1791: l_rslt_id number;
1792: --
1793: begin
1794: --
1795: if pay_jp_report_pkg.g_legislation_code is null
1796: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1797: --
1798: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);

Line 1796: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then

1792: --
1793: begin
1794: --
1795: if pay_jp_report_pkg.g_legislation_code is null
1796: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1797: --
1798: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);

Line 1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);

1795: if pay_jp_report_pkg.g_legislation_code is null
1796: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1797: --
1798: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);

Line 1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);

1796: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1797: --
1798: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);

Line 1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);

1797: --
1798: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1805: --

Line 1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);

1798: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1805: --
1806: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);

Line 1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);

1799: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1805: --
1806: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1807: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);

Line 1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);

1800: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1801: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1802: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1805: --
1806: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1807: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1808: --

Line 1807: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);

1803: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1804: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1805: --
1806: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1807: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1808: --
1809: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1810: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1811: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1810: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1806: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1807: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1808: --
1809: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1810: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1811: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1812: --
1813: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1814: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1811: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1807: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1808: --
1809: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1810: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1811: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1812: --
1813: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1814: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1815: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1814: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1810: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1811: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1812: --
1813: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1814: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1815: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1816: --
1817: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1818: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1815: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1811: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1812: --
1813: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1814: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1815: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1816: --
1817: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1818: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1819: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1818: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1814: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1815: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1816: --
1817: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1818: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1819: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1820: --
1821: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1822: --

Line 1819: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1815: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1816: --
1817: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1818: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1819: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1820: --
1821: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1822: --
1823: end if;

Line 1821: pay_jp_report_pkg.g_legislation_code := c_legislation_code;

1817: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1818: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1819: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1820: --
1821: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1822: --
1823: end if;
1824: --
1825: if p_rec_name = 'hi_org_iv_id' then

Line 1826: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then

1822: --
1823: end if;
1824: --
1825: if p_rec_name = 'hi_org_iv_id' then
1826: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then
1827: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1828: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1829: end if;
1830: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;

Line 1828: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);

1824: --
1825: if p_rec_name = 'hi_org_iv_id' then
1826: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then
1827: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1828: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1829: end if;
1830: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1831: elsif p_rec_name = 'wp_org_iv_id' then
1832: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then

Line 1830: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;

1826: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then
1827: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1828: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1829: end if;
1830: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1831: elsif p_rec_name = 'wp_org_iv_id' then
1832: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1833: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1834: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);

Line 1832: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then

1828: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1829: end if;
1830: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1831: elsif p_rec_name = 'wp_org_iv_id' then
1832: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1833: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1834: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1835: end if;
1836: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;

Line 1834: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);

1830: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1831: elsif p_rec_name = 'wp_org_iv_id' then
1832: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1833: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1834: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1835: end if;
1836: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1837: elsif p_rec_name = 'wpf_org_iv_id' then
1838: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then

Line 1836: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;

1832: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1833: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1834: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1835: end if;
1836: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1837: elsif p_rec_name = 'wpf_org_iv_id' then
1838: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1839: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1840: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);

Line 1838: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then

1834: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1835: end if;
1836: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1837: elsif p_rec_name = 'wpf_org_iv_id' then
1838: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1839: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1840: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1841: end if;
1842: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;

Line 1840: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);

1836: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1837: elsif p_rec_name = 'wpf_org_iv_id' then
1838: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1839: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1840: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1841: end if;
1842: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1843: elsif p_rec_name = 'hi_num_iv_id' then
1844: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then

Line 1842: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;

1838: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1839: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1840: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1841: end if;
1842: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1843: elsif p_rec_name = 'hi_num_iv_id' then
1844: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1845: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1846: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);

Line 1844: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then

1840: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1841: end if;
1842: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1843: elsif p_rec_name = 'hi_num_iv_id' then
1844: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1845: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1846: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1847: end if;
1848: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;

Line 1846: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);

1842: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1843: elsif p_rec_name = 'hi_num_iv_id' then
1844: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1845: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1846: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1847: end if;
1848: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1849: elsif p_rec_name = 'wp_num_iv_id' then
1850: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then

Line 1848: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;

1844: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1845: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1846: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1847: end if;
1848: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1849: elsif p_rec_name = 'wp_num_iv_id' then
1850: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1851: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1852: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);

Line 1850: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then

1846: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1847: end if;
1848: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1849: elsif p_rec_name = 'wp_num_iv_id' then
1850: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1851: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1852: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1853: end if;
1854: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;

Line 1852: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);

1848: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1849: elsif p_rec_name = 'wp_num_iv_id' then
1850: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1851: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1852: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1853: end if;
1854: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1855: elsif p_rec_name = 'bp_num_iv_id' then
1856: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then

Line 1854: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;

1850: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1851: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1852: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1853: end if;
1854: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1855: elsif p_rec_name = 'bp_num_iv_id' then
1856: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1857: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1858: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);

Line 1856: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then

1852: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1853: end if;
1854: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1855: elsif p_rec_name = 'bp_num_iv_id' then
1856: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1857: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1858: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1859: end if;
1860: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;

Line 1858: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);

1854: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1855: elsif p_rec_name = 'bp_num_iv_id' then
1856: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1857: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1858: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1859: end if;
1860: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1861: elsif p_rec_name = 'exc_iv_id' then
1862: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then

Line 1860: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;

1856: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1857: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1858: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1859: end if;
1860: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1861: elsif p_rec_name = 'exc_iv_id' then
1862: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1863: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1864: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);

Line 1862: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then

1858: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1859: end if;
1860: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1861: elsif p_rec_name = 'exc_iv_id' then
1862: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1863: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1864: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1865: end if;
1866: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;

Line 1864: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);

1860: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1861: elsif p_rec_name = 'exc_iv_id' then
1862: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1863: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1864: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1865: end if;
1866: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1867: elsif p_rec_name = 'hi_qd_iv_id' then
1868: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then

Line 1866: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;

1862: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1863: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1864: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1865: end if;
1866: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1867: elsif p_rec_name = 'hi_qd_iv_id' then
1868: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1869: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1870: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1868: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then

1864: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1865: end if;
1866: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1867: elsif p_rec_name = 'hi_qd_iv_id' then
1868: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1869: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1870: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1871: end if;
1872: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;

Line 1870: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1866: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1867: elsif p_rec_name = 'hi_qd_iv_id' then
1868: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1869: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1870: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1871: end if;
1872: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1873: elsif p_rec_name = 'wp_qd_iv_id' then
1874: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then

Line 1872: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;

1868: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1869: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1870: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1871: end if;
1872: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1873: elsif p_rec_name = 'wp_qd_iv_id' then
1874: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1875: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1876: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1874: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then

1870: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1871: end if;
1872: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1873: elsif p_rec_name = 'wp_qd_iv_id' then
1874: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1875: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1876: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1877: end if;
1878: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;

Line 1876: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1872: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1873: elsif p_rec_name = 'wp_qd_iv_id' then
1874: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1875: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1876: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1877: end if;
1878: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1879: elsif p_rec_name = 'wpf_qd_iv_id' then
1880: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then

Line 1878: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;

1874: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1875: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1876: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1877: end if;
1878: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1879: elsif p_rec_name = 'wpf_qd_iv_id' then
1880: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1881: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1882: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1880: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then

1876: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1877: end if;
1878: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1879: elsif p_rec_name = 'wpf_qd_iv_id' then
1880: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1881: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1882: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1883: end if;
1884: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;

Line 1882: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1878: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1879: elsif p_rec_name = 'wpf_qd_iv_id' then
1880: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1881: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1882: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1883: end if;
1884: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1885: elsif p_rec_name = 'hi_dqd_iv_id' then
1886: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then

Line 1884: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;

1880: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1881: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1882: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1883: end if;
1884: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1885: elsif p_rec_name = 'hi_dqd_iv_id' then
1886: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1887: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1888: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1886: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then

1882: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1883: end if;
1884: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1885: elsif p_rec_name = 'hi_dqd_iv_id' then
1886: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1887: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1888: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1889: end if;
1890: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;

Line 1888: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1884: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1885: elsif p_rec_name = 'hi_dqd_iv_id' then
1886: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1887: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1888: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1889: end if;
1890: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1891: elsif p_rec_name = 'wp_dqd_iv_id' then
1892: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then

Line 1890: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;

1886: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1887: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1888: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1889: end if;
1890: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1891: elsif p_rec_name = 'wp_dqd_iv_id' then
1892: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1893: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1894: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1892: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then

1888: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1889: end if;
1890: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1891: elsif p_rec_name = 'wp_dqd_iv_id' then
1892: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1893: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1894: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1895: end if;
1896: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;

Line 1894: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1890: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1891: elsif p_rec_name = 'wp_dqd_iv_id' then
1892: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1893: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1894: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1895: end if;
1896: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1897: elsif p_rec_name = 'wpf_dqd_iv_id' then
1898: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then

Line 1896: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;

1892: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1893: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1894: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1895: end if;
1896: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1897: elsif p_rec_name = 'wpf_dqd_iv_id' then
1898: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1899: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1900: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1898: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then

1894: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1895: end if;
1896: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1897: elsif p_rec_name = 'wpf_dqd_iv_id' then
1898: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1899: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1900: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1901: end if;
1902: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;

Line 1900: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1896: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1897: elsif p_rec_name = 'wpf_dqd_iv_id' then
1898: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1899: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1900: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1901: end if;
1902: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;
1903: end if;
1904: --

Line 1902: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;

1898: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1899: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1900: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1901: end if;
1902: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;
1903: end if;
1904: --
1905: return l_rslt_id;
1906: end get_si_rec_id;

Line 1925: if pay_jp_report_pkg.g_legislation_code is null

1921: and pes.element_set_name = l_ele_set;
1922: --
1923: begin
1924: --
1925: if pay_jp_report_pkg.g_legislation_code is null
1926: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1927: --
1928: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1929: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

Line 1926: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then

1922: --
1923: begin
1924: --
1925: if pay_jp_report_pkg.g_legislation_code is null
1926: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1927: --
1928: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1929: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1930: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

Line 1929: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

1925: if pay_jp_report_pkg.g_legislation_code is null
1926: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1927: --
1928: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1929: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1930: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1931: --
1932: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1933: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

Line 1930: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

1926: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1927: --
1928: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1929: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1930: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1931: --
1932: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1933: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1934: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

Line 1933: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

1929: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1930: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1931: --
1932: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1933: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1934: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1935: --
1936: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);

Line 1934: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

1930: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1931: --
1932: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1933: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1934: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1935: --
1936: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);

Line 1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);

1933: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1934: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1935: --
1936: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);

Line 1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);

1934: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1935: --
1936: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);

Line 1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);

1935: --
1936: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1943: --

Line 1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);

1936: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1943: --
1944: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);

Line 1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);

1937: pay_jp_report_pkg.g_si_rec.hi_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_org_iv);
1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1943: --
1944: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1945: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);

Line 1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);

1938: pay_jp_report_pkg.g_si_rec.wp_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_org_iv);
1939: pay_jp_report_pkg.g_si_rec.wpf_org_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wpf_org_iv);
1940: pay_jp_report_pkg.g_si_rec.hi_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_hi_num_iv);
1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1943: --
1944: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1945: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1946: --

Line 1945: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);

1941: pay_jp_report_pkg.g_si_rec.wp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_wp_num_iv);
1942: pay_jp_report_pkg.g_si_rec.bp_num_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_bp_num_iv);
1943: --
1944: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1945: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1946: --
1947: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1948: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1949: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1948: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1944: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1945: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1946: --
1947: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1948: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1949: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1950: --
1951: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1952: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1949: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1945: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1946: --
1947: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1948: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1949: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1950: --
1951: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1952: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1953: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1952: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1948: pay_jp_report_pkg.g_si_rec.hi_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1949: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1950: --
1951: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1952: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1953: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1954: --
1955: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1956: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

Line 1953: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1949: pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1950: --
1951: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1952: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1953: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1954: --
1955: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1956: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1957: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

Line 1956: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);

1952: pay_jp_report_pkg.g_si_rec.wp_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1953: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1954: --
1955: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1956: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1957: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1958: --
1959: l_ele_set := c_san_ele_set;
1960: open csr_ele_set;

Line 1957: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);

1953: pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1954: --
1955: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1956: pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_qd_iv);
1957: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1958: --
1959: l_ele_set := c_san_ele_set;
1960: open csr_ele_set;
1961: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

Line 1961: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

1957: pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_dqd_iv);
1958: --
1959: l_ele_set := c_san_ele_set;
1960: open csr_ele_set;
1961: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
1962: close csr_ele_set;
1963: --
1964: l_ele_set := c_gep_ele_set;
1965: open csr_ele_set;

Line 1966: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;

1962: close csr_ele_set;
1963: --
1964: l_ele_set := c_gep_ele_set;
1965: open csr_ele_set;
1966: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
1967: close csr_ele_set;
1968: --
1969: l_ele_set := c_iku_ele_set;
1970: open csr_ele_set;

Line 1971: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;

1967: close csr_ele_set;
1968: --
1969: l_ele_set := c_iku_ele_set;
1970: open csr_ele_set;
1971: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
1972: close csr_ele_set;
1973: --
1974: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1975: --

Line 1974: pay_jp_report_pkg.g_legislation_code := c_legislation_code;

1970: open csr_ele_set;
1971: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
1972: close csr_ele_set;
1973: --
1974: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1975: --
1976: end if;
1977: --
1978: if p_rec_name = 'hi_appl_mth_iv_id' then

Line 1979: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then

1975: --
1976: end if;
1977: --
1978: if p_rec_name = 'hi_appl_mth_iv_id' then
1979: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then
1980: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1981: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1982: end if;
1983: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;

Line 1981: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

1977: --
1978: if p_rec_name = 'hi_appl_mth_iv_id' then
1979: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then
1980: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1981: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1982: end if;
1983: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1984: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1985: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then

Line 1983: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;

1979: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then
1980: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1981: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1982: end if;
1983: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1984: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1985: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1986: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1987: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

Line 1985: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then

1981: pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1982: end if;
1983: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1984: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1985: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1986: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1987: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1988: end if;
1989: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;

Line 1987: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);

1983: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1984: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1985: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1986: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1987: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1988: end if;
1989: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1990: elsif p_rec_name = 'hi_appl_cat_iv_id' then
1991: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then

Line 1989: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;

1985: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1986: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1987: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1988: end if;
1989: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1990: elsif p_rec_name = 'hi_appl_cat_iv_id' then
1991: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
1992: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1993: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

Line 1991: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then

1987: pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_mth_iv);
1988: end if;
1989: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1990: elsif p_rec_name = 'hi_appl_cat_iv_id' then
1991: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
1992: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1993: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1994: end if;
1995: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;

Line 1993: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

1989: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1990: elsif p_rec_name = 'hi_appl_cat_iv_id' then
1991: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
1992: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1993: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1994: end if;
1995: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
1996: elsif p_rec_name = 'wp_appl_cat_iv_id' then
1997: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then

Line 1995: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;

1991: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
1992: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1993: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1994: end if;
1995: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
1996: elsif p_rec_name = 'wp_appl_cat_iv_id' then
1997: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
1998: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1999: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

Line 1997: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then

1993: pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
1994: end if;
1995: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
1996: elsif p_rec_name = 'wp_appl_cat_iv_id' then
1997: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
1998: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1999: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
2000: end if;
2001: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;

Line 1999: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);

1995: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
1996: elsif p_rec_name = 'wp_appl_cat_iv_id' then
1997: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
1998: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1999: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
2000: end if;
2001: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2002: elsif p_rec_name = 'san_ele_set_id' then
2003: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then

Line 2001: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;

1997: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
1998: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1999: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
2000: end if;
2001: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2002: elsif p_rec_name = 'san_ele_set_id' then
2003: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then
2004: open csr_ele_set;
2005: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

Line 2003: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then

1999: pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_appl_cat_iv);
2000: end if;
2001: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2002: elsif p_rec_name = 'san_ele_set_id' then
2003: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then
2004: open csr_ele_set;
2005: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2006: close csr_ele_set;
2007: end if;

Line 2005: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

2001: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2002: elsif p_rec_name = 'san_ele_set_id' then
2003: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then
2004: open csr_ele_set;
2005: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2006: close csr_ele_set;
2007: end if;
2008: l_rslt_id := pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2009: elsif p_rec_name = 'gep_ele_set_id' then

Line 2008: l_rslt_id := pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

2004: open csr_ele_set;
2005: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2006: close csr_ele_set;
2007: end if;
2008: l_rslt_id := pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2009: elsif p_rec_name = 'gep_ele_set_id' then
2010: if pay_jp_report_pkg.g_gs_rec.gep_ele_set_id is null then
2011: open csr_ele_set;
2012: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;

Line 2010: if pay_jp_report_pkg.g_gs_rec.gep_ele_set_id is null then

2006: close csr_ele_set;
2007: end if;
2008: l_rslt_id := pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2009: elsif p_rec_name = 'gep_ele_set_id' then
2010: if pay_jp_report_pkg.g_gs_rec.gep_ele_set_id is null then
2011: open csr_ele_set;
2012: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2013: close csr_ele_set;
2014: end if;

Line 2012: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;

2008: l_rslt_id := pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2009: elsif p_rec_name = 'gep_ele_set_id' then
2010: if pay_jp_report_pkg.g_gs_rec.gep_ele_set_id is null then
2011: open csr_ele_set;
2012: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2013: close csr_ele_set;
2014: end if;
2015: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2016: elsif p_rec_name = 'iku_ele_set_id' then

Line 2015: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;

2011: open csr_ele_set;
2012: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2013: close csr_ele_set;
2014: end if;
2015: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2016: elsif p_rec_name = 'iku_ele_set_id' then
2017: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then
2018: open csr_ele_set;
2019: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;

Line 2017: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then

2013: close csr_ele_set;
2014: end if;
2015: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2016: elsif p_rec_name = 'iku_ele_set_id' then
2017: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then
2018: open csr_ele_set;
2019: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2020: close csr_ele_set;
2021: end if;

Line 2019: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;

2015: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2016: elsif p_rec_name = 'iku_ele_set_id' then
2017: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then
2018: open csr_ele_set;
2019: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2020: close csr_ele_set;
2021: end if;
2022: l_rslt_id := pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2023: end if;

Line 2022: l_rslt_id := pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;

2018: open csr_ele_set;
2019: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2020: close csr_ele_set;
2021: end if;
2022: l_rslt_id := pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2023: end if;
2024: --
2025: return l_rslt_id;
2026: end get_gs_rec_id;

Line 2293: END PAY_JP_REPORT_PKG;

2289: --
2290: return l_user_elm_name;
2291: end get_user_elm_name;
2292: --
2293: END PAY_JP_REPORT_PKG;