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 924: pa_project_fundings_pkg.insert_row(

920: x_err_msg := l_err_msg;
921:
922: if x_err_code = 0 then
923:
924: pa_project_fundings_pkg.insert_row(
925: x_rowid => p_rowid,
926: x_project_funding_id => p_project_funding_id,
927: x_last_update_date => p_last_update_date,
928: x_last_updated_by => p_last_updated_by,

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

990:
991: --
992: --Name: update_funding
993: --Type: PROCEDURE
994: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
995: --Called subprograms: pa_project_fundings_pkg.update_row
996: --
997: --
998: --

Line 995: --Called subprograms: pa_project_fundings_pkg.update_row

991: --
992: --Name: update_funding
993: --Type: PROCEDURE
994: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
995: --Called subprograms: pa_project_fundings_pkg.update_row
996: --
997: --
998: --
999: --History:

Line 1043: FROM PA_PROJECT_FUNDINGS

1039: IS
1040: CURSOR C IS
1041: SELECT
1042: rowid
1043: FROM PA_PROJECT_FUNDINGS
1044: WHERE project_funding_id = p_Project_Funding_Id;
1045: fun_rec C%ROWTYPE;
1046: l_funding_currency_code VARCHAR2(15);
1047: l_project_currency_code VARCHAR2(15);

Line 1119: pa_project_fundings_pkg.update_row(

1115: x_err_code := l_err_code;
1116: x_err_msg := l_err_msg;
1117:
1118: if x_err_code = 0 then
1119: pa_project_fundings_pkg.update_row(
1120: x_rowid => fun_rec.rowid,
1121: x_project_funding_id => p_project_funding_id,
1122: x_last_update_date => p_last_update_date,
1123: x_last_updated_by => p_last_updated_by,

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

1183:
1184: --
1185: --Name: delete_funding
1186: --Type: PROCEDURE
1187: --Description: This procedure is used to delete a funding record in PA_PROJECT_FUNDINGS
1188: --Called subprograms: pa_project_fundings_pkg.delete_row
1189: --
1190: --
1191: --

Line 1188: --Called subprograms: pa_project_fundings_pkg.delete_row

1184: --
1185: --Name: delete_funding
1186: --Type: PROCEDURE
1187: --Description: This procedure is used to delete a funding record in PA_PROJECT_FUNDINGS
1188: --Called subprograms: pa_project_fundings_pkg.delete_row
1189: --
1190: --
1191: --
1192: --History:

Line 1200: FROM PA_PROJECT_FUNDINGS

1196: PROCEDURE Delete_funding(p_project_funding_id IN NUMBER)
1197: is
1198: CURSOR C IS
1199: SELECT rowid
1200: FROM PA_PROJECT_FUNDINGS
1201: WHERE project_funding_id = p_project_funding_id;
1202: fun_row_id VARCHAR2(2000);
1203: BEGIN
1204: OPEN C;

Line 1208: pa_project_fundings_pkg.delete_row(fun_row_id);

1204: OPEN C;
1205: FETCH C INTO fun_row_id;
1206: IF C%FOUND THEN
1207: --dbms_output.put_line('yes');
1208: pa_project_fundings_pkg.delete_row(fun_row_id);
1209: END IF;
1210: CLOSE C;
1211: END delete_funding;
1212: --

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

1211: END delete_funding;
1212: --
1213: --Name: lock_funding
1214: --Type: PROCEDURE
1215: --Description: This procedure is used to lock a funding record in PA_PROJECT_FUNDINGS
1216: --Called subprograms: pa_project_fundings_pkg.lock_row
1217: --
1218: --
1219: --

Line 1216: --Called subprograms: pa_project_fundings_pkg.lock_row

1212: --
1213: --Name: lock_funding
1214: --Type: PROCEDURE
1215: --Description: This procedure is used to lock a funding record in PA_PROJECT_FUNDINGS
1216: --Called subprograms: pa_project_fundings_pkg.lock_row
1217: --
1218: --
1219: --
1220: --History:

Line 1255: FROM PA_PROJECT_FUNDINGS

1251: project_rate_date, project_exchange_rate, project_allocated_amount,
1252: projfunc_currency_code, projfunc_rate_type, projfunc_rate_date,
1253: projfunc_exchange_rate, projfunc_allocated_amount,
1254: funding_category /* For Bug2244796 */
1255: FROM PA_PROJECT_FUNDINGS
1256: WHERE project_funding_id = p_Project_Funding_Id;
1257: fun_rec C%ROWTYPE;
1258: BEGIN
1259: OPEN C;

Line 1262: pa_project_fundings_pkg.lock_row(

1258: BEGIN
1259: OPEN C;
1260: FETCH C INTO fun_rec;
1261: IF C%FOUND THEN
1262: pa_project_fundings_pkg.lock_row(
1263: fun_rec.rowid,
1264: fun_rec.project_funding_id,
1265: fun_rec.agreement_id,
1266: fun_rec.project_id,

Line 1399: FROM PA_PROJECT_FUNDINGS

1395: NVL(REVPROC_ALLOCATED_AMOUNT,0))),0),
1396: NVL(SUM(DECODE(BUDGET_TYPE_CODE,'DRAFT',
1397: NVL(REVPROC_ALLOCATED_AMOUNT,0))),0),
1398: 0
1399: FROM PA_PROJECT_FUNDINGS
1400: WHERE BUDGET_TYPE_CODE IN ('BASELINE','DRAFT')
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)

Line 1472: FROM PA_PROJECT_FUNDINGS F

1468: SUM(DECODE(F.BUDGET_TYPE_CODE, 'BASELINE',0,
1469: 'DRAFT',nvl(F.INVPROC_ALLOCATED_AMOUNT,0))),
1470: SUM(DECODE(F.BUDGET_TYPE_CODE, 'BASELINE',0,
1471: 'DRAFT',nvl(F.REVPROC_ALLOCATED_AMOUNT,0)))
1472: FROM PA_PROJECT_FUNDINGS F
1473: WHERE F.PROJECT_ID = S.PROJECT_ID
1474: AND F.AGREEMENT_ID = S.AGREEMENT_ID
1475: AND NVL(F.TASK_ID,0) = NVL(S.TASK_ID,0)
1476: GROUP BY F.AGREEMENT_ID, F.PROJECT_ID, F.TASK_ID)

Line 1524: from pa_project_fundings

1520: dummy number;
1521:
1522: cursor d1 is
1523: select 1
1524: from pa_project_fundings
1525: where project_id = p_project_id
1526: and nvl(task_id, 0) = nvl(p_task_id, 0)
1527: and agreement_id = p_agreement_id;
1528: BEGIN

Line 2188: pa_project_fundings_pkg.insert_row(

2184: l_Invproc_Exchange_Rate := NULL;
2185: l_Invproc_Allocated_Amount := p_Allocated_Amount;
2186: END IF;
2187:
2188: pa_project_fundings_pkg.insert_row(
2189: x_rowid => p_rowid,
2190: x_project_funding_id => p_project_funding_id,
2191: x_last_update_date => p_last_update_date,
2192: x_last_updated_by => p_last_updated_by,