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.17 2011/07/29 08:33:53 keyazawa ship $ */
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 912: pay_jp_report_pkg.substrb2(

908: cursor csr_prev_swot(cp_date_earned DATE, cp_itax_organization_id NUMBER) is
909: select /* Removed the hint as per Bug# 4767108 */
910: decode(p_kanji_flag,
911: '1',hoi.org_information1,hoi.org_information2) EMPLOYER_NAME,
912: pay_jp_report_pkg.substrb2(
913: decode(p_kanji_flag,
914: '1',hoi.org_information6||hoi.org_information7||hoi.org_information8,
915: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
916: peev.effective_end_date PREV_SWOT_TERM_DATE

Line 971: pay_jp_report_pkg.to_era(l_prev_swot_rec.prev_swot_term_date,

967: l_prev_add := NULL;
968: l_prev_name := NULL;
969: l_prev_term := NULL;
970:
971: pay_jp_report_pkg.to_era(l_prev_swot_rec.prev_swot_term_date,
972: l_prev_term_era_code,
973: l_prev_term_year,
974: l_prev_term_month,
975: l_prev_term_day);

Line 1049: l_description := pay_jp_report_pkg.substrb2(l_description

1045: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1046: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1047: end if;
1048: end if;
1049: l_description := pay_jp_report_pkg.substrb2(l_description
1050: || l_prev_taxable_amt || l_prev_si_prem
1051: || l_prev_mutual_aid || l_prev_itax
1052: || l_prev_add_id_for_file || l_prev_add
1053: || l_prev_name_id_for_file || l_prev_name

Line 1188: pay_jp_report_pkg.to_era(l_get_entry_values_rec.pjob_term_date,

1184: l_pjob_term_date := NULL;
1185: l_pjob_addr := NULL;
1186: l_pjob_employer_name := NULL;
1187:
1188: pay_jp_report_pkg.to_era(l_get_entry_values_rec.pjob_term_date,
1189: l_era_code,
1190: l_year,
1191: l_month,
1192: l_day);

Line 1265: l_description := pay_jp_report_pkg.substrb2(l_description

1261: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1262: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1263: end if;
1264: end if;
1265: l_description := pay_jp_report_pkg.substrb2(l_description
1266: || l_pjob_taxable_amt || l_pjob_si_prem
1267: || l_pjob_mutual_aid || l_pjob_itax
1268: || l_prev_add_id_for_file || l_pjob_addr
1269: || l_prev_name_id_for_file || l_pjob_employer_name

Line 1804: if pay_jp_report_pkg.g_legislation_code is null

1800: l_rslt_id number;
1801: --
1802: begin
1803: --
1804: if pay_jp_report_pkg.g_legislation_code is null
1805: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1806: --
1807: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1808: 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 1805: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then

1801: --
1802: begin
1803: --
1804: if pay_jp_report_pkg.g_legislation_code is null
1805: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1806: --
1807: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1808: 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);
1809: 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 1808: 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);

1804: if pay_jp_report_pkg.g_legislation_code is null
1805: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1806: --
1807: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1808: 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);
1809: 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);
1810: 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);
1811: 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);
1812: 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 1809: 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);

1805: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1806: --
1807: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1808: 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);
1809: 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);
1810: 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);
1811: 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);
1812: 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);
1813: 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 1810: 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);

1806: --
1807: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1808: 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);
1809: 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);
1810: 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);
1811: 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);
1812: 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);
1813: 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);
1814: --

Line 1811: 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);

1807: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1808: 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);
1809: 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);
1810: 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);
1811: 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);
1812: 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);
1813: 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);
1814: --
1815: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);

Line 1812: 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);

1808: 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);
1809: 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);
1810: 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);
1811: 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);
1812: 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);
1813: 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);
1814: --
1815: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1816: 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 1813: 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);

1809: 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);
1810: 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);
1811: 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);
1812: 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);
1813: 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);
1814: --
1815: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1816: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1817: --

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

