APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_JP_DATA_MIGRATION_PKG

Line 1: PACKAGE BODY pay_jp_data_migration_pkg AS

1: PACKAGE BODY pay_jp_data_migration_pkg AS
2: /* $Header: pyjpdatamig.pkb 120.17 2012/01/19 10:08:36 rpahune ship $ */
3: --
4: -- Global Utils
5: g_pkg VARCHAR2(30) := 'pay_jp_data_migration_pkg';

Line 5: g_pkg VARCHAR2(30) := 'pay_jp_data_migration_pkg';

1: PACKAGE BODY pay_jp_data_migration_pkg AS
2: /* $Header: pyjpdatamig.pkb 120.17 2012/01/19 10:08:36 rpahune ship $ */
3: --
4: -- Global Utils
5: g_pkg VARCHAR2(30) := 'pay_jp_data_migration_pkg';
6: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should be output
7: g_dbg BOOLEAN := FALSE; --Used for diagnosing issues by dev, more outputs
8: --
9: -- |-------------------------------------------------------------------|

Line 5331: -- target only elm which are listed in rename by pay_jp_data_migration_pkg.migrate_element_types

5327: end if;
5328: --
5329: if l_elm_cnt > 0 then
5330: --
5331: -- target only elm which are listed in rename by pay_jp_data_migration_pkg.migrate_element_types
5332: --
5333: l_elm_tbl(1) := 'SAL_HI_PREM_PROC';
5334: l_elm_tbl(2) := 'SAL_EI_PREM_PROC';
5335: l_elm_tbl(3) := 'SAL_WP_PREM_PROC';

Line 5582: -- target only class which are listed in rename by pay_jp_data_migration_pkg.migrate_element_class

5578: end if;
5579: --
5580: if l_class_cnt > 0 then
5581: --
5582: -- target only class which are listed in rename by pay_jp_data_migration_pkg.migrate_element_class
5583: --
5584: l_class_tbl(1) := 'TRM_ERN_KIND_TXBL';
5585: l_class_tbl(2) := 'TRM_ERN_KIND_NRES_TXBL';
5586: l_class_tbl(3) := 'BON_SI_EI_PREM';

Line 5752: -- target only bal which are listed in rename by pay_jp_data_migration_pkg.migrate_balance_types

5748: end if;
5749: --
5750: if l_bal_cnt > 0 then
5751: --
5752: -- target only bal which are listed in rename by pay_jp_data_migration_pkg.migrate_balance_types
5753: --
5754: l_bal_tbl(1) := 'B_COM_WP_PREM';
5755: l_bal_tbl(2) := 'B_GEP_FIXED_WAGE';
5756: l_bal_tbl(3) := 'B_COM_SAN_GEP_SP_BON_ERN_KIND';

Line 5956: -- target only dim which are listed in rename by pay_jp_data_migration_pkg.migrate_bal_dimensions

5952: end if;
5953: --
5954: if l_dim_cnt > 0 then
5955: --
5956: -- target only dim which are listed in rename by pay_jp_data_migration_pkg.migrate_bal_dimensions
5957: --
5958: l_dim_tbl(1) := '_ASG_RUN';
5959: l_dim_tbl(2) := '_ASG_LTD';
5960: l_dim_tbl(3) := '_PAYMENTS';

Line 6048: -- target only eset which are listed in rename by pay_jp_data_migration_pkg.migrate_element_sets

6044: end if;
6045: --
6046: if l_eset_cnt > 0 then
6047: --
6048: -- target only eset which are listed in rename by pay_jp_data_migration_pkg.migrate_element_sets
6049: --
6050: l_eset_tbl(1) := 'BON';
6051: l_eset_tbl(2) := 'SAN';
6052: l_eset_tbl(3) := 'SAL';

Line 6134: -- target only glb which are listed in rename by pay_jp_data_migration_pkg.migrate_globals

6130: end if;
6131: --
6132: if l_glb_cnt > 0 then
6133: --
6134: -- target only glb which are listed in rename by pay_jp_data_migration_pkg.migrate_globals
6135: --
6136: l_glb_tbl(1) := 'G_COM_ITX_TBL_NUM_OF_DEP_MAX';
6137: l_glb_tbl(2) := 'G_SAL_HI_PREM_RATE_EE';
6138: l_glb_tbl(3) := 'G_SAL_HI_PREM_RATE';

Line 6280: -- target only ff which are listed in rename by pay_jp_data_migration_pkg.migrate_formulas

6276: end if;
6277: --
6278: if l_ff_cnt > 0 then
6279: --
6280: -- target only ff which are listed in rename by pay_jp_data_migration_pkg.migrate_formulas
6281: --
6282: l_ff_tbl(1) := 'GEP_MR_PROC';
6283: l_ff_tbl(2) := 'SAN_MR_PROC';
6284: l_ff_tbl(3) := 'GEP_MR_PROC_SKIP';

Line 6446: -- target only mon which are listed in rename by pay_jp_data_migration_pkg.migrate_monetary_units

6442: end if;
6443: --
6444: if l_mon_cnt > 0 then
6445: --
6446: -- target only mon which are listed in rename by pay_jp_data_migration_pkg.migrate_monetary_units
6447: --
6448: l_mon_tbl(1) := 'TEN_THOUSAND_YEN';
6449: l_mon_tbl(2) := 'ONE_THOUSAND_YEN';
6450: l_mon_tbl(3) := 'ONE_HUNDRED_YEN';

Line 6533: -- target only udt which are listed in rename by pay_jp_data_migration_pkg.migrate_user_tables

6529: end if;
6530: --
6531: if l_udt_cnt > 0 then
6532: --
6533: -- target only udt which are listed in rename by pay_jp_data_migration_pkg.migrate_user_tables
6534: --
6535: l_udt_tbl(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';
6536: l_udt_tbl(2) := 'T_YEA_AMT_AFTER_EMP_INCOME_DCT1';
6537: l_udt_tbl(3) := 'T_YEA_AMT_AFTER_EMP_INCOME_DCT2';

Line 7058: END pay_jp_data_migration_pkg;

7054: raise;
7055:
7056: END migrate_data;
7057: --
7058: END pay_jp_data_migration_pkg;