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_FUNDING_CORE dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 53: From Pa_summary_project_fundings

49: --dbms_output.put_line('Inside:PA_FUNDING_CORE.CHECK_FUND_ALLOCATED');
50: --dbms_output.put_line('Agreement_id = '||nvl(to_char(p_agreement_id),'NULL'));
51: Select sum(total_unbaselined_amount) , sum(total_baselined_amount)
52: Into l_total_unbaselined_amount, l_total_baselined_amount
53: From Pa_summary_project_fundings
54: Where agreement_id = p_agreement_id;
55: IF (nvl(l_total_unbaselined_amount, 0) = 0 AND
56: nvl(l_total_baselined_amount, 0) = 0) THEN
57: BEGIN

Line 105: From pa_summary_project_fundings

101: greatest(nvl(total_accrued_amount, 0),
102: nvl(total_billed_amount, 0),
103: nvl(total_baselined_amount, 0) +
104: nvl(total_unbaselined_amount, 0)))
105: From pa_summary_project_fundings
106: Where project_id = p_project_id
107: And agreement_id = p_agreement_id
108: And nvl(task_id, 0) = nvl(p_task_id, 0);
109: mflag number;

Line 595: FROM PA_SUMMARY_PROJECT_FUNDINGS spf

591: AND (P.multi_currency_billing_flag = 'Y'
592: OR (p.multi_currency_billing_flag = 'N'
593: AND p.projfunc_currency_code = a.agreement_currency_code))
594: AND not exists ( SELECT null
595: FROM PA_SUMMARY_PROJECT_FUNDINGS spf
596: WHERE spf.project_id = p.project_id
597: AND p.invproc_currency_type = 'FUNDING_CURRENCY'
598: AND spf.funding_currency_code <> a.agreement_currency_code
599: AND (spf.total_baselined_amount <> 0

Line 604: FROM PA_SUMMARY_PROJECT_FUNDINGS spf

600: OR spf.total_unbaselined_amount <> 0))
601: AND (nvl(p.template_flag,'N') = 'N'
602: OR ( p.template_flag = 'Y'
603: AND not exists ( select null
604: FROM PA_SUMMARY_PROJECT_FUNDINGS spf
605: where spf.project_id=p.project_id
606: and spf.agreement_id <> a.agreement_id))
607: )
608: AND (nvl(a.template_flag,'N') = 'N'

Line 611: FROM PA_SUMMARY_PROJECT_FUNDINGS spf

607: )
608: AND (nvl(a.template_flag,'N') = 'N'
609: OR ( a.template_flag = 'Y'
610: AND not exists ( select null
611: FROM PA_SUMMARY_PROJECT_FUNDINGS spf
612: where spf.project_id <> p.project_id
613: and spf.agreement_id = a.agreement_id))
614: ) ;
615:

Line 1303: --Description: This procedure inserts row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.

1299: END lock_funding;
1300: --
1301: --Name: summary_funding_insert_row
1302: --Type: Procedure
1303: --Description: This procedure inserts row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.
1304: --
1305: --Called subprograms: summary_fundings_update_row
1306: --
1307: --

Line 1328: from pa_summary_project_fundings

1324: BEGIN
1325: declare
1326: cursor c1 is
1327: select 1
1328: from pa_summary_project_fundings
1329: where project_id = p_project_id
1330: and agreement_id = p_agreement_id
1331: and nvl(task_id, 0) = nvl(p_task_id, 0);
1332: dummy number;

Line 1351: INSERT INTO PA_SUMMARY_PROJECT_FUNDINGS

1347:
1348:
1349: ELSE
1350:
1351: INSERT INTO PA_SUMMARY_PROJECT_FUNDINGS
1352: (AGREEMENT_ID, PROJECT_ID, TASK_ID,
1353: TOTAL_BASELINED_AMOUNT, TOTAL_UNBASELINED_AMOUNT,
1354: TOTAL_ACCRUED_AMOUNT, TOTAL_BILLED_AMOUNT,
1355: LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1405: (select NULL from PA_SUMMARY_PROJECT_FUNDINGS S

1401: AND PROJECT_ID = p_project_id
1402: AND AGREEMENT_ID = p_agreement_id
1403: AND NVL(TASK_ID,0) = NVL(p_task_id,0)
1404: AND NOT EXISTS
1405: (select NULL from PA_SUMMARY_PROJECT_FUNDINGS S
1406: WHERE s.PROJECT_ID = p_project_id
1407: AND s.AGREEMENT_ID = p_agreement_id
1408: AND NVL(s.TASK_ID,0) = NVL(p_task_id,0))
1409: GROUP BY AGREEMENT_ID,PROJECT_ID,TASK_ID,FUNDING_CURRENCY_CODE,

Line 1434: --Description: This procedure updates row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.

1430:
1431: --
1432: --Name: summary_fundings_update_row
1433: --Type: Procedure
1434: --Description: This procedure updates row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.
1435: --
1436: --Called subprograms: pa_agreement_utils.summary_fundings_insert_row
1437: --
1438: --

Line 1458: UPDATE PA_SUMMARY_PROJECT_FUNDINGS S

1454: BEGIN
1455: --dbms_output.put_line('Inside: PA_AGREEMENT_CORE.SUMMARY_FUNDING_UPDATE_ROW');
1456: IF (p_budget_type_code = 'DRAFT') THEN
1457:
1458: UPDATE PA_SUMMARY_PROJECT_FUNDINGS S
1459: SET (S.TOTAL_UNBASELINED_AMOUNT, S.PROJECT_UNBASELINED_AMOUNT,
1460: S.PROJFUNC_UNBASELINED_AMOUNT,
1461: S.INVPROC_UNBASELINED_AMOUNT, S.REVPROC_UNBASELINED_AMOUNT) =
1462: (SELECT SUM(DECODE(F.BUDGET_TYPE_CODE, 'BASELINE',0,

Line 1499: --Description: This procedure deletes row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.

1495:
1496: --
1497: --Name: summary_funding_delete_row
1498: --Type: Procedure
1499: --Description: This procedure deletes row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.
1500: --
1501: --Called subprograms: summary_fundings_insert_row
1502: --
1503: --

Line 1541: DELETE FROM PA_SUMMARY_PROJECT_FUNDINGS S

1537: ,p_budget_type_code
1538: );
1539:
1540: ELSE
1541: DELETE FROM PA_SUMMARY_PROJECT_FUNDINGS S
1542: WHERE S.PROJECT_ID = p_project_id
1543: AND S.AGREEMENT_ID = p_agreement_id
1544: AND NVL(S.TASK_ID,0) = NVL(p_task_id,0);
1545: END IF;

Line 1790: FROM PA_SUMMARY_PROJECT_FUNDINGS spf

1786:
1787: SELECT 'Y' into l_mult_funding_flag
1788: FROM dual
1789: WHERE exists ( select null
1790: FROM PA_SUMMARY_PROJECT_FUNDINGS spf
1791: WHERE spf.project_id = p_project_id
1792: AND spf.funding_currency_code <> p_funding_currency_code
1793: AND spf.total_baselined_amount <> 0
1794: AND spf.total_unbaselined_amount <> 0);