APPS.OKE_AGREEMENT_PVT dependencies on PA_PROJECT_FUNDINGS

Line 452: p_project_funding OUT NOCOPY PA_PROJECT_FUNDINGS%ROWTYPE

448: --
449:
450: PROCEDURE get_proj_funding(p_fund_allocation_id NUMBER ,
451: p_version NUMBER ,
452: p_project_funding OUT NOCOPY PA_PROJECT_FUNDINGS%ROWTYPE
453: ) is
454:
455: cursor c_project is
456: select *

Line 457: from pa_project_fundings

453: ) is
454:
455: cursor c_project is
456: select *
457: from pa_project_fundings
458: where pm_product_code = G_PRODUCT_CODE
459: and pm_funding_reference = to_char(p_fund_allocation_id) || '.' || to_char(p_version)
460: FOR UPDATE OF project_funding_id NOWAIT;
461:

Line 1488: from pa_project_fundings f,

1484: ) is
1485:
1486: cursor c_total(x_org_id NUMBER) is
1487: select sum(nvl(f.allocated_amount, 0)), p.agreement_id
1488: from pa_project_fundings f,
1489: pa_agreements_all p
1490: where p.agreement_id = f.agreement_id
1491: and p.pm_product_code = G_PRODUCT_CODE
1492: and p.pm_agreement_reference = x_org_id || '-N-' || p_funding_source_id

Line 1497: from pa_project_fundings f

1493: group by p.agreement_id;
1494:
1495: cursor c_total2(x_agreement_id NUMBER) is
1496: select sum(nvl(f.allocated_amount, 0))
1497: from pa_project_fundings f
1498: where f.agreement_id = x_agreement_id
1499: group by f.agreement_id;
1500:
1501: cursor c_agreement_count (x_length NUMBER) is

Line 1509: from pa_project_fundings f,

1505: and substr(pm_agreement_reference, -1 * x_length, x_length) = '-' || to_char(p_funding_source_id);
1506:
1507: cursor c_update_agreement (x_length NUMBER) is
1508: select sum(nvl(f.allocated_amount, 0)) amount, pm_agreement_reference, p.agreement_id, org_id
1509: from pa_project_fundings f,
1510: pa_agreements_all p
1511: where p.agreement_id = f.agreement_id
1512: and p.pm_product_code = G_PRODUCT_CODE
1513: and substr(pm_agreement_reference, -1 * x_length, x_length) = '-' || to_char(p_funding_source_id)

Line 2102: from pa_project_fundings f,

2098: and substr(pm_agreement_reference, -1 * x_length, x_length) = to_char(p_funding_source_id);
2099:
2100: cursor c_update_agreement (x_length NUMBER) is
2101: select sum(nvl(f.allocated_amount, 0)) amount, pm_agreement_reference, p.agreement_id, org_id
2102: from pa_project_fundings f,
2103: pa_agreements_all p
2104: where p.agreement_id = f.agreement_id
2105: and p.pm_product_code = G_PRODUCT_CODE
2106: and substr(pm_agreement_reference, -1 * x_length, x_length) = 'Y-' || to_char(p_funding_source_id)

Line 2284: from pa_project_fundings

2280: ) is
2281:
2282: cursor c_sum (length NUMBER) is
2283: select sum(nvl(allocated_amount, 0)), max(project_funding_id)
2284: from pa_project_fundings
2285: where pm_product_code = G_PRODUCT_CODE
2286: and substr(pm_funding_reference, 1, length + 1) = to_char(p_fund_allocation_id) || '.';
2287:
2288: cursor c_proj_funding (x_project_funding_id NUMBER) is

Line 2290: from pa_project_fundings

2286: and substr(pm_funding_reference, 1, length + 1) = to_char(p_fund_allocation_id) || '.';
2287:
2288: cursor c_proj_funding (x_project_funding_id NUMBER) is
2289: select nvl(allocated_amount, 0), budget_type_code, pm_funding_reference
2290: from pa_project_fundings
2291: where project_funding_id = x_project_funding_id;
2292:
2293: l_length NUMBER;
2294: l_max_proj_funding NUMBER := 0;

Line 3151: pa_project_fundings p

3147: a.agreement_num,
3148: sum(p.allocated_amount) agreement_sum,
3149: a.agreement_currency_code
3150: from pa_agreements_all a,
3151: pa_project_fundings p
3152: where a.pm_product_code = G_PRODUCT_CODE
3153: and a.agreement_id = p.agreement_id
3154: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3155: = '-' || p_funding_in_rec.funding_source_id

Line 3194: pa_project_fundings p,

3190: f.task_id,
3191: f.amount,
3192: f.funding_category
3193: from oke_k_fund_allocations f,
3194: pa_project_fundings p,
3195: pa_agreements_all a
3196: where funding_source_id = p_funding_in_rec.funding_source_id
3197: and f.project_id = x_project_id
3198: and nvl(insert_update_flag, 'N') = 'Y'

Line 3270: pa_project_fundings p,

3266: f.start_date_active,
3267: f.amount,
3268: f.funding_category
3269: from oke_k_fund_allocations f,
3270: pa_project_fundings p,
3271: pa_agreements_all a
3272: where funding_source_id = p_funding_in_rec.funding_source_id
3273: and f.project_id = x_project_id
3274: and nvl(insert_update_flag, 'N') = 'Y'

Line 4370: from pa_project_fundings

4366: and substr(a.pm_funding_reference, 1, x_length + 1) = to_char(p_allocation_in_rec.fund_allocation_id) || '.';
4367:
4368: cursor c_project_funding (length number) is
4369: select *
4370: from pa_project_fundings
4371: where agreement_id = p_allocation_in_rec.agreement_id
4372: and substr(pm_funding_reference, 1, length + 1) = to_char(p_allocation_in_rec.fund_allocation_id) || '.'
4373: and pm_product_code = G_PRODUCT_CODE;
4374: */

Line 4381: l_project_funding PA_PROJECT_FUNDINGS%ROWTYPE;

4377: l_return_status VARCHAR2(1);
4378: l_amount NUMBER;
4379: l_funding_id NUMBER;
4380: l_diff_amount NUMBER;
4381: l_project_funding PA_PROJECT_FUNDINGS%ROWTYPE;
4382: l_version NUMBER;
4383: l_add_flag VARCHAR2(1);
4384: l_org_id_vc VARCHAR(10);
4385: l_org_id_n NUMBER;

Line 4719: update pa_project_fundings

4715: RAISE OKE_API.G_EXCEPTION_ERROR;
4716:
4717: END IF;
4718: */
4719: update pa_project_fundings
4720: set attribute_category = l_allocation_in_rec.pa_attribute_category
4721: , attribute1 = l_allocation_in_rec.pa_attribute1
4722: , attribute2 = l_allocation_in_rec.pa_attribute2
4723: , attribute3 = l_allocation_in_rec.pa_attribute3

Line 4956: update pa_project_fundings

4952: --
4953: -- Update project funding line flexfield since PA AMG add_funding doesn't handle
4954: --
4955:
4956: update pa_project_fundings
4957: set attribute_category = l_allocation_in_rec.pa_attribute_category
4958: , attribute1 = l_allocation_in_rec.pa_attribute1
4959: , attribute2 = l_allocation_in_rec.pa_attribute2
4960: , attribute3 = l_allocation_in_rec.pa_attribute3