DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_FP_PLANNING_TRANSACTION_PUB

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

5057: ENd IF;
5058: */
5059:
5060: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5061: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5062: BEGIN
5063: pa_fp_planning_transaction_pub.copy_planning_transactions(
5064: p_context => 'WORKPLAN'
5065: ,p_copy_external_flag => l_copy_external_flag

Line 5063: pa_fp_planning_transaction_pub.copy_planning_transactions(

5059:
5060: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5061: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5062: BEGIN
5063: pa_fp_planning_transaction_pub.copy_planning_transactions(
5064: p_context => 'WORKPLAN'
5065: ,p_copy_external_flag => l_copy_external_flag
5066: ,p_src_project_id => p_src_project_id
5067: ,p_target_project_id => l_dest_project_id

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

5081: EXCEPTION
5082: WHEN OTHERS THEN
5083: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
5084: p_procedure_name => 'COPY_TASK',
5085: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.copy_planning_transactions:'||SQLERRM,1,240));
5086: RAISE FND_API.G_EXC_ERROR;
5087: END;
5088:
5089:

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

5114: THEN
5115: l_task_ver_ids2.extend(1); /* Venky */
5116: l_task_ver_ids2(1) := p_dest_task_version_id;
5117: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5118: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
5119: DECLARE
5120: --p1 bug 3888432
5121: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5122: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 5136: pa_fp_planning_transaction_pub.delete_planning_transactions

5132:
5133: IF (l_assign_id IS NOT NULL) THEN
5134: l_assign_ids.extend(1);
5135: l_assign_ids(1) := l_assign_id;
5136: pa_fp_planning_transaction_pub.delete_planning_transactions
5137: (
5138: p_context => 'WORKPLAN'
5139: ,p_task_or_res => 'ASSIGNMENT'
5140: -- ,p_element_version_id_tbl => l_task_ver_ids2

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

5148: EXCEPTION
5149: WHEN OTHERS THEN
5150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
5151: p_procedure_name => 'COPY_TASK',
5152: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
5153: RAISE FND_API.G_EXC_ERROR;
5154: END;
5155:
5156: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

5187: ENd IF;
5188: */
5189:
5190: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5191: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5192: /* P1 4210796
5193: BEGIN
5194: pa_fp_planning_transaction_pub.copy_planning_transactions(
5195: p_context => 'WORKPLAN'

Line 5194: pa_fp_planning_transaction_pub.copy_planning_transactions(

5190: /*Smukka Bug No. 3474141 Date 03/01/2004 */
5191: /*moved pa_fp_planning_transaction_pub.copy_planning_transactions into plsql block */
5192: /* P1 4210796
5193: BEGIN
5194: pa_fp_planning_transaction_pub.copy_planning_transactions(
5195: p_context => 'WORKPLAN'
5196: ,p_copy_external_flag => l_copy_external_flag
5197: ,p_src_project_id => p_src_project_id
5198: ,p_target_project_id => l_dest_project_id

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

5212: EXCEPTION
5213: WHEN OTHERS THEN
5214: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
5215: p_procedure_name => 'COPY_TASK',
5216: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.copy_planning_transactions:'||SQLERRM,1,240));
5217: RAISE FND_API.G_EXC_ERROR;
5218: END;
5219:
5220:

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

6422: THEN
6423: l_task_ver_ids2.extend(1); /* Venky */
6424: l_task_ver_ids2(1) := p_ref_task_version_id;
6425: /*Smukka Bug No. 3474141 Date 03/01/2004 */
6426: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
6427: DECLARE
6428: --p1 bug 3888432
6429: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6430: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 6444: pa_fp_planning_transaction_pub.delete_planning_transactions

6440:
6441: IF (l_assign_id IS NOT NULL) THEN
6442: l_assign_ids.extend(1);
6443: l_assign_ids(1) := l_assign_id;
6444: pa_fp_planning_transaction_pub.delete_planning_transactions
6445: (
6446: p_context => 'WORKPLAN'
6447: ,p_task_or_res => 'ASSIGNMENT'
6448: -- ,p_element_version_id_tbl => l_task_ver_ids2

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

6456: EXCEPTION
6457: WHEN OTHERS THEN
6458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
6459: p_procedure_name => 'MOVE_TASK_VERSION',
6460: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
6461: RAISE FND_API.G_EXC_ERROR;
6462: END;
6463: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6464: x_msg_count := FND_MSG_PUB.count_msg;

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

8269: THEN
8270: l_task_ver_ids.extend(1); /* Venky */
8271: l_task_ver_ids(1) := p_ref_task_version_id;
8272: /*Smukka Bug No. 3474141 Date 03/01/2004 */
8273: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
8274: DECLARE
8275: --p1 bug 3888432
8276: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8277: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 8291: pa_fp_planning_transaction_pub.delete_planning_transactions

8287:
8288: IF (l_assign_id IS NOT NULL) THEN
8289: l_assign_ids.extend(1);
8290: l_assign_ids(1) := l_assign_id;
8291: pa_fp_planning_transaction_pub.delete_planning_transactions
8292: (
8293: p_context => 'WORKPLAN'
8294: ,p_task_or_res => 'ASSIGNMENT'
8295: --,p_element_version_id_tbl => l_task_ver_ids

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

8302: EXCEPTION
8303: WHEN OTHERS THEN
8304: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCTURE_TASK_PUB',
8305: p_procedure_name => 'CREATE_TASKS',
8306: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
8307: RAISE API_ERROR;
8308: END;
8309: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8310: x_msg_count := FND_MSG_PUB.count_msg;

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

10444: --now call call delete planning for task version id.
10445: l_task_ver_ids2.extend(1); /* Venky */
10446: l_task_ver_ids2(1) := p_task_version_id;
10447: /*Smukka Bug No. 3474141 Date 03/01/2004 */
10448: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
10449: DECLARE
10450: --p1 bug 3888432
10451: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10452: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 10466: pa_fp_planning_transaction_pub.delete_planning_transactions

10462:
10463: IF (l_assign_id IS NOT NULL) THEN
10464: l_assign_ids.extend(1);
10465: l_assign_ids(1) := l_assign_id;
10466: pa_fp_planning_transaction_pub.delete_planning_transactions
10467: (
10468: p_context => 'WORKPLAN'
10469: ,p_task_or_res => 'ASSIGNMENT'
10470: --- ,p_element_version_id_tbl => l_task_ver_ids2

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

10478: EXCEPTION
10479: WHEN OTHERS THEN
10480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
10481: p_procedure_name => 'INDENT_TASK_VERSION_BULK',
10482: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
10483: RAISE FND_API.G_EXC_ERROR;
10484: END;
10485:
10486: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

12081: --now call call delete planning for task version id.
12082: l_task_ver_ids2.extend(1); /* Venky */
12083: l_task_ver_ids2(1) := p_task_version_id;
12084: /*Smukka Bug No. 3474141 Date 03/01/2004 */
12085: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
12086: DECLARE
12087: --p1 bug 3888432
12088: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12089: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS

Line 12103: pa_fp_planning_transaction_pub.delete_planning_transactions

12099:
12100: IF (l_assign_id IS NOT NULL) THEN
12101: l_assign_ids.extend(1);
12102: l_assign_ids(1) := l_assign_id;
12103: pa_fp_planning_transaction_pub.delete_planning_transactions
12104: (
12105: p_context => 'WORKPLAN'
12106: ,p_task_or_res => 'ASSIGNMENT'
12107: -- ,p_element_version_id_tbl => l_task_ver_ids2

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

12115: EXCEPTION
12116: WHEN OTHERS then
12117: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
12118: p_procedure_name => 'OUTDENT_TASK_VERSION_BULK',
12119: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
12120: RAISE FND_API.G_EXC_ERROR;
12121: END;
12122: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12123: x_msg_count := FND_MSG_PUB.count_msg;

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

13134:
13135: IF l_task_ver_ids.exists(1)
13136: THEN
13137: /*Smukka Bug No. 3474141 Date 03/01/2004 */
13138: /*moved pa_fp_planning_transaction_pub.add_planning_transactions into plsql block */
13139: BEGIN
13140: pa_fp_planning_transaction_pub.add_planning_transactions(
13141: p_context => 'WORKPLAN'
13142: ,p_project_id => p_project_id

Line 13140: pa_fp_planning_transaction_pub.add_planning_transactions(

13136: THEN
13137: /*Smukka Bug No. 3474141 Date 03/01/2004 */
13138: /*moved pa_fp_planning_transaction_pub.add_planning_transactions into plsql block */
13139: BEGIN
13140: pa_fp_planning_transaction_pub.add_planning_transactions(
13141: p_context => 'WORKPLAN'
13142: ,p_project_id => p_project_id
13143: ,p_struct_elem_version_id => p_structure_version_id
13144: ,p_task_elem_version_id_tbl => l_task_ver_ids

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

13153: EXCEPTION
13154: WHEN OTHERS THEN
13155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
13156: p_procedure_name => 'call_add_planning_txns',
13157: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
13158: raise API_ERROR;
13159: END;
13160: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13161: x_msg_count := FND_MSG_PUB.count_msg;

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

13697: 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);
13698: END IF;
13699: --bug 3959087, end
13700:
13701: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().
13702:
13703: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND
13704: IF (l_lowest_level_task = 'Y' AND --bug 3959087
13705: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'

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

13738: l_start_dates(1) := l_SCHEDULED_START_DATE;
13739: l_end_dates(1) := l_SCHEDULED_END_DATE;
13740:
13741: /*Smukka Bug No. 3474141 Date 03/01/2004 */
13742: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */
13743: BEGIN
13744: IF NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
13745: THEN
13746: IF l_debug_mode = 'Y' THEN

Line 13754: pa_fp_planning_transaction_pub.update_planning_transactions

13750: 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);
13751: 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);
13752: END IF;
13753:
13754: pa_fp_planning_transaction_pub.update_planning_transactions
13755: (
13756: p_context => 'WORKPLAN'
13757: ,p_struct_elem_version_id => p_structure_version_id
13758: ,p_task_elem_version_id_tbl => l_task_ver_ids2

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

13767: EXCEPTION
13768: WHEN OTHERS THEN
13769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
13770: p_procedure_name => 'update_task_det_sch_info',
13771: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
13772: RAISE FND_API.G_EXC_ERROR;
13773: END;
13774: --end 3301192 fp changes
13775: END IF; --<< l_planned_effort >>