APPS.PA_PROJECT_ASSETS_PUB dependencies on PA_PROJECTS_ALL

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 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 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 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 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 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