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_TASK_PROG_ACTSET dependencies on PA_ACTION_SETS

Line 7: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'

3:
4:
5:
6: PROCEDURE process_action_set (
7: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
8: , p_action_set_id IN NUMBER
9: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
10: , x_return_status OUT NOCOPY VARCHAR2
11: ) IS

Line 9: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL

5:
6: PROCEDURE process_action_set (
7: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
8: , p_action_set_id IN NUMBER
9: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
10: , x_return_status OUT NOCOPY VARCHAR2
11: ) IS
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;

Line 54: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(

50: l_line_number_tbl(loop_cnt) := loop_cnt;
51: END LOOP;
52:
53: --order lines for both template and project action set
54: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(
55: p_action_set_line_id_tbl => l_line_id_tbl
56: ,p_line_number_tbl => l_line_number_tbl
57: ,x_return_status => x_return_status
58: );

Line 67: -- PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

63: -- FOR loop_cnt IN l_line_cond_id_tbl.FIRST .. l_line_cond_id_tbl.LAST LOOP
64: -- l_line_cond_date_tbl(loop_cnt) := sysdate;
65: -- END LOOP;
66: --
67: -- PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
68: -- p_action_line_condition_id_tbl => l_line_cond_id_tbl
69: -- ,p_condition_date_tbl => l_line_cond_date_tbl
70: -- ,x_return_status => l_return_status
71: -- );

Line 90: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE

86: END process_action_set;
87: /*===================================================================================*/
88: PROCEDURE perform_action_set_line(
89: p_action_set_type_code IN VARCHAR2 := 'PA_TASK_PROGRESS'
90: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
91: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
92: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
93: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
94: ,x_action_line_result_code OUT NOCOPY VARCHAR2)

Line 322: from pa_action_sets

318: Cursor task_reminder_action_set
319: is
320: /*
321: Select action_set_id
322: from pa_action_sets
323: where object_type = 'PA_PROJECTS'
324: and object_id = p_project_id_from;
325: */
326: SELECT

Line 353: pa_action_sets_pub.apply_action_set

