APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_RM_WORK_TYPE_ROWID

Line 529: insert into PJI_RM_WORK_TYPE_ROWID

525:
526: --Synchronize NORMAL slice of PJI_RM_WORK_TYPE_INFO
527: --with PA_WORK_TYPES_B when extraction type is FULL
528: --or INCREMENTAL
529: insert into PJI_RM_WORK_TYPE_ROWID
530: (
531: PA_ROWID,
532: PJI_ROWID,
533: CHANGE_FLAG

Line 561: PJI_RM_WORK_TYPE_ROWID wt_r

557: (
558: select
559: wt_r.PJI_ROWID
560: from
561: PJI_RM_WORK_TYPE_ROWID wt_r
562: where
563: wt_r.PJI_ROWID is not null
564: )
565: and wt.RECORD_TYPE = 'NORMAL';

Line 592: PJI_RM_WORK_TYPE_ROWID wt_r,

588: pa.TRAINING_FLAG,
589: pa.LAST_UPDATE_DATE,
590: pa.LAST_UPDATED_BY
591: from
592: PJI_RM_WORK_TYPE_ROWID wt_r,
593: PA_WORK_TYPES_B pa
594: where
595: wt_r.PJI_ROWID = wt.ROWID and
596: pa.ROWID = wt_r.PA_ROWID

Line 604: PJI_RM_WORK_TYPE_ROWID wt_r

600: (
601: select
602: wt_r.PJI_ROWID
603: from
604: PJI_RM_WORK_TYPE_ROWID wt_r
605: where
606: wt_r.PJI_ROWID is not null and
607: wt_r.CHANGE_FLAG = 'Y'
608: );

Line 646: PJI_RM_WORK_TYPE_ROWID wt_r

642: (
643: select
644: wt_r.PA_ROWID
645: from
646: PJI_RM_WORK_TYPE_ROWID wt_r
647: where
648: wt_r.PJI_ROWID is null
649: );
650:

Line 773: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_RM_WORK_TYPE_ROWID', 'NORMAL', null);

769: pji_utils.write2log(sql%rowcount || ' rows inserted :3.');
770:
771: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);');
772:
773: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_RM_WORK_TYPE_ROWID', 'NORMAL', null);
774:
775: commit;
776:
777: end UPDATE_PJI_RM_WORK_TYPE_INFO;