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_PROJECTS

Line 97: FROM pa_projects p

93:
94: --Used to get the project number for AMG messages
95: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
96: SELECT segment1
97: FROM pa_projects p
98: WHERE p.project_id = x_project_id;
99:
100: l_amg_project_number pa_projects_all.segment1%TYPE;
101: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;

Line 100: l_amg_project_number pa_projects_all.segment1%TYPE;

96: SELECT segment1
97: FROM pa_projects p
98: WHERE p.project_id = x_project_id;
99:
100: l_amg_project_number pa_projects_all.segment1%TYPE;
101: l_amg_pa_asset_name pa_project_assets_all.asset_name%TYPE;
102:
103:
104: --Used to determine if the project is CAPITAL

Line 107: FROM pa_projects p,

103:
104: --Used to determine if the project is CAPITAL
105: CURSOR capital_project_cur(x_project_id NUMBER) IS
106: SELECT 'Project is CAPITAL'
107: FROM pa_projects p,
108: pa_project_types t
109: WHERE p.project_id = x_project_id
110: AND p.project_type = t.project_type
111: AND t.project_type_class_code = 'CAPITAL';

Line 308: l_project_id pa_projects.project_id%TYPE;

304:
305:
306: l_api_name CONSTANT VARCHAR2(30) := 'add_project_asset';
307: l_return_status VARCHAR2(1);
308: l_project_id pa_projects.project_id%TYPE;
309: l_task_id pa_tasks.task_id%TYPE;
310: l_msg_count NUMBER ;
311: l_msg_data VARCHAR2(2000);
312: l_function_allowed VARCHAR2(1);

Line 1353: pa_projects p

1349:
1350: SELECT NVL(pt.interface_complete_asset_flag,'N')
1351: INTO v_intf_complete_asset_flag
1352: FROM pa_project_types pt,
1353: pa_projects p
1354: WHERE p.project_type = pt.project_type
1355: AND p.project_id = l_project_id;
1356:
1357:

Line 1889: FROM pa_projects p

1885:
1886: --Used to get the project number for AMG messages
1887: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
1888: SELECT segment1
1889: FROM pa_projects p
1890: WHERE p.project_id = x_project_id;
1891:
1892: l_amg_project_number pa_projects_all.segment1%TYPE;
1893:

Line 1892: l_amg_project_number pa_projects_all.segment1%TYPE;

1888: SELECT segment1
1889: FROM pa_projects p
1890: WHERE p.project_id = x_project_id;
1891:
1892: l_amg_project_number pa_projects_all.segment1%TYPE;
1893:
1894:
1895: --Used to get the asset number for AMG messages
1896: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER) IS

Line 1907: FROM pa_projects p,

1903:
1904: --Used to determine if the project is CAPITAL
1905: CURSOR capital_project_cur(x_project_id NUMBER) IS
1906: SELECT 'Project is CAPITAL'
1907: FROM pa_projects p,
1908: pa_project_types t
1909: WHERE p.project_id = x_project_id
1910: AND p.project_type = t.project_type
1911: AND t.project_type_class_code = 'CAPITAL';

Line 2855: FROM pa_projects p

2851:
2852: --Used to get the project number for AMG messages
2853: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
2854: SELECT segment1
2855: FROM pa_projects p
2856: WHERE p.project_id = x_project_id;
2857:
2858: l_amg_project_number pa_projects_all.segment1%TYPE;
2859:

Line 2858: l_amg_project_number pa_projects_all.segment1%TYPE;

2854: SELECT segment1
2855: FROM pa_projects p
2856: WHERE p.project_id = x_project_id;
2857:
2858: l_amg_project_number pa_projects_all.segment1%TYPE;
2859:
2860:
2861: --Used to get the asset number for AMG messages
2862: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER) IS

Line 2873: FROM pa_projects p,

2869:
2870: --Used to determine if the project is CAPITAL
2871: CURSOR capital_project_cur(x_project_id NUMBER) IS
2872: SELECT 'Project is CAPITAL'
2873: FROM pa_projects p,
2874: pa_project_types t
2875: WHERE p.project_id = x_project_id
2876: AND p.project_type = t.project_type
2877: AND t.project_type_class_code = 'CAPITAL';

Line 5118: pa_projects p

5114:
5115: SELECT NVL(pt.interface_complete_asset_flag,'N')
5116: INTO v_intf_complete_asset_flag
5117: FROM pa_project_types pt,
5118: pa_projects p
5119: WHERE p.project_type = pt.project_type
5120: AND p.project_id = l_project_id;
5121:
5122:

