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_AGREEMENT_UTILS dependencies on PA_FUNDING_CORE

Line 61: --Called subprograms: PA_FUNDING_CORE.CHECK_FUND_ALLOCATED

57: --Description: This function will return 'Y' IF funds have been allocated to the
58: -- passed agreement ELSE will return 'N'
59: --
60: --
61: --Called subprograms: PA_FUNDING_CORE.CHECK_FUND_ALLOCATED
62: --
63: --
64: --
65: --History:

Line 76: return (PA_FUNDING_CORE.CHECK_FUND_ALLOCATED ( p_agreement_id));

72: RETURN VARCHAR2
73: IS
74: BEGIN
75: -- dbms_output.put_line('Inside:PA_AGREEMENT_UTILS.CHECK_FUND_ALLOCATED');
76: return (PA_FUNDING_CORE.CHECK_FUND_ALLOCATED ( p_agreement_id));
77: END check_fund_allocated;
78:
79:
80: --

Line 87: --Called subprograms: PA_FUNDING_CORE.CHECK_ACCRUED_BILLED_BASELINED

83: --Description: This function will return 'Y'
84: -- Total amount of funds allocated is less than amount accrued or billed.
85: -- ELSE will return 'N' for given Projet_id, agreement_id, task_id and fund amount.
86: --
87: --Called subprograms: PA_FUNDING_CORE.CHECK_ACCRUED_BILLED_BASELINED
88: --
89: --History:
90: -- 16-APR-2000 Created Nikhil Mishra.
91:

