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.PA_PROJ_ACCUM_MAIN dependencies on PA_TXN_ACCUM

Line 859: -- exist in pa_txn_accum

855: -- PT is when the accumulation period type has changed,
856: -- since the previous accumulation
857: -- PR is when the current reporting period is moved forward.
858: -- TX is when unaccumulated transactions (cdls and rdls)
859: -- exist in pa_txn_accum
860: -- TM is when unaccumulated commitments exist in pa_txn_accum
861:
862: CURSOR all_projs IS
863: SELECT DISTINCT pfa.project_id, pfa.segment1

Line 860: -- TM is when unaccumulated commitments exist in pa_txn_accum

856: -- since the previous accumulation
857: -- PR is when the current reporting period is moved forward.
858: -- TX is when unaccumulated transactions (cdls and rdls)
859: -- exist in pa_txn_accum
860: -- TM is when unaccumulated commitments exist in pa_txn_accum
861:
862: CURSOR all_projs IS
863: SELECT DISTINCT pfa.project_id, pfa.segment1
864: FROM pa_projects_for_accum pfa

Line 1201: FROM pa_txn_accum txn

1197: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1198: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1199: AND (x_actual_cost_flag = 'Y' OR x_revenue_flag = 'Y')
1200: AND EXISTS (SELECT 'x'
1201: FROM pa_txn_accum txn
1202: WHERE txn.actual_cost_rollup_flag = 'Y'
1203: AND txn.project_id = proj.project_id
1204: AND x_actual_cost_flag = 'Y'
1205: UNION ALL

Line 1207: FROM pa_txn_accum txn_r

1203: AND txn.project_id = proj.project_id
1204: AND x_actual_cost_flag = 'Y'
1205: UNION ALL
1206: SELECT 'x'
1207: FROM pa_txn_accum txn_r
1208: WHERE txn_r.revenue_rollup_flag = 'Y'
1209: AND txn_r.project_id = proj.project_id
1210: AND x_revenue_flag = 'Y')
1211: UNION ALL

Line 1220: FROM pa_txn_accum txn_m

1216: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1217: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1218: AND x_commitments_flag = 'Y'
1219: AND EXISTS (SELECT 'x'
1220: FROM pa_txn_accum txn_m
1221: WHERE txn_m.cmt_rollup_flag = 'Y'
1222: AND txn_m.project_id = proj.project_id
1223: AND x_commitments_flag = 'Y')
1224: ;

Line 1486: Pa_Txn_Accums.get_accum_configurations

1482:
1483: END IF ;
1484:
1485: x_summ_process := 'UP';
1486: Pa_Txn_Accums.get_accum_configurations
1487: (l_project_id,
1488: x_err_stage,
1489: x_err_code);
1490:

Line 1516: -- incrementally accumulate actuals txns to PA_TXN_ACCUM

1512: (x_action_flag => 'CS',
1513: x_actions_in => x_actions_in,
1514: x_actions_cnt => x_actions_cnt) = 'Y')) THEN
1515:
1516: -- incrementally accumulate actuals txns to PA_TXN_ACCUM
1517: IF x_log_summ_mode = 'Y' THEN
1518: x_CdlStart := SYSDATE; /* Start time for CDLs */
1519: END IF;
1520:

Line 1521: Pa_Txn_Accums.accum_cdls