1812: 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);
1813: 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);
1814: --
1815: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1816: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1817: --
1818: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1819: 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);
1820: 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 1819: 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);

1815: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1816: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1817: --
1818: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1819: 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);
1820: 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);
1821: --
1822: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1823: 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 1820: 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);

1816: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1817: --
1818: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1819: 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);
1820: 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);
1821: --
1822: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1823: 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);
1824: 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 1823: 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);

1819: 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);
1820: 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);
1821: --
1822: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1823: 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);
1824: 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);
1825: --
1826: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1827: 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 1824: 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);

1820: 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);
1821: --
1822: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1823: 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);
1824: 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);
1825: --
1826: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1827: 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);
1828: 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 1827: 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);

1823: 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);
1824: 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);
1825: --
1826: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1827: 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);
1828: 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);
1829: --
1830: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1831: --

Line 1828: 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);

1824: 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);
1825: --
1826: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1827: 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);
1828: 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);
1829: --
1830: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1831: --
1832: end if;

Line 1830: pay_jp_report_pkg.g_legislation_code := c_legislation_code;

1826: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1827: 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);
1828: 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);
1829: --
1830: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1831: --
1832: end if;
1833: --
1834: if p_rec_name = 'hi_org_iv_id' then

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

1831: --
1832: end if;
1833: --
1834: if p_rec_name = 'hi_org_iv_id' then
1835: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then
1836: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1837: 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);
1838: end if;
1839: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;

Line 1837: 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);

1833: --
1834: if p_rec_name = 'hi_org_iv_id' then
1835: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then
1836: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1837: 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);
1838: end if;
1839: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1840: elsif p_rec_name = 'wp_org_iv_id' then
1841: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then

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

1835: if pay_jp_report_pkg.g_si_rec.hi_org_iv_id is null then
1836: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1837: 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);
1838: end if;
1839: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1840: elsif p_rec_name = 'wp_org_iv_id' then
1841: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1842: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1843: 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 1841: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then

1837: 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);
1838: end if;
1839: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1840: elsif p_rec_name = 'wp_org_iv_id' then
1841: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1842: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1843: 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);
1844: end if;
1845: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;

Line 1843: 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);

1839: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_org_iv_id;
1840: elsif p_rec_name = 'wp_org_iv_id' then
1841: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1842: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1843: 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);
1844: end if;
1845: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1846: elsif p_rec_name = 'wpf_org_iv_id' then
1847: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then

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

1841: if pay_jp_report_pkg.g_si_rec.wp_org_iv_id is null then
1842: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1843: 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);
1844: end if;
1845: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1846: elsif p_rec_name = 'wpf_org_iv_id' then
1847: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1848: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1849: 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 1847: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then

1843: 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);
1844: end if;
1845: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1846: elsif p_rec_name = 'wpf_org_iv_id' then
1847: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1848: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1849: 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);
1850: end if;
1851: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;

Line 1849: 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);

1845: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_org_iv_id;
1846: elsif p_rec_name = 'wpf_org_iv_id' then
1847: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1848: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1849: 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);
1850: end if;
1851: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1852: elsif p_rec_name = 'hi_num_iv_id' then
1853: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then

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

1847: if pay_jp_report_pkg.g_si_rec.wpf_org_iv_id is null then
1848: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1849: 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);
1850: end if;
1851: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1852: elsif p_rec_name = 'hi_num_iv_id' then
1853: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1854: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1855: 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 1853: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then

1849: 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);
1850: end if;
1851: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1852: elsif p_rec_name = 'hi_num_iv_id' then
1853: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1854: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1855: 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);
1856: end if;
1857: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;

Line 1855: 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);

1851: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_org_iv_id;
1852: elsif p_rec_name = 'hi_num_iv_id' then
1853: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1854: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1855: 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);
1856: end if;
1857: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1858: elsif p_rec_name = 'wp_num_iv_id' then
1859: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then

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

