APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_PATCH_STATUS

Line 4649: FROM pay_patch_status

4645: l_dbi_cnt number := 0;
4646: --
4647: CURSOR c_del_dtls IS
4648: SELECT *
4649: FROM pay_patch_status
4650: WHERE patch_number = 5758299
4651: AND patch_name = 'JP_UPGRADE_R12'
4652: AND phase = 'C'
4653: AND legislation_code = 'JP';

Line 4826: INSERT INTO pay_patch_status

4822: l_global_rec.creation_date);
4823: -- hr_utility.trace('Global Value DBI: ' || l_global_rec.global_name || ' created.');
4824: end loop;
4825: --
4826: INSERT INTO pay_patch_status
4827: (id
4828: ,patch_number
4829: ,patch_name
4830: ,phase

Line 4834: SELECT pay_patch_status_s.nextval

4830: ,phase
4831: ,applied_date
4832: ,legislation_code
4833: ,process_type)
4834: SELECT pay_patch_status_s.nextval
4835: ,5758299
4836: ,'JP_UPGRADE_R12'
4837: ,'C'
4838: ,sysdate

Line 4884: update pay_patch_status

4880: close csr_corrupt_dbi;
4881: --
4882: -- need 12566233 check once even if post 9737155 pkg version
4883: -- because of case 12566233 issue of never run 9737155 status
4884: update pay_patch_status
4885: set process_type = decode(nvl(rec_del_dtls.process_type,'X'),'X',null,rec_del_dtls.process_type||',')||'9737155'
4886: where id = rec_del_dtls.id;
4887: --
4888: if (g_dbg) then

Line 5065: from pay_patch_status

5061: --
5062: cursor csr_run_script
5063: is
5064: select 'Y'
5065: from pay_patch_status
5066: where patch_number = 5758299
5067: and patch_name = 'JP_UPGRADE_R12'
5068: and phase = 'C'
5069: and legislation_code = 'JP';

Line 6648: l_process_type pay_patch_status.process_type%type;

6644: o_dbi_corrupt varchar2(1) := 'N';
6645: --
6646: l_pay_install varchar2(1);
6647: l_run_script varchar2(1);
6648: l_process_type pay_patch_status.process_type%type;
6649: --
6650: cursor csr_pay_install
6651: is
6652: select 'Y'

Line 6662: from pay_patch_status

6658: cursor csr_run_script
6659: is
6660: select 'Y' run_status,
6661: process_type
6662: from pay_patch_status
6663: where patch_number = 5758299
6664: and patch_name = 'JP_UPGRADE_R12'
6665: and phase = 'C'
6666: and legislation_code = 'JP';

Line 6836: update pay_patch_status

6832: if (g_dbg) then
6833: hr_utility.set_location(l_proc,10);
6834: end if;
6835: --
6836: update pay_patch_status
6837: set process_type = decode(nvl(process_type,'X'),'X',null,process_type||',')||'12566233'
6838: where patch_number = 5758299
6839: and patch_name = 'JP_UPGRADE_R12'
6840: and phase = 'C'