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 1602: l_task_id pa_tasks.task_id%TYPE ;

1598: l_project_id pa_projects_all.project_id%TYPE ;
1599: l_project_id_last pa_projects_all.project_id%TYPE ;
1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;
1605: l_task_number_last pa_tasks.task_number%TYPE ;
1606: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;

Line 1603: l_task_id_last pa_tasks.task_id%TYPE ;

1599: l_project_id_last pa_projects_all.project_id%TYPE ;
1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;
1605: l_task_number_last pa_tasks.task_number%TYPE ;
1606: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1607: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763

Line 1604: l_task_number pa_tasks.task_number%TYPE ;

1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;
1605: l_task_number_last pa_tasks.task_number%TYPE ;
1606: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1607: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1608:

Line 1605: l_task_number_last pa_tasks.task_number%TYPE ;

1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;
1605: l_task_number_last pa_tasks.task_number%TYPE ;
1606: --l_sponsored_flag gms_project_types_all.sponsored_flag%TYPE ;
1607: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1608:
1609: cursor c_project_id is

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

1612: where segment1 = l_project_number ;
1613:
1614: --
1615: -- bug : 3628820 perf issue in gmsawdeb.pls
1616: -- FTS on pa_projects and pa_tasks table.
1617: --
1618: cursor c_project_number is
1619: select segment1
1620: from pa_projects_all

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

1620: from pa_projects_all
1621: where project_id = l_project_id ;
1622: --
1623: -- bug : 3628820 perf issue in gmsawdeb.pls
1624: -- FTS on pa_projects and pa_tasks table.
1625: --
1626: cursor c_task_id is
1627: select task_id
1628: from pa_tasks

Line 1628: from pa_tasks

1624: -- FTS on pa_projects and pa_tasks table.
1625: --
1626: cursor c_task_id is
1627: select task_id
1628: from pa_tasks
1629: where task_number = l_task_number
1630: and project_id = l_project_id ;
1631:
1632: --

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

1630: and project_id = l_project_id ;
1631:
1632: --
1633: -- bug : 3628820 perf issue in gmsawdeb.pls
1634: -- FTS on pa_projects and pa_tasks table.
1635: --
1636: cursor c_task_number is
1637: select task_number
1638: from pa_tasks

Line 1638: from pa_tasks

1634: -- FTS on pa_projects and pa_tasks table.
1635: --
1636: cursor c_task_number is
1637: select task_number
1638: from pa_tasks
1639: where task_id = l_task_id ;
1640:
1641: --
1642: -- bug : 3628820 perf issue in gmsawdeb.pls

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

1639: where task_id = l_task_id ;
1640:
1641: --
1642: -- bug : 3628820 perf issue in gmsawdeb.pls
1643: -- FTS on pa_projects and pa_tasks table.
1644: --
1645: cursor c_sponsored_flag is
1646: select sponsored_flag
1647: from pa_projects_all p,

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

1911: EXIT expenditures ;
1912: END IF;
1913: --
1914: -- bug : 3628820 perf issue in gmsawdeb.pls
1915: -- FTS on pa_projects and pa_tasks table.
1916: --
1917: IF l_project_number is NULL and l_project_id is NOT NULL THEN
1918:
1919: IF l_project_id_last <> l_project_id THEN

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

1940: END IF ;
1941:
1942: --
1943: -- bug : 3628820 perf issue in gmsawdeb.pls
1944: -- FTS on pa_projects and pa_tasks table.
1945: --
1946: IF l_project_number is not NULL and l_project_id is NULL THEN
1947: IF l_project_number_last <> l_project_number OR
1948: l_project_number_last is NULL THEN

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

1976: END IF ;
1977:
1978: --
1979: -- bug : 3628820 perf issue in gmsawdeb.pls
1980: -- FTS on pa_projects and pa_tasks table.
1981: --
1982: IF l_task_number is NULL and l_task_id is NOT NULL THEN
1983: IF l_task_id_last <> l_task_id OR
1984: l_task_id_last is NULL THEN

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

1998: END IF ;
1999:
2000: --
2001: -- bug : 3628820 perf issue in gmsawdeb.pls
2002: -- FTS on pa_projects and pa_tasks table.
2003: --
2004: IF l_task_number is not NULL and l_task_id is NULL THEN
2005: IF l_task_number_last <> l_task_number OR
2006: l_task_number_last is NULL THEN

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

2036: -- bug:5131439 end...
2037: --
2038: --
2039: -- bug : 3628820 perf issue in gmsawdeb.pls
2040: -- FTS on pa_projects and pa_tasks table.
2041: --
2042:
2043: -- Following sql will be executed if both project id and project number
2044: -- are populated in the transaction interface table.

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

2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2069: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2070: --
2071: -- bug : 3628820 perf issue in gmsawdeb.pls
2072: -- FTS on pa_projects and pa_tasks table.
2073: --
2074: IF NVL(l_sponsored_flag,'N') = 'N' THEN
2075: X_status := 'GMS_NOT_A_SPONSORED_PROJECT' ;
2076: x_org_status := x_status ;