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_PROJECT_FUNDINGS

Line 16: FROM pa_project_fundings

12: BEGIN
13:
14: SELECT NVL(SUM(allocated_amount),0)
15: INTO l_amount
16: FROM pa_project_fundings
17: WHERE project_id = p_project_id
18: AND NVL(task_id,-99) = NVL(p_task_id ,-99)
19: AND RTRIM(budget_type_code) = RTRIM(p_budget_type);
20:

Line 63: from pa_project_fundings

59: select 1
60: into dummy
61: from dual
62: where exists ( select 1
63: from pa_project_fundings
64: where agreement_id = p_agreement_id);
65:
66: IF dummy = 1 THEN
67: return 'Y';

Line 240: FROM PA_PROJECT_FUNDINGS f

236:
237: CURSOR c1
238: IS
239: SELECT f.project_funding_id
240: FROM PA_PROJECT_FUNDINGS f
241: WHERE f.pm_funding_reference = p_funding_reference;
242:
243: l_fund_rec1 c1%ROWTYPE;
244:

Line 544: FROM pa_project_fundings

540:
541: BEGIN
542: V_task_id := NULL;
543: SELECT task_id INTO V_task_id
544: FROM pa_project_fundings
545: WHERE project_funding_id =
546: (SELECT max(project_funding_id)
547: FROM pa_project_fundings
548: WHERE project_id = p_project_id

Line 547: FROM pa_project_fundings

543: SELECT task_id INTO V_task_id
544: FROM pa_project_fundings
545: WHERE project_funding_id =
546: (SELECT max(project_funding_id)
547: FROM pa_project_fundings
548: WHERE project_id = p_project_id
549: AND agreement_id = p_agreement_id);
550:
551: IF (((V_task_id IS NULL) AND (p_task_id IS NULL)) OR

Line 673: FROM PA_PROJECT_FUNDINGS P

669:
670:
671: SELECT nvl(max(sum(nvl(allocated_amount,0))),0)
672: INTO dummy_amount
673: FROM PA_PROJECT_FUNDINGS P
674: WHERE P.PROJECT_ID = p_project_id
675: AND TASK_ID IS NOT NULL
676: AND BUDGET_TYPE_CODE IN ('BASELINE', 'DRAFT')
677: GROUP BY TASK_ID;

Line 696: FROM PA_PROJECT_FUNDINGS P

692: END IF;
693:
694: SELECT NVL(SUM(ALLOCATED_AMOUNT), 0)
695: INTO dummy_amount
696: FROM PA_PROJECT_FUNDINGS P
697: WHERE P.PROJECT_ID = p_project_id
698: AND P.TASK_ID IS NULL
699: AND P.BUDGET_TYPE_CODE IN ('BASELINE', 'DRAFT');
700:

Line 762: l_budget_code pa_project_fundings.budget_type_code%type;

758: FUNCTION check_budget_type
759: (p_funding_id IN NUMBER
760: ) RETURN VARCHAR2
761: IS
762: l_budget_code pa_project_fundings.budget_type_code%type;
763: BEGIN
764:
765: Select pf.budget_type_code
766: Into l_budget_code

Line 767: From pa_project_fundings pf

763: BEGIN
764:
765: Select pf.budget_type_code
766: Into l_budget_code
767: From pa_project_fundings pf
768: where pf.project_funding_id = p_funding_id;
769:
770: IF l_budget_code = 'DRAFT'
771: THEN RETURN 'Y';

Line 781: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS

777:
778: --
779: --Name: create_funding
780: --Type: PROCEDURE
781: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
782: --Called subprograms: pa_project_fundings_pkg.insert_row
783: --
784: --
785: --

Line 782: --Called subprograms: pa_project_fundings_pkg.insert_row

778: --
779: --Name: create_funding
780: --Type: PROCEDURE
781: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
782: --Called subprograms: pa_project_fundings_pkg.insert_row
783: --
784: --
785: --
786: --History:

Line 933: pa_project_fundings_pkg.insert_row(

929: x_err_msg := l_err_msg;
930:
931: if x_err_code = 0 then
932:
933: pa_project_fundings_pkg.insert_row(
934: x_rowid => p_rowid,
935: x_project_funding_id => p_project_funding_id,
936: x_last_update_date => p_last_update_date,
937: x_last_updated_by => p_last_updated_by,

Line 1003: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS

999:
1000: --
1001: --Name: update_funding
1002: --Type: PROCEDURE
1003: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
1004: --Called subprograms: pa_project_fundings_pkg.update_row
1005: --
1006: --
1007: --

Line 1004: --Called subprograms: pa_project_fundings_pkg.update_row

1000: --
1001: --Name: update_funding
1002: --Type: PROCEDURE
1003: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
1004: --Called subprograms: pa_project_fundings_pkg.update_row
1005: --
1006: --
1007: --
1008: --History:

Line 1052: FROM PA_PROJECT_FUNDINGS

1048: IS
1049: CURSOR C IS
1050: SELECT
1051: rowid
1052: FROM PA_PROJECT_FUNDINGS
1053: WHERE project_funding_id = p_Project_Funding_Id;
1054: fun_rec C%ROWTYPE;
1055: l_funding_currency_code VARCHAR2(15);
1056: l_project_currency_code VARCHAR2(15);

Line 1137: pa_project_fundings_pkg.update_row(

1133: x_err_code := l_err_code;
1134: x_err_msg := l_err_msg;
1135:
1136: if x_err_code = 0 then
1137: pa_project_fundings_pkg.update_row(
1138: x_rowid => fun_rec.rowid,
1139: x_project_funding_id => p_project_funding_id,
1140: x_last_update_date => p_last_update_date,
1141: x_last_updated_by => p_last_updated_by,

Line 1205: --Description: This procedure is used to delete a funding record in PA_PROJECT_FUNDINGS

1201:
1202: --
1203: --Name: delete_funding
1204: --Type: PROCEDURE
1205: --Description: This procedure is used to delete a funding record in PA_PROJECT_FUNDINGS
1206: --Called subprograms: pa_project_fundings_pkg.delete_row
1207: --
1208: --
1209: --

Line 1206: --Called subprograms: pa_project_fundings_pkg.delete_row

1202: --
1203: --Name: delete_funding
1204: --Type: PROCEDURE
1205: --Description: This procedure is used to delete a funding record in PA_PROJECT_FUNDINGS
1206: --Called subprograms: pa_project_fundings_pkg.delete_row
1207: --
1208: --
1209: --
1210: --History:

Line 1218: FROM PA_PROJECT_FUNDINGS

1214: PROCEDURE Delete_funding(p_project_funding_id IN NUMBER)
1215: is
1216: CURSOR C IS
1217: SELECT rowid
1218: FROM PA_PROJECT_FUNDINGS
1219: WHERE project_funding_id = p_project_funding_id;
1220: fun_row_id VARCHAR2(2000);
1221: BEGIN
1222: OPEN C;

Line 1226: pa_project_fundings_pkg.delete_row(fun_row_id);

1222: OPEN C;
1223: FETCH C INTO fun_row_id;
1224: IF C%FOUND THEN
1225: --dbms_output.put_line('yes');
1226: pa_project_fundings_pkg.delete_row(fun_row_id);
1227: END IF;
1228: CLOSE C;
1229: END delete_funding;
1230: --

Line 1233: --Description: This procedure is used to lock a funding record in PA_PROJECT_FUNDINGS

1229: END delete_funding;
1230: --
1231: --Name: lock_funding
1232: --Type: PROCEDURE
1233: --Description: This procedure is used to lock a funding record in PA_PROJECT_FUNDINGS
1234: --Called subprograms: pa_project_fundings_pkg.lock_row
1235: --
1236: --
1237: --

Line 1234: --Called subprograms: pa_project_fundings_pkg.lock_row

1230: --
1231: --Name: lock_funding
1232: --Type: PROCEDURE
1233: --Description: This procedure is used to lock a funding record in PA_PROJECT_FUNDINGS
1234: --Called subprograms: pa_project_fundings_pkg.lock_row
1235: --
1236: --
1237: --
1238: --History:

Line 1273: FROM PA_PROJECT_FUNDINGS

1269: project_rate_date, project_exchange_rate, project_allocated_amount,
1270: projfunc_currency_code, projfunc_rate_type, projfunc_rate_date,
1271: projfunc_exchange_rate, projfunc_allocated_amount,
1272: funding_category /* For Bug2244796 */
1273: FROM PA_PROJECT_FUNDINGS
1274: WHERE project_funding_id = p_Project_Funding_Id;
1275: fun_rec C%ROWTYPE;
1276: BEGIN
1277: OPEN C;

Line 1280: pa_project_fundings_pkg.lock_row(

1276: BEGIN
1277: OPEN C;
1278: FETCH C INTO fun_rec;
1279: IF C%FOUND THEN
1280: pa_project_fundings_pkg.lock_row(
1281: fun_rec.rowid,
1282: fun_rec.project_funding_id,
1283: fun_rec.agreement_id,
1284: fun_rec.project_id,

Line 1417: FROM PA_PROJECT_FUNDINGS

1413: NVL(REVPROC_ALLOCATED_AMOUNT,0))),0),
1414: NVL(SUM(DECODE(BUDGET_TYPE_CODE,'DRAFT',
1415: NVL(REVPROC_ALLOCATED_AMOUNT,0))),0),
1416: 0
1417: FROM PA_PROJECT_FUNDINGS
1418: WHERE BUDGET_TYPE_CODE IN ('BASELINE','DRAFT')
1419: AND PROJECT_ID = p_project_id
1420: AND AGREEMENT_ID = p_agreement_id
1421: AND NVL(TASK_ID,0) = NVL(p_task_id,0)

Line 1490: FROM PA_PROJECT_FUNDINGS F

1486: SUM(DECODE(F.BUDGET_TYPE_CODE, 'BASELINE',0,
1487: 'DRAFT',nvl(F.INVPROC_ALLOCATED_AMOUNT,0))),
1488: SUM(DECODE(F.BUDGET_TYPE_CODE, 'BASELINE',0,
1489: 'DRAFT',nvl(F.REVPROC_ALLOCATED_AMOUNT,0)))
1490: FROM PA_PROJECT_FUNDINGS F
1491: WHERE F.PROJECT_ID = S.PROJECT_ID
1492: AND F.AGREEMENT_ID = S.AGREEMENT_ID
1493: AND NVL(F.TASK_ID,0) = NVL(S.TASK_ID,0)
1494: GROUP BY F.AGREEMENT_ID, F.PROJECT_ID, F.TASK_ID)

Line 1542: from pa_project_fundings

1538: dummy number;
1539:
1540: cursor d1 is
1541: select 1
1542: from pa_project_fundings
1543: where project_id = p_project_id
1544: and nvl(task_id, 0) = nvl(p_task_id, 0)
1545: and agreement_id = p_agreement_id;
1546: BEGIN

Line 2206: pa_project_fundings_pkg.insert_row(

2202: l_Invproc_Exchange_Rate := NULL;
2203: l_Invproc_Allocated_Amount := p_Allocated_Amount;
2204: END IF;
2205:
2206: pa_project_fundings_pkg.insert_row(
2207: x_rowid => p_rowid,
2208: x_project_funding_id => p_project_funding_id,
2209: x_last_update_date => p_last_update_date,
2210: x_last_updated_by => p_last_updated_by,