1853: if pay_jp_report_pkg.g_si_rec.hi_num_iv_id is null then
1854: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1855: 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);
1856: end if;
1857: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1858: elsif p_rec_name = 'wp_num_iv_id' then
1859: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1860: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1861: 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 1859: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then

1855: 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);
1856: end if;
1857: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1858: elsif p_rec_name = 'wp_num_iv_id' then
1859: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1860: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1861: 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);
1862: end if;
1863: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;

Line 1861: 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);

1857: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_num_iv_id;
1858: elsif p_rec_name = 'wp_num_iv_id' then
1859: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1860: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1861: 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);
1862: end if;
1863: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1864: elsif p_rec_name = 'bp_num_iv_id' then
1865: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then

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

1859: if pay_jp_report_pkg.g_si_rec.wp_num_iv_id is null then
1860: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1861: 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);
1862: end if;
1863: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1864: elsif p_rec_name = 'bp_num_iv_id' then
1865: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1866: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1867: 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 1865: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then

1861: 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);
1862: end if;
1863: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1864: elsif p_rec_name = 'bp_num_iv_id' then
1865: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1866: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1867: 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);
1868: end if;
1869: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;

Line 1867: 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);

1863: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_num_iv_id;
1864: elsif p_rec_name = 'bp_num_iv_id' then
1865: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1866: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1867: 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);
1868: end if;
1869: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1870: elsif p_rec_name = 'exc_iv_id' then
1871: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then

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

1865: if pay_jp_report_pkg.g_si_rec.bp_num_iv_id is null then
1866: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1867: 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);
1868: end if;
1869: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1870: elsif p_rec_name = 'exc_iv_id' then
1871: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1872: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1873: 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 1871: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then

1867: 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);
1868: end if;
1869: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1870: elsif p_rec_name = 'exc_iv_id' then
1871: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1872: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1873: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1874: end if;
1875: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;

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

1869: l_rslt_id := pay_jp_report_pkg.g_si_rec.bp_num_iv_id;
1870: elsif p_rec_name = 'exc_iv_id' then
1871: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1872: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1873: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1874: end if;
1875: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1876: elsif p_rec_name = 'hi_qd_iv_id' then
1877: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then

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

1871: if pay_jp_report_pkg.g_si_rec.exc_iv_id is null then
1872: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1873: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1874: end if;
1875: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1876: elsif p_rec_name = 'hi_qd_iv_id' then
1877: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1878: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1879: 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 1877: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then

1873: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1874: end if;
1875: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1876: elsif p_rec_name = 'hi_qd_iv_id' then
1877: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1878: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1879: 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);
1880: end if;
1881: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;

Line 1879: 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);

1875: l_rslt_id := pay_jp_report_pkg.g_si_rec.exc_iv_id;
1876: elsif p_rec_name = 'hi_qd_iv_id' then
1877: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1878: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1879: 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);
1880: end if;
1881: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1882: elsif p_rec_name = 'wp_qd_iv_id' then
1883: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then

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

1877: if pay_jp_report_pkg.g_si_rec.hi_qd_iv_id is null then
1878: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1879: 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);
1880: end if;
1881: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1882: elsif p_rec_name = 'wp_qd_iv_id' then
1883: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1884: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1885: 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 1883: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then

1879: 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);
1880: end if;
1881: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1882: elsif p_rec_name = 'wp_qd_iv_id' then
1883: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1884: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1885: 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);
1886: end if;
1887: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;

Line 1885: 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);

1881: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_qd_iv_id;
1882: elsif p_rec_name = 'wp_qd_iv_id' then
1883: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1884: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1885: 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);
1886: end if;
1887: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1888: elsif p_rec_name = 'wpf_qd_iv_id' then
1889: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then

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

1883: if pay_jp_report_pkg.g_si_rec.wp_qd_iv_id is null then
1884: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1885: 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);
1886: end if;
1887: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1888: elsif p_rec_name = 'wpf_qd_iv_id' then
1889: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1890: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1891: 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 1889: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then

