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_RESOURCE_ACCUM_DETAILS

Line 587: -- We will not allow to have multiple PA_RESOURCE_ACCUM_DETAILS

583: RETURN NULL;
584: END get_group_resource_type_code;
585:
586: -- This procedure created resource accum details
587: -- We will not allow to have multiple PA_RESOURCE_ACCUM_DETAILS
588: -- for the same TXN_ACCUM_ID and different resource_id and
589: -- pa_resource_list_member_id
590:
591: PROCEDURE create_resource_accum_details

Line 611: INSERT INTO pa_resource_accum_details

607: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
608: pa_debug.debug('old_map_txns: ' || x_err_stage);
609: END IF;
610:
611: INSERT INTO pa_resource_accum_details
612: (resource_list_id,
613: resource_list_assignment_id,
614: resource_list_member_id,
615: resource_id,

Line 649: pa_resource_accum_details rad

645: WHERE NOT EXISTS
646: (SELECT
647: 'Yes'
648: FROM
649: pa_resource_accum_details rad
650: WHERE
651: resource_list_id = x_resource_list_id
652: AND resource_list_assignment_id = x_resource_list_assignment_id
653: /*

Line 692: pa_resource_accum_details

688:
689: LOOP
690: IF (x_resource_list_id IS NULL) THEN
691: DELETE
692: pa_resource_accum_details
693: WHERE
694: resource_list_assignment_id =
695: NVL(x_resource_list_assignment_id,resource_list_assignment_id)
696: AND project_id = x_project_id

Line 701: pa_resource_accum_details

697: and rownum <= pa_proj_accum_main.x_commit_size;
698: ELSE
699:
700: DELETE
701: pa_resource_accum_details
702: WHERE
703: resource_list_assignment_id =
704: NVL(x_resource_list_assignment_id,resource_list_assignment_id)
705: AND resource_list_id = x_resource_list_id

Line 1160: -- Now create pa_resource_accum_details

1156: txnaccumrec.system_linkage_function,
1157: x_err_stage,
1158: x_err_code);
1159:
1160: -- Now create pa_resource_accum_details
1161:
1162: create_resource_accum_details
1163: (current_rl_id,
1164: current_rl_assignment_id,

Line 1280: -- Now create pa_resource_accum_details

1276: mapping_done := TRUE;
1277: end if;
1278:
1279: if mapping_done then
1280: -- Now create pa_resource_accum_details
1281: create_resource_accum_details
1282: (current_rl_id,
1283: current_rl_assignment_id,
1284: old_rl_member_id,

Line 1541: -- Now create pa_resource_accum_details

1537: txnaccumrec.system_linkage_function,
1538: x_err_stage,
1539: x_err_code);
1540:
1541: -- Now create pa_resource_accum_details
1542:
1543: create_resource_accum_details
1544: (current_rl_id,
1545: current_rl_assignment_id,

Line 1607: result in NULL insert into PA_RESOURCE_ACCUM_DETAILS. This cursor is called

1603: AND res.resource_list_id = prla.resource_list_id
1604: AND NVL(res.MIGRATION_CODE,'-99') <> 'N';
1605:
1606: /* This cursor is used print all the attribute details of the txns which
1607: result in NULL insert into PA_RESOURCE_ACCUM_DETAILS. This cursor is called
1608: only during NULL insert exception (resource_id and resource_list_member_id can
1609: be NULL if MAP_TXNS has failed to derive the same) */
1610:
1611: CURSOR C2 IS

Line 1632: FROM pa_resource_accum_details rad

1628: system_reference3 task_id
1629: FROM PA_MAPPABLE_TXNS_TMP pmt
1630: WHERE NOT EXISTS
1631: (SELECT 'Yes'
1632: FROM pa_resource_accum_details rad
1633: WHERE resource_list_id = l_resource_list_id
1634: AND resource_list_assignment_id = l_resource_list_assignment_id
1635: AND txn_accum_id = pmt.system_reference1
1636: AND project_id = pmt.system_reference2

Line 1699: pta.task_id /* pa_resource_accum_details table */

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
1703: (pta.revenue_rollup_flag = 'Y') OR

Line 1720: deleted records from pa_resource_accum_details table */

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 */
1721: AND NOT EXISTS
1722: (SELECT 'Yes'
1723: FROM pa_resource_accum_details prad
1724: WHERE prad.txn_accum_id = pta.txn_accum_id

Line 1723: FROM pa_resource_accum_details prad

1719: because from refresh process we call map_txns only after we have
1720: deleted records from pa_resource_accum_details table */
1721: AND NOT EXISTS
1722: (SELECT 'Yes'
1723: FROM pa_resource_accum_details prad
1724: WHERE prad.txn_accum_id = pta.txn_accum_id
1725: AND resource_list_id = l_resource_list_id
1726: AND resource_list_assignment_id = l_resource_list_assignment_id
1727: )

Line 1768: pta.task_id /* pa_resource_accum_details table */

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
1772: (SELECT 'Yes'

Line 1777: deleted records from pa_resource_accum_details table */

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 */
1778: AND NOT EXISTS
1779: (SELECT 'Yes'
1780: FROM pa_resource_accum_details prad
1781: WHERE prad.txn_accum_id = pta.txn_accum_id

Line 1780: FROM pa_resource_accum_details prad

1776: because from refresh process we call map_txns only after we have
1777: deleted records from pa_resource_accum_details table */
1778: AND NOT EXISTS
1779: (SELECT 'Yes'
1780: FROM pa_resource_accum_details prad
1781: WHERE prad.txn_accum_id = pta.txn_accum_id
1782: AND resource_list_id = l_resource_list_id
1783: AND resource_list_assignment_id = l_resource_list_assignment_id
1784: )

Line 1831: x_err_stage := 'Inserting into pa_resource_accum_details';

1827: null_insert EXCEPTION;
1828: PRAGMA EXCEPTION_INIT(null_insert,-1400);
1829:
1830: BEGIN
1831: x_err_stage := 'Inserting into pa_resource_accum_details';
1832: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1833: pa_debug.debug('map_txns: ' || x_err_stage);
1834: END IF;
1835:

Line 1836: INSERT INTO pa_resource_accum_details

1832: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1833: pa_debug.debug('map_txns: ' || x_err_stage);
1834: END IF;
1835:
1836: INSERT INTO pa_resource_accum_details
1837: (resource_list_id,
1838: resource_list_assignment_id,
1839: resource_list_member_id,
1840: resource_id,

Line 1871: FROM pa_resource_accum_details rad

1867: x_program_id
1868: FROM PA_MAPPABLE_TXNS_TMP pmt
1869: WHERE NOT EXISTS
1870: (SELECT 'Yes'
1871: FROM pa_resource_accum_details rad
1872: WHERE resource_list_id = l_resource_list_id
1873: AND resource_list_assignment_id = l_resource_list_assignment_id
1874: AND txn_accum_id = pmt.system_reference1
1875: AND project_id = pmt.system_reference2

Line 1910: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount || ' rows into PA_RESOURCE_ACCUM_DETAILS');

1906: RAISE;
1907: END;
1908:
1909: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1910: pa_debug.debug('map_txns: ' || 'Inserted ' || sql%rowcount || ' rows into PA_RESOURCE_ACCUM_DETAILS');
1911: END IF;
1912:
1913: COMMIT;
1914: END IF; /* PA_MAPPABLE_TXNS_TMP%rowcount check */