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_XC_PROJECT_PUB dependencies on PA_PROJECT_PUB

Line 30: -- pa_project_pub.execute_update_project in the procedure Import_project.

26: -- Commented l_get_working_version_csr existing cursor definition and added new definition
27: -- for the same
28: -- 23-JUL-04 adarora Bug 3627124 :
29: -- 3696234 : Added the parameter, p_pass_entire_structure in the procedure call to
30: -- pa_project_pub.execute_update_project in the procedure Import_project.
31: -- 15-MAR-2005 -- adarora Bug 3601700:Modified check_ref_unique to handle split case.
32: -- 23-May-2006 sliburd for amksingh Bug 5233777 : Added new parameter p_resp_appl_id in import_project
33: --
34: -- 09-OCT-2006 Ram Namburi Bug 5465108: Added the parameter p_long_task_name in the procedure

Line 35: -- call to PA_PROJECT_PUB.load_task

31: -- 15-MAR-2005 -- adarora Bug 3601700:Modified check_ref_unique to handle split case.
32: -- 23-May-2006 sliburd for amksingh Bug 5233777 : Added new parameter p_resp_appl_id in import_project
33: --
34: -- 09-OCT-2006 Ram Namburi Bug 5465108: Added the parameter p_long_task_name in the procedure
35: -- call to PA_PROJECT_PUB.load_task
36: -- 22-AUG-2008 rballamu Bug 7245488: Passed Schedule start/finish dates to PA_PROJECT_PUB.load_task.
37: -- 29-Jun-2011 Rodrigo Bruno Fixed 12.2 bug 12668006
38: --
39:

Line 36: -- 22-AUG-2008 rballamu Bug 7245488: Passed Schedule start/finish dates to PA_PROJECT_PUB.load_task.

32: -- 23-May-2006 sliburd for amksingh Bug 5233777 : Added new parameter p_resp_appl_id in import_project
33: --
34: -- 09-OCT-2006 Ram Namburi Bug 5465108: Added the parameter p_long_task_name in the procedure
35: -- call to PA_PROJECT_PUB.load_task
36: -- 22-AUG-2008 rballamu Bug 7245488: Passed Schedule start/finish dates to PA_PROJECT_PUB.load_task.
37: -- 29-Jun-2011 Rodrigo Bruno Fixed 12.2 bug 12668006
38: --
39:
40: PROCEDURE import_task

Line 215: pa_project_pub.G_tasks_in_tbl.delete;

211: --pl/sql table and then calls the publishing API. The publish_structure api calls this API to load tasks
212: --in the same pl/sql table. If we dont flush out the tasks already loaded by project connect update
213: --then this api will load the same tasks again and publish_structure will fail.
214:
215: pa_project_pub.G_tasks_in_tbl.delete;
216:
217: --dbms_output.put_line('Inside publish');
218:
219: -- Delete tasks from the temp database table

Line 383: PA_PROJECT_PUB.load_task (

379: OPEN pa_schedule_dates_csr(p_structure_version_id,l_proj_elements_rec.proj_element_id); /* 7245488 */
380: FETCH pa_schedule_dates_csr INTO l_sched_start_date,l_sched_fin_date;
381: CLOSE pa_schedule_dates_csr;
382:
383: PA_PROJECT_PUB.load_task (
384: p_api_version_number => G_API_VERSION_NUMBER
385: ,p_return_status => l_return_status
386: ,p_pm_task_reference => l_pm_source_reference
387: ,p_pa_task_id => l_task_id

Line 939: -- pa_project_pub.init_project;

935: if (p_debug_mode = 'Y') then
936: pa_debug.debug('Import-Project : Calling init project Program Starts ');
937: end if;
938:
939: -- pa_project_pub.init_project;
940:
941: -- Check project id
942:
943: if (p_project_id is null or p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

Line 998: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');

994: l_project_mpx_start_date := fnd_date.canonical_to_date(p_project_mpx_start_date);
995: l_project_mpx_end_date := fnd_date.canonical_to_date(p_project_mpx_end_date);
996:
997: if (p_debug_mode = 'Y') then
998: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');
999: end if;
1000:
1001: pa_project_pub.load_project
1002: ( p_api_version_number => G_API_VERSION_NUMBER

Line 1001: pa_project_pub.load_project

997: if (p_debug_mode = 'Y') then
998: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');
999: end if;
1000:
1001: pa_project_pub.load_project
1002: ( p_api_version_number => G_API_VERSION_NUMBER
1003: ,p_init_msg_list => 'F'
1004: ,p_return_status => l_return_status
1005: ,p_project_name => l_project_name

Line 1095: pa_project_pub.execute_update_project

1091: ELSE
1092: l_pm_product_code2 := l_pm_product_code;
1093: END IF;
1094:
1095: pa_project_pub.execute_update_project
1096: ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
1097: ,p_commit => FND_API.G_FALSE
1098: ,p_init_msg_list => FND_API.G_FALSE
1099: ,p_msg_count => p_msg_count

Line 1171: pa_project_pub.init_project;

1167: if (p_debug_mode = 'Y') then
1168: pa_debug.debug('Import-Project : Calling init project Program Starts ...');
1169: end if;
1170:
1171: pa_project_pub.init_project;
1172:
1173: if (p_debug_mode = 'Y') then
1174: pa_debug.debug('Import-Project : Program Ends ...');
1175: end if;

Line 1207: pa_project_pub.clear_project;

1203: x_return_status := FND_API.G_RET_STS_ERROR ;
1204:
1205: --hsiu added
1206: IF (p_calling_mode <> 'PUBLISH') THEN
1207: pa_project_pub.clear_project;
1208: --hsiu added
1209: END IF;
1210:
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1241: pa_project_pub.clear_project;

1237:
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: --hsiu added
1240: IF (p_calling_mode <> 'PUBLISH') THEN
1241: pa_project_pub.clear_project;
1242: --hsiu added
1243: END IF;
1244:
1245: WHEN API_ERROR THEN

Line 1248: pa_project_pub.clear_project;

1244:
1245: WHEN API_ERROR THEN
1246:
1247: IF (p_calling_mode <> 'PUBLISH') THEN
1248: pa_project_pub.clear_project;
1249: END IF;
1250: WHEN NO_DATA_FOUND THEN
1251: -- dbms_output.put_line('NO-DATA-FOUND : YOU ARE IN MAIN PROCEDURE ');
1252:

Line 1334: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := NULL;

1330: IF l_get_task_csr%NOTFOUND
1331: THEN
1332:
1333: CLOSE l_get_task_csr;
1334: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := NULL;
1335: x_task_id :=NULL;
1336: return;
1337: END IF;
1338:

Line 1341: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := l_task_id;

1337: END IF;
1338:
1339: CLOSE l_get_task_csr;
1340:
1341: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := l_task_id;
1342:
1343: x_task_id := l_task_id;
1344:
1345: EXCEPTION --4537865

Line 1393: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := NULL;

1389:
1390: IF l_get_task_csr%NOTFOUND
1391: THEN
1392: CLOSE l_get_task_csr;
1393: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := NULL;
1394: x_task_id :=NULL;
1395: return;
1396: END IF;
1397:

Line 1400: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := l_task_id;

1396: END IF;
1397:
1398: CLOSE l_get_task_csr;
1399:
1400: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := l_task_id;
1401:
1402: x_task_id := l_task_id;
1403:
1404: EXCEPTION --4537865