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 840: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');

836: print_time('CREATE_SECONDARY_PVT: begin.. ');
837:
838: l_pji_schema := pji_utils.get_pji_schema_name; /* Added for bug 13897252 */
839:
840: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');
841: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');
842: print_time(' Identified plan versions to be extracted. ');
843:
844: /* Added for bug 13897252 starts */

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

837:
838: l_pji_schema := pji_utils.get_pji_schema_name; /* Added for bug 13897252 */
839:
840: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');
841: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');
842: print_time(' Identified plan versions to be extracted. ');
843:
844: /* Added for bug 13897252 starts */
845: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

Line 858: Pji_Fm_Plan_Maint_Pvt.GET_GLOBAL_EXCHANGE_RATES;

854: print_time(' No data in ver3, returning. ');
855: RETURN;
856: END IF;
857:
858: Pji_Fm_Plan_Maint_Pvt.GET_GLOBAL_EXCHANGE_RATES;
859: print_time(' Got global exchange rates. ');
860:
861: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
862: print_time('Populated RBS header table.');

Line 861: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;

857:
858: Pji_Fm_Plan_Maint_Pvt.GET_GLOBAL_EXCHANGE_RATES;
859: print_time(' Got global exchange rates. ');
860:
861: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
862: print_time('Populated RBS header table.');
863:
864: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;
865: print_time('Populated WBS header table.');

Line 864: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;

860:
861: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
862: print_time('Populated RBS header table.');
863:
864: Pji_Fm_Plan_Maint_Pvt.POPULATE_WBS_HDR;
865: print_time('Populated WBS header table.');
866:
867: -- Bug 15881881
868: -- Commented for bug 16360282

Line 873: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;

869: /*fnd_stats.gather_table_stats('PA','PA_RESOURCE_ASSIGNMENTS',PERCENT=>40);
870: fnd_stats.gather_table_stats('PA','PA_BUDGET_LINES',PERCENT=>40); */
871: -- End Bug 15881881
872:
873: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
874: print_time(' Extracted plan data for primary RBSes.');
875:
876: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
877: print_time(' Extracted plan data for primary RBSes.');

Line 876: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;

872:
873: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
874: print_time(' Extracted plan data for primary RBSes.');
875:
876: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
877: print_time(' Extracted plan data for primary RBSes.');
878:
879: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;
880: print_time(' Deleted global exchange rates. ');

Line 879: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;

875:
876: Pji_Fm_Plan_Maint_Pvt.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
877: print_time(' Extracted plan data for primary RBSes.');
878:
879: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;
880: print_time(' Deleted global exchange rates. ');
881:
882: /* Added for bug 8708651 */
883: l_time_phase_flag := PJI_UTILS.GET_SETUP_PARAMETER('TIME_PHASE_FLAG');

Line 891: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS; /* Modified to PJI_FM_PLAN_MAINT_PVT

887: -- End Bug 15881881
888: if l_time_phase_flag = 'Y' then
889: null;
890: else
891: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS; /* Modified to PJI_FM_PLAN_MAINT_PVT
892: for bug 12996111 */
893: end if;
894: /* Added for bug 8708651 */
895: print_time(' Prorated to all calendars. ');

Line 897: -- PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR; /* Commented for bug 13897252 */

893: end if;
894: /* Added for bug 8708651 */
895: print_time(' Prorated to all calendars. ');
896:
897: -- PJI_FM_PLAN_MAINT_PVT.UPDATE_WBS_HDR; /* Commented for bug 13897252 */
898: -- print_time(' Updated the WBS header table with min max txn dates.');
899:
900: -- Bug 15881881
901: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);

Line 906: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;

902: -- Commented for bug 16360282
903: -- fnd_stats.gather_table_stats('PJI','PJI_FP_XBS_ACCUM_F',PERCENT=>40);
904: -- End Bug 15881881
905:
906: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
907: print_time(' Inserted Reversal records for dangling plans.');
908:
909: Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');
910: print_time('Marked dangling versions.. ');

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

905:
906: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
907: print_time(' Inserted Reversal records for dangling plans.');
908:
909: Pji_Fm_Plan_Maint_Pvt.MARK_EXTRACTED_PLANS('SEC');
910: print_time('Marked dangling versions.. ');
911: -- Back from unlock headers because at the time of dangling its not marking
912: -- due to purge before unlock headers bug 5155692
913:

