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 360: where syn.synonym_name = 'PA_AGREEMENTS_ALL'

356: cursor c_length(b_owner varchar2) is
357: select col.data_length
358: from user_synonyms syn,
359: all_tab_columns col
360: where syn.synonym_name = 'PA_AGREEMENTS_ALL'
361: and col.owner = b_owner
362: and col.table_name = syn.table_name
363: AND col.column_name = 'AGREEMENT_NUM';
364:

Line 371: where table_name = 'PA_AGREEMENTS_ALL'

367: /* commnented out for bugfix 15926104
368: cursor c_length(b_owner varchar2) is
369: select data_length
370: from all_tab_columns
371: where table_name = 'PA_AGREEMENTS_ALL'
372: and column_name = 'AGREEMENT_NUM'
373: and owner = b_owner; */
374:
375: l_schema_owner varchar2(10);

Line 411: from pa_agreements_all

407: RETURN NUMBER is
408:
409: cursor c_org is
410: select org_id
411: from pa_agreements_all
412: where agreement_id = p_agreement_id;
413:
414: l_org_id NUMBER;
415:

Line 829: from pa_agreements_all a

825:
826: cursor c_ou is
827: select org_id,
828: agreement_currency_code
829: from pa_agreements_all a
830: where a.agreement_id = p_allocation_in_rec.agreement_id;
831:
832: l_allocation c_rate%ROWTYPE;
833: l_ou c_ou%ROWTYPE;

Line 1347: from pa_agreements_all

1343: p_agreement_amount OUT NOCOPY NUMBER
1344: ) is
1345: cursor c_agreement is
1346: select *
1347: from pa_agreements_all
1348: where agreement_id = p_agreement_in_rec.agreement_id;
1349:
1350: l_agreement_row c_agreement%ROWTYPE;
1351:

Line 1489: pa_agreements_all p

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

Line 1503: from pa_agreements_all

1499: group by f.agreement_id;
1500:
1501: cursor c_agreement_count (x_length NUMBER) is
1502: select count(1)
1503: from pa_agreements_all
1504: where pm_product_code = G_PRODUCT_CODE
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

Line 1510: pa_agreements_all p

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

Line 2096: from pa_agreements_all

2092: ) is
2093:
2094: cursor c_agreement_count (x_length NUMBER) is
2095: select count(1)
2096: from pa_agreements_all
2097: where pm_product_code = G_PRODUCT_CODE
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

Line 2103: pa_agreements_all p

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

Line 2438: pa_agreements_all a,

2434: o.start_date_active,
2435: o.funding_category
2436: from oke_k_fund_allocations o,
2437: pa_projects_all p,
2438: pa_agreements_all a,
2439: pa_implementations_all i
2440: where funding_source_id = p_funding_in_rec.funding_source_id
2441: and o.project_id = x_project_id
2442: and o.project_id = p.project_id

Line 2463: pa_agreements_all a,

2459: o.start_date_active ,
2460: o.funding_category
2461: from oke_k_fund_allocations o,
2462: pa_projects_all p,
2463: pa_agreements_all a,
2464: pa_implementations_all i
2465: where funding_source_id = p_funding_in_rec.funding_source_id
2466: and o.project_id = p.project_id
2467: and o.project_id = x_project_id

Line 3131: from pa_agreements_all

3127: agreement_id,
3128: pm_agreement_reference,
3129: agreement_num,
3130: agreement_currency_code
3131: from pa_agreements_all
3132: where pm_product_code = G_PRODUCT_CODE
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;
3135:

Line 3138: from pa_agreements_all

3134: = '-' || p_funding_in_rec.funding_source_id;
3135:
3136: cursor c_count is
3137: select count(1)
3138: from pa_agreements_all
3139: where pm_product_code = G_PRODUCT_CODE
3140: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3141: = '-' || p_funding_in_rec.funding_source_id;
3142:

Line 3150: from pa_agreements_all a,

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

Line 3162: from pa_agreements_all

3158: cursor c_agreement2 (x_org_id number,
3159: x_currency varchar) is
3160: select nvl(org_id, -99) org_id,
3161: agreement_id
3162: from pa_agreements_all
3163: where pm_product_code = G_PRODUCT_CODE
3164: and nvl(org_id, -99) = x_org_id
3165: and pm_agreement_reference = org_id || '-' || x_currency || '-' || p_funding_in_rec.funding_source_id;
3166:

Line 3170: from pa_agreements_all

3166:
3167: cursor c_agreement4 is
3168: select nvl(org_id, -99) org_id,
3169: agreement_id
3170: from pa_agreements_all
3171: where pm_product_code = G_PRODUCT_CODE
3172: and substr(pm_agreement_reference, -1 * (length(p_funding_in_rec.funding_source_id) + 1), length(p_funding_in_rec.funding_source_id) + 1)
3173: = '-' || p_funding_in_rec.funding_source_id;
3174:

Line 3195: pa_agreements_all a

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

Line 3271: pa_agreements_all a

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

Line 4337: pa_agreements_all a,

4333: select a.agreement_currency_code,
4334: nvl(a.org_id, -99),
4335: s.currency_code
4336: from oke_k_fund_allocations o,
4337: pa_agreements_all a,
4338: --pa_projects_all p,
4339: oke_k_funding_sources s
4340: -- pa_implementations_all i
4341: where a.agreement_id = p_allocation_in_rec.agreement_id

Line 4356: pa_agreements_all a,

4352: --p.projfunc_currency_code,
4353: nvl(a.org_id, -99),
4354: i.multi_currency_billing_flag
4355: from oke_k_fund_allocations o,
4356: pa_agreements_all a,
4357: pa_projects_all p,
4358: oke_k_funding_sources s,
4359: pa_implementations_all i
4360: where a.agreement_id = p_allocation_in_rec.agreement_id