DBA Data[Home] [Help]

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:
38: PROCEDURE import_task
39: ( p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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:
38: PROCEDURE import_task
39: ( p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: ,p_task_reference IN PA_VC_1000_25

Line 213: pa_project_pub.G_tasks_in_tbl.delete;

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

Line 372: PA_PROJECT_PUB.load_task (

368: OPEN pa_schedule_dates_csr(p_structure_version_id,l_proj_elements_rec.proj_element_id); /* 7245488 */
369: FETCH pa_schedule_dates_csr INTO l_sched_start_date,l_sched_fin_date;
370: CLOSE pa_schedule_dates_csr;
371:
372: PA_PROJECT_PUB.load_task (
373: p_api_version_number => G_API_VERSION_NUMBER
374: ,p_return_status => l_return_status
375: ,p_pm_task_reference => l_pm_source_reference
376: ,p_pa_task_id => l_task_id

Line 928: -- pa_project_pub.init_project;

924: if (p_debug_mode = 'Y') then
925: pa_debug.debug('Import-Project : Calling init project Program Starts ');
926: end if;
927:
928: -- pa_project_pub.init_project;
929:
930: -- Check project id
931:
932: if (p_project_id is null or p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

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

983: l_project_mpx_start_date := fnd_date.canonical_to_date(p_project_mpx_start_date);
984: l_project_mpx_end_date := fnd_date.canonical_to_date(p_project_mpx_end_date);
985:
986: if (p_debug_mode = 'Y') then
987: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');
988: end if;
989:
990: pa_project_pub.load_project
991: ( p_api_version_number => G_API_VERSION_NUMBER

Line 990: pa_project_pub.load_project

986: if (p_debug_mode = 'Y') then
987: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');
988: end if;
989:
990: pa_project_pub.load_project
991: ( p_api_version_number => G_API_VERSION_NUMBER
992: ,p_init_msg_list => 'F'
993: ,p_return_status => l_return_status
994: ,p_project_name => l_project_name

Line 1084: pa_project_pub.execute_update_project

1080: ELSE
1081: l_pm_product_code2 := l_pm_product_code;
1082: END IF;
1083:
1084: pa_project_pub.execute_update_project
1085: ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
1086: ,p_commit => FND_API.G_FALSE
1087: ,p_init_msg_list => FND_API.G_FALSE
1088: ,p_msg_count => p_msg_count

Line 1160: pa_project_pub.init_project;

1156: if (p_debug_mode = 'Y') then
1157: pa_debug.debug('Import-Project : Calling init project Program Starts ...');
1158: end if;
1159:
1160: pa_project_pub.init_project;
1161:
1162: if (p_debug_mode = 'Y') then
1163: pa_debug.debug('Import-Project : Program Ends ...');
1164: end if;

Line 1196: pa_project_pub.clear_project;

1192: x_return_status := FND_API.G_RET_STS_ERROR ;
1193:
1194: --hsiu added
1195: IF (p_calling_mode <> 'PUBLISH') THEN
1196: pa_project_pub.clear_project;
1197: --hsiu added
1198: END IF;
1199:
1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1230: pa_project_pub.clear_project;

1226:
1227: x_return_status := FND_API.G_RET_STS_ERROR;
1228: --hsiu added
1229: IF (p_calling_mode <> 'PUBLISH') THEN
1230: pa_project_pub.clear_project;
1231: --hsiu added
1232: END IF;
1233:
1234: WHEN API_ERROR THEN

Line 1237: pa_project_pub.clear_project;

1233:
1234: WHEN API_ERROR THEN
1235:
1236: IF (p_calling_mode <> 'PUBLISH') THEN
1237: pa_project_pub.clear_project;
1238: END IF;
1239: WHEN NO_DATA_FOUND THEN
1240: -- dbms_output.put_line('NO-DATA-FOUND : YOU ARE IN MAIN PROCEDURE ');
1241:

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

1319: IF l_get_task_csr%NOTFOUND
1320: THEN
1321:
1322: CLOSE l_get_task_csr;
1323: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := NULL;
1324: x_task_id :=NULL;
1325: return;
1326: END IF;
1327:

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

1326: END IF;
1327:
1328: CLOSE l_get_task_csr;
1329:
1330: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := l_task_id;
1331:
1332: x_task_id := l_task_id;
1333:
1334: EXCEPTION --4537865

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

1378:
1379: IF l_get_task_csr%NOTFOUND
1380: THEN
1381: CLOSE l_get_task_csr;
1382: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := NULL;
1383: x_task_id :=NULL;
1384: return;
1385: END IF;
1386:

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

1385: END IF;
1386:
1387: CLOSE l_get_task_csr;
1388:
1389: --hy PA_PROJECT_PUB.G_tasks_in_tbl(to_number(p_pm_task_reference)).pa_task_id := l_task_id;
1390:
1391: x_task_id := l_task_id;
1392:
1393: EXCEPTION --4537865