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_AGREEMENT_CORE

Line 11: --Called subprograms: PA_AGREEMENT_CORE.CHECK_MULTI_CUSTOMERS

7: --Description: This function will return 'Y' IF the Project has Multiple-Customers
8: -- ELSE will return 'N'
9: --
10: --
11: --Called subprograms: PA_AGREEMENT_CORE.CHECK_MULTI_CUSTOMERS
12: --
13: --
14: --
15: --History:

Line 26: return (PA_AGREEMENT_CORE.CHECK_MULTI_CUSTOMERS(p_project_id));

22: )
23: RETURN VARCHAR2
24: IS
25: BEGIN
26: return (PA_AGREEMENT_CORE.CHECK_MULTI_CUSTOMERS(p_project_id));
27: END check_multi_customers;
28:
29:
30: --

Line 37: --Called subprograms: PA_AGREEMENT_CORE.CHECK_CONTRIBUTION

33: --Description: This function will return 'Y' IF the Project has Multiple-Customers
34: -- ELSE will return 'N'
35: --
36: --
37: --Called subprograms: PA_AGREEMENT_CORE.CHECK_CONTRIBUTION
38: --
39: --
40: --
41: --History:

Line 51: return (PA_AGREEMENT_CORE.CHECK_CONTRIBUTION(p_agreement_id));

47: )
48: RETURN VARCHAR2
49: IS
50: BEGIN
51: return (PA_AGREEMENT_CORE.CHECK_CONTRIBUTION(p_agreement_id));
52: END check_contribution;
53:
54: --
55: --Name: check_fund_allocated

Line 256: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_CUSTOMER

252: -- is as follows
253: -- "A" Then this user is not a registered employee and he is not allowed to
254: -- create agreement. Message is PA_ALL_WARN_NO_EMPL_REC
255: -- "Y" for valid customer
256: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_CUSTOMER
257: --
258: --
259: --
260: --History:

Line 272: return(PA_AGREEMENT_CORE.CHECK_VALID_CUSTOMER(p_customer_id));

268: IS
269: BEGIN
270: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_VALID_CUSTOMER');
271: -- dbms_output.put_line('Customer_id: '||nvl(to_char(p_customer_id),'NULL'));
272: return(PA_AGREEMENT_CORE.CHECK_VALID_CUSTOMER(p_customer_id));
273: END check_valid_customer;
274:
275: --
276: --Name: check_valid_type

Line 279: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_TYPE

275: --
276: --Name: check_valid_type
277: --Type: Function
278: --Description: Will return Y IF agreement type is valid ELSE return N.
279: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_TYPE
280: --
281: --History:
282: -- 05-MAY-2000 Created Nikhil Mishra.
283: --

Line 292: return(PA_AGREEMENT_CORE.CHECK_VALID_TYPE(p_agreement_type));

288: )
289: RETURN VARCHAR2
290: IS
291: BEGIN
292: return(PA_AGREEMENT_CORE.CHECK_VALID_TYPE(p_agreement_type));
293: END check_valid_type;
294:
295: --
296: --Name: check_valid_term_id

Line 301: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_TERM_ID

297: --Type: Function
298: --Description: This function will return 'Y' IF the Term Id is valid
299: -- ELSE will return 'N'
300: --
301: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_TERM_ID
302: --
303: --
304: --History:
305: -- 05-MAY-2000 Created Nikhil Mishra.

Line 314: return(PA_AGREEMENT_CORE.CHECK_VALID_TERM_ID(p_term_id));

310: )
311: RETURN VARCHAR2
312: IS
313: BEGIN
314: return(PA_AGREEMENT_CORE.CHECK_VALID_TERM_ID(p_term_id));
315: END check_valid_term_id;
316:
317: --
318: --Name: check_valid_owned_by_person_id

Line 323: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_OWNED_BY_PERSON_ID

319: --Type: Function
320: --Description: This function will return 'Y' IF the Person_id is valid
321: -- ELSE will return 'N'
322: --
323: --Called subprograms: PA_AGREEMENT_CORE.CHECK_VALID_OWNED_BY_PERSON_ID
324: --
325: --
326: --History:
327: -- 05-MAY-2000 Created Nikhil Mishra.

Line 337: return(PA_AGREEMENT_CORE.CHECK_VALID_OWNED_BY_PERSON_ID(p_owned_by_person_id));

333: )
334: RETURN VARCHAR2
335: IS
336: BEGIN
337: return(PA_AGREEMENT_CORE.CHECK_VALID_OWNED_BY_PERSON_ID(p_owned_by_person_id));
338: END check_valid_owned_by_person_id;
339:
340: --
341: --Name: check_unique_agreement

Line 347: --Called subprograms: PA_AGREEMENT_CORE.CHECK_UNIQUE_AGREEMENT

343: --Description: This function will return 'Y' IF the combination of
344: -- Agreement_Number, Agreement_type, Customer is unique
345: -- ELSE will return 'N' Message is PA_BU_AGRMNT_NOT_UNIQUE
346: --
347: --Called subprograms: PA_AGREEMENT_CORE.CHECK_UNIQUE_AGREEMENT
348: --
349: --
350: --History:
351: -- 05-MAY-2000 Created Nikhil Mishra.

Line 362: return(PA_AGREEMENT_CORE.CHECK_UNIQUE_AGREEMENT(p_agreement_num

358: )
359: RETURN VARCHAR2
360: IS
361: BEGIN
362: return(PA_AGREEMENT_CORE.CHECK_UNIQUE_AGREEMENT(p_agreement_num
363: ,p_agreement_type
364: ,p_customer_id ));
365: END check_unique_agreement;
366:

Line 389: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_AGREEMENT_REF(p_agreement_reference));

385: RETURN VARCHAR2
386: IS
387: BEGIN
388: -- dbms_output.put_line('PA_AGREEMENT_UTILS.CHECK_VALID_AGREEMENT_REF');
389: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_AGREEMENT_REF(p_agreement_reference));
390: END check_valid_agreement_ref;
391:
392: --
393: --Name: check_valid_agreement_id

Line 412: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_AGREEMENT_ID(p_agreement_id));

408: )
409: RETURN VARCHAR2
410: IS
411: BEGIN
412: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_AGREEMENT_ID(p_agreement_id));
413: END check_valid_agreement_id;
414:
415:
416:

Line 440: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_FUNDING_REF( p_funding_reference

436: IS
437:
438: BEGIN
439: -- dbms_output.put_line(' Inside: PA_AGREEMENT_UTILS.CHECK_VALID_FUNDING_REF');
440: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_FUNDING_REF( p_funding_reference
441: ,p_agreement_id ));
442: END check_valid_funding_ref;
443:
444: --

