APPS.OKE_AGREEMENT_PVT dependencies on PA_PROJECT_FUNDINGS

Line 437: p_project_funding OUT NOCOPY PA_PROJECT_FUNDINGS%ROWTYPE

433: --
434:
435: PROCEDURE get_proj_funding(p_fund_allocation_id NUMBER ,
436: p_version NUMBER ,
437: p_project_funding OUT NOCOPY PA_PROJECT_FUNDINGS%ROWTYPE
438: ) is
439:
440: cursor c_project is
441: select *

Line 442: from pa_project_fundings

438: ) is
439:
440: cursor c_project is
441: select *
442: from pa_project_fundings
443: where pm_product_code = G_PRODUCT_CODE
444: and pm_funding_reference = to_char(p_fund_allocation_id) || '.' || to_char(p_version)
445: FOR UPDATE OF project_funding_id NOWAIT;
446:

Line 1473: from pa_project_fundings f,

1469: ) is
1470:
1471: cursor c_total(x_org_id NUMBER) is
1472: select sum(nvl(f.allocated_amount, 0)), p.agreement_id
1473: from pa_project_fundings f,
1474: pa_agreements_all p
1475: where p.agreement_id = f.agreement_id
1476: and p.pm_product_code = G_PRODUCT_CODE
1477: and p.pm_agreement_reference = x_org_id || '-N-' || p_funding_source_id

Line 1482: from pa_project_fundings f

1478: group by p.agreement_id;
1479:
1480: cursor c_total2(x_agreement_id NUMBER) is
1481: select sum(nvl(f.allocated_amount, 0))
1482: from pa_project_fundings f
1483: where f.agreement_id = x_agreement_id
1484: group by f.agreement_id;
1485:
1486: cursor c_agreement_count (x_length NUMBER) is

Line 1494: from pa_project_fundings f,

1490: and substr(pm_agreement_reference, -1 * x_length, x_length) = '-' || to_char(p_funding_source_id);
1491:
1492: cursor c_update_agreement (x_length NUMBER) is
1493: select sum(nvl(f.allocated_amount, 0)) amount, pm_agreement_reference, p.agreement_id, org_id
1494: from pa_project_fundings f,
1495: pa_agreements_all p
1496: where p.agreement_id = f.agreement_id
1497: and p.pm_product_code = G_PRODUCT_CODE
1498: and substr(pm_agreement_reference, -1 * x_length, x_length) = '-' || to_char(p_funding_source_id)

Line 2087: from pa_project_fundings f,

2083: and substr(pm_agreement_reference, -1 * x_length, x_length) = to_char(p_funding_source_id);
2084:
2085: cursor c_update_agreement (x_length NUMBER) is
2086: select sum(nvl(f.allocated_amount, 0)) amount, pm_agreement_reference, p.agreement_id, org_id
2087: from pa_project_fundings f,
2088: pa_agreements_all p
2089: where p.agreement_id = f.agreement_id
2090: and p.pm_product_code = G_PRODUCT_CODE
2091: and substr(pm_agreement_reference, -1 * x_length, x_length) = 'Y-' || to_char(p_funding_source_id)

Line 2269: from pa_project_fundings

2265: ) is
2266:
2267: cursor c_sum (length NUMBER) is
2268: select sum(nvl(allocated_amount, 0)), max(project_funding_id)
2269: from pa_project_fundings
2270: where pm_product_code = G_PRODUCT_CODE
2271: and substr(pm_funding_reference, 1, length + 1) = to_char(p_fund_allocation_id) || '.';
2272:
2273: cursor c_proj_funding (x_project_funding_id NUMBER) is

Line 2275: from pa_project_fundings

2271: and substr(pm_funding_reference, 1, length + 1) = to_char(p_fund_allocation_id) || '.';
2272:
2273: cursor c_proj_funding (x_project_funding_id NUMBER) is
2274: select nvl(allocated_amount, 0), budget_type_code, pm_funding_reference
2275: from pa_project_fundings
2276: where project_funding_id = x_project_funding_id;
2277:
2278: l_length NUMBER;
2279: l_max_proj_funding NUMBER := 0;

Line 3130: pa_project_fundings p

3126: a.agreement_num,
3127: sum(p.allocated_amount) agreement_sum,
3128: a.agreement_currency_code
3129: from pa_agreements_all a,
3130: pa_project_fundings p
3131: where a.pm_product_code = G_PRODUCT_CODE
3132: and a.agreement_id = p.agreement_id
3133: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3134: = '-' || p_funding_in_rec.funding_source_id

Line 3173: pa_project_fundings p,

3169: f.task_id,
3170: f.amount,
3171: f.funding_category
3172: from oke_k_fund_allocations f,
3173: pa_project_fundings p,
3174: pa_agreements_all a
3175: where funding_source_id = p_funding_in_rec.funding_source_id
3176: and f.project_id = x_project_id
3177: and nvl(insert_update_flag, 'N') = 'Y'

Line 3249: pa_project_fundings p,

3245: f.start_date_active,
3246: f.amount,
3247: f.funding_category
3248: from oke_k_fund_allocations f,
3249: pa_project_fundings p,
3250: pa_agreements_all a
3251: where funding_source_id = p_funding_in_rec.funding_source_id
3252: and f.project_id = x_project_id
3253: and nvl(insert_update_flag, 'N') = 'Y'

Line 4345: from pa_project_fundings

4341: and substr(a.pm_funding_reference, 1, x_length + 1) = to_char(p_allocation_in_rec.fund_allocation_id) || '.';
4342:
4343: cursor c_project_funding (length number) is
4344: select *
4345: from pa_project_fundings
4346: where agreement_id = p_allocation_in_rec.agreement_id
4347: and substr(pm_funding_reference, 1, length + 1) = to_char(p_allocation_in_rec.fund_allocation_id) || '.'
4348: and pm_product_code = G_PRODUCT_CODE;
4349: */

Line 4356: l_project_funding PA_PROJECT_FUNDINGS%ROWTYPE;

4352: l_return_status VARCHAR2(1);
4353: l_amount NUMBER;
4354: l_funding_id NUMBER;
4355: l_diff_amount NUMBER;
4356: l_project_funding PA_PROJECT_FUNDINGS%ROWTYPE;
4357: l_version NUMBER;
4358: l_add_flag VARCHAR2(1);
4359: l_org_id_vc VARCHAR(10);
4360: l_org_id_n NUMBER;

Line 4694: update pa_project_fundings

4690: RAISE OKE_API.G_EXCEPTION_ERROR;
4691:
4692: END IF;
4693: */
4694: update pa_project_fundings
4695: set attribute_category = l_allocation_in_rec.pa_attribute_category
4696: , attribute1 = l_allocation_in_rec.pa_attribute1
4697: , attribute2 = l_allocation_in_rec.pa_attribute2
4698: , attribute3 = l_allocation_in_rec.pa_attribute3

Line 4931: update pa_project_fundings

4927: --
4928: -- Update project funding line flexfield since PA AMG add_funding doesn't handle
4929: --
4930:
4931: update pa_project_fundings
4932: set attribute_category = l_allocation_in_rec.pa_attribute_category
4933: , attribute1 = l_allocation_in_rec.pa_attribute1
4934: , attribute2 = l_allocation_in_rec.pa_attribute2
4935: , attribute3 = l_allocation_in_rec.pa_attribute3