Line 101: return(PA_FUNDING_CORE.CHECK_ACCRUED_BILLED_BASELINED( p_agreement_id

97: )
98: RETURN VARCHAR2
99: IS
100: BEGIN
101: return(PA_FUNDING_CORE.CHECK_ACCRUED_BILLED_BASELINED( p_agreement_id
102: ,p_project_id
103: ,p_task_id
104: ,p_amount));
105: END accrued_billed_baselined;

Line 131: Is_agr_fund_ok := Pa_funding_core.check_proj_agr_fund_ok( p_agreement_id, p_project_id);

127:
128: BEGIN
129: --dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_PROJ_AGR_FUND_OK');
130:
131: Is_agr_fund_ok := Pa_funding_core.check_proj_agr_fund_ok( p_agreement_id, p_project_id);
132:
133: --dbms_output.put_line('Outside: PA_AGREEMENT_UTILS.CHECK_PROJ_AGR_FUND_OK');
134:
135: RETURN Is_agr_fund_ok;

Line 153: --Called subprograms: PA_FUNDING_CORE.CHECK_PROJ_TASK_LVL_FUNDING

149: -- "T" IF user is allocating funding at Project level when Top task level
150: -- funding exists. Message is PA_BU_TASK_ALLOC_ONLY
151: -- "B" IF user change to task-level funding when project-level events exist,
152: -- or IF Revenue has been distributed. Message is PA_TASK_FUND_NO_PROJ_TRANS
153: --Called subprograms: PA_FUNDING_CORE.CHECK_PROJ_TASK_LVL_FUNDING
154: --
155: --
156: --
157: --History:

Line 170: return(PA_FUNDING_CORE.CHECK_PROJ_TASK_LVL_FUNDING(p_agreement_id

166: RETURN VARCHAR2
167: IS
168: BEGIN
169: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_PROJ_TASK_LVL_FUNDING');
170: return(PA_FUNDING_CORE.CHECK_PROJ_TASK_LVL_FUNDING(p_agreement_id
171: ,p_project_id
172: ,p_task_id));
173: END check_proj_task_lvl_funding;
174:

Line 185: return(PA_FUNDING_CORE.CHECK_PROJ_TASK_LVL_FUNDING_FP(p_agreement_id

181: RETURN VARCHAR2
182: IS
183: BEGIN
184: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_PROJ_TASK_LVL_FUNDING_FP');
185: return(PA_FUNDING_CORE.CHECK_PROJ_TASK_LVL_FUNDING_FP(p_agreement_id
186: ,p_project_id
187: ,p_task_id));
188: END check_proj_task_lvl_funding_fp;
189:

Line 200: --Called subprograms: PA_FUNDING_CORE.VALIDATE_LEVEL_CHANGE

196: -- (1) Any expEND iture item is revenue distributed ?
197: -- (2) Any event is revenue distributed?
198: -- (3) Any event is billed ??
199: --
200: --Called subprograms: PA_FUNDING_CORE.VALIDATE_LEVEL_CHANGE
201: --
202: --
203: --
204: --History:

Line 215: return(PA_FUNDING_CORE.VALIDATE_LEVEL_CHANGE( p_project_id

211: )
212: RETURN VARCHAR2
213: IS
214: BEGIN
215: return(PA_FUNDING_CORE.VALIDATE_LEVEL_CHANGE( p_project_id
216: ,p_task_id));
217: END validate_level_change;
218:
219: --

Line 226: --Called subprograms: PA_FUNDING_CORE.CHECK_LEVEL_CHANGE

222: --Description: This function will return 'Y' IF the funding level has been changed.
223: -- and the chenged level is a valis one. this can be done by
224: -- calling validate_level_change
225: --
226: --Called subprograms: PA_FUNDING_CORE.CHECK_LEVEL_CHANGE
227: --
228: --
229: --
230: --History:

Line 242: return(PA_FUNDING_CORE.CHECK_LEVEL_CHANGE(p_agreement_id

238: )
239: RETURN VARCHAR2
240: IS
241: BEGIN
242: return(PA_FUNDING_CORE.CHECK_LEVEL_CHANGE(p_agreement_id
243: ,p_project_id
244: ,p_task_id));
245:
246: END check_level_change;

Line 568: -- dbms_output.put_line(' Returning: '||to_char(PA_FUNDING_CORE.GET_FUNDING_ID(p_funding_reference)));

564: RETURN NUMBER
565: IS
566: BEGIN
567: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_FUNDING_ID');
568: -- dbms_output.put_line(' Returning: '||to_char(PA_FUNDING_CORE.GET_FUNDING_ID(p_funding_reference)));
569: RETURN(PA_FUNDING_CORE.GET_FUNDING_ID(p_funding_reference));
570: END get_funding_id;
571:
572: --

Line 569: RETURN(PA_FUNDING_CORE.GET_FUNDING_ID(p_funding_reference));

565: IS
566: BEGIN
567: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_FUNDING_ID');
568: -- dbms_output.put_line(' Returning: '||to_char(PA_FUNDING_CORE.GET_FUNDING_ID(p_funding_reference)));
569: RETURN(PA_FUNDING_CORE.GET_FUNDING_ID(p_funding_reference));
570: END get_funding_id;
571:
572: --
573: --Name: get_customer_id

Line 654: --Called subprograms PA_FUNDING_CORE.SUMMARY_FUNDING_INSERT_ROW

650: --Name: summary_funding_insert_row
651: --Type: Procedure
652: --Description: This procedure inserts row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.
653: --
654: --Called subprograms PA_FUNDING_CORE.SUMMARY_FUNDING_INSERT_ROW
655: --
656: --
657: --
658: --History:

Line 671: PA_FUNDING_CORE.SUMMARY_FUNDING_INSERT_ROW( p_agreement_id

667: ,p_user_id IN VARCHAR2
668: )
669: IS
670: BEGIN
671: PA_FUNDING_CORE.SUMMARY_FUNDING_INSERT_ROW( p_agreement_id
672: ,p_project_id
673: ,p_task_id
674: ,p_login_id
675: ,p_user_id

Line 685: --Called subprograms: PA_FUNDING_CORE.SUMMARY_FUNDING_UPDATE_ROW

681: --Name: summary_funding_update_row
682: --Type: Procedure
683: --Description: This procedure updates row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.
684: --
685: --Called subprograms: PA_FUNDING_CORE.SUMMARY_FUNDING_UPDATE_ROW
686: --
687: --
688: --
689: --History:

Line 702: PA_FUNDING_CORE.SUMMARY_FUNDING_UPDATE_ROW( p_agreement_id

698: )
699: IS
700: BEGIN
701: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.SUMMARY_FUNDING_UPDATE_ROW');
702: PA_FUNDING_CORE.SUMMARY_FUNDING_UPDATE_ROW( p_agreement_id
703: ,p_project_id
704: ,p_task_id
705: ,p_login_id
706: ,p_user_id

Line 715: --Called subprograms: PA_FUNDING_CORE.SUMMARY_FUNDING_DELETE_ROW

711: --Name: summary_funding_delete_row
712: --Type: Procedure
713: --Description: This procedure deletes row(s) in to PA_SUMMARY_PROJECT_FUNDINGS.
714: --
715: --Called subprograms: PA_FUNDING_CORE.SUMMARY_FUNDING_DELETE_ROW
716: --
717: --History:
718: -- 15-MAY-2000 Created Nikhil Mishra.
719: --

Line 729: PA_FUNDING_CORE.SUMMARY_FUNDING_DELETE_ROW( p_agreement_id

725: ,p_user_id IN VARCHAR2
726: )
727: IS
728: BEGIN
729: PA_FUNDING_CORE.SUMMARY_FUNDING_DELETE_ROW( p_agreement_id
730: ,p_project_id
731: ,p_task_id
732: ,p_login_id
733: ,p_user_id

Line 742: --Called subprograms: PA_FUNDING_CORE.CHECK_VALID_PROJECT

738: --Type: Function
739: --Description: This function will return 'Y'
740: -- IF the project is a valid project ELSE will return 'N'
741: --
742: --Called subprograms: PA_FUNDING_CORE.CHECK_VALID_PROJECT
743: --
744: --History:
745: -- 10-SEP-01 : added new param project_id srividya
746:

Line 757: return(PA_FUNDING_CORE.CHECK_VALID_PROJECT(

753:
754: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_VALID_PROJECT');
755: -- dbms_output.put_line('Customer_id: '||nvl(to_char(p_customer_id),'NULL'));
756:
757: return(PA_FUNDING_CORE.CHECK_VALID_PROJECT(
758: p_customer_id => p_customer_id,
759: p_project_id => p_project_id,
760: p_agreement_id => p_agreement_id));
761:

Line 771: --Called subprograms: PA_FUNDING_CORE.CHECK_VALID_TASK

767: --Type: Function
768: --Description: This function will return 'Y'
769: -- IF the task is a valid task for project_id passed ELSE will return 'N'
770: --
771: --Called subprograms: PA_FUNDING_CORE.CHECK_VALID_TASK
772: --
773: --History:
774: -- 16-APR-2000 Created Nikhil Mishra.
775:

Line 786: return(PA_FUNDING_CORE.CHECK_VALID_TASK(p_project_id

782: RETURN VARCHAR2
783: IS
784: BEGIN
785: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_VALID_TASK');
786: return(PA_FUNDING_CORE.CHECK_VALID_TASK(p_project_id
787: ,p_task_id));
788:
789: END check_valid_task;
790:

Line 797: --Called subprograms: PA_FUNDING_CORE.CHECK_PROJECT_TYPE

793: --Type: Function
794: --Description: This function will return 'Y'
795: -- IF the Project Type is "CONTRACT" ELSE will return 'N'
796: --
797: --Called subprograms: PA_FUNDING_CORE.CHECK_PROJECT_TYPE
798: --
799: --History:
800: -- 16-APR-2000 Created Nikhil Mishra.
801:

Line 809: return(PA_FUNDING_CORE.CHECK_PROJECT_TYPE(p_project_id));

805: )
806: RETURN VARCHAR2
807: IS
808: BEGIN
809: return(PA_FUNDING_CORE.CHECK_PROJECT_TYPE(p_project_id));
810: END check_project_type;
811:
812: --
813: --Name: check_funding_level

Line 819: --Called subprograms: PA_FUNDING_CORE.CHECK_LEVEL_CHANGE

815: --Description: This function will return 'Y' IF the funding level has been changed.
816: -- and the chenged level is a valis one. this can be done by
817: -- calling validate_level_change
818: --
819: --Called subprograms: PA_FUNDING_CORE.CHECK_LEVEL_CHANGE
820: --
821: --
822: --
823: --History:

Line 836: return(PA_FUNDING_CORE.CHECK_LEVEL_CHANGE(p_agreement_id

832: )
833: RETURN VARCHAR2
834: IS
835: BEGIN
836: return(PA_FUNDING_CORE.CHECK_LEVEL_CHANGE(p_agreement_id
837: ,p_project_id
838: ,p_task_id));
839: END check_funding_level;
840:

Line 868: --Called subprograms: PA_FUNDING_CORE.CHECK_BUDGET_TYPE

864: --Description: This function will return 'Y' IF the Project has budget_type_code as 'DRAFT'
865: -- ELSE will return 'N'
866: --
867: --
868: --Called subprograms: PA_FUNDING_CORE.CHECK_BUDGET_TYPE
869: --
870: --
871: --
872: --History:

Line 893: --Called subprograms: PA_FUNDING_CORE.CHECK_REVENUE_LIMIT

889: --Description: This function will return 'Y' IF the revenue limit of theagreemnet is in the permissible limts
890: -- ELSE will return 'N'
891: --
892: --
893: --Called subprograms: PA_FUNDING_CORE.CHECK_REVENUE_LIMIT
894: --
895: --
896: --
897: --History:

Line 1208: --Called subprograms: PA_FUNDING_CORE.CREATE_FUNDING

1204: --
1205: --Name: create_funding
1206: --Type: PROCEDURE
1207: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
1208: --Called subprograms: PA_FUNDING_CORE.CREATE_FUNDING
1209: --
1210: --
1211: --
1212: --History:

Line 1267: PA_FUNDING_CORE.CREATE_FUNDING(

1263:
1264: x_err_code := 0;
1265: x_err_msg := null;
1266:
1267: PA_FUNDING_CORE.CREATE_FUNDING(
1268: p_rowid => p_rowid,
1269: p_project_funding_id => p_project_funding_id,
1270: p_last_update_date => p_last_update_date,
1271: p_last_updated_by => p_last_updated_by,

Line 1321: --Called subprograms: PA_FUNDING_CORE.UPDATE_FUNDING

1317: --
1318: --Name: update_funding
1319: --Type: PROCEDURE
1320: --Description: This procedure is used to create a funding record in PA_PROJECT_FUNDINGS
1321: --Called subprograms: PA_FUNDING_CORE.UPDATE_FUNDING
1322: --
1323: --
1324: --
1325: --History:

Line 1373: PA_FUNDING_CORE.UPDATE_FUNDING(

1369:
1370: x_err_code := 0;
1371: x_err_msg := null;
1372:
1373: PA_FUNDING_CORE.UPDATE_FUNDING(
1374: p_project_funding_id => p_project_funding_id,
1375: p_last_update_date => p_last_update_date,
1376: p_last_updated_by => p_last_updated_by,
1377: p_last_update_login => p_last_update_login,

Line 1424: --Called subprograms: PA_FUNDING_CORE.DELETE_FUNDING

1420: --
1421: --Name: delete_funding
1422: --Type: PROCEDURE
1423: --Description: This procedure is used to delete a funding record in PA_PROJECT_FUNDINGS
1424: --Called subprograms: PA_FUNDING_CORE.DELETE_FUNDING
1425: --
1426: --
1427: --
1428: --History:

Line 1435: PA_FUNDING_CORE.DELETE_FUNDING(p_project_funding_id);

1431:
1432: PROCEDURE Delete_funding(p_project_funding_id IN NUMBER)
1433: IS
1434: BEGIN
1435: PA_FUNDING_CORE.DELETE_FUNDING(p_project_funding_id);
1436: END Delete_funding;
1437:
1438: --
1439: --Name: lock_funding

Line 1442: --Called subprograms: PA_FUNDING_CORE.LOCK_FUNDING

1438: --
1439: --Name: lock_funding
1440: --Type: PROCEDURE
1441: --Description: This procedure is used to lock a funding record in PA_PROJECT_FUNDINGS
1442: --Called subprograms: PA_FUNDING_CORE.LOCK_FUNDING
1443: --
1444: --
1445: --
1446: --History:

Line 1453: PA_FUNDING_CORE.LOCK_FUNDING(p_Project_Funding_Id);

1449: PROCEDURE Lock_funding
1450: (p_Project_Funding_Id IN NUMBER)
1451: IS
1452: BEGIN
1453: PA_FUNDING_CORE.LOCK_FUNDING(p_Project_Funding_Id);
1454: END lock_funding;
1455:
1456:
1457: --

Line 1536: --Called subprograms: PA_FUNDING_CORE.CHECK_INVOICE_LIMIT

1532: -- the agreemnet is in the permissible limts
1533: -- ELSE will return 'N'
1534: --
1535: --
1536: --Called subprograms: PA_FUNDING_CORE.CHECK_INVOICE_LIMIT
1537: --
1538: --
1539: --History:
1540: -- 10-SEP-2001 Created Srividya

Line 1560: --Called subprograms: PA_FUNDING_CORE.CHECK_VALID_EXCH_RATE

1556: -- exch rate type/rate is valid
1557: -- ELSE will return 'N'
1558: --
1559: --
1560: --Called subprograms: PA_FUNDING_CORE.CHECK_VALID_EXCH_RATE
1561: --
1562: --
1563: --History:
1564: -- 10-SEP-2001 Created Srividya

Line 1575: return(PA_FUNDING_CORE.CHECK_VALID_EXCH_RATE(

1571: RETURN VARCHAR2 IS
1572:
1573: BEGIN
1574:
1575: return(PA_FUNDING_CORE.CHECK_VALID_EXCH_RATE(
1576: p_exchange_rate_type => p_exchange_rate_type,
1577: p_exchange_rate => p_exchange_rate ));
1578:
1579: END check_valid_exch_rate;