1885: 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);
1886: end if;
1887: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1888: elsif p_rec_name = 'wpf_qd_iv_id' then
1889: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1890: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1891: 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);
1892: end if;
1893: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;

Line 1891: 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);

1887: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_qd_iv_id;
1888: elsif p_rec_name = 'wpf_qd_iv_id' then
1889: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1890: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1891: 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);
1892: end if;
1893: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1894: elsif p_rec_name = 'hi_dqd_iv_id' then
1895: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then

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

1889: if pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id is null then
1890: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1891: 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);
1892: end if;
1893: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1894: elsif p_rec_name = 'hi_dqd_iv_id' then
1895: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1896: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1897: 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 1895: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then

1891: 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);
1892: end if;
1893: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1894: elsif p_rec_name = 'hi_dqd_iv_id' then
1895: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1896: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1897: 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);
1898: end if;
1899: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;

Line 1897: 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);

1893: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_qd_iv_id;
1894: elsif p_rec_name = 'hi_dqd_iv_id' then
1895: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1896: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1897: 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);
1898: end if;
1899: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1900: elsif p_rec_name = 'wp_dqd_iv_id' then
1901: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then

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

1895: if pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id is null then
1896: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1897: 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);
1898: end if;
1899: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1900: elsif p_rec_name = 'wp_dqd_iv_id' then
1901: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1902: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1903: 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 1901: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then

1897: 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);
1898: end if;
1899: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1900: elsif p_rec_name = 'wp_dqd_iv_id' then
1901: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1902: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1903: 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);
1904: end if;
1905: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;

Line 1903: 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);

1899: l_rslt_id := pay_jp_report_pkg.g_si_rec.hi_dqd_iv_id;
1900: elsif p_rec_name = 'wp_dqd_iv_id' then
1901: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1902: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1903: 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);
1904: end if;
1905: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1906: elsif p_rec_name = 'wpf_dqd_iv_id' then
1907: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then

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

1901: if pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id is null then
1902: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1903: 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);
1904: end if;
1905: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1906: elsif p_rec_name = 'wpf_dqd_iv_id' then
1907: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1908: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1909: 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 1907: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then

1903: 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);
1904: end if;
1905: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1906: elsif p_rec_name = 'wpf_dqd_iv_id' then
1907: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1908: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1909: 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);
1910: end if;
1911: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;

Line 1909: 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);

1905: l_rslt_id := pay_jp_report_pkg.g_si_rec.wp_dqd_iv_id;
1906: elsif p_rec_name = 'wpf_dqd_iv_id' then
1907: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1908: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1909: 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);
1910: end if;
1911: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;
1912: end if;
1913: --

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

1907: if pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id is null then
1908: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1909: 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);
1910: end if;
1911: l_rslt_id := pay_jp_report_pkg.g_si_rec.wpf_dqd_iv_id;
1912: end if;
1913: --
1914: return l_rslt_id;
1915: end get_si_rec_id;

Line 1934: if pay_jp_report_pkg.g_legislation_code is null

1930: and pes.element_set_name = l_ele_set;
1931: --
1932: begin
1933: --
1934: if pay_jp_report_pkg.g_legislation_code is null
1935: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1936: --
1937: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1938: 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 1935: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then

1931: --
1932: begin
1933: --
1934: if pay_jp_report_pkg.g_legislation_code is null
1935: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1936: --
1937: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1938: 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);
1939: 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 1938: 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);

1934: if pay_jp_report_pkg.g_legislation_code is null
1935: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1936: --
1937: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1938: 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);
1939: 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);
1940: --
1941: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1942: 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 1939: 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);

1935: or pay_jp_report_pkg.g_legislation_code <> c_legislation_code then
1936: --
1937: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,-1,c_legislation_code);
1938: 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);
1939: 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);
1940: --
1941: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1942: 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);
1943: 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 1942: 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);

1938: 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);
1939: 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);
1940: --
1941: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1942: 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);
1943: 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);
1944: --
1945: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1946: 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 1943: 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);

