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 2205: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then

2201: -- ************************************************************************************************************************
2202: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
2203: -- ************************************************************************************************************************
2204:
2205: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
2206: --Bug 5580992: Removed the reference to pa_percent_completes. The columns Progress_comments and
2207: --Progress_brief_overview are updated after this insert.
2208:
2209: INSERT INTO pa_structures_tasks_tmp

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

3658: -- ************************************************************************************************************************
3659: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
3660: -- ************************************************************************************************************************
3661:
3662: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
3663:
3664: INSERT INTO pa_structures_tasks_tmp
3665: (
3666: parent_project_id

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

5157: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
5158: p_debug_mode IN VARCHAR2 := 'N',
5159: p_project_id IN NUMBER,
5160: p_structure_version_id IN NUMBER,
5161: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
5162: p_sequence_offset IN NUMBER := 0, --bug 4448499
5163: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
5164: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
5165: x_return_status OUT NOCOPY VARCHAR2,

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

5160: p_structure_version_id IN NUMBER,
5161: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
5162: p_sequence_offset IN NUMBER := 0, --bug 4448499
5163: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
5164: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
5165: x_return_status OUT NOCOPY VARCHAR2,
5166: x_msg_count OUT NOCOPY NUMBER,
5167: x_msg_data OUT NOCOPY VARCHAR2
5168: )

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

5232: -- ************************************************************************************************************************
5233: -- if only p_structure_version_id is passed in, populate all task records for the given structure version.
5234: -- ************************************************************************************************************************
5235:
5236: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
5237:
5238: INSERT INTO pa_structures_tasks_tmp
5239: (
5240: parent_project_id

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

6058: -- ************************************************************************************************************************
6059: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
6060: -- ************************************************************************************************************************
6061:
6062: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
6063:
6064: INSERT INTO pa_structures_tasks_tmp
6065: (
6066: parent_project_id

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

6885: -- ************************************************************************************************************************
6886: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
6887: -- ************************************************************************************************************************
6888:
6889: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
6890:
6891: INSERT INTO pa_structures_tasks_tmp
6892: (
6893: parent_project_id

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

9753: p_debug_mode IN VARCHAR2 := 'N',
9754: p_project_id IN NUMBER,
9755: p_structure_version_id IN NUMBER,
9756: p_task_version_id IN NUMBER,
9757: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
9758: x_return_status OUT NOCOPY VARCHAR2,
9759: x_msg_count OUT NOCOPY NUMBER,
9760: x_msg_data OUT NOCOPY VARCHAR2
9761: )

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

10513: p_debug_mode IN VARCHAR2 := 'N',
10514: p_project_id IN NUMBER,
10515: p_structure_version_id IN NUMBER,
10516: p_task_version_id IN NUMBER,
10517: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
10518: x_return_status OUT NOCOPY VARCHAR2,
10519: x_msg_count OUT NOCOPY NUMBER,
10520: x_msg_data OUT NOCOPY VARCHAR2
10521: )

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

11270: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
11271: p_debug_mode IN VARCHAR2 := 'N',
11272: p_project_id IN NUMBER,
11273: p_structure_version_id IN NUMBER,
11274: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
11275: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
11276: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
11277: x_return_status OUT NOCOPY VARCHAR2,
11278: x_msg_count OUT NOCOPY NUMBER,

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

11272: p_project_id IN NUMBER,
11273: p_structure_version_id IN NUMBER,
11274: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
11275: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
11276: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
11277: x_return_status OUT NOCOPY VARCHAR2,
11278: x_msg_count OUT NOCOPY NUMBER,
11279: x_msg_data OUT NOCOPY VARCHAR2
11280: )

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

11358: 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);
11359: -- End of Fix for bug 5611634.
11360:
11361:
11362: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
11363:
11364: INSERT INTO pa_structures_tasks_tmp
11365: (
11366: parent_project_id

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

12186: -- ************************************************************************************************************************
12187: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
12188: -- ************************************************************************************************************************
12189:
12190: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
12191:
12192: INSERT INTO pa_structures_tasks_tmp
12193: (
12194: parent_project_id

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

13015: -- ************************************************************************************************************************
13016: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
13017: -- ************************************************************************************************************************
13018:
13019: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
13020:
13021: INSERT INTO pa_structures_tasks_tmp
13022: (
13023: parent_project_id

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

13887: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
13888: p_debug_mode IN VARCHAR2 := 'N',
13889: p_project_id IN NUMBER,
13890: p_structure_version_id IN NUMBER,
13891: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13892: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
13893: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
13894: x_return_status OUT NOCOPY VARCHAR2,
13895: x_msg_count OUT NOCOPY NUMBER,

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

13889: p_project_id IN NUMBER,
13890: p_structure_version_id IN NUMBER,
13891: p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13892: p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
13893: p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
13894: x_return_status OUT NOCOPY VARCHAR2,
13895: x_msg_count OUT NOCOPY NUMBER,
13896: x_msg_data OUT NOCOPY VARCHAR2
13897: )

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

13975: 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);
13976: -- End of Fix for bug 5611634.
13977:
13978:
13979: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
13980:
13981: INSERT INTO pa_structures_tasks_tmp
13982: (
13983: parent_project_id

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

14772: -- ************************************************************************************************************************
14773: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
14774: -- ************************************************************************************************************************
14775:
14776: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
14777:
14778: INSERT INTO pa_structures_tasks_tmp
14779: (
14780: parent_project_id

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

15570: -- ************************************************************************************************************************
15571: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.
15572: -- ************************************************************************************************************************
15573:
15574: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
15575:
15576: INSERT INTO pa_structures_tasks_tmp
15577: (
15578: parent_project_id

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

16412: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
16413: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
16414: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
16415: ,p_debug_mode IN VARCHAR2 :='N'
16416: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16417: ,p_project_id IN NUMBER
16418: ,p_project_element_id IN NUMBER DEFAULT NULL
16419: ,p_structure_version_id IN NUMBER DEFAULT NULL
16420: ,p_baselined_str_ver_id IN NUMBER DEFAULT NULL