1517: IF x_log_summ_mode = 'Y' THEN
1518: x_CdlStart := SYSDATE; /* Start time for CDLs */
1519: END IF;
1520:
1521: Pa_Txn_Accums.accum_cdls
1522: (l_project_id, -- start_project_id
1523: l_project_id, -- end_project_id
1524: x_start_pa_date, -- start_pa_period
1525: x_date_through, -- end_pa_period

Line 1542: Pa_Txn_Accums.accum_cdls

1538: Pa_Debug.debug('proj_accum: Call Accum_Cdls with x_cdl_line_type = I' );
1539: END IF;
1540:
1541:
1542: Pa_Txn_Accums.accum_cdls
1543: (l_project_id, -- start_project_id
1544: l_project_id, -- end_project_id
1545: x_start_pa_date, -- start_pa_period
1546: x_date_through, -- end_pa_period

Line 1570: Pa_Txn_Accums.accum_revenue

1566:
1567: IF x_log_summ_mode = 'Y' THEN
1568: x_RdlStart := SYSDATE; /* Start time for RDLs */
1569: END IF;
1570: Pa_Txn_Accums.accum_revenue
1571: (l_project_id, -- start_project_id
1572: l_project_id, -- end_project_id
1573: x_start_pa_date, -- start_pa_period
1574: x_date_through, -- end_pa_period

Line 1596: -- pa_txn_accum to Zero for commitments

1592: x_err_stack,
1593: x_err_stage,
1594: x_err_code) ;
1595: -- Initialize the commitment figures in
1596: -- pa_txn_accum to Zero for commitments
1597:
1598: Pa_Txn_Accums.refresh_txn_accum
1599: (l_project_id, -- start_project_id
1600: l_project_id, -- end_project_id

Line 1598: Pa_Txn_Accums.refresh_txn_accum

1594: x_err_code) ;
1595: -- Initialize the commitment figures in
1596: -- pa_txn_accum to Zero for commitments
1597:
1598: Pa_Txn_Accums.refresh_txn_accum
1599: (l_project_id, -- start_project_id
1600: l_project_id, -- end_project_id
1601: x_start_pa_date, -- start_pa_period
1602: x_end_pa_date, -- end_pa_period

Line 1612: Pa_Txn_Accums.create_cmt_txns

1608: -- Create new commitments in the pa_commitment_txns
1609: IF x_log_summ_mode = 'Y' THEN
1610: x_CmtcrStart := SYSDATE; --Start time for CMT creation
1611: END IF;
1612: Pa_Txn_Accums.create_cmt_txns
1613: (l_project_id, -- start_project_id
1614: l_project_id, -- end_project_id
1615: x_system_linkage_function,
1616: x_err_stage,

Line 1631: -- pa_commitment_txns to pa_txn_accum

1627: stage=>x_stage ,
1628: x_run_id=>x_run_id);
1629:
1630: -- accumulate the commitments from
1631: -- pa_commitment_txns to pa_txn_accum
1632: IF x_log_summ_mode = 'Y' THEN
1633: x_CmtaccStart := SYSDATE; /* Start time for CMT accum */
1634: END IF;
1635: Pa_Txn_Accums.accum_commitments

Line 1635: Pa_Txn_Accums.accum_commitments

1631: -- pa_commitment_txns to pa_txn_accum
1632: IF x_log_summ_mode = 'Y' THEN
1633: x_CmtaccStart := SYSDATE; /* Start time for CMT accum */
1634: END IF;
1635: Pa_Txn_Accums.accum_commitments
1636: (l_project_id, -- start_project_id
1637: l_project_id, -- end_project_id
1638: x_system_linkage_function,
1639: x_err_stage,

Line 1848: -- -- rollup the commitments from pa_txn_accum to

1844: -- x_actions_cnt => x_actions_cnt) = 'Y'
1845: -- AND x_commitments_flag = 'Y')
1846: -- THEN
1847: --
1848: -- -- rollup the commitments from pa_txn_accum to
1849: -- -- pa_project_accum_commitments
1850: -- IF x_log_summ_mode = 'Y' THEN
1851: -- -- Start time for Process txn accum cmt
1852: -- x_PrcCmtStart := SYSDATE;

Line 1899: -- rollup the actuals from pa_txn_accum to

1895: x_actions_in => x_actions_in,
1896: x_actions_cnt => x_actions_cnt) = 'Y'
1897: AND x_commitments_flag = 'Y') THEN
1898:
1899: -- rollup the actuals from pa_txn_accum to
1900: -- pa_project_accum_actuals
1901: -- Process the transactions by reading PA_TXN_ACCUM
1902: IF x_log_summ_mode = 'Y' THEN
1903: -- Start time for Process Txn Accum

Line 1901: -- Process the transactions by reading PA_TXN_ACCUM

1897: AND x_commitments_flag = 'Y') THEN
1898:
1899: -- rollup the actuals from pa_txn_accum to
1900: -- pa_project_accum_actuals
1901: -- Process the transactions by reading PA_TXN_ACCUM
1902: IF x_log_summ_mode = 'Y' THEN
1903: -- Start time for Process Txn Accum
1904: x_PrcTxnStart := SYSDATE;
1905: x_PrcCmtStart := SYSDATE;

Line 2284: Pa_Txn_Accums.get_accum_configurations

2280: -------------------------------------------------
2281:
2282: -- Get the accum configuration
2283:
2284: Pa_Txn_Accums.get_accum_configurations
2285: (projrec.project_id,
2286: x_err_stage,
2287: x_err_code);
2288:

Line 2340: Pa_Txn_Accums.update_resource_flag

2336: x_err_code);
2337:
2338: ------- updating resource_accumulated_flag if through_date is null
2339: IF x_end_date_through IS NOT NULL THEN
2340: Pa_Txn_Accums.update_resource_flag
2341: (projrec.project_id,
2342: projrec.project_id,
2343: x_start_pa_date,
2344: x_end_pa_date,

Line 2348: -- refresh the actuals txns to PA_TXN_ACCUM

2344: x_end_pa_date,
2345: x_err_stage,
2346: x_err_code);
2347: END IF;
2348: -- refresh the actuals txns to PA_TXN_ACCUM
2349:
2350: Pa_Txn_Accums.refresh_txn_accum
2351: (projrec.project_id, -- start_project_id
2352: projrec.project_id, -- end_project_id

Line 2350: Pa_Txn_Accums.refresh_txn_accum

2346: x_err_code);
2347: END IF;
2348: -- refresh the actuals txns to PA_TXN_ACCUM
2349:
2350: Pa_Txn_Accums.refresh_txn_accum
2351: (projrec.project_id, -- start_project_id
2352: projrec.project_id, -- end_project_id
2353: x_start_pa_date, -- start_pa_period
2354: x_end_pa_date, -- end_pa_period

Line 2360: Pa_Txn_Accums.refresh_txn_accum

2356: NULL,
2357: x_err_stage,
2358: x_err_code);
2359:
2360: Pa_Txn_Accums.refresh_txn_accum
2361: (projrec.project_id, -- start_project_id
2362: projrec.project_id, -- end_project_id
2363: x_start_pa_date, -- start_pa_period
2364: x_end_pa_date, -- end_pa_period

Line 2377: Pa_Txn_Accums.accum_cdls

2373: IF x_log_summ_mode = 'Y' THEN
2374: x_CdlStart := SYSDATE; /* Start time for CDLs */
2375: END IF;
2376:
2377: Pa_Txn_Accums.accum_cdls
2378: (projrec.project_id, -- start_project_id
2379: projrec.project_id, -- end_project_id
2380: x_start_pa_date, -- start_pa_period
2381: x_date_through, -- end_pa_period

Line 2397: Pa_Txn_Accums.accum_cdls

2393: THEN
2394: Pa_Debug.debug('proj_accum: Call Accum_Cdls with x_cdl_line_type = I' );
2395: END IF;
2396:
2397: Pa_Txn_Accums.accum_cdls
2398: (projrec.project_id, -- start_project_id
2399: projrec.project_id, -- end_project_id
2400: x_start_pa_date, -- start_pa_period
2401: x_date_through, -- end_pa_period

Line 2419: Pa_Txn_Accums.accum_revenue

2415:
2416: x_RdlStart := SYSDATE; /* Start time for RDLs */
2417: END IF;
2418:
2419: Pa_Txn_Accums.accum_revenue
2420: (projrec.project_id, -- start_project_id
2421: projrec.project_id, -- end_project_id
2422: x_start_pa_date, -- start_pa_period
2423: x_date_through, -- end_pa_period

Line 2434: Pa_Txn_Accums.refresh_txn_accum

2430:
2431: -- now refresh the commitments
2432: -- please note that the commitments are always refreshed
2433:
2434: Pa_Txn_Accums.refresh_txn_accum
2435: (projrec.project_id, -- start_project_id
2436: projrec.project_id, -- end_project_id
2437: x_start_pa_date, -- start_pa_period
2438: x_end_pa_date, -- end_pa_period

Line 2448: Pa_Txn_Accums.create_cmt_txns

2444: IF x_log_summ_mode = 'Y' THEN
2445: x_CmtCrStart := SYSDATE; /* Start time for CMTs creation */
2446: END IF;
2447:
2448: Pa_Txn_Accums.create_cmt_txns
2449: (projrec.project_id, -- start_project_id
2450: projrec.project_id, -- end_project_id
2451: NULL,
2452: x_err_stage,

Line 2468: Pa_Txn_Accums.accum_commitments

2464: status=>x_status,
2465: stage=>x_stage ,
2466: x_run_id=>x_run_id);
2467:
2468: Pa_Txn_Accums.accum_commitments
2469: (projrec.project_id, -- start_project_id
2470: projrec.project_id, -- end_project_id
2471: NULL,
2472: x_err_stage,

Line 2495: -- Process the transactions by reading PA_TXN_ACCUM

2491: x_PrcCmtStart := SYSDATE; /* Start time process_txn_accum_cmt */
2492: END IF;
2493:
2494: -- refresh actuals
2495: -- Process the transactions by reading PA_TXN_ACCUM
2496: Pa_Maint_Project_Accums.process_txn_accum
2497: ( projrec.project_id,
2498: x_impl_option,
2499: x_proj_level_accum_id,

Line 3307: Pa_Txn_Accums.get_accum_configurations

3303: Pa_Proj_Accum_Main.initialize_project(projrec.project_id, l_accum_period_type_changed);
3304:
3305: -- Get the accum configuration
3306:
3307: Pa_Txn_Accums.get_accum_configurations
3308: ( projrec.project_id,
3309: x_err_stage,
3310: x_err_code);
3311:

Line 3354: -- refresh and accumulate the actuals txns to PA_TXN_ACCUM

3350: x_err_stack,
3351: x_err_stage,
3352: x_err_code);
3353:
3354: -- refresh and accumulate the actuals txns to PA_TXN_ACCUM
3355: -- First call the refresh APIs
3356:
3357: Pa_Txn_Accums.refresh_txn_accum
3358: (projrec.project_id, -- start_project_id

Line 3357: Pa_Txn_Accums.refresh_txn_accum

3353:
3354: -- refresh and accumulate the actuals txns to PA_TXN_ACCUM
3355: -- First call the refresh APIs
3356:
3357: Pa_Txn_Accums.refresh_txn_accum
3358: (projrec.project_id, -- start_project_id
3359: projrec.project_id, -- end_project_id
3360: x_start_pa_date, -- start_pa_period
3361: x_end_pa_date, -- end_pa_period

Line 3367: Pa_Txn_Accums.refresh_txn_accum

3363: x_system_linkage_function,
3364: x_err_stage,
3365: x_err_code);
3366:
3367: Pa_Txn_Accums.refresh_txn_accum
3368: (projrec.project_id, -- start_project_id
3369: projrec.project_id, -- end_project_id
3370: x_start_pa_date, -- start_pa_period
3371: x_end_pa_date, -- end_pa_period

Line 3378: Pa_Txn_Accums.accum_cdls

3374: -- cannot be specified for Rev.
3375: x_err_stage,
3376: x_err_code);
3377:
3378: Pa_Txn_Accums.accum_cdls
3379: (projrec.project_id, -- start_project_id
3380: projrec.project_id, -- end_project_id
3381: x_start_pa_date, -- start_pa_period
3382: x_end_pa_date, -- end_pa_period

Line 3400: Pa_Txn_Accums.accum_cdls

3396: THEN
3397: Pa_Debug.debug('build_txn_accum: Call Accum_Cdls with x_cdl_line_type = I' );
3398: END IF;
3399:
3400: Pa_Txn_Accums.accum_cdls
3401: (projrec.project_id, -- start_project_id
3402: projrec.project_id, -- end_project_id
3403: x_start_pa_date, -- start_pa_period
3404: x_end_pa_date, -- end_pa_period

Line 3415: Pa_Txn_Accums.accum_revenue

3411: END IF;
3412: -- --------------------------------------------------------------
3413:
3414:
3415: Pa_Txn_Accums.accum_revenue
3416: (projrec.project_id, -- start_project_id
3417: projrec.project_id, -- end_project_id
3418: x_start_pa_date, -- start_pa_period
3419: x_end_pa_date, -- end_pa_period

Line 3427: Pa_Txn_Accums.update_act_txn_accum

3423:
3424: -- Move the tot_ figures into i_ figures for other transactions
3425: -- which are not refreshed currently
3426:
3427: Pa_Txn_Accums.update_act_txn_accum
3428: ( projrec.project_id,
3429: projrec.project_id,
3430: x_err_stage,
3431: x_err_code);

Line 3438: Pa_Txn_Accums.refresh_txn_accum

3434:
3435: -- introduce the budgets API here
3436: -- first refresh the commitments
3437:
3438: Pa_Txn_Accums.refresh_txn_accum
3439: (projrec.project_id, -- start_project_id
3440: projrec.project_id, -- end_project_id
3441: x_start_pa_date, -- start_pa_period
3442: x_end_pa_date, -- end_pa_period

Line 3448: Pa_Txn_Accums.create_cmt_txns

3444: x_system_linkage_function,
3445: x_err_stage,
3446: x_err_code);
3447:
3448: Pa_Txn_Accums.create_cmt_txns
3449: (projrec.project_id, -- start_project_id
3450: projrec.project_id, -- end_project_id
3451: x_system_linkage_function,
3452: x_err_stage,

Line 3463: Pa_Txn_Accums.accum_commitments

3459: status=>x_status,
3460: stage=>x_stage ,
3461: x_run_id=>x_run_id);
3462:
3463: Pa_Txn_Accums.accum_commitments
3464: (projrec.project_id, -- start_project_id
3465: projrec.project_id, -- end_project_id
3466: x_system_linkage_function,
3467: x_err_stage,