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_FM_PLAN_MAINT dependencies on PJI_FM_PLAN_MAINT_PVT

Line 837: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');

833:
834: print_time('CREATE_SECONDARY_PVT: begin.. ');
835:
836:
837: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');
838: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');
839: print_time(' Identified plan versions to be extracted. ');
840:
841: IF (CHECK_VER3_NOT_EMPTY(p_online => 'F') = 'F') THEN

Line 838: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');

834: print_time('CREATE_SECONDARY_PVT: begin.. ');
835:
836:
837: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');
838: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');
839: print_time(' Identified plan versions to be extracted. ');
840:
841: IF (CHECK_VER3_NOT_EMPTY(p_online => 'F') = 'F') THEN
842: print_time(' No data in ver3, returning. ');

Line 846: Pji_Fm_Plan_Maint_Pvt.GET_GLOBAL_EXCHANGE_RATES;

842: print_time(' No data in ver3, returning. ');
843: RETURN;
844: END IF;
845:
846: Pji_Fm_Plan_Maint_Pvt.GET_GLOBAL_EXCHANGE_RATES;
847: print_time(' Got global exchange rates. ');
848:
849: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
850: print_time('Populated RBS header table.');

Line 849: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;

845:
846: Pji_Fm_Plan_Maint_Pvt.GET_GLOBAL_EXCHANGE_RATES;
847: print_time(' Got global exchange rates. ');
848:
849: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
850: print_time('Populated RBS header table.');
851:
852: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;
853: print_time('Populated WBS header table.');

Line 852: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;

848:
849: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
850: print_time('Populated RBS header table.');
851:
852: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;
853: print_time('Populated WBS header table.');
854:
855: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
856: print_time(' Extracted plan data for primary RBSes.');

Line 855: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;

851:
852: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;
853: print_time('Populated WBS header table.');
854:
855: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
856: print_time(' Extracted plan data for primary RBSes.');
857:
858: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
859: print_time(' Extracted plan data for primary RBSes.');

Line 858: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;

854:
855: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
856: print_time(' Extracted plan data for primary RBSes.');
857:
858: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
859: print_time(' Extracted plan data for primary RBSes.');
860:
861: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;
862: print_time(' Deleted global exchange rates. ');

Line 861: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;

857:
858: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
859: print_time(' Extracted plan data for primary RBSes.');
860:
861: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;
862: print_time(' Deleted global exchange rates. ');
863:
864: Pji_Fm_Plan_Maint_Pvt.PRORATE_TO_ALL_CALENDARS;
865: print_time(' Prorated to all calendars. ');

Line 864: Pji_Fm_Plan_Maint_Pvt.PRORATE_TO_ALL_CALENDARS;

860:
861: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;
862: print_time(' Deleted global exchange rates. ');
863:
864: Pji_Fm_Plan_Maint_Pvt.PRORATE_TO_ALL_CALENDARS;
865: print_time(' Prorated to all calendars. ');
866:
867: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;
868: print_time(' Updated the WBS header table with min max txn dates.');

Line 867: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;

863:
864: Pji_Fm_Plan_Maint_Pvt.PRORATE_TO_ALL_CALENDARS;
865: print_time(' Prorated to all calendars. ');
866:
867: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;
868: print_time(' Updated the WBS header table with min max txn dates.');
869:
870: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
871: print_time(' Inserted Reversal records for dangling plans.');

Line 870: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;

866:
867: PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR;
868: print_time(' Updated the WBS header table with min max txn dates.');
869:
870: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
871: print_time(' Inserted Reversal records for dangling plans.');
872:
873: Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');
874: print_time('Marked dangling versions.. ');

Line 873: Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');

869:
870: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
871: print_time(' Inserted Reversal records for dangling plans.');
872:
873: Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');
874: print_time('Marked dangling versions.. ');
875: -- Back from unlock headers because at the time of dangling its not marking
876: -- due to purge before unlock headers bug 5155692
877:

Line 1586: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(

1582:
1583: print_time(' PULL_PLANS_FOR_PR value of p_plan_type_id is ' || p_plan_type_id || ' and p_rbs_version_id is ' || p_rbs_version_id );
1584:
1585:
1586: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(
1587: p_rbs_version_id => p_rbs_version_id
1588: , p_plan_type_id => p_plan_type_id
1589: , p_context => p_context
1590: , x_num_rows => l_num_rows

Line 1603: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;

1599: RETURN;
1600: END IF;
1601:
1602:
1603: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
1604: print_time('Populated new records into RBS Header Table.');
1605:
1606: -- Retrieve overridden ETC values for latest published WP structures in budget lines table.
1607: -- PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;

Line 1607: -- PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;

1603: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
1604: print_time('Populated new records into RBS Header Table.');
1605:
1606: -- Retrieve overridden ETC values for latest published WP structures in budget lines table.
1607: -- PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;
1608: print_time('Retrieved overridden ETC values.');
1609:
1610: -- Pull primary slice for workplans and relevant fin plans.
1611: -- Do not pull actuals/overriddend ETC values, they are extracted in "get plan res actuals" flow.

Line 1612: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS ;

1608: print_time('Retrieved overridden ETC values.');
1609:
1610: -- Pull primary slice for workplans and relevant fin plans.
1611: -- Do not pull actuals/overriddend ETC values, they are extracted in "get plan res actuals" flow.
1612: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS ;
1613: print_time('Extracted workplan data.');
1614:
1615: -- Plan lines for ETCs are populated in get plan res actuals flow.
1616: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );

Line 1616: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );

1612: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS ;
1613: print_time('Extracted workplan data.');
1614:
1615: -- Plan lines for ETCs are populated in get plan res actuals flow.
1616: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );
1617: -- print_time('Delete processed plan lines.');
1618:
1619: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;
1620: print_time(' Got global exchange rates. ');

Line 1619: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;

1615: -- Plan lines for ETCs are populated in get plan res actuals flow.
1616: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );
1617: -- print_time('Delete processed plan lines.');
1618:
1619: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;
1620: print_time(' Got global exchange rates. ');
1621:
1622: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12
1623: (p_pull_dangling_flag => 'N');

Line 1622: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12

1618:
1619: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;
1620: print_time(' Got global exchange rates. ');
1621:
1622: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12
1623: (p_pull_dangling_flag => 'N');
1624: print_time('Extracted finplan data for pri RBS for secondary currencies as well.');
1625:
1626: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12

Line 1626: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12

1622: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12
1623: (p_pull_dangling_flag => 'N');
1624: print_time('Extracted finplan data for pri RBS for secondary currencies as well.');
1625:
1626: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12
1627: (p_pull_dangling_flag => 'N');
1628: print_time('Extracted finplan data for Secondary RBS for secondary currencies as well.');
1629:
1630: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS ;

Line 1630: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS ;

1626: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12
1627: (p_pull_dangling_flag => 'N');
1628: print_time('Extracted finplan data for Secondary RBS for secondary currencies as well.');
1629:
1630: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS ;
1631: print_time('Prorated Fin plan data to all calendars.');
1632:
1633:
1634: --

Line 1688: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(

1684: Pji_Fm_Xbs_Accum_Maint.debug_plan_lines;
1685:
1686:
1687: -- Populate ver3 table.
1688: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(
1689: p_rbs_version_id => NULL
1690: , p_plan_type_id => NULL
1691: , p_context => p_extr_type
1692: , x_num_rows => l_num_rows

Line 1706: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;

1702: RETURN;
1703: END IF;
1704:
1705:
1706: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
1707: print_time('Populated new records into RBS Header Table.');
1708:
1709:
1710: -- Extract actuals from budget lines for FULL summarization.

Line 1711: pji_fm_plan_maint_pvt.EXTRACT_ACTUALS(

1707: print_time('Populated new records into RBS Header Table.');
1708:
1709:
1710: -- Extract actuals from budget lines for FULL summarization.
1711: pji_fm_plan_maint_pvt.EXTRACT_ACTUALS(
1712: p_extrn_type => p_extr_type
1713: );
1714: print_time('Actuals/etc extraction.');
1715:

Line 1720: --PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );

1716: --
1717: -- WBS and RBS headers will be populated in PROCESS_PENDING_PLAN_UPDATES
1718: --
1719:
1720: --PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );
1721: --print_time('Delete processed plan lines for this worker id.');
1722:
1723: --
1724: -- All rollups are done for plans along with actuals from the calling