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.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_RM_WORK_TYPE_INFO

Line 414: , tabname => 'PJI_RM_WORK_TYPE_INFO'

410: , degree => l_degree
411: );
412: FND_STATS.GATHER_TABLE_STATS(
413: ownname => l_schema
414: , tabname => 'PJI_RM_WORK_TYPE_INFO'
415: , percent => 50
416: , degree => l_degree
417: );
418: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

Line 419: tabname => 'PJI_RM_WORK_TYPE_INFO',

415: , percent => 50
416: , degree => l_degree
417: );
418: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
419: tabname => 'PJI_RM_WORK_TYPE_INFO',
420: colname => 'WORK_TYPE_ID',
421: percent => 10,
422: degree => l_degree);
423: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

Line 424: tabname => 'PJI_RM_WORK_TYPE_INFO',

420: colname => 'WORK_TYPE_ID',
421: percent => 10,
422: degree => l_degree);
423: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
424: tabname => 'PJI_RM_WORK_TYPE_INFO',
425: colname => 'RECORD_TYPE',
426: percent => 10,
427: degree => l_degree);
428: FND_STATS.GATHER_TABLE_STATS(

Line 470: -- procedure UPDATE_PJI_RM_WORK_TYPE_INFO

466: END SEED_PJI_RM_STATS;
467:
468:
469: -- ------------------------------------------------------------------
470: -- procedure UPDATE_PJI_RM_WORK_TYPE_INFO
471: --
472: -- This procedure maintains the table PJI_RM_WORK_TYPE_INFO
473: -- This table contains 3 slices of data which can be distinguished
474: -- by the value in RECORD_TYPE column

Line 472: -- This procedure maintains the table PJI_RM_WORK_TYPE_INFO

468:
469: -- ------------------------------------------------------------------
470: -- procedure UPDATE_PJI_RM_WORK_TYPE_INFO
471: --
472: -- This procedure maintains the table PJI_RM_WORK_TYPE_INFO
473: -- This table contains 3 slices of data which can be distinguished
474: -- by the value in RECORD_TYPE column
475: -- RECORD_TYPE column can take 3 values
476: -- NORMAL - This slice is a copy of PA_WORK_TYPE _B table;

Line 488: procedure UPDATE_PJI_RM_WORK_TYPE_INFO (p_process in varchar2) is

484: -- changed work type record. Records in this slice will
485: -- be copies of NORMAL slice records for which CHANGE_OLD
486: -- record exists
487: -- ------------------------------------------------------------------
488: procedure UPDATE_PJI_RM_WORK_TYPE_INFO (p_process in varchar2) is
489:
490: l_row_count number;
491: l_extraction_type varchar2(30);
492: l_event_id number;

Line 496: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);')) then

492: l_event_id number;
493:
494: begin
495:
496: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);')) then
497: return;
498: end if;
499:
500: select count(*)

Line 502: from PJI_RM_WORK_TYPE_INFO

498: end if;
499:
500: select count(*)
501: into l_row_count
502: from PJI_RM_WORK_TYPE_INFO
503: where ROWNUM = 1;
504:
505: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
506: 'TRANSITION') = 'Y' and

Line 513: from PJI_RM_WORK_TYPE_INFO

509: end if;
510:
511: --delete CHANGE_NEW / CHANGE_OLD records
512: delete
513: from PJI_RM_WORK_TYPE_INFO
514: where RECORD_TYPE in ( 'CHANGE_NEW', 'CHANGE_OLD');
515:
516: --Conditional processing based on extraction type
517: --Work type change processing is not done for

Line 526: --Synchronize NORMAL slice of PJI_RM_WORK_TYPE_INFO

522: IF l_extraction_type = 'PARTIAL' THEN
523: return;
524: END IF;
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: (

Line 548: PJI_RM_WORK_TYPE_INFO pji

544: else 'N'
545: end
546: from
547: PA_WORK_TYPES_B pa,
548: PJI_RM_WORK_TYPE_INFO pji
549: where
550: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
551: pji.RECORD_TYPE (+)= 'NORMAL'; */
552:

Line 554: from PJI_RM_WORK_TYPE_INFO wt

550: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
551: pji.RECORD_TYPE (+)= 'NORMAL'; */
552:
553: delete
554: from PJI_RM_WORK_TYPE_INFO wt
555: where
556: wt.ROWID not in
557: (
558: select

Line 562: PJI_RM_WORK_TYPE_INFO pji

558: select
559: pji.ROWID
560: from
561: PA_WORK_TYPES_B pa,
562: PJI_RM_WORK_TYPE_INFO pji
563: where
564: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
565: pji.RECORD_TYPE (+)= 'NORMAL' AND
566: pji.ROWID IS NOT null

Line 573: update PJI_RM_WORK_TYPE_INFO wt

569: and wt.RECORD_TYPE = 'NORMAL';
570:
571: pji_utils.write2log(sql%rowcount || ' rows deleted.');
572:
573: update PJI_RM_WORK_TYPE_INFO wt
574: set
575: (
576: WORK_TYPE_ID,
577: BILLABLE_CAPITALIZABLE_FLAG,

Line 609: PJI_RM_WORK_TYPE_INFO pji

605: else 'N'
606: end
607: from
608: PA_WORK_TYPES_B pa,
609: PJI_RM_WORK_TYPE_INFO pji
610: where
611: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
612: pji.RECORD_TYPE (+)= 'NORMAL') wt_r,
613: PA_WORK_TYPES_B pa

Line 637: PJI_RM_WORK_TYPE_INFO pji

633: else 'N'
634: end CHANGE_FLAG
635: from
636: PA_WORK_TYPES_B pa,
637: PJI_RM_WORK_TYPE_INFO pji
638: where
639: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
640: pji.RECORD_TYPE (+)= 'NORMAL') wt_r
641: where

Line 648: insert into PJI_RM_WORK_TYPE_INFO

644: );
645:
646: pji_utils.write2log(sql%rowcount || ' rows updated.');
647:
648: insert into PJI_RM_WORK_TYPE_INFO
649: (
650: WORK_TYPE_ID,
651: BILLABLE_CAPITALIZABLE_FLAG,
652: REDUCE_CAPACITY_FLAG,

Line 695: PJI_RM_WORK_TYPE_INFO pji

691: else 'N'
692: end
693: from
694: PA_WORK_TYPES_B pa,
695: PJI_RM_WORK_TYPE_INFO pji
696: where
697: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
698: pji.RECORD_TYPE (+)= 'NORMAL') wt_r
699: where

