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_UTILS

Line 1: package body PA_AGREEMENT_UTILS as

1: package body PA_AGREEMENT_UTILS as
2: /*$Header: PAAFAGUB.pls 120.2 2007/02/07 10:47:24 rgandhi ship $*/
3:
4: --
5: --Name: check_multi_customers

Line 75: -- dbms_output.put_line('Inside:PA_AGREEMENT_UTILS.CHECK_FUND_ALLOCATED');

71: )
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:

Line 129: --dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_PROJ_AGR_FUND_OK');

125:
126: Is_agr_fund_ok varchar2(1) := 'N';
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');

Line 133: --dbms_output.put_line('Outside: PA_AGREEMENT_UTILS.CHECK_PROJ_AGR_FUND_OK');

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;
136:
137: END check_proj_agr_fund_ok;

Line 169: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_PROJ_TASK_LVL_FUNDING');

165: )
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;

Line 184: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_PROJ_TASK_LVL_FUNDING_FP');

180: )
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;

Line 270: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_VALID_CUSTOMER');

266: )
267: RETURN VARCHAR2
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:

Line 388: -- dbms_output.put_line('PA_AGREEMENT_UTILS.CHECK_VALID_AGREEMENT_REF');

384: )
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: --

Line 439: -- dbms_output.put_line(' Inside: PA_AGREEMENT_UTILS.CHECK_VALID_FUNDING_REF');

435: RETURN VARCHAR2
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:

Line 542: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_AGREEMENT_ID');

538: )
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;

Line 567: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_FUNDING_ID');

563: )
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:

Line 592: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_CUSTOMER_ID');

588: )
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:

Line 619: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_PROJECT_ID');

615: RETURN NUMBER
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:

Line 645: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.GET_TASK_ID');

641: RETURN NUMBER
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: --

Line 701: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.SUMMARY_FUNDING_UPDATE_ROW');

697: ,p_user_id IN VARCHAR2
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

Line 754: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_VALID_PROJECT');

750: p_agreement_id IN NUMBER) /*Federal*/
751: RETURN VARCHAR2 IS
752: BEGIN
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,

Line 785: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_VALID_TASK');

781: )
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;

Line 883: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_BUDGET_TYPE');

879: )
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

Line 908: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_REVENUE_LIMIT');

904: )
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:

Line 1149: -- dbms_output.put_line('Inside: pa_agreement_utils.update_agreement');

1145: p_Attribute24 IN VARCHAR2 DEFAULT NULL,
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,

Line 1262: -- dbms_output.put_line('Inside: pa_agreement_utils.create_funding');

1258: l_err_code NUMBER;
1259: l_err_msg VARCHAR2(100);
1260: np_p_Project_Funding_Id NUMBER := p_Project_Funding_Id;
1261: BEGIN
1262: -- dbms_output.put_line('Inside: pa_agreement_utils.create_funding');
1263:
1264: x_err_code := 0;
1265: x_err_msg := null;
1266:

Line 1548: -- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.CHECK_INVOICE_LIMIT');

1544: RETURN VARCHAR2 IS
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:

Line 1582: END PA_AGREEMENT_UTILS;

1578:
1579: END check_valid_exch_rate;
1580: */
1581:
1582: END PA_AGREEMENT_UTILS;