1939: 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);
1940: --
1941: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,-1,c_legislation_code);
1942: 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);
1943: 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);
1944: --
1945: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1946: 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);
1947: 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 1946: 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);

1942: 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);
1943: 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);
1944: --
1945: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1946: 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);
1947: 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);
1948: 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);
1949: 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);
1950: 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 1947: 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);

1943: 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);
1944: --
1945: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1946: 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);
1947: 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);
1948: 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);
1949: 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);
1950: 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);
1951: 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 1948: 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);

1944: --
1945: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1946: 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);
1947: 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);
1948: 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);
1949: 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);
1950: 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);
1951: 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);
1952: --

Line 1949: 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);

1945: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_info_elm,-1,c_legislation_code);
1946: 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);
1947: 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);
1948: 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);
1949: 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);
1950: 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);
1951: 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);
1952: --
1953: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);

Line 1950: 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);

1946: 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);
1947: 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);
1948: 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);
1949: 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);
1950: 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);
1951: 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);
1952: --
1953: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1954: 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 1951: 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);

1947: 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);
1948: 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);
1949: 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);
1950: 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);
1951: 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);
1952: --
1953: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1954: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1955: --

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

1950: 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);
1951: 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);
1952: --
1953: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1954: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1955: --
1956: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1957: 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);
1958: 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 1957: 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);

1953: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_si_rep_elm,-1,c_legislation_code);
1954: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1955: --
1956: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1957: 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);
1958: 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);
1959: --
1960: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1961: 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 1958: 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);

1954: pay_jp_report_pkg.g_si_rec.exc_iv_id := pay_jp_balance_pkg.get_input_value_id(l_elm_id,c_exc_iv);
1955: --
1956: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_q_info_elm,-1,c_legislation_code);
1957: 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);
1958: 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);
1959: --
1960: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1961: 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);
1962: 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 1961: 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);

1957: 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);
1958: 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);
1959: --
1960: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1961: 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);
1962: 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);
1963: --
1964: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1965: 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 1962: 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);

1958: 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);
1959: --
1960: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_q_info_elm,-1,c_legislation_code);
1961: 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);
1962: 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);
1963: --
1964: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1965: 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);
1966: 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 1965: 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);

1961: 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);
1962: 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);
1963: --
1964: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1965: 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);
1966: 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);
1967: --
1968: l_ele_set := c_san_ele_set;
1969: open csr_ele_set;

Line 1966: 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);

1962: 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);
1963: --
1964: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wpf_q_info_elm,-1,c_legislation_code);
1965: 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);
1966: 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);
1967: --
1968: l_ele_set := c_san_ele_set;
1969: open csr_ele_set;
1970: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

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

1966: 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);
1967: --
1968: l_ele_set := c_san_ele_set;
1969: open csr_ele_set;
1970: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
1971: close csr_ele_set;
1972: --
1973: l_ele_set := c_gep_ele_set;
1974: open csr_ele_set;

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

1971: close csr_ele_set;
1972: --
1973: l_ele_set := c_gep_ele_set;
1974: open csr_ele_set;
1975: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
1976: close csr_ele_set;
1977: --
1978: l_ele_set := c_iku_ele_set;
1979: open csr_ele_set;

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

1976: close csr_ele_set;
1977: --
1978: l_ele_set := c_iku_ele_set;
1979: open csr_ele_set;
1980: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
1981: close csr_ele_set;
1982: --
1983: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1984: --

Line 1983: pay_jp_report_pkg.g_legislation_code := c_legislation_code;

1979: open csr_ele_set;
1980: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
1981: close csr_ele_set;
1982: --
1983: pay_jp_report_pkg.g_legislation_code := c_legislation_code;
1984: --
1985: end if;
1986: --
1987: if p_rec_name = 'hi_appl_mth_iv_id' then

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

1984: --
1985: end if;
1986: --
1987: if p_rec_name = 'hi_appl_mth_iv_id' then
1988: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then
1989: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1990: 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);
1991: end if;
1992: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;

Line 1990: 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);

1986: --
1987: if p_rec_name = 'hi_appl_mth_iv_id' then
1988: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then
1989: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1990: 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);
1991: end if;
1992: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1993: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1994: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then

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

1988: if pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id is null then
1989: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
1990: 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);
1991: end if;
1992: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1993: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1994: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1995: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1996: 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 1994: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then

1990: 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);
1991: end if;
1992: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1993: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1994: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1995: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1996: 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);
1997: end if;
1998: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;

Line 1996: 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);

1992: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_mth_iv_id;
1993: elsif p_rec_name = 'wp_appl_mth_iv_id' then
1994: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1995: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1996: 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);
1997: end if;
1998: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1999: elsif p_rec_name = 'hi_appl_cat_iv_id' then
2000: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then

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

1994: if pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id is null then
1995: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
1996: 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);
1997: end if;
1998: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1999: elsif p_rec_name = 'hi_appl_cat_iv_id' then
2000: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
2001: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
2002: 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 2000: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then

1996: 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);
1997: end if;
1998: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1999: elsif p_rec_name = 'hi_appl_cat_iv_id' then
2000: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
2001: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
2002: 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);
2003: end if;
2004: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;

Line 2002: 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);

1998: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_mth_iv_id;
1999: elsif p_rec_name = 'hi_appl_cat_iv_id' then
2000: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
2001: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
2002: 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);
2003: end if;
2004: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
2005: elsif p_rec_name = 'wp_appl_cat_iv_id' then
2006: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then

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

2000: if pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id is null then
2001: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_hi_smr_info_elm,null,c_legislation_code);
2002: 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);
2003: end if;
2004: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
2005: elsif p_rec_name = 'wp_appl_cat_iv_id' then
2006: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
2007: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
2008: 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 2006: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then

2002: 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);
2003: end if;
2004: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
2005: elsif p_rec_name = 'wp_appl_cat_iv_id' then
2006: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
2007: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
2008: 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);
2009: end if;
2010: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;

Line 2008: 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);

2004: l_rslt_id := pay_jp_report_pkg.g_gs_rec.hi_appl_cat_iv_id;
2005: elsif p_rec_name = 'wp_appl_cat_iv_id' then
2006: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
2007: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
2008: 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);
2009: end if;
2010: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2011: elsif p_rec_name = 'san_ele_set_id' then
2012: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then

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

2006: if pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id is null then
2007: l_elm_id := pay_jp_balance_pkg.get_element_type_id(c_com_wp_smr_info_elm,null,c_legislation_code);
2008: 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);
2009: end if;
2010: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2011: elsif p_rec_name = 'san_ele_set_id' then
2012: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then
2013: open csr_ele_set;
2014: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;

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

2008: 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);
2009: end if;
2010: l_rslt_id := pay_jp_report_pkg.g_gs_rec.wp_appl_cat_iv_id;
2011: elsif p_rec_name = 'san_ele_set_id' then
2012: if pay_jp_report_pkg.g_gs_rec.san_ele_set_id is null then
2013: open csr_ele_set;
2014: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.san_ele_set_id;
2015: close csr_ele_set;
2016: end if;

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

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

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

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

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

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

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

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

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

2020: open csr_ele_set;
2021: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2022: close csr_ele_set;
2023: end if;
2024: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2025: elsif p_rec_name = 'iku_ele_set_id' then
2026: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then
2027: open csr_ele_set;
2028: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;

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

2022: close csr_ele_set;
2023: end if;
2024: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2025: elsif p_rec_name = 'iku_ele_set_id' then
2026: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then
2027: open csr_ele_set;
2028: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2029: close csr_ele_set;
2030: end if;

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

2024: l_rslt_id := pay_jp_report_pkg.g_gs_rec.gep_ele_set_id;
2025: elsif p_rec_name = 'iku_ele_set_id' then
2026: if pay_jp_report_pkg.g_gs_rec.iku_ele_set_id is null then
2027: open csr_ele_set;
2028: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2029: close csr_ele_set;
2030: end if;
2031: l_rslt_id := pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2032: end if;

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

