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.PA_PROJECT_ASSETS_PUB dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 1922: FROM pa_project_asset_assignments

1918:
1919: --Used to determine if Task assignments exist
1920: CURSOR task_assign_cur IS
1921: SELECT 'Task Assignments Exist'
1922: FROM pa_project_asset_assignments
1923: WHERE project_id = l_project_id
1924: AND task_id <> 0;
1925:
1926: task_assign_rec task_assign_cur%ROWTYPE;

Line 1932: FROM pa_project_asset_assignments

1928:
1929: --Used to determine if Project assignments exist
1930: CURSOR proj_assign_cur IS
1931: SELECT 'Project Assignments Exist'
1932: FROM pa_project_asset_assignments
1933: WHERE project_id = l_project_id
1934: AND task_id = 0;
1935:
1936: proj_assign_rec proj_assign_cur%ROWTYPE;

Line 1942: FROM pa_project_asset_assignments

1938:
1939: --Used to determine if Project-level Specific Asset assignments exist
1940: CURSOR specific_assign_cur IS
1941: SELECT 'Project Specific Assignments Exist'
1942: FROM pa_project_asset_assignments
1943: WHERE project_id = l_project_id
1944: AND task_id = 0
1945: AND project_asset_id <> 0;
1946:

Line 1953: FROM pa_project_asset_assignments

1949:
1950: --Used to determine if Project-level Common assignments exist
1951: CURSOR common_assign_cur IS
1952: SELECT 'Project Common Assignments Exist'
1953: FROM pa_project_asset_assignments
1954: WHERE project_id = l_project_id
1955: AND task_id = 0
1956: AND project_asset_id = 0;
1957:

Line 1964: FROM pa_project_asset_assignments

1960:
1961: --Used to determine if Task-level Specific Asset assignments exist
1962: CURSOR task_specific_assign_cur(x_task_id NUMBER) IS
1963: SELECT 'Project Specific Assignments Exist'
1964: FROM pa_project_asset_assignments
1965: WHERE project_id = l_project_id
1966: AND task_id = x_task_id
1967: AND project_asset_id <> 0;
1968:

Line 1975: FROM pa_project_asset_assignments

1971:
1972: --Used to determine if Task-level Common assignments exist
1973: CURSOR task_common_assign_cur(x_task_id NUMBER) IS
1974: SELECT 'Project Common Assignments Exist'
1975: FROM pa_project_asset_assignments
1976: WHERE project_id = l_project_id
1977: AND task_id = x_task_id
1978: AND project_asset_id = 0;
1979:

Line 2004: FROM pa_project_asset_assignments p,

2000:
2001: --Used to determine if Lowest-Task assignments exist below a given Top Task
2002: CURSOR child_assign_cur(x_task_id NUMBER) IS
2003: SELECT 'Lowest Task Assignments Exist'
2004: FROM pa_project_asset_assignments p,
2005: pa_tasks t
2006: WHERE p.project_id = l_project_id
2007: AND p.task_id = t.task_id
2008: AND t.top_task_id = x_task_id

Line 2017: FROM pa_project_asset_assignments p,

2013:
2014: --Used to determine if Top-Task assignments exist above a given Lowest Task
2015: CURSOR top_assign_cur(x_task_id NUMBER) IS
2016: SELECT 'Top Task Assignments Exist'
2017: FROM pa_project_asset_assignments p,
2018: pa_tasks t
2019: WHERE p.project_id = l_project_id
2020: AND p.task_id = t.top_task_id
2021: AND t.task_id = x_task_id

Line 2032: FROM pa_project_asset_assignments

2028: CURSOR existing_assignment_cur (x_project_id NUMBER,
2029: x_task_id NUMBER,
2030: x_project_asset_id NUMBER) IS
2031: SELECT 'Assignment Already Exists'
2032: FROM pa_project_asset_assignments
2033: WHERE project_id = x_project_id
2034: AND task_id = x_task_id
2035: AND project_asset_id = x_project_asset_id;
2036:

Line 2051: l_attribute_category PA_PROJECT_ASSET_ASSIGNMENTS.attribute_category%TYPE;

2047: l_msg_count NUMBER ;
2048: l_msg_data VARCHAR2(2000);
2049: l_task_id NUMBER;
2050: l_project_asset_id NUMBER;
2051: l_attribute_category PA_PROJECT_ASSET_ASSIGNMENTS.attribute_category%TYPE;
2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;
2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;

Line 2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;

2048: l_msg_data VARCHAR2(2000);
2049: l_task_id NUMBER;
2050: l_project_asset_id NUMBER;
2051: l_attribute_category PA_PROJECT_ASSET_ASSIGNMENTS.attribute_category%TYPE;
2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;
2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;

Line 2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;

2049: l_task_id NUMBER;
2050: l_project_asset_id NUMBER;
2051: l_attribute_category PA_PROJECT_ASSET_ASSIGNMENTS.attribute_category%TYPE;
2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;
2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;

Line 2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;

2050: l_project_asset_id NUMBER;
2051: l_attribute_category PA_PROJECT_ASSET_ASSIGNMENTS.attribute_category%TYPE;
2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;
2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;

Line 2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;

2051: l_attribute_category PA_PROJECT_ASSET_ASSIGNMENTS.attribute_category%TYPE;
2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;
2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;

Line 2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;

2052: l_attribute1 PA_PROJECT_ASSET_ASSIGNMENTS.attribute1%TYPE;
2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;

Line 2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;

