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.OKE_AGREEMENT_PVT dependencies on PA_AGREEMENTS_ALL

Line 356: where table_name = 'PA_AGREEMENTS_ALL'

352:
353: cursor c_length(b_owner varchar2) is
354: select data_length
355: from all_tab_columns
356: where table_name = 'PA_AGREEMENTS_ALL'
357: and column_name = 'AGREEMENT_NUM'
358: and owner = b_owner;
359:
360: l_schema_owner varchar2(10);

Line 396: from pa_agreements_all

392: RETURN NUMBER is
393:
394: cursor c_org is
395: select org_id
396: from pa_agreements_all
397: where agreement_id = p_agreement_id;
398:
399: l_org_id NUMBER;
400:

Line 814: from pa_agreements_all a

810:
811: cursor c_ou is
812: select org_id,
813: agreement_currency_code
814: from pa_agreements_all a
815: where a.agreement_id = p_allocation_in_rec.agreement_id;
816:
817: l_allocation c_rate%ROWTYPE;
818: l_ou c_ou%ROWTYPE;

Line 1332: from pa_agreements_all

1328: p_agreement_amount OUT NOCOPY NUMBER
1329: ) is
1330: cursor c_agreement is
1331: select *
1332: from pa_agreements_all
1333: where agreement_id = p_agreement_in_rec.agreement_id;
1334:
1335: l_agreement_row c_agreement%ROWTYPE;
1336:

Line 1474: pa_agreements_all p

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
1478: group by p.agreement_id;

Line 1488: from pa_agreements_all

1484: group by f.agreement_id;
1485:
1486: cursor c_agreement_count (x_length NUMBER) is
1487: select count(1)
1488: from pa_agreements_all
1489: where pm_product_code = G_PRODUCT_CODE
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

Line 1495: pa_agreements_all p

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)
1499: group by p.agreement_id, pm_agreement_reference, org_id;

Line 2081: from pa_agreements_all

2077: ) is
2078:
2079: cursor c_agreement_count (x_length NUMBER) is
2080: select count(1)
2081: from pa_agreements_all
2082: where pm_product_code = G_PRODUCT_CODE
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

Line 2088: pa_agreements_all p

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)
2092: group by p.agreement_id, pm_agreement_reference, org_id;

Line 2422: pa_agreements_all a,

2418: o.start_date_active,
2419: o.funding_category
2420: from oke_k_fund_allocations o,
2421: pa_projects_all p,
2422: pa_agreements_all a,
2423: pa_implementations_all i
2424: where funding_source_id = p_funding_in_rec.funding_source_id
2425: and o.project_id = x_project_id
2426: and o.project_id = p.project_id

Line 2447: pa_agreements_all a,

2443: o.start_date_active ,
2444: o.funding_category
2445: from oke_k_fund_allocations o,
2446: pa_projects_all p,
2447: pa_agreements_all a,
2448: pa_implementations_all i
2449: where funding_source_id = p_funding_in_rec.funding_source_id
2450: and o.project_id = p.project_id
2451: and o.project_id = x_project_id

Line 3110: from pa_agreements_all

3106: agreement_id,
3107: pm_agreement_reference,
3108: agreement_num,
3109: agreement_currency_code
3110: from pa_agreements_all
3111: where pm_product_code = G_PRODUCT_CODE
3112: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3113: = '-' || p_funding_in_rec.funding_source_id;
3114:

Line 3117: from pa_agreements_all

3113: = '-' || p_funding_in_rec.funding_source_id;
3114:
3115: cursor c_count is
3116: select count(1)
3117: from pa_agreements_all
3118: where pm_product_code = G_PRODUCT_CODE
3119: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3120: = '-' || p_funding_in_rec.funding_source_id;
3121:

Line 3129: from pa_agreements_all a,

3125: a.pm_agreement_reference,
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)

Line 3141: from pa_agreements_all

3137: cursor c_agreement2 (x_org_id number,
3138: x_currency varchar) is
3139: select nvl(org_id, -99) org_id,
3140: agreement_id
3141: from pa_agreements_all
3142: where pm_product_code = G_PRODUCT_CODE
3143: and nvl(org_id, -99) = x_org_id
3144: and pm_agreement_reference = org_id || '-' || x_currency || '-' || p_funding_in_rec.funding_source_id;
3145:

Line 3149: from pa_agreements_all

3145:
3146: cursor c_agreement4 is
3147: select nvl(org_id, -99) org_id,
3148: agreement_id
3149: from pa_agreements_all
3150: where pm_product_code = G_PRODUCT_CODE
3151: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3152: = '-' || p_funding_in_rec.funding_source_id;
3153:

Line 3174: pa_agreements_all a

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'
3178: and p.pm_product_code = G_PRODUCT_CODE

Line 3250: pa_agreements_all a

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'
3254: and f.project_id = p.project_id

Line 4312: pa_agreements_all a,

4308: select a.agreement_currency_code,
4309: nvl(a.org_id, -99),
4310: s.currency_code
4311: from oke_k_fund_allocations o,
4312: pa_agreements_all a,
4313: --pa_projects_all p,
4314: oke_k_funding_sources s
4315: -- pa_implementations_all i
4316: where a.agreement_id = p_allocation_in_rec.agreement_id

Line 4331: pa_agreements_all a,

4327: --p.projfunc_currency_code,
4328: nvl(a.org_id, -99),
4329: i.multi_currency_billing_flag
4330: from oke_k_fund_allocations o,
4331: pa_agreements_all a,
4332: pa_projects_all p,
4333: oke_k_funding_sources s,
4334: pa_implementations_all i
4335: where a.agreement_id = p_allocation_in_rec.agreement_id