DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_FP_PLANNING_TRANSACTION_PUB

Line 5336: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */

5332: ENd IF;
5333: */
5334:
5335: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5336: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5337: BEGIN
5338: pa_fp_planning_transaction_pub.copy_planning_transactions(
5339: p_context => 'WORKPLAN'
5340: ,p_copy_external_flag => l_copy_external_flag

Line 5338: pa_fp_planning_transaction_pub.copy_planning_transactions(

5334:
5335: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5336: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5337: BEGIN
5338: pa_fp_planning_transaction_pub.copy_planning_transactions(
5339: p_context => 'WORKPLAN'
5340: ,p_copy_external_flag => l_copy_external_flag
5341: ,p_src_project_id => p_src_project_id
5342: ,p_target_project_id => l_dest_project_id

Line 5360: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.copy_planning_transactions:'||SQLERRM,1,240));

5356: EXCEPTION
5357: WHEN OTHERS THEN
5358: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
5359: p_procedure_name => 'COPY_TASK',
5360: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.copy_planning_transactions:'||SQLERRM,1,240));
5361: RAISE FND_API.G_EXC_ERROR;
5362: END;
5363:
5364:

Line 5393: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */

5389: THEN
5390: l_task_ver_ids2.extend(1); /* Venky */
5391: l_task_ver_ids2(1) := p_dest_task_version_id;
5392: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5393: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
5394: DECLARE
5395: --p1 bug 3888432
5396: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5397: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 5411: pa_fp_planning_transaction_pub.delete_planning_transactions

5407:
5408: IF (l_assign_id IS NOT NULL) THEN
5409: l_assign_ids.extend(1);
5410: l_assign_ids(1) := l_assign_id;
5411: pa_fp_planning_transaction_pub.delete_planning_transactions
5412: (
5413: p_context => 'WORKPLAN'
5414: ,p_task_or_res => 'ASSIGNMENT'
5415: -- ,p_element_version_id_tbl => l_task_ver_ids2

Line 5427: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));

5423: EXCEPTION
5424: WHEN OTHERS THEN
5425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
5426: p_procedure_name => 'COPY_TASK',
5427: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
5428: RAISE FND_API.G_EXC_ERROR;
5429: END;
5430:
5431: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 5466: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */

5462: ENd IF;
5463: */
5464:
5465: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5466: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5467: /* P1 4210796
5468: BEGIN
5469: pa_fp_planning_transaction_pub.copy_planning_transactions(
5470: p_context => 'WORKPLAN'

Line 5469: pa_fp_planning_transaction_pub.copy_planning_transactions(

5465: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5466: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5467: /* P1 4210796
5468: BEGIN
5469: pa_fp_planning_transaction_pub.copy_planning_transactions(
5470: p_context => 'WORKPLAN'
5471: ,p_copy_external_flag => l_copy_external_flag
5472: ,p_src_project_id => p_src_project_id
5473: ,p_target_project_id => l_dest_project_id

Line 5491: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.copy_planning_transactions:'||SQLERRM,1,240));

5487: EXCEPTION
5488: WHEN OTHERS THEN
5489: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
5490: p_procedure_name => 'COPY_TASK',
5491: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.copy_planning_transactions:'||SQLERRM,1,240));
5492: RAISE FND_API.G_EXC_ERROR;
5493: END;
5494:
5495:

Line 6708: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */

6704: THEN
6705: l_task_ver_ids2.extend(1); /* Venky */
6706: l_task_ver_ids2(1) := p_ref_task_version_id;
6707: /*Smukka Bug No. 3474141 Date 03/01/2004 */
6708: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
6709: DECLARE
6710: --p1 bug 3888432
6711: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6712: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 6726: pa_fp_planning_transaction_pub.delete_planning_transactions

6722:
6723: IF (l_assign_id IS NOT NULL) THEN
6724: l_assign_ids.extend(1);
6725: l_assign_ids(1) := l_assign_id;
6726: pa_fp_planning_transaction_pub.delete_planning_transactions
6727: (
6728: p_context => 'WORKPLAN'
6729: ,p_task_or_res => 'ASSIGNMENT'
6730: -- ,p_element_version_id_tbl => l_task_ver_ids2

Line 6742: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));

6738: EXCEPTION
6739: WHEN OTHERS THEN
6740: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
6741: p_procedure_name => 'MOVE_TASK_VERSION',
6742: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
6743: RAISE FND_API.G_EXC_ERROR;
6744: END;
6745: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6746: x_msg_count := FND_MSG_PUB.count_msg;

Line 8636: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */

8632: THEN
8633: l_task_ver_ids.extend(1); /* Venky */
8634: l_task_ver_ids(1) := p_ref_task_version_id;
8635: /*Smukka Bug No. 3474141 Date 03/01/2004 */
8636: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
8637: DECLARE
8638: --p1 bug 3888432
8639: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8640: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 8654: pa_fp_planning_transaction_pub.delete_planning_transactions

8650:
8651: IF (l_assign_id IS NOT NULL) THEN
8652: l_assign_ids.extend(1);
8653: l_assign_ids(1) := l_assign_id;
8654: pa_fp_planning_transaction_pub.delete_planning_transactions
8655: (
8656: p_context => 'WORKPLAN'
8657: ,p_task_or_res => 'ASSIGNMENT'
8658: --,p_element_version_id_tbl => l_task_ver_ids

Line 8669: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));

8665: EXCEPTION
8666: WHEN OTHERS THEN
8667: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCTURE_TASK_PUB',
8668: p_procedure_name => 'CREATE_TASKS',
8669: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
8670: RAISE API_ERROR;
8671: END;
8672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8673: x_msg_count := FND_MSG_PUB.count_msg;

Line 10828: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */

10824: --now call call delete planning for task version id.
10825: l_task_ver_ids2.extend(1); /* Venky */
10826: l_task_ver_ids2(1) := p_task_version_id;
10827: /*Smukka Bug No. 3474141 Date 03/01/2004 */
10828: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
10829: DECLARE
10830: --p1 bug 3888432
10831: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10832: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 10846: pa_fp_planning_transaction_pub.delete_planning_transactions

10842:
10843: IF (l_assign_id IS NOT NULL) THEN
10844: l_assign_ids.extend(1);
10845: l_assign_ids(1) := l_assign_id;
10846: pa_fp_planning_transaction_pub.delete_planning_transactions
10847: (
10848: p_context => 'WORKPLAN'
10849: ,p_task_or_res => 'ASSIGNMENT'
10850: --- ,p_element_version_id_tbl => l_task_ver_ids2

Line 10862: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));

10858: EXCEPTION
10859: WHEN OTHERS THEN
10860: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
10861: p_procedure_name => 'INDENT_TASK_VERSION_BULK',
10862: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
10863: RAISE FND_API.G_EXC_ERROR;
10864: END;
10865:
10866: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12501: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */

12497: --now call call delete planning for task version id.
12498: l_task_ver_ids2.extend(1); /* Venky */
12499: l_task_ver_ids2(1) := p_task_version_id;
12500: /*Smukka Bug No. 3474141 Date 03/01/2004 */
12501: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
12502: DECLARE
12503: --p1 bug 3888432
12504: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12505: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 12519: pa_fp_planning_transaction_pub.delete_planning_transactions

12515:
12516: IF (l_assign_id IS NOT NULL) THEN
12517: l_assign_ids.extend(1);
12518: l_assign_ids(1) := l_assign_id;
12519: pa_fp_planning_transaction_pub.delete_planning_transactions
12520: (
12521: p_context => 'WORKPLAN'
12522: ,p_task_or_res => 'ASSIGNMENT'
12523: -- ,p_element_version_id_tbl => l_task_ver_ids2

Line 12535: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));

12531: EXCEPTION
12532: WHEN OTHERS then
12533: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
12534: p_procedure_name => 'OUTDENT_TASK_VERSION_BULK',
12535: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
12536: RAISE FND_API.G_EXC_ERROR;
12537: END;
12538: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12539: x_msg_count := FND_MSG_PUB.count_msg;

Line 13662: /*moved pa_fp_planning_transaction_pub.add_planning_transactions into plsql block */

13658:
13659: IF l_task_ver_ids.exists(1)
13660: THEN
13661: /*Smukka Bug No. 3474141 Date 03/01/2004 */
13662: /*moved pa_fp_planning_transaction_pub.add_planning_transactions into plsql block */
13663: BEGIN
13664: pa_fp_planning_transaction_pub.add_planning_transactions(
13665: p_context => 'WORKPLAN'
13666: ,p_project_id => p_project_id

Line 13664: pa_fp_planning_transaction_pub.add_planning_transactions(

13660: THEN
13661: /*Smukka Bug No. 3474141 Date 03/01/2004 */
13662: /*moved pa_fp_planning_transaction_pub.add_planning_transactions into plsql block */
13663: BEGIN
13664: pa_fp_planning_transaction_pub.add_planning_transactions(
13665: p_context => 'WORKPLAN'
13666: ,p_project_id => p_project_id
13667: ,p_struct_elem_version_id => p_structure_version_id
13668: ,p_task_elem_version_id_tbl => l_task_ver_ids

Line 13681: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));

13677: EXCEPTION
13678: WHEN OTHERS THEN
13679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
13680: p_procedure_name => 'call_add_planning_txns',
13681: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
13682: raise API_ERROR;
13683: END;
13684: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13685: x_msg_count := FND_MSG_PUB.count_msg;

Line 14225: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().

14221: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_assignment_exists='||l_assignment_exists, x_Log_Level=> 3);
14222: END IF;
14223: --bug 3959087, end
14224:
14225: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().
14226:
14227: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND
14228: IF (l_lowest_level_task = 'Y' AND --bug 3959087
14229: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'

Line 14266: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */

14262: l_start_dates(1) := l_SCHEDULED_START_DATE;
14263: l_end_dates(1) := l_SCHEDULED_END_DATE;
14264:
14265: /*Smukka Bug No. 3474141 Date 03/01/2004 */
14266: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */
14267: BEGIN
14268: IF NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
14269: THEN
14270: IF l_debug_mode = 'Y' THEN

Line 14278: pa_fp_planning_transaction_pub.update_planning_transactions

14274: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_start_dates='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14275: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_end_dates='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14276: END IF;
14277:
14278: pa_fp_planning_transaction_pub.update_planning_transactions
14279: (
14280: p_context => 'WORKPLAN'
14281: ,p_struct_elem_version_id => p_structure_version_id
14282: ,p_task_elem_version_id_tbl => l_task_ver_ids2

Line 14295: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));

14291: EXCEPTION
14292: WHEN OTHERS THEN
14293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
14294: p_procedure_name => 'update_task_det_sch_info',
14295: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
14296: RAISE FND_API.G_EXC_ERROR;
14297: END;
14298: --end 3301192 fp changes
14299: END IF; --<< l_planned_effort >>