Line 744: insert into PJI_RM_WORK_TYPE_INFO

740:
741: pji_utils.write2log(sql%rowcount || ' rows deleted :2.');
742:
743: --populate CHANGE_OLD slice from PA_PJI_PROJ_EVENTS_LOG table
744: insert into PJI_RM_WORK_TYPE_INFO
745: (
746: WORK_TYPE_ID,
747: BILLABLE_CAPITALIZABLE_FLAG,
748: REDUCE_CAPACITY_FLAG,

Line 788: --Populate PJI_RM_WORK_TYPE_INFO with CHANGE_NEW records

784: log.EVENT_TYPE = 'Work Types' and
785: log.OPERATION_TYPE = 'U';
786: pji_utils.write2log(sql%rowcount || ' rows deleted 3.');
787:
788: --Populate PJI_RM_WORK_TYPE_INFO with CHANGE_NEW records
789: insert into PJI_RM_WORK_TYPE_INFO
790: (
791: WORK_TYPE_ID,
792: BILLABLE_CAPITALIZABLE_FLAG,

Line 789: insert into PJI_RM_WORK_TYPE_INFO

785: log.OPERATION_TYPE = 'U';
786: pji_utils.write2log(sql%rowcount || ' rows deleted 3.');
787:
788: --Populate PJI_RM_WORK_TYPE_INFO with CHANGE_NEW records
789: insert into PJI_RM_WORK_TYPE_INFO
790: (
791: WORK_TYPE_ID,
792: BILLABLE_CAPITALIZABLE_FLAG,
793: REDUCE_CAPACITY_FLAG,

Line 815: from PJI_RM_WORK_TYPE_INFO info

811: CREATION_DATE,
812: CREATED_BY,
813: LAST_UPDATE_DATE,
814: LAST_UPDATED_BY
815: from PJI_RM_WORK_TYPE_INFO info
816: where info.RECORD_TYPE = 'NORMAL'
817: and info.WORK_TYPE_ID in ( select WORK_TYPE_ID
818: from PJI_RM_WORK_TYPE_INFO wt
819: where wt.RECORD_TYPE = 'CHANGE_OLD');

Line 818: from PJI_RM_WORK_TYPE_INFO wt

814: LAST_UPDATED_BY
815: from PJI_RM_WORK_TYPE_INFO info
816: where info.RECORD_TYPE = 'NORMAL'
817: and info.WORK_TYPE_ID in ( select WORK_TYPE_ID
818: from PJI_RM_WORK_TYPE_INFO wt
819: where wt.RECORD_TYPE = 'CHANGE_OLD');
820:
821: pji_utils.write2log(sql%rowcount || ' rows inserted :3.');
822:

Line 823: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);');

819: where wt.RECORD_TYPE = 'CHANGE_OLD');
820:
821: pji_utils.write2log(sql%rowcount || ' rows inserted :3.');
822:
823: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);');
824:
825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_RM_WORK_TYPE_ROWID', 'NORMAL', null);
826:
827: commit;

Line 829: end UPDATE_PJI_RM_WORK_TYPE_INFO;

825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_RM_WORK_TYPE_ROWID', 'NORMAL', null);
826:
827: commit;
828:
829: end UPDATE_PJI_RM_WORK_TYPE_INFO;
830:
831:
832: -- -----------------------------------------------------
833: -- procedure UPDATE_PJI_ORG_HRCHY

Line 1296: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RM_WORK_TYPE_INFO', 'NORMAL', null);

1292: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_RM_SUM_MAIN.g_process || '%');
1293:
1294: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PROJECT_CLASSES', 'NORMAL', null);
1295: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RESOURCES_DENORM', 'NORMAL', null); Commented for bug 13011859 */
1296: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RM_WORK_TYPE_INFO', 'NORMAL', null);
1297: /* PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_CLASS_CATEGORIES', 'NORMAL', null);
1298: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_CLASS_CODES', 'NORMAL', null);
1299: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_ORG_DENORM', 'NORMAL', null);Commented for bug 13011859 */
1300: