APPS.PA_AGREEMENT_PVT dependencies on PA_PROJECT_FUNDINGS

Line 161: FROM pa_project_fundings

157: IS
158: CURSOR l_funding_id_csr
159: IS
160: SELECT 'X'
161: FROM pa_project_fundings
162: where project_funding_id = p_af_funding_id;
163:
164: l_api_name CONSTANT VARCHAR2(30) := 'Convert_fu_ref_to_id';
165: l_agreement_id NUMBER ;

Line 320: pa_project_fundings

316: IS
317: CURSOR c_fundings_csr IS
318: SELECT project_funding_id
319: FROM
320: pa_project_fundings
321: WHERE
322: pm_funding_reference = p_pm_funding_reference;
323:
324: l_funding_rec c_fundings_csr%ROWTYPE;

Line 1058: FROM pa_project_fundings

1054: WHERE agreement_id = p_agreement_id;
1055: /* Commented for bug 6853994
1056: SELECT sum(allocated_amount)
1057: INTO l_tot_fund
1058: FROM pa_project_fundings
1059: WHERE agreement_id = p_agreement_id;
1060: */
1061: IF (p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
1062: l_start_date := cur_start_date;

Line 1113: FROM pa_project_fundings fun,

1109:
1110: /* Federal
1111: SELECT count(*)
1112: INTO l_count
1113: FROM pa_project_fundings fun,
1114: pa_events ev
1115: WHERE fun.agreement_id = p_agreement_id
1116: AND fun.agreement_id = ev.agreement_id
1117: AND fun.project_id = ev.project_id

Line 1144: FROM pa_project_fundings

1140: IF (cur_adv_req <> l_adv_req) then
1141:
1142: SELECT COUNT(*)
1143: INTO l_fund_count
1144: FROM pa_project_fundings
1145: WHERE agreement_id = p_agreement_id;
1146:
1147: IF l_fund_count >0 THEN
1148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1321: FROM PA_PROJECT_FUNDINGS

1317: FROM PA_AGREEMENTS_ALL
1318: WHERE AGREEMENT_ID = p_agreement_id
1319: AND (AGREEMENT_CURRENCY_CODE <> p_agreement_currency_code
1320: AND EXISTS ( SELECT *
1321: FROM PA_PROJECT_FUNDINGS
1322: WHERE AGREEMENT_ID= p_agreement_id
1323: AND nvl(ALLOCATED_AMOUNT,0) <> 0));
1324: --dbms_output.put_line('Invalid agreement_currency_code ');
1325: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1452: FROM pa_project_fundings f

1448:
1449: CURSOR l_funding_id_csr(p_agreement_id NUMBER)
1450: IS
1451: SELECT project_funding_id,pm_funding_reference,agreement_id, allocated_amount
1452: FROM pa_project_fundings f
1453: WHERE f.agreement_id = p_agreement_id;
1454:
1455: -- LOCAL VARIABLES
1456: l_RETURN VARCHAR2(1) :='Y';

Line 1525: pa_project_fundings f

1521: /*
1522: select count(*)
1523: into l_count
1524: from pa_events e,
1525: pa_project_fundings f
1526: where e.project_id = f.project_id
1527: and e.agreement_id = f.agreement_id
1528: and f.agreement_id = p_agreement_id;
1529:

Line 2519: FROM pa_project_fundings f

2515: -- added to validate the funding amount
2516: IF p_funding_id IS NOT NULL THEN
2517: SELECT f.allocated_amount
2518: INTO l_funding_amt
2519: FROM pa_project_fundings f
2520: WHERE f.project_funding_id = p_funding_id;
2521: ELSIF p_pm_funding_reference IS NULL THEN
2522: SELECT f.allocated_amount
2523: INTO l_funding_amt

Line 2524: FROM pa_project_fundings f

2520: WHERE f.project_funding_id = p_funding_id;
2521: ELSIF p_pm_funding_reference IS NULL THEN
2522: SELECT f.allocated_amount
2523: INTO l_funding_amt
2524: FROM pa_project_fundings f
2525: WHERE f.pm_funding_reference = p_pm_funding_reference
2526: AND f.agreement_id = p_agreement_id;
2527: END IF;
2528: l_valid_fund_amt := pa_agreement_pvt.validate_funding_amt(p_funding_amt => l_funding_amt

Line 2707: Select 1 from pa_project_fundings

2703: (p_funding_reference VARCHAR2)
2704: RETURN VARCHAR2
2705: IS
2706: CURSOR C1 is
2707: Select 1 from pa_project_fundings
2708: where pm_funding_reference = p_funding_reference;
2709:
2710: l_temp NUMBER;
2711:

Line 2768: FROM pa_project_fundings f

2764: IF p_funding_id IS NOT NULL THEN
2765: --dbms_output.put_line('INSIDE: => validate_funding_amt => Funding id is '|| to_char(p_funding_id));
2766: SELECT nvl(f.allocated_amount,0)
2767: INTO l_fun_amt
2768: FROM pa_project_fundings f
2769: WHERE f.project_funding_id = p_funding_id;
2770: END IF;
2771:
2772: /*Federal*/

Line 2781: FROM pa_project_fundings f

2777: --dbms_output.put_line('INSIDE: => validate_funding_amt => Total Agreement Amt is '|| to_char(l_agr_amt));
2778:
2779: SELECT nvl(SUM(f.allocated_amount),0)
2780: INTO l_fun_sum
2781: FROM pa_project_fundings f
2782: WHERE f.agreement_id = p_agreement_id;
2783:
2784: --dbms_output.put_line('INSIDE: => validate_funding_amt => Total Funding Amt is '|| to_char(l_fun_sum));
2785: