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.WIP_WS_PTPKPI_PK dependencies on WIP_WS_PTPKPI_PLAN

Line 187: delete wip_ws_ptpkpi_plan

183: -- for the parameter org
184:
185: wip_ws_util.trace_log('Entering Populate_plan_data API');
186:
187: delete wip_ws_ptpkpi_plan
188: where organization_id = p_org_id;
189:
190: wip_ws_util.trace_log(' Deleted old rows in the table. Rows deleted = '||sql%rowcount);
191:

Line 197: 'insert into wip_ws_ptpkpi_plan(

193: -- ptp kpi plan table
194: l_job_status_clause := ' and wdj.status_type in ('|| get_pref_job_statuses(p_org_ptpkpi_rec) || ')';
195: l_job_type_clause := ' and wdj.job_type in ('||get_job_types(p_org_ptpkpi_rec) || ')';
196: l_sql :=
197: 'insert into wip_ws_ptpkpi_plan(
198: organization_id,
199: department_id,
200: wip_entity_id,
201: operation_seq_num,