Line 466: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_FUNDING_ID(p_agreement_id

462: RETURN VARCHAR2
463: IS
464:
465: BEGIN
466: RETURN(PA_AGREEMENT_CORE.CHECK_VALID_FUNDING_ID(p_agreement_id
467: ,p_funding_id));
468: END check_valid_funding_id;
469:
470: --

Line 479: --Called subprograms: PA_AGREEMENT_CORE.VALIDATE_AGREEMENT_AMOUNT

475: -- total baselined and unbaselined amount for that agreement_id;
476: -- IF returning 'N' indicating invalid amount then message is
477: -- PA_BU_AMOUNT_NOT_UPDATEABLE
478: --
479: --Called subprograms: PA_AGREEMENT_CORE.VALIDATE_AGREEMENT_AMOUNT
480: --
481: --
482: --History:
483: -- 05-MAY-2000 Created Nikhil Mishra.

Line 494: return(PA_AGREEMENT_CORE.VALIDATE_AGREEMENT_AMOUNT(p_agreement_id

490: )
491: RETURN VARCHAR2
492: IS
493: BEGIN
494: return(PA_AGREEMENT_CORE.VALIDATE_AGREEMENT_AMOUNT(p_agreement_id
495: ,p_amount));
496:
497: END validate_agreement_amount;
498:

Line 518: RETURN(PA_AGREEMENT_CORE.CHECK_ADD_UPDATE( p_funding_id

514: )
515: RETURN VARCHAR2
516: IS
517: BEGIN
518: RETURN(PA_AGREEMENT_CORE.CHECK_ADD_UPDATE( p_funding_id
519: ,p_funding_reference));
520:
521: END check_add_update;
522:

Line 543: -- dbms_output.put_line(' Returning: '||to_char(PA_AGREEMENT_CORE.GET_AGREEMENT_ID(p_funding_id,p_funding_reference)));

539: RETURN NUMBER
540: IS
541: BEGIN
542: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_AGREEMENT_ID');
543: -- dbms_output.put_line(' Returning: '||to_char(PA_AGREEMENT_CORE.GET_AGREEMENT_ID(p_funding_id,p_funding_reference)));
544: RETURN(PA_AGREEMENT_CORE.GET_AGREEMENT_ID(p_funding_id
545: ,p_funding_reference));
546: END get_agreement_id;
547:

Line 544: RETURN(PA_AGREEMENT_CORE.GET_AGREEMENT_ID(p_funding_id

540: IS
541: BEGIN
542: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_AGREEMENT_ID');
543: -- dbms_output.put_line(' Returning: '||to_char(PA_AGREEMENT_CORE.GET_AGREEMENT_ID(p_funding_id,p_funding_reference)));
544: RETURN(PA_AGREEMENT_CORE.GET_AGREEMENT_ID(p_funding_id
545: ,p_funding_reference));
546: END get_agreement_id;
547:
548: --

Line 593: RETURN(PA_AGREEMENT_CORE.GET_CUSTOMER_ID(p_funding_id

589: RETURN NUMBER
590: IS
591: BEGIN
592: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_CUSTOMER_ID');
593: RETURN(PA_AGREEMENT_CORE.GET_CUSTOMER_ID(p_funding_id
594: ,p_funding_reference));
595: END get_customer_id;
596:
597:

Line 604: --Called subprograms: PA_AGREEMENT_CORE.GET_PROJECT_ID

600: --Name: get_project_id
601: --Type: FUNCTION
602: --Description: This procedure will get the corresponding project_id for the funding_id or funding _reference given
603: --
604: --Called subprograms: PA_AGREEMENT_CORE.GET_PROJECT_ID
605: --
606: --
607: --History:
608: -- 15-MAY-2000 Created Nikhil Mishra.

Line 620: RETURN(PA_AGREEMENT_CORE.GET_PROJECT_ID(p_funding_id

616: IS
617:
618: BEGIN
619: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_PROJECT_ID');
620: RETURN(PA_AGREEMENT_CORE.GET_PROJECT_ID(p_funding_id
621: ,p_funding_reference));
622: END get_project_id;
623:
624:

Line 630: --Called subprograms: PA_AGREEMENT_CORE.GET_TASK_ID

626: --Name: get_task_id
627: --Type: FUNCTION
628: --Description: This function will get the corresponding task_id for the funding_id or funding _reference given
629: --
630: --Called subprograms: PA_AGREEMENT_CORE.GET_TASK_ID
631: --
632: --
633: --History:
634: -- 15-MAY-2000 Created Nikhil Mishra.

Line 646: RETURN(PA_AGREEMENT_CORE.GET_TASK_ID( p_funding_id

642: IS
643:
644: BEGIN
645: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_TASK_ID');
646: RETURN(PA_AGREEMENT_CORE.GET_TASK_ID( p_funding_id
647: ,p_funding_reference));
648: END get_task_id;
649: --
650: --Name: summary_funding_insert_row

Line 846: --Called subprograms: PA_AGREEMENT_CORE.CHECK_INVOICE_EXISTS

842: --Name: check_invoice_exists
843: --Type: Function
844: --Description: Will return Y IF invoices exists for given agreement ELSE return N
845: --
846: --Called subprograms: PA_AGREEMENT_CORE.CHECK_INVOICE_EXISTS
847: --
848: --
849: --History:
850: -- 05-MAY-2000 Created Nikhil Mishra.

Line 858: RETURN (PA_AGREEMENT_CORE.CHECK_INVOICE_EXISTS( p_agreement_id));

854: ( p_agreement_id IN NUMBER)
855: RETURN VARCHAR2
856: IS
857: BEGIN
858: RETURN (PA_AGREEMENT_CORE.CHECK_INVOICE_EXISTS( p_agreement_id));
859: END check_invoice_exists;
860:
861:
862: --Name: check_budget_type

Line 884: return (PA_AGREEMENT_CORE.CHECK_BUDGET_TYPE(p_funding_id));

880: RETURN VARCHAR2
881: IS
882: BEGIN
883: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_BUDGET_TYPE');
884: return (PA_AGREEMENT_CORE.CHECK_BUDGET_TYPE(p_funding_id));
885: END check_budget_type;
886:
887: --Name: check_revenue_type
888: --Type: Function

Line 909: return (PA_AGREEMENT_CORE.CHECK_REVENUE_LIMIT(p_agreement_id));

905: RETURN VARCHAR2
906: IS
907: BEGIN
908: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_REVENUE_LIMIT');
909: return (PA_AGREEMENT_CORE.CHECK_REVENUE_LIMIT(p_agreement_id));
910: END check_revenue_limit;
911:
912:
913: --

Line 918: --Called subprograms: PA_AGREEMENT_CORE.CREATE_AGREEMENT

914: --Name: create_agreement
915: --Type: PROCEDURE
916: --Description: This procedure will insert one row in to PA_AGREEMENTS_ALL
917: --
918: --Called subprograms: PA_AGREEMENT_CORE.CREATE_AGREEMENT
919: --
920: --
921: --History:
922: -- 15-MAY-2000 Created Nikhil Mishra.

Line 984: PA_AGREEMENT_CORE.CREATE_AGREEMENT(

980: IS
981: np_p_Agreement_Id Number :=p_Agreement_Id; /*file.sql.39*/
982: BEGIN
983: -- dbms_output.put_line('In UTILS - create_agreement');
984: PA_AGREEMENT_CORE.CREATE_AGREEMENT(
985: p_rowid => p_rowid,
986: p_agreement_id => p_agreement_id,
987: p_customer_id => p_customer_id,
988: p_agreement_num => p_agreement_num,

Line 1052: --Called subprograms: PA_AGREEMENT_CORE.LOCK_AGREEMENT

1048: --Name: lock_agreement
1049: --Type: PROCEDURE
1050: --Description: This procedure will lock one row in to PA_AGREEMENTS_ALL
1051: --
1052: --Called subprograms: PA_AGREEMENT_CORE.LOCK_AGREEMENT
1053: --
1054: --
1055: --History:
1056: -- 15-MAY-2000 Created Nikhil Mishra.

Line 1061: PA_AGREEMENT_CORE.LOCK_AGREEMENT(p_Agreement_Id );

1057: --
1058: PROCEDURE Lock_agreement(p_Agreement_Id IN NUMBER )
1059: IS
1060: BEGIN
1061: PA_AGREEMENT_CORE.LOCK_AGREEMENT(p_Agreement_Id );
1062: END Lock_agreement;
1063:
1064: --
1065: --Name: delete_agreement

Line 1069: --Called subprograms: PA_AGREEMENT_CORE.DELETE_AGREEMENT

1065: --Name: delete_agreement
1066: --Type: PROCEDURE
1067: --Description: This procedure will delete one row in to PA_AGREEMENTS_ALL
1068: --
1069: --Called subprograms: PA_AGREEMENT_CORE.DELETE_AGREEMENT
1070: --
1071: --
1072: --History:
1073: -- 15-MAY-2000 Created Nikhil Mishra.

Line 1079: PA_AGREEMENT_CORE.DELETE_AGREEMENT(p_agreement_id);

1075:
1076: PROCEDURE Delete_agreement(p_agreement_id IN NUMBER )
1077: IS
1078: BEGIN
1079: PA_AGREEMENT_CORE.DELETE_AGREEMENT(p_agreement_id);
1080: END Delete_agreement;
1081:
1082: --
1083: --Name: update_agreement

Line 1087: --Called subprograms: PA_AGREEMENT_CORE.UPDATE_AGREEMENT

1083: --Name: update_agreement
1084: --Type: PROCEDURE
1085: --Description: This procedure will update one row in to PA_AGREEMENTS_ALL
1086: --
1087: --Called subprograms: PA_AGREEMENT_CORE.UPDATE_AGREEMENT
1088: --
1089: --
1090: --History:
1091: -- 15-MAY-2000 Created Nikhil Mishra.

Line 1150: PA_AGREEMENT_CORE.UPDATE_AGREEMENT(

1146: p_Attribute25 IN VARCHAR2 DEFAULT NULL)
1147: IS
1148: BEGIN
1149: -- dbms_output.put_line('Inside: pa_agreement_utils.update_agreement');
1150: PA_AGREEMENT_CORE.UPDATE_AGREEMENT(
1151: p_agreement_id => p_agreement_id,
1152: p_customer_id => p_customer_id,
1153: p_agreement_num => p_agreement_num,
1154: p_agreement_type => p_agreement_type,

Line 1462: --Called subprograms: PA_AGREEMENT_CORE.get_agr_curr_code

1458: --Name: get_agr_curr_code
1459: --Type: function
1460: --Description: This function is used to get agreement currency code
1461: -- for a given agreement
1462: --Called subprograms: PA_AGREEMENT_CORE.get_agr_curr_code
1463: --
1464: --History:
1465: -- 10-SEP-2001 Created Srividya
1466: -- written for MCB2

Line 1475: return (PA_AGREEMENT_CORE.GET_AGR_CURR_CODE(p_agreement_id));

1471: IS
1472:
1473: BEGIN
1474:
1475: return (PA_AGREEMENT_CORE.GET_AGR_CURR_CODE(p_agreement_id));
1476:
1477: END get_agr_curr_code;
1478:
1479:

Line 1487: --Called subprograms: PA_AGREEMENT_CORE.check_valid_owning_orgn_id

1483: --Description: This function will return 'Y'
1484: -- if the owning organization id is valid
1485: -- ELSE will return 'N'
1486: --
1487: --Called subprograms: PA_AGREEMENT_CORE.check_valid_owning_orgn_id
1488: --
1489: --
1490: --History:
1491: -- 10-SEP-2001 Created Srividya

Line 1500: return(PA_AGREEMENT_CORE.CHECK_VALID_OWNING_ORGN_ID(

1496: RETURN VARCHAR2 IS
1497:
1498:
1499: BEGIN
1500: return(PA_AGREEMENT_CORE.CHECK_VALID_OWNING_ORGN_ID(
1501: p_owning_organization_id));
1502: END check_valid_owning_orgn_id;
1503:
1504: --

Line 1511: --Called subprograms: PA_AGREEMENT_CORE.check_valid_agr_curr_code

1507: --Description: This function will return 'Y'
1508: -- if the agreement currency code is valid
1509: -- ELSE will return 'N'
1510: --
1511: --Called subprograms: PA_AGREEMENT_CORE.check_valid_agr_curr_code
1512: --
1513: --
1514: --History:
1515: -- 10-SEP-2001 Created Srividya

Line 1524: return(PA_AGREEMENT_CORE.CHECK_VALID_agr_curr_code(

1520: RETURN VARCHAR2 IS
1521:
1522:
1523: BEGIN
1524: return(PA_AGREEMENT_CORE.CHECK_VALID_agr_curr_code(
1525: p_agreement_currency_code));
1526: END check_valid_agr_curr_code;
1527:
1528:

Line 1549: return (PA_AGREEMENT_CORE.CHECK_INVOICE_LIMIT(p_agreement_id));

1545:
1546: BEGIN
1547:
1548: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_INVOICE_LIMIT');
1549: return (PA_AGREEMENT_CORE.CHECK_INVOICE_LIMIT(p_agreement_id));
1550:
1551: END check_invoice_limit;
1552:
1553: --Name: check_valid_exch_rate