DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 41: ( p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

37: -- 29-Jun-2011 Rodrigo Bruno Fixed 12.2 bug 12668006
38: --
39:
40: PROCEDURE import_task
41: ( p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_task_reference IN PA_VC_1000_25
43: ,p_task_name IN PA_VC_1000_150
44: ,p_task_start_date IN PA_VC_1000_10
45: ,p_task_end_date IN PA_VC_1000_10

Line 57: ,p_login_user_name IN PA_VC_1000_150:= PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

53: ,p_early_finish_date IN PA_VC_1000_10
54: ,p_late_start_date IN PA_VC_1000_10
55: ,p_late_finish_date IN PA_VC_1000_10
56: ,p_display_seq IN PA_VC_1000_150
57: ,p_login_user_name IN PA_VC_1000_150:= PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_critical_path IN PA_VC_1000_150
59: ,p_sub_project_id IN PA_VC_1000_150
60: ,p_attribute7 IN PA_VC_1000_150
61: ,p_attribute8 IN PA_VC_1000_150

Line 71: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

67: ,p_progress_asof_date IN PA_VC_1000_10
68: ,p_predecessors IN PA_VC_1000_2000
69: ,p_language IN VARCHAR2 default 'US'
70: ,p_delimiter IN VARCHAR2 default ','
71: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
72: ,p_calling_mode IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73: )
74:
75: IS

Line 72: ,p_calling_mode IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

68: ,p_predecessors IN PA_VC_1000_2000
69: ,p_language IN VARCHAR2 default 'US'
70: ,p_delimiter IN VARCHAR2 default ','
71: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
72: ,p_calling_mode IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73: )
74:
75: IS
76:

Line 349: l_task_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

345: --Commented and replpaced following for BUG 4278979, rtarway
346: --l_task_start_date := null;
347: --l_task_finish_date := null;
348:
349: l_task_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
350: l_task_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
351: l_long_task_name := null; -- Added for bug 5465108
352:
353:

Line 350: l_task_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

346: --l_task_start_date := null;
347: --l_task_finish_date := null;
348:
349: l_task_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
350: l_task_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
351: l_long_task_name := null; -- Added for bug 5465108
352:
353:
354: END IF;

Line 400: ,p_attribute1 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

396: ,p_pm_parent_task_reference => l_pm_parent_task_reference
397: ,p_pa_parent_task_id => null
398: ,p_carrying_out_organization_id => l_proj_elements_rec.carrying_out_organization_id
399: ,p_task_manager_person_id => l_proj_elements_rec.manager_person_id
400: ,p_attribute1 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

397: ,p_pa_parent_task_id => null
398: ,p_carrying_out_organization_id => l_proj_elements_rec.carrying_out_organization_id
399: ,p_task_manager_person_id => l_proj_elements_rec.manager_person_id
400: ,p_attribute1 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

398: ,p_carrying_out_organization_id => l_proj_elements_rec.carrying_out_organization_id
399: ,p_task_manager_person_id => l_proj_elements_rec.manager_person_id
400: ,p_attribute1 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

399: ,p_task_manager_person_id => l_proj_elements_rec.manager_person_id
400: ,p_attribute1 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

400: ,p_attribute1 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

401: ,p_attribute2 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: ,p_attribute10 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

402: ,p_attribute3 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: ,p_attribute10 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: );

Line 407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

403: ,p_attribute4 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: ,p_attribute10 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: );
411:

Line 408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

404: ,p_attribute5 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: ,p_attribute10 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: );
411:
412: l_stage := '3.8';

Line 409: ,p_attribute10 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

405: ,p_attribute6 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
406: ,p_attribute7 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
407: ,p_attribute8 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
408: ,p_attribute9 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
409: ,p_attribute10 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: );
411:
412: l_stage := '3.8';
413:

Line 459: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

455: PROCEDURE import_project
456: ( p_user_id IN NUMBER
457: ,p_commit IN VARCHAR2 default 'N'
458: ,p_debug_mode IN VARCHAR2 default 'N'
459: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: ,p_task_mgr_override IN VARCHAR2 default 'N'
463: ,p_task_pgs_override IN VARCHAR2 default 'N'

Line 460: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

456: ( p_user_id IN NUMBER
457: ,p_commit IN VARCHAR2 default 'N'
458: ,p_debug_mode IN VARCHAR2 default 'N'
459: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: ,p_task_mgr_override IN VARCHAR2 default 'N'
463: ,p_task_pgs_override IN VARCHAR2 default 'N'
464: ,p_process_id IN NUMBER default -1

Line 461: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

457: ,p_commit IN VARCHAR2 default 'N'
458: ,p_debug_mode IN VARCHAR2 default 'N'
459: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
460: ,p_project_mpx_start_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461: ,p_project_mpx_end_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462: ,p_task_mgr_override IN VARCHAR2 default 'N'
463: ,p_task_pgs_override IN VARCHAR2 default 'N'
464: ,p_process_id IN NUMBER default -1
465: ,p_language IN VARCHAR2 default 'US'

Line 467: ,p_responsibility_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

463: ,p_task_pgs_override IN VARCHAR2 default 'N'
464: ,p_process_id IN NUMBER default -1
465: ,p_language IN VARCHAR2 default 'US'
466: ,p_delimiter IN VARCHAR2 default ','
467: ,p_responsibility_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
468: ,p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
469: ,p_structure_version_id IN NUMBER
470: ,p_calling_mode IN VARCHAR2
471: ,p_resp_appl_id IN NUMBER default 275 -- 5233777

Line 468: ,p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

464: ,p_process_id IN NUMBER default -1
465: ,p_language IN VARCHAR2 default 'US'
466: ,p_delimiter IN VARCHAR2 default ','
467: ,p_responsibility_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
468: ,p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
469: ,p_structure_version_id IN NUMBER
470: ,p_calling_mode IN VARCHAR2
471: ,p_resp_appl_id IN NUMBER default 275 -- 5233777
472: ,x_msg_count IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 715: if (p_structure_id is not NULL and p_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_id <>0) then

711:
712: -- HY Check to make sure that the project id, the structure id, and the structure version id passed
713: -- in are a valid combination
714:
715: if (p_structure_id is not NULL and p_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_id <>0) then
716: NULL;
717: /*
718: -- Both Structure Id and Structure Version Id are not empty.
719: if (p_structure_version_id is not NULL and p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_version_id <>0) then

Line 719: if (p_structure_version_id is not NULL and p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_version_id <>0) then

715: if (p_structure_id is not NULL and p_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_id <>0) then
716: NULL;
717: /*
718: -- Both Structure Id and Structure Version Id are not empty.
719: if (p_structure_version_id is not NULL and p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_version_id <>0) then
720: OPEN l_check_proj_struct_ver_id_csr (p_project_id, p_structure_id, p_structure_version_id);
721: FETCH l_check_proj_struct_ver_id_csr INTO l_validate_flag;
722: if l_check_proj_struct_ver_id_csr%NOTFOUND then
723: x_msg_count := x_msg_count + 1;

Line 748: if (p_structure_version_id is not NULL and p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_version_id <>0) then

744:
745: end if;
746: else
747: --Structure ID is empty and Structure Version ID is not empty
748: if (p_structure_version_id is not NULL and p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_version_id <>0) then
749: OPEN l_check_proj_ver_id_csr (p_project_id, p_structure_version_id);
750: FETCH l_check_proj_ver_id_csr INTO l_validate_flag;
751: if l_check_proj_ver_id_csr%NOTFOUND then
752: -- fnd_message.set_name('PA', 'PA_INVLD_PROJ_VER_PR');

Line 835: if (p_structure_id is not null or p_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then

831: */
832: else
833: l_structure_version_id := p_structure_version_id;
834: --HY Get the Structure ID if it's not passed in.
835: if (p_structure_id is not null or p_structure_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
836: l_structure_id := p_structure_id;
837: else
838: OPEN l_get_struct_id_csr (l_structure_version_id);
839: FETCH l_get_struct_id_csr INTO l_structure_id;

Line 857: IF (p_responsibility_id is NULL) OR (p_responsibility_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

853: end if;
854:
855: -- To Set global info like responsibility_id and user_id
856:
857: IF (p_responsibility_id is NULL) OR (p_responsibility_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
858: -- Fix for Bug # 4513291. There was an old fix done thru Bug 2358887, do not put msgs in stack
859: -- This was wrong as the calling env. except MSP(I guess) does not look at the x_msg_data array.
860: -- Other calling envs. rely on fnd_msg_pub.count_msg, for which we need to add msgs in stack
861:

Line 887: PA_INTERFACE_UTILS_PUB.Set_Global_Info

883: CLOSE proj_ou_id_csr;
884:
885: -- 4363092 end
886:
887: PA_INTERFACE_UTILS_PUB.Set_Global_Info
888: ( p_api_version_number => G_API_VERSION_NUMBER
889: ,p_responsibility_id => p_responsibility_id
890: ,p_user_id => p_user_id
891: ,p_calling_mode => p_calling_mode --bug 2783845

Line 943: if (p_project_id is null or p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

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
944: fnd_message.set_name('PA', 'PA_NO_PROJECT_ID');
945: x_msg_count := x_msg_count + 1;
946: x_msg_data.extend(1);
947: --added for bug 2192242

Line 1190: PA_INTERFACE_UTILS_PUB.get_messages (

1186: end if;
1187:
1188: -- Fix for Bug # 4513291. Ideally this call should use p_encoded as F
1189: -- So that it gets decoded messages. But not changing Right now.
1190: PA_INTERFACE_UTILS_PUB.get_messages (
1191: p_msg_count => 1
1192: ,p_msg_index => i
1193: ,p_msg_data => p_msg_data
1194: ,p_data => l_data

Line 1225: PA_INTERFACE_UTILS_PUB.get_messages (

1221: if (p_debug_mode = 'Y') then
1222: pa_debug.debug('Import-Project : Inside Error Handling Program ...');
1223: end if;
1224:
1225: PA_INTERFACE_UTILS_PUB.get_messages (
1226: p_msg_count => 1
1227: ,p_msg_index => i
1228: ,p_msg_data => p_msg_data
1229: ,p_data => l_data

Line 1307: ( p_task_index IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3302732 : Changed type to varchar2

1303: --Called subprograms:
1304: --
1305:
1306: PROCEDURE fetch_task_id
1307: ( p_task_index IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3302732 : Changed type to varchar2
1308: ,p_project_id IN NUMBER
1309: ,p_pm_task_reference IN VARCHAR2
1310: ,x_task_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
1311: IS

Line 1365: ( p_task_index IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3302732

1361: --Called subprograms:
1362: --
1363:
1364: PROCEDURE fetch_proj_element_id
1365: ( p_task_index IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3302732
1366: ,p_project_id IN NUMBER
1367: ,p_pm_task_reference IN VARCHAR2
1368: ,x_task_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
1369: IS