349: PA_DEBUG.Reset_Err_Stack;
350: return ;
351: end if ;
352:
353: pa_action_sets_pub.apply_action_set
354: (p_action_set_id => l_action_set_id
355: ,p_object_type => 'PA_PROJECTS'
356: ,p_object_id => p_project_id_to
357: ,p_validate_only => FND_API.G_FALSE

Line 391: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL

387: END copy_action_sets;
388:
389:
390: PROCEDURE delete_action_set
391: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
392: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
393: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
394: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
395: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 392: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'

388:
389:
390: PROCEDURE delete_action_set
391: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
392: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
393: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
394: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
395: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
396: ,p_api_version IN NUMBER := 1.0

Line 393: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'

389:
390: PROCEDURE delete_action_set
391: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
392: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
393: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
394: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
395: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
396: ,p_api_version IN NUMBER := 1.0
397: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 394: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL

390: PROCEDURE delete_action_set
391: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
392: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
393: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
394: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
395: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
396: ,p_api_version IN NUMBER := 1.0
397: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
398: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 395: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

391: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
392: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
393: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
394: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
395: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
396: ,p_api_version IN NUMBER := 1.0
397: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
398: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
399: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 420: from pa_action_sets

416: l_record_version_number := p_record_version_number;
417: IF l_record_version_number is NULL THEN
418: select record_version_number
419: into l_record_version_number
420: from pa_action_sets
421: where action_set_id = p_action_set_id;
422: END IF;
423: PA_ACTION_SETS_PUB.delete_action_set
424: (p_action_set_id => p_action_set_id

Line 423: PA_ACTION_SETS_PUB.delete_action_set

419: into l_record_version_number
420: from pa_action_sets
421: where action_set_id = p_action_set_id;
422: END IF;
423: PA_ACTION_SETS_PUB.delete_action_set
424: (p_action_set_id => p_action_set_id
425: ,p_action_set_type_code => p_action_set_type_code
426: ,p_object_type => p_object_type
427: ,p_object_id => p_object_id

Line 457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL

453:
454: END delete_action_set;
455:
456: PROCEDURE update_action_set
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
458: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
459: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
460: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
461: ,p_perform_action_set_flag IN VARCHAR2 := 'N'

Line 458: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'

454: END delete_action_set;
455:
456: PROCEDURE update_action_set
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
458: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
459: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
460: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
461: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
462: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 459: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'

455:
456: PROCEDURE update_action_set
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
458: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
459: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
460: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
461: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
462: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
463: ,p_api_version IN NUMBER := 1.0

Line 460: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL

456: PROCEDURE update_action_set
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
458: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
459: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
460: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
461: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
462: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
463: ,p_api_version IN NUMBER := 1.0
464: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 462: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

458: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
459: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
460: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
461: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
462: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
463: ,p_api_version IN NUMBER := 1.0
464: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
465: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
466: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 473: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,

469: ,x_msg_count OUT NOCOPY NUMBER
470: ,x_msg_data OUT NOCOPY VARCHAR2
471: ) IS
472: /*
473: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
474: cp_obj pa_action_sets.object_type%TYPE ) IS
475: select action_set_id,record_version_number
476: from pa_action_sets
477: where object_id = cp_object_id

Line 474: cp_obj pa_action_sets.object_type%TYPE ) IS

470: ,x_msg_data OUT NOCOPY VARCHAR2
471: ) IS
472: /*
473: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
474: cp_obj pa_action_sets.object_type%TYPE ) IS
475: select action_set_id,record_version_number
476: from pa_action_sets
477: where object_id = cp_object_id
478: AND object_type = cp_obj

Line 476: from pa_action_sets

472: /*
473: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
474: cp_obj pa_action_sets.object_type%TYPE ) IS
475: select action_set_id,record_version_number
476: from pa_action_sets
477: where object_id = cp_object_id
478: AND object_type = cp_obj
479: AND action_set_type_code = cp_type;
480: */

Line 484: from pa_action_sets

480: */
481: CURSOR c_action_set_info(cp_action_set_id NUMBER
482: ) IS
483: select action_set_id,record_version_number
484: from pa_action_sets
485: where action_set_id = cp_action_set_id;
486:
487: l_record_version_number NUMBER;
488: l_curr_action_set_id NUMBER := NULL;

Line 538: PA_ACTION_SETS_PUB.delete_action_set

534: CLOSE c_action_set_info;
535: END IF;
536: */
537: IF p_action_set_id is NULL AND l_curr_action_set_id is NOT NULL THEN
538: PA_ACTION_SETS_PUB.delete_action_set
539: (p_action_set_id => l_curr_action_set_id
540: ,p_action_set_type_code => p_action_set_type_code
541: ,p_object_type => p_object_type
542: ,p_object_id => p_object_id

Line 552: PA_ACTION_SETS_PUB.apply_action_set

548: ,x_msg_count => x_msg_count
549: ,x_msg_data => x_msg_data);
550: ELSE
551: IF p_action_set_id is NOT NULL AND l_curr_action_set_id is NULL THEN
552: PA_ACTION_SETS_PUB.apply_action_set
553: (p_action_set_id => p_action_set_id
554: ,p_object_type => p_object_type
555: ,p_object_id => p_object_id
556: ,p_perform_action_set_flag => p_perform_action_set_flag

Line 570: PA_ACTION_SETS_PUB.replace_action_set

566: IF p_action_set_id is NOT NULL AND l_curr_action_set_id is NOT NULL THEN
567: IF l_curr_action_set_id = p_action_set_id THEN
568: RETURN;
569: END IF;
570: PA_ACTION_SETS_PUB.replace_action_set
571: (p_current_action_set_id => l_curr_action_set_id
572: ,p_action_set_type_code => p_action_set_type_code
573: ,p_object_type => p_object_type
574: ,p_object_id => p_object_id