2027: open csr_ele_set;
2028: fetch csr_ele_set into pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2029: close csr_ele_set;
2030: end if;
2031: l_rslt_id := pay_jp_report_pkg.g_gs_rec.iku_ele_set_id;
2032: end if;
2033: --
2034: return l_rslt_id;
2035: end get_gs_rec_id;

Line 2483: pay_jp_report_pkg.g_char_set := p_char_set;

2479: p_char_set in varchar2)
2480: is
2481: begin
2482: --
2483: pay_jp_report_pkg.g_char_set := p_char_set;
2484: --
2485: end set_char_set;
2486: --
2487: -- -------------------------------------------------------------------------

Line 2507: pay_jp_report_pkg.g_db_char_set := p_db_char_set;

2503: begin
2504: --
2505: if p_db_char_set is not null then
2506: --
2507: pay_jp_report_pkg.g_db_char_set := p_db_char_set;
2508: --
2509: else
2510: --
2511: if pay_jp_report_pkg.g_db_char_set is null then

Line 2511: if pay_jp_report_pkg.g_db_char_set is null then

2507: pay_jp_report_pkg.g_db_char_set := p_db_char_set;
2508: --
2509: else
2510: --
2511: if pay_jp_report_pkg.g_db_char_set is null then
2512: --
2513: open csr_db_char_set;
2514: fetch csr_db_char_set into pay_jp_report_pkg.g_db_char_set;
2515: close csr_db_char_set;

Line 2514: fetch csr_db_char_set into pay_jp_report_pkg.g_db_char_set;

2510: --
2511: if pay_jp_report_pkg.g_db_char_set is null then
2512: --
2513: open csr_db_char_set;
2514: fetch csr_db_char_set into pay_jp_report_pkg.g_db_char_set;
2515: close csr_db_char_set;
2516: --
2517: end if;
2518: --

Line 2792: --if pay_jp_report_pkg.g_char_set is null then

2788: --
2789: l_char_set := p_char_set;
2790: if l_char_set is null then
2791: --
2792: --if pay_jp_report_pkg.g_char_set is null then
2793: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
2794: -- hr_utility.raise_error;
2795: --else
2796: l_char_set := pay_jp_report_pkg.g_char_set;

Line 2796: l_char_set := pay_jp_report_pkg.g_char_set;

2792: --if pay_jp_report_pkg.g_char_set is null then
2793: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
2794: -- hr_utility.raise_error;
2795: --else
2796: l_char_set := pay_jp_report_pkg.g_char_set;
2797: --end if;
2798: --
2799: end if;
2800: --

Line 3121: --if pay_jp_report_pkg.g_char_set is null then

3117: --
3118: l_char_set := p_char_set;
3119: if l_char_set is null then
3120: --
3121: --if pay_jp_report_pkg.g_char_set is null then
3122: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
3123: -- hr_utility.raise_error;
3124: --else
3125: l_char_set := pay_jp_report_pkg.g_char_set;

Line 3125: l_char_set := pay_jp_report_pkg.g_char_set;

3121: --if pay_jp_report_pkg.g_char_set is null then
3122: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
3123: -- hr_utility.raise_error;
3124: --else
3125: l_char_set := pay_jp_report_pkg.g_char_set;
3126: --end if;
3127: --
3128: end if;
3129: --

Line 3180: --if pay_jp_report_pkg.g_char_set is null then

3176: --
3177: l_char_set := p_char_set;
3178: if l_char_set is null then
3179: --
3180: --if pay_jp_report_pkg.g_char_set is null then
3181: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
3182: -- hr_utility.raise_error;
3183: --else
3184: l_char_set := pay_jp_report_pkg.g_char_set;

Line 3184: l_char_set := pay_jp_report_pkg.g_char_set;