Line 5569: FROM pa_projects

5565:
5566: CURSOR l_project_id_csr
5567: IS
5568: SELECT 'X'
5569: FROM pa_projects
5570: where project_id = p_pa_project_id;
5571:
5572:
5573: CURSOR l_project_asset_id_csr

Line 5597: (p_pa_project_id pa_projects.project_id%type)

5593:
5594:
5595: --Used to get the field values associated to a AMG message
5596: CURSOR l_amg_project_csr
5597: (p_pa_project_id pa_projects.project_id%type)
5598: IS
5599: SELECT segment1
5600: FROM pa_projects p
5601: WHERE p.project_id = p_pa_project_id;

Line 5600: FROM pa_projects p

5596: CURSOR l_amg_project_csr
5597: (p_pa_project_id pa_projects.project_id%type)
5598: IS
5599: SELECT segment1
5600: FROM pa_projects p
5601: WHERE p.project_id = p_pa_project_id;
5602:
5603: l_amg_segment1 VARCHAR2(25);
5604:

Line 6138: FROM pa_projects p

6134:
6135: --Used to get the project number for AMG messages
6136: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
6137: SELECT segment1
6138: FROM pa_projects p
6139: WHERE p.project_id = x_project_id;
6140:
6141: l_amg_project_number pa_projects_all.segment1%TYPE;
6142:

Line 6141: l_amg_project_number pa_projects_all.segment1%TYPE;

6137: SELECT segment1
6138: FROM pa_projects p
6139: WHERE p.project_id = x_project_id;
6140:
6141: l_amg_project_number pa_projects_all.segment1%TYPE;
6142:
6143:
6144: --Used to get the asset number for output parameter
6145: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER,

Line 6175: l_project_number PA_PROJECTS_ALL.segment1%TYPE;

6171: l_project_asset_id NUMBER;
6172: l_project_id NUMBER;
6173: l_task_id NUMBER;
6174: l_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;
6175: l_project_number PA_PROJECTS_ALL.segment1%TYPE;
6176: l_msg_data VARCHAR2(2000);
6177: v_assignment_count NUMBER := 0;
6178:
6179:

Line 6695: FROM pa_projects p

6691:
6692: --Used to get the project number for AMG messages
6693: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
6694: SELECT segment1
6695: FROM pa_projects p
6696: WHERE p.project_id = x_project_id;
6697:
6698: l_amg_project_number pa_projects_all.segment1%TYPE;
6699:

Line 6698: l_amg_project_number pa_projects_all.segment1%TYPE;

6694: SELECT segment1
6695: FROM pa_projects p
6696: WHERE p.project_id = x_project_id;
6697:
6698: l_amg_project_number pa_projects_all.segment1%TYPE;
6699:
6700:
6701: --Used to get the asset number for AMG messages
6702: CURSOR l_amg_asset_csr(x_project_asset_id NUMBER) IS

Line 6713: FROM pa_projects p,

6709:
6710: --Used to determine if the project is CAPITAL
6711: CURSOR capital_project_cur(x_project_id NUMBER) IS
6712: SELECT 'Project is CAPITAL'
6713: FROM pa_projects p,
6714: pa_project_types t
6715: WHERE p.project_id = x_project_id
6716: AND p.project_type = t.project_type
6717: AND t.project_type_class_code = 'CAPITAL';

Line 7107: FROM pa_projects p

7103:
7104: --Used to get the project number for AMG messages
7105: CURSOR l_amg_project_csr(x_project_id NUMBER) IS
7106: SELECT segment1
7107: FROM pa_projects p
7108: WHERE p.project_id = x_project_id;
7109:
7110: l_amg_project_number pa_projects_all.segment1%TYPE;
7111:

Line 7110: l_amg_project_number pa_projects_all.segment1%TYPE;

7106: SELECT segment1
7107: FROM pa_projects p
7108: WHERE p.project_id = x_project_id;
7109:
7110: l_amg_project_number pa_projects_all.segment1%TYPE;
7111:
7112:
7113: --Used to determine if the project is CAPITAL
7114: CURSOR capital_project_cur(x_project_id NUMBER) IS

Line 7116: FROM pa_projects p,

7112:
7113: --Used to determine if the project is CAPITAL
7114: CURSOR capital_project_cur(x_project_id NUMBER) IS
7115: SELECT 'Project is CAPITAL'
7116: FROM pa_projects p,
7117: pa_project_types t
7118: WHERE p.project_id = x_project_id
7119: AND p.project_type = t.project_type
7120: AND t.project_type_class_code = 'CAPITAL';