Line 1640: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(

1636:
1637: 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 );
1638:
1639:
1640: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(
1641: p_rbs_version_id => p_rbs_version_id
1642: , p_plan_type_id => p_plan_type_id
1643: , p_context => p_context
1644: , x_num_rows => l_num_rows

Line 1657: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;

1653: RETURN;
1654: END IF;
1655:
1656:
1657: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
1658: print_time('Populated new records into RBS Header Table.');
1659:
1660: -- Retrieve overridden ETC values for latest published WP structures in budget lines table.
1661: -- PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;

Line 1661: -- PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;

1657: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
1658: print_time('Populated new records into RBS Header Table.');
1659:
1660: -- Retrieve overridden ETC values for latest published WP structures in budget lines table.
1661: -- PJI_FM_PLAN_MAINT_PVT.RETRIEVE_OVERRIDDEN_WP_ETC;
1662: print_time('Retrieved overridden ETC values.');
1663:
1664: -- Pull primary slice for workplans and relevant fin plans.
1665: -- Do not pull actuals/overriddend ETC values, they are extracted in "get plan res actuals" flow.

Line 1666: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS ;

1662: print_time('Retrieved overridden ETC values.');
1663:
1664: -- Pull primary slice for workplans and relevant fin plans.
1665: -- Do not pull actuals/overriddend ETC values, they are extracted in "get plan res actuals" flow.
1666: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS ;
1667: print_time('Extracted workplan data.');
1668:
1669: -- Plan lines for ETCs are populated in get plan res actuals flow.
1670: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );

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

1666: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_ETC_PRIRBS ;
1667: print_time('Extracted workplan data.');
1668:
1669: -- Plan lines for ETCs are populated in get plan res actuals flow.
1670: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );
1671: -- print_time('Delete processed plan lines.');
1672:
1673: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;
1674: print_time(' Got global exchange rates. ');

Line 1673: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;

1669: -- Plan lines for ETCs are populated in get plan res actuals flow.
1670: -- PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );
1671: -- print_time('Delete processed plan lines.');
1672:
1673: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;
1674: print_time(' Got global exchange rates. ');
1675:
1676: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12
1677: (p_pull_dangling_flag => 'N');

Line 1676: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12

1672:
1673: PJI_FM_PLAN_MAINT_PVT.GET_GLOBAL_EXCHANGE_RATES;
1674: print_time(' Got global exchange rates. ');
1675:
1676: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12
1677: (p_pull_dangling_flag => 'N');
1678: print_time('Extracted finplan data for pri RBS for secondary currencies as well.');
1679:
1680: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12

Line 1680: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12

1676: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12
1677: (p_pull_dangling_flag => 'N');
1678: print_time('Extracted finplan data for pri RBS for secondary currencies as well.');
1679:
1680: PJI_FM_PLAN_MAINT_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12
1681: (p_pull_dangling_flag => 'N');
1682: print_time('Extracted finplan data for Secondary RBS for secondary currencies as well.');
1683:
1684: /* Added for bug 8708651 */

Line 1690: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS ;

1686:
1687: if l_time_phase_flag = 'Y' then
1688: null;
1689: else
1690: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS ;
1691: print_time('Prorated Fin plan data to all calendars.');
1692: end if;
1693: /* Added for bug 8708651 */
1694: --

Line 1748: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(

1744: Pji_Fm_Xbs_Accum_Maint.debug_plan_lines;
1745:
1746:
1747: -- Populate ver3 table.
1748: PJI_FM_PLAN_MAINT_PVT.VALIDATE_SET_PR_PARAMS(
1749: p_rbs_version_id => NULL
1750: , p_plan_type_id => NULL
1751: , p_context => p_extr_type
1752: , x_num_rows => l_num_rows

Line 1766: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;

1762: RETURN;
1763: END IF;
1764:
1765:
1766: Pji_Fm_Plan_Maint_Pvt.POPULATE_RBS_HDR;
1767: print_time('Populated new records into RBS Header Table.');
1768:
1769:
1770: -- Extract actuals from budget lines for FULL summarization.

Line 1771: pji_fm_plan_maint_pvt.EXTRACT_ACTUALS(

1767: print_time('Populated new records into RBS Header Table.');
1768:
1769:
1770: -- Extract actuals from budget lines for FULL summarization.
1771: pji_fm_plan_maint_pvt.EXTRACT_ACTUALS(
1772: p_extrn_type => p_extr_type
1773: );
1774: print_time('Actuals/etc extraction.');
1775:

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

1776: --
1777: -- WBS and RBS headers will be populated in PROCESS_PENDING_PLAN_UPDATES
1778: --
1779:
1780: --PJI_FM_PLAN_MAINT_PVT.DELETE_PLAN_LINES ( x_return_status => x_return_status );
1781: --print_time('Delete processed plan lines for this worker id.');
1782:
1783: --
1784: -- All rollups are done for plans along with actuals from the calling