2053: l_attribute2 PA_PROJECT_ASSET_ASSIGNMENTS.attribute2%TYPE;
2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;

Line 2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;

2054: l_attribute3 PA_PROJECT_ASSET_ASSIGNMENTS.attribute3%TYPE;
2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;

Line 2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;

2055: l_attribute4 PA_PROJECT_ASSET_ASSIGNMENTS.attribute4%TYPE;
2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;

Line 2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;

2056: l_attribute5 PA_PROJECT_ASSET_ASSIGNMENTS.attribute5%TYPE;
2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;

Line 2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;

2057: l_attribute6 PA_PROJECT_ASSET_ASSIGNMENTS.attribute6%TYPE;
2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;
2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;

Line 2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;

2058: l_attribute7 PA_PROJECT_ASSET_ASSIGNMENTS.attribute7%TYPE;
2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;
2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;
2066: l_attribute15 PA_PROJECT_ASSET_ASSIGNMENTS.attribute15%TYPE;

Line 2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;

2059: l_attribute8 PA_PROJECT_ASSET_ASSIGNMENTS.attribute8%TYPE;
2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;
2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;
2066: l_attribute15 PA_PROJECT_ASSET_ASSIGNMENTS.attribute15%TYPE;
2067:

Line 2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;

2060: l_attribute9 PA_PROJECT_ASSET_ASSIGNMENTS.attribute9%TYPE;
2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;
2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;
2066: l_attribute15 PA_PROJECT_ASSET_ASSIGNMENTS.attribute15%TYPE;
2067:
2068:

Line 2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;

2061: l_attribute10 PA_PROJECT_ASSET_ASSIGNMENTS.attribute10%TYPE;
2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;
2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;
2066: l_attribute15 PA_PROJECT_ASSET_ASSIGNMENTS.attribute15%TYPE;
2067:
2068:
2069: BEGIN

Line 2066: l_attribute15 PA_PROJECT_ASSET_ASSIGNMENTS.attribute15%TYPE;

2062: l_attribute11 PA_PROJECT_ASSET_ASSIGNMENTS.attribute11%TYPE;
2063: l_attribute12 PA_PROJECT_ASSET_ASSIGNMENTS.attribute12%TYPE;
2064: l_attribute13 PA_PROJECT_ASSET_ASSIGNMENTS.attribute13%TYPE;
2065: l_attribute14 PA_PROJECT_ASSET_ASSIGNMENTS.attribute14%TYPE;
2066: l_attribute15 PA_PROJECT_ASSET_ASSIGNMENTS.attribute15%TYPE;
2067:
2068:
2069: BEGIN
2070:

Line 2669: INSERT INTO pa_project_asset_assignments

2665: FETCH existing_assignment_cur INTO existing_assignment_rec;
2666: IF existing_assignment_cur%NOTFOUND THEN
2667:
2668: --Insert new assignment
2669: INSERT INTO pa_project_asset_assignments
2670: (project_asset_id,
2671: task_id,
2672: project_id,
2673: last_update_date,

Line 6571: FROM pa_project_asset_assignments

6567:
6568: --Check if Assignment already exists
6569: SELECT COUNT(*)
6570: INTO v_assignment_count
6571: FROM pa_project_asset_assignments
6572: WHERE project_id = l_project_id
6573: AND task_id = l_task_id
6574: AND project_asset_id = l_project_asset_id;
6575:

Line 6726: FROM pa_project_asset_assignments

6722: --Used to determine if the new assignment already exists
6723: CURSOR lock_assignment_cur (x_project_id NUMBER,
6724: x_project_asset_id NUMBER) IS
6725: SELECT 'x'
6726: FROM pa_project_asset_assignments
6727: WHERE project_id = x_project_id
6728: AND project_asset_id = x_project_asset_id
6729: FOR UPDATE NOWAIT;
6730:

Line 7025: DELETE pa_project_asset_assignments

7021: OPEN lock_assignment_cur(l_project_id, l_project_asset_id);
7022: CLOSE lock_assignment_cur;
7023:
7024:
7025: DELETE pa_project_asset_assignments
7026: WHERE project_id = l_project_id
7027: AND project_asset_id = l_project_asset_id;
7028:
7029:

Line 7130: FROM pa_project_asset_assignments

7126: CURSOR existing_assignment_cur (x_project_id NUMBER,
7127: x_task_id NUMBER,
7128: x_project_asset_id NUMBER) IS
7129: SELECT 'Assignment Already Exists'
7130: FROM pa_project_asset_assignments
7131: WHERE project_id = x_project_id
7132: AND task_id = x_task_id
7133: AND project_asset_id = x_project_asset_id;
7134:

Line 7143: FROM pa_project_asset_assignments

7139: CURSOR lock_assignment_cur (x_project_id NUMBER,
7140: x_task_id NUMBER,
7141: x_project_asset_id NUMBER) IS
7142: SELECT 'x'
7143: FROM pa_project_asset_assignments
7144: WHERE project_id = x_project_id
7145: AND task_id = x_task_id
7146: AND project_asset_id = x_project_asset_id
7147: FOR UPDATE NOWAIT;

Line 7438: DELETE pa_project_asset_assignments

7434: OPEN lock_assignment_cur(l_project_id, l_task_id, l_project_asset_id);
7435: CLOSE lock_assignment_cur;
7436:
7437:
7438: DELETE pa_project_asset_assignments
7439: WHERE project_id = l_project_id
7440: AND task_id = l_task_id
7441: AND project_asset_id = l_project_asset_id;
7442: