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_RES_ACCUMS dependencies on PA_TXN_ACCUM

Line 984: pa_txn_accum pta

980: pta.non_labor_resource_org_id,
981: pta.event_type_classification,
982: pta.system_linkage_function
983: FROM
984: pa_txn_accum pta
985: WHERE
986: pta.project_id = x_project_id
987: AND ((pta.actual_cost_rollup_flag = DECODE(x_mode,'I','Y',
988: 'F',pta.actual_cost_rollup_flag,

Line 1000: FROM pa_txn_accum_details ptad

996: 'F',pta.cmt_rollup_flag,
997: pta.cmt_rollup_flag)))
998: AND EXISTS
999: ( SELECT 'Yes'
1000: FROM pa_txn_accum_details ptad
1001: WHERE pta.txn_accum_id = ptad.txn_accum_id
1002: );
1003:
1004: txnaccumrec seltxnaccums%ROWTYPE;

Line 1094: -- Now process all the eligible pa_txn_accum

1090: ' Member id= '|| to_char(x_resources_in(res_count).resource_list_member_id));
1091:
1092: END LOOP; */
1093:
1094: -- Now process all the eligible pa_txn_accum
1095:
1096: -- Get the txns for which mapping is to be done
1097: FOR txnaccumrec IN seltxnaccums LOOP
1098:

Line 1565: -- no records in pa_txn_accum table need to be rolled up

1561:
1562:
1563: EXCEPTION
1564: -- Return if either no resource list are assigned to the project and/or
1565: -- no records in pa_txn_accum table need to be rolled up
1566:
1567: WHEN NO_DATA_FOUND THEN
1568: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1569: pa_debug.debug('old_map_txns: ' || 'Exception Raised on Procedure map_txns');

Line 1695: NULL, /* Project role id is not there on pa_txn_accum */

1691: pta.revenue_category,
1692: pta.non_labor_resource_org_id,
1693: pta.event_type_classification,
1694: pta.system_linkage_function,
1695: NULL, /* Project role id is not there on pa_txn_accum */
1696: l_resource_list_id,
1697: pta.txn_accum_id, /* To identify our records back */
1698: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */
1699: pta.task_id /* pa_resource_accum_details table */

Line 1698: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */

1694: pta.system_linkage_function,
1695: NULL, /* Project role id is not there on pa_txn_accum */
1696: l_resource_list_id,
1697: pta.txn_accum_id, /* To identify our records back */
1698: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */
1699: pta.task_id /* pa_resource_accum_details table */
1700: FROM pa_txn_accum pta
1701: WHERE pta.project_id = x_project_id
1702: AND ((pta.actual_cost_rollup_flag = 'Y') OR

Line 1700: FROM pa_txn_accum pta

1696: l_resource_list_id,
1697: pta.txn_accum_id, /* To identify our records back */
1698: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */
1699: pta.task_id /* pa_resource_accum_details table */
1700: FROM pa_txn_accum pta
1701: WHERE pta.project_id = x_project_id
1702: AND ((pta.actual_cost_rollup_flag = 'Y') OR
1703: (pta.revenue_rollup_flag = 'Y') OR
1704: (pta.cmt_rollup_flag = 'Y') )

Line 1716: FROM pa_txn_accum_details ptad

1712: 'F',pta.cmt_rollup_flag,
1713: pta.cmt_rollup_flag))) 5571792 */
1714: AND EXISTS
1715: (SELECT 'Yes'
1716: FROM pa_txn_accum_details ptad
1717: WHERE pta.txn_accum_id = ptad.txn_accum_id
1718: /* following not exists will be valid even in case of refresh ( x_mode = 'F' )
1719: because from refresh process we call map_txns only after we have
1720: deleted records from pa_resource_accum_details table */

Line 1764: NULL, /* Project role id is not there on pa_txn_accum */

1760: pta.revenue_category,
1761: pta.non_labor_resource_org_id,
1762: pta.event_type_classification,
1763: pta.system_linkage_function,
1764: NULL, /* Project role id is not there on pa_txn_accum */
1765: l_resource_list_id,
1766: pta.txn_accum_id, /* To identify our records back */
1767: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */
1768: pta.task_id /* pa_resource_accum_details table */

Line 1767: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */

1763: pta.system_linkage_function,
1764: NULL, /* Project role id is not there on pa_txn_accum */
1765: l_resource_list_id,
1766: pta.txn_accum_id, /* To identify our records back */
1767: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */
1768: pta.task_id /* pa_resource_accum_details table */
1769: FROM pa_txn_accum pta
1770: WHERE pta.project_id = x_project_id
1771: AND EXISTS

Line 1769: FROM pa_txn_accum pta

1765: l_resource_list_id,
1766: pta.txn_accum_id, /* To identify our records back */
1767: pta.project_id, /* This will avoid joining to pa_txn_accum again during insertion */
1768: pta.task_id /* pa_resource_accum_details table */
1769: FROM pa_txn_accum pta
1770: WHERE pta.project_id = x_project_id
1771: AND EXISTS
1772: (SELECT 'Yes'
1773: FROM pa_txn_accum_details ptad

Line 1773: FROM pa_txn_accum_details ptad

1769: FROM pa_txn_accum pta
1770: WHERE pta.project_id = x_project_id
1771: AND EXISTS
1772: (SELECT 'Yes'
1773: FROM pa_txn_accum_details ptad
1774: WHERE pta.txn_accum_id = ptad.txn_accum_id
1775: /* following not exists will be valid even in case of refresh ( x_mode = 'F' )
1776: because from refresh process we call map_txns only after we have
1777: deleted records from pa_resource_accum_details table */