[Home] [Help]
396: l_transition_flag :=
397: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
398: 'TRANSITION');
399:
400: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DREVN
401: (
402: ROW_ID
403: , WORKER_ID
404: , LINE_SOURCE_TYPE
669: BATCH_ID,
670: null,
671: null
672: from
673: PJI_FM_EXTR_DREVN
674: where
675: (LINE_SOURCE_TYPE = 'R' and
676: PJI_SUMMARIZED_FLAG is not null) or
677: (LINE_SOURCE_TYPE = 'L');
746: UPDATE pa_draft_revenues_all drv
747: SET drv.pji_summarized_flag = null
748: WHERE drv.rowid in (select /*+ cardinality(drvn, 1) */
749: drvn.row_id
750: from PJI_FM_EXTR_DREVN drvn
751: where drvn.pji_summarized_flag is not null
752: and drvn.LINE_SOURCE_TYPE = 'R'
753: and drvn.batch_id = l_helper_batch_id);
754:
755: -- Clean up log table
756:
757: DELETE pa_pji_proj_events_log
758: WHERE rowid in (select row_id
759: from PJI_FM_EXTR_DREVN
760: where line_source_type = 'L'
761: and batch_id = l_helper_batch_id);
762:
763: update PJI_HELPER_BATCH_MAP
894: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
895: 'CURRENT_BATCH') = 1) then
896: -- implicit commit
897: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
898: tabname => 'PJI_FM_EXTR_DREVN',
899: percent => 10,
900: degree => PJI_UTILS.
901: GET_DEGREE_OF_PARALLELISM);
902: -- implicit commit
900: degree => PJI_UTILS.
901: GET_DEGREE_OF_PARALLELISM);
902: -- implicit commit
903: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
904: tabname => 'PJI_FM_EXTR_DREVN',
905: colname => 'PROJECT_ID',
906: percent => 10,
907: degree => PJI_UTILS.
908: GET_DEGREE_OF_PARALLELISM);
1266: , to_number(null) AS EOU_UER
1267: , to_number(null) AS QUANTITY
1268: , to_number(null) AS BILL_QUANTITY
1269: , -1 AS CBS_ELEMENT_ID /* Added for CBS Changes */
1270: From PJI_FM_EXTR_DREVN drev
1271: , pa_agreements_all ag
1272: , pa_project_customers cust
1273: , pa_cust_rev_dist_lines_all crdl
1274: Where 1 = 1
1504: From pa_agreements_all ag
1505: , pa_project_customers cust
1506: , pa_events ev
1507: , pa_event_types evt
1508: , PJI_FM_EXTR_DREVN drev
1509: , pa_cust_event_rdl_all erdl
1510: Where 1 = 1
1511: And drev.worker_id = p_worker_id
1512: And drev.project_id = erdl.project_id
1696: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
1697: 'CURRENT_BATCH') = 1) then
1698: -- implicit commit
1699: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1700: tabname => 'PJI_FM_EXTR_DREVN',
1701: percent => 10,
1702: degree => PJI_UTILS.
1703: GET_DEGREE_OF_PARALLELISM);
1704: end if;
1736: , drev.line_source_type
1737: , cust.bill_another_project_flag
1738: , cust.customer_id
1739: FROM
1740: PJI_FM_EXTR_DREVN drev
1741: , pa_agreements_all ag
1742: , pa_project_customers cust
1743: , pa_cust_rev_dist_lines_all crdl
1744: WHERE
1830: , drev.pa_period_name pa_period_name
1831: , drev.gl_date gl_date
1832: , drev.gl_period_name gl_period_name
1833: FROM
1834: PJI_FM_EXTR_DREVN drev
1835: , pa_agreements_all ag
1836: , pa_project_customers cust
1837: , pa_cust_event_rdl_all erdl /* Changed the order for bug 8668173 */
1838: , pa_events ev
3785: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3786:
3787: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);
3788:
3789: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);
3790:
3791: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);
3792:
3793: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);