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.GMS_AWARD_DIST_ENG dependencies on PA_TASKS

Line 7: -- top_task_id and pa_tasks join was added.

3:
4: -- =================================================================================
5: -- BUG: 3358176 Award Distribution not recognized for sub tasks when funding
6: -- pattern is defined at top task level.
7: -- top_task_id and pa_tasks join was added.
8: -- =================================================================================
9: cursor get_funding_pattern (p_project_id in number,
10: p_task_id in number,
11: p_exp_item_dt in date,

Line 16: pa_tasks t

12: p_org_id in number) is
13: select fp.funding_sequence,
14: fp.funding_pattern_id
15: from gms_funding_patterns_all fp,
16: pa_tasks t
17: where nvl(fp.retroactive_flag, 'N') = 'N'
18: and NVL(fp.status, 'N') = 'A'
19: -- and org_id = nvl(p_org_id, org_id )
20: and ((fp.org_id = p_org_id) or (fp.org_id is null and p_org_id is null)) -- bug 2362489

Line 38: pa_tasks t1

34: and task_id is null
35: and p_exp_item_dt between start_date and nvl(end_date, p_exp_item_dt)
36: and not exists (select '1'
37: from gms_funding_patterns_all b,
38: pa_tasks t1
39: where gfpa.project_id = b.project_id
40: and b.status = 'A'
41: and t1.task_id = p_task_id
42: and b.task_id = t1.top_task_id)

Line 1736: l_task_id pa_tasks.task_id%TYPE ;

1732: l_project_id pa_projects_all.project_id%TYPE ;
1733: l_project_id_last pa_projects_all.project_id%TYPE ;
1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;
1739: l_task_number_last pa_tasks.task_number%TYPE ;
1740: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;

Line 1737: l_task_id_last pa_tasks.task_id%TYPE ;

1733: l_project_id_last pa_projects_all.project_id%TYPE ;
1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;
1739: l_task_number_last pa_tasks.task_number%TYPE ;
1740: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1741: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763

Line 1738: l_task_number pa_tasks.task_number%TYPE ;

1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;
1739: l_task_number_last pa_tasks.task_number%TYPE ;
1740: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1741: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1742:

Line 1739: l_task_number_last pa_tasks.task_number%TYPE ;

1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;
1739: l_task_number_last pa_tasks.task_number%TYPE ;
1740: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1741: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1742:
1743: cursor c_project_id is

Line 1750: -- FTS on pa_projects and pa_tasks table.

1746: where segment1 = l_project_number ;
1747:
1748: --
1749: -- bug : 3628820 perf issue in gmsawdeb.pls
1750: -- FTS on pa_projects and pa_tasks table.
1751: --
1752: cursor c_project_number is
1753: select segment1
1754: from pa_projects_all

Line 1758: -- FTS on pa_projects and pa_tasks table.

1754: from pa_projects_all
1755: where project_id = l_project_id ;
1756: --
1757: -- bug : 3628820 perf issue in gmsawdeb.pls
1758: -- FTS on pa_projects and pa_tasks table.
1759: --
1760: cursor c_task_id is
1761: select task_id
1762: from pa_tasks

Line 1762: from pa_tasks

1758: -- FTS on pa_projects and pa_tasks table.
1759: --
1760: cursor c_task_id is
1761: select task_id
1762: from pa_tasks
1763: where task_number = l_task_number
1764: and project_id = l_project_id ;
1765:
1766: --

Line 1768: -- FTS on pa_projects and pa_tasks table.

1764: and project_id = l_project_id ;
1765:
1766: --
1767: -- bug : 3628820 perf issue in gmsawdeb.pls
1768: -- FTS on pa_projects and pa_tasks table.
1769: --
1770: cursor c_task_number is
1771: select task_number
1772: from pa_tasks

Line 1772: from pa_tasks

1768: -- FTS on pa_projects and pa_tasks table.
1769: --
1770: cursor c_task_number is
1771: select task_number
1772: from pa_tasks
1773: where task_id = l_task_id ;
1774:
1775: --
1776: -- bug : 3628820 perf issue in gmsawdeb.pls

Line 1777: -- FTS on pa_projects and pa_tasks table.

1773: where task_id = l_task_id ;
1774:
1775: --
1776: -- bug : 3628820 perf issue in gmsawdeb.pls
1777: -- FTS on pa_projects and pa_tasks table.
1778: --
1779: cursor c_sponsored_flag is
1780: select sponsored_flag
1781: from pa_projects_all p,

Line 2049: -- FTS on pa_projects and pa_tasks table.

2045: EXIT expenditures ;
2046: END IF;
2047: --
2048: -- bug : 3628820 perf issue in gmsawdeb.pls
2049: -- FTS on pa_projects and pa_tasks table.
2050: --
2051: IF l_project_number is NULL and l_project_id is NOT NULL THEN
2052:
2053: IF l_project_id_last <> l_project_id THEN

Line 2078: -- FTS on pa_projects and pa_tasks table.

2074: END IF ;
2075:
2076: --
2077: -- bug : 3628820 perf issue in gmsawdeb.pls
2078: -- FTS on pa_projects and pa_tasks table.
2079: --
2080: IF l_project_number is not NULL and l_project_id is NULL THEN
2081: IF l_project_number_last <> l_project_number OR
2082: l_project_number_last is NULL THEN

Line 2114: -- FTS on pa_projects and pa_tasks table.

2110: END IF ;
2111:
2112: --
2113: -- bug : 3628820 perf issue in gmsawdeb.pls
2114: -- FTS on pa_projects and pa_tasks table.
2115: --
2116: IF l_task_number is NULL and l_task_id is NOT NULL THEN
2117: IF l_task_id_last <> l_task_id OR
2118: l_task_id_last is NULL THEN

Line 2136: -- FTS on pa_projects and pa_tasks table.

2132: END IF ;
2133:
2134: --
2135: -- bug : 3628820 perf issue in gmsawdeb.pls
2136: -- FTS on pa_projects and pa_tasks table.
2137: --
2138: IF l_task_number is not NULL and l_task_id is NULL THEN
2139: IF l_task_number_last <> l_task_number OR
2140: l_task_number_last is NULL THEN

Line 2174: -- FTS on pa_projects and pa_tasks table.

2170: -- bug:5131439 end...
2171: --
2172: --
2173: -- bug : 3628820 perf issue in gmsawdeb.pls
2174: -- FTS on pa_projects and pa_tasks table.
2175: --
2176:
2177: -- Following sql will be executed if both project id and project number
2178: -- are populated in the transaction interface table.

Line 2206: -- FTS on pa_projects and pa_tasks table.

2202: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2203: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2204: --
2205: -- bug : 3628820 perf issue in gmsawdeb.pls
2206: -- FTS on pa_projects and pa_tasks table.
2207: --
2208: IF NVL(l_sponsored_flag,'N') = 'N' THEN
2209: X_status := 'GMS_NOT_A_SPONSORED_PROJECT' ;
2210: x_org_status := x_status ;