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_PROJ_STRUCTURE_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 154: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

150: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
151: p_debug_mode IN VARCHAR2 := 'N',
152: p_project_id IN NUMBER,
153: p_structure_version_id IN NUMBER,
154: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
155: p_calling_page_name IN VARCHAR2,
156: p_populate_tmp_tab_flag IN VARCHAR2 := 'Y',
157: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
158: p_sequence_offset IN NUMBER := 0, --bug 4448499

Line 157: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

153: p_structure_version_id IN NUMBER,
154: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
155: p_calling_page_name IN VARCHAR2,
156: p_populate_tmp_tab_flag IN VARCHAR2 := 'Y',
157: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
158: p_sequence_offset IN NUMBER := 0, --bug 4448499
159: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,

Line 239: IF p_parent_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

235: --bug 4448499
236: END IF;
237:
238: --bug 4197654
239: IF p_parent_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
240: l_parent_project_id := p_project_id;
241: ELSE
242: l_parent_project_id := p_parent_project_id;
243: END IF;

Line 265: l_task_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

261: -- Bug # 4875311.
262:
263: if ((p_calling_page_name = 'GANTT_REGION') or (p_calling_page_name = 'LIST_REGION') or (l_program_flag = 'Y')) then
264: l_wbs_display_depth := -1;
265: l_task_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
266: else
267: l_wbs_display_depth := nvl(p_wbs_display_depth, -1);
268: l_task_version_id := nvl(p_task_version_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
269: end if;

Line 268: l_task_version_id := nvl(p_task_version_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);

264: l_wbs_display_depth := -1;
265: l_task_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
266: else
267: l_wbs_display_depth := nvl(p_wbs_display_depth, -1);
268: l_task_version_id := nvl(p_task_version_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
269: end if;
270:
271: -- Bug # 4875311.
272:

Line 292: p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) )

288: --Now for bug 4448499, the api should get executed if the project is a program.
289: AND PA_PROJ_STRUCTURE_UTILS.CHECK_STR_TEMP_TAB_POPULATED(p_project_id) = 'Y' ) OR --bug 4290593
290: ( p_calling_page_name = 'TASK_DETAILS' AND
291: ( p_task_version_id IS NULL OR
292: p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) )
293: THEN
294: return;
295: END IF;
296:

Line 308: if ((l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

304: -- from the table: pa_structures_tasks_tmp before re-populating the records.
305:
306: -- Bug # 4875311.
307:
308: if ((l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
309: and (l_program_flag = 'N') --Bug # 4875311.
310: and (p_calling_page_name <> 'TASK_DETAILS')) -- Bug # 4875311.
311: then
312:

Line 352: AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

348: THEN
349:
350: IF p_calling_page_name = 'TASK_DETAILS'
351: AND p_task_version_id IS NOT NULL
352: AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
353: THEN
354: IF g1_debug_mode = 'Y' THEN
355: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Calling PA_PROJ_STRUCTURE_PUB.INSERT_PUBLISHED_RECORD', x_Log_Level=> 3);
356: END IF;

Line 444: AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

440: THEN
441:
442: IF p_calling_page_name = 'TASK_DETAILS'
443: AND p_task_version_id IS NOT NULL
444: AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445: THEN
446: IF g1_debug_mode = 'Y' THEN
447: pa_debug.write(x_Module=>'PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB', x_Msg => 'Before calling PA_PROJ_STRUCTURE_PUB.INSERT_WORKING_RECORD', x_Log_Level=> 3);
448: END IF;

Line 614: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

610: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
611: p_debug_mode IN VARCHAR2 := 'N',
612: p_project_id IN NUMBER,
613: p_structure_version_id IN NUMBER,
614: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
615: p_sequence_offset IN NUMBER := 0, --bug 4448499
616: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
617: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
618: x_return_status OUT NOCOPY VARCHAR2,

Line 617: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.

613: p_structure_version_id IN NUMBER,
614: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
615: p_sequence_offset IN NUMBER := 0, --bug 4448499
616: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
617: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
618: x_return_status OUT NOCOPY VARCHAR2,
619: x_msg_count OUT NOCOPY NUMBER,
620: x_msg_data OUT NOCOPY VARCHAR2
621: )

Line 810: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then

806: end if;
807: end if;
808: -- End of Bug 6156686
809:
810: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
811:
812: INSERT INTO pa_structures_tasks_tmp
813: (
814: parent_project_id

Line 1621: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then

1617: -- ************************************************************************************************************************
1618: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
1619: -- ************************************************************************************************************************
1620:
1621: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
1622: --Bug 5580992: Removed the reference to pa_percent_completes. The columns Progress_comments and
1623: --Progress_brief_overview are updated after this insert.
1624:
1625: INSERT INTO pa_structures_tasks_tmp

Line 2486: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

2482: -- ************************************************************************************************************************
2483: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
2484: -- ************************************************************************************************************************
2485:
2486: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
2487:
2488: INSERT INTO pa_structures_tasks_tmp
2489: (
2490: parent_project_id

Line 3350: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

3346: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
3347: p_debug_mode IN VARCHAR2 := 'N',
3348: p_project_id IN NUMBER,
3349: p_structure_version_id IN NUMBER,
3350: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3351: p_sequence_offset IN NUMBER := 0, --bug 4448499
3352: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
3353: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
3354: x_return_status OUT NOCOPY VARCHAR2,

Line 3353: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.

3349: p_structure_version_id IN NUMBER,
3350: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3351: p_sequence_offset IN NUMBER := 0, --bug 4448499
3352: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
3353: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
3354: x_return_status OUT NOCOPY VARCHAR2,
3355: x_msg_count OUT NOCOPY NUMBER,
3356: x_msg_data OUT NOCOPY VARCHAR2
3357: )

Line 3425: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then

3421: -- ************************************************************************************************************************
3422: -- if only p_structure_version_id is passed in, populate all task records for the given structure version.
3423: -- ************************************************************************************************************************
3424:
3425: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
3426:
3427: INSERT INTO pa_structures_tasks_tmp
3428: (
3429: parent_project_id

Line 4250: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then

4246: -- ************************************************************************************************************************
4247: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
4248: -- ************************************************************************************************************************
4249:
4250: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
4251:
4252: INSERT INTO pa_structures_tasks_tmp
4253: (
4254: parent_project_id

Line 5076: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

5072: -- ************************************************************************************************************************
5073: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
5074: -- ************************************************************************************************************************
5075:
5076: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
5077:
5078: INSERT INTO pa_structures_tasks_tmp
5079: (
5080: parent_project_id

Line 7427: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

7423: p_debug_mode IN VARCHAR2 := 'N',
7424: p_project_id IN NUMBER,
7425: p_structure_version_id IN NUMBER,
7426: p_task_version_id IN NUMBER,
7427: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
7428: x_return_status OUT NOCOPY VARCHAR2,
7429: x_msg_count OUT NOCOPY NUMBER,
7430: x_msg_data OUT NOCOPY VARCHAR2
7431: )

Line 8187: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

8183: p_debug_mode IN VARCHAR2 := 'N',
8184: p_project_id IN NUMBER,
8185: p_structure_version_id IN NUMBER,
8186: p_task_version_id IN NUMBER,
8187: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
8188: x_return_status OUT NOCOPY VARCHAR2,
8189: x_msg_count OUT NOCOPY NUMBER,
8190: x_msg_data OUT NOCOPY VARCHAR2
8191: )

Line 8944: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

8940: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8941: p_debug_mode IN VARCHAR2 := 'N',
8942: p_project_id IN NUMBER,
8943: p_structure_version_id IN NUMBER,
8944: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
8945: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
8946: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
8947: x_return_status OUT NOCOPY VARCHAR2,
8948: x_msg_count OUT NOCOPY NUMBER,

Line 8946: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.

8942: p_project_id IN NUMBER,
8943: p_structure_version_id IN NUMBER,
8944: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
8945: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
8946: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
8947: x_return_status OUT NOCOPY VARCHAR2,
8948: x_msg_count OUT NOCOPY NUMBER,
8949: x_msg_data OUT NOCOPY VARCHAR2
8950: )

Line 9032: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then

9028: l_check_edit_task_ok := PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(p_project_id, p_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId);
9029: -- End of Fix for bug 5611634.
9030:
9031:
9032: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
9033:
9034: INSERT INTO pa_structures_tasks_tmp
9035: (
9036: parent_project_id

Line 9859: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then

9855: -- ************************************************************************************************************************
9856: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
9857: -- ************************************************************************************************************************
9858:
9859: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
9860:
9861: INSERT INTO pa_structures_tasks_tmp
9862: (
9863: parent_project_id

Line 10687: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

10683: -- ************************************************************************************************************************
10684: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
10685: -- ************************************************************************************************************************
10686:
10687: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
10688:
10689: INSERT INTO pa_structures_tasks_tmp
10690: (
10691: parent_project_id

Line 11558: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

11554: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
11555: p_debug_mode IN VARCHAR2 := 'N',
11556: p_project_id IN NUMBER,
11557: p_structure_version_id IN NUMBER,
11558: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
11559: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
11560: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
11561: x_return_status OUT NOCOPY VARCHAR2,
11562: x_msg_count OUT NOCOPY NUMBER,

Line 11560: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.

11556: p_project_id IN NUMBER,
11557: p_structure_version_id IN NUMBER,
11558: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
11559: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
11560: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
11561: x_return_status OUT NOCOPY VARCHAR2,
11562: x_msg_count OUT NOCOPY NUMBER,
11563: x_msg_data OUT NOCOPY VARCHAR2
11564: )

Line 11646: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then

11642: l_check_edit_task_ok := PA_PROJ_ELEMENTS_UTILS.Check_Edit_Task_Ok(p_project_id, p_structure_version_id, PA_PROJ_ELEMENTS_UTILS.GetGlobalStrucVerId);
11643: -- End of Fix for bug 5611634.
11644:
11645:
11646: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
11647:
11648: INSERT INTO pa_structures_tasks_tmp
11649: (
11650: parent_project_id

Line 12442: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then

12438: -- ************************************************************************************************************************
12439: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
12440: -- ************************************************************************************************************************
12441:
12442: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
12443:
12444: INSERT INTO pa_structures_tasks_tmp
12445: (
12446: parent_project_id

Line 13239: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then

13235: -- ************************************************************************************************************************
13236: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
13237: -- ************************************************************************************************************************
13238:
13239: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
13240:
13241: INSERT INTO pa_structures_tasks_tmp
13242: (
13243: parent_project_id

Line 14080: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

14076: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
14077: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
14078: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
14079: ,p_debug_mode IN VARCHAR2 :='N'
14080: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14081: ,p_project_id IN NUMBER
14082: ,p_project_element_id IN NUMBER DEFAULT NULL
14083: ,p_structure_version_id IN NUMBER DEFAULT NULL
14084: ,p_baselined_str_ver_id IN NUMBER DEFAULT NULL