3180: --if pay_jp_report_pkg.g_char_set is null then
3181: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
3182: -- hr_utility.raise_error;
3183: --else
3184: l_char_set := pay_jp_report_pkg.g_char_set;
3185: --end if;
3186: --
3187: end if;
3188: --

Line 3192: --if pay_jp_report_pkg.g_db_char_set is null then

3188: --
3189: l_db_char_set := p_db_char_set;
3190: if l_db_char_set is null then
3191: --
3192: --if pay_jp_report_pkg.g_db_char_set is null then
3193: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
3194: -- hr_utility.raise_error;
3195: --else
3196: l_db_char_set := pay_jp_report_pkg.g_db_char_set;

Line 3196: l_db_char_set := pay_jp_report_pkg.g_db_char_set;

3192: --if pay_jp_report_pkg.g_db_char_set is null then
3193: -- hr_utility.set_message(800,'HR_7944_CHECK_FMT_BAD_FORMAT');
3194: -- hr_utility.raise_error;
3195: --else
3196: l_db_char_set := pay_jp_report_pkg.g_db_char_set;
3197: --end if;
3198: --
3199: end if;
3200: --

Line 3326: pay_jp_report_pkg.g_delimiter := p_delimiter;

3322: p_delimiter in varchar2)
3323: is
3324: begin
3325: --
3326: pay_jp_report_pkg.g_delimiter := p_delimiter;
3327: --
3328: end set_delimiter;
3329: --
3330: -- -------------------------------------------------------------------------

Line 3342: if pay_jp_report_pkg.g_delimiter is null then

3338: l_text varchar2(4000);
3339: --
3340: begin
3341: --
3342: if pay_jp_report_pkg.g_delimiter is null then
3343: set_delimiter(c_dot_delimiter);
3344: end if;
3345: --
3346: l_text := replace(p_text,c_comma_delimiter,pay_jp_report_pkg.g_delimiter);

Line 3346: l_text := replace(p_text,c_comma_delimiter,pay_jp_report_pkg.g_delimiter);

3342: if pay_jp_report_pkg.g_delimiter is null then
3343: set_delimiter(c_dot_delimiter);
3344: end if;
3345: --
3346: l_text := replace(p_text,c_comma_delimiter,pay_jp_report_pkg.g_delimiter);
3347: --
3348: return l_text;
3349: end csvspchar;
3350: --

Line 3518: l_era_code := pay_jp_report_pkg.jp_era_date(p_date,'E');

3514: o_match_era varchar2(60);
3515: --
3516: begin
3517: --
3518: l_era_code := pay_jp_report_pkg.jp_era_date(p_date,'E');
3519: --
3520: if l_era_code = p_era_code then
3521: --
3522: o_match_era := c_circle;

Line 3598: pay_jp_report_pkg.g_detail_debug := p_yn;

3594: begin
3595: --
3596: if p_yn is not null then
3597: --
3598: pay_jp_report_pkg.g_detail_debug := p_yn;
3599: --
3600: else
3601: --
3602: open csr_hidden_debug;

Line 3608: pay_jp_report_pkg.g_detail_debug := l_hidden_debug;

3604: close csr_hidden_debug;
3605: --
3606: if l_hidden_debug = 'Y' then
3607: --
3608: pay_jp_report_pkg.g_detail_debug := l_hidden_debug;
3609: --
3610: end if;
3611: --
3612: end if;

Line 3617: hr_utility.trace('g_detail_debug : '||pay_jp_report_pkg.g_detail_debug);

3613: --
3614: if g_debug then
3615: --
3616: hr_utility.trace('l_hidden_debug : '||l_hidden_debug);
3617: hr_utility.trace('g_detail_debug : '||pay_jp_report_pkg.g_detail_debug);
3618: --
3619: end if;
3620: --
3621: end set_detail_debug;

Line 3623: END PAY_JP_REPORT_PKG;

3619: end if;
3620: --
3621: end set_detail_debug;
3622: --
3623: END PAY_JP_REPORT_PKG;