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

Line 6: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

2: --$Header: PAASPSB.pls 115.18 2003/04/08 18:46:59 mwasowic noship $
3:
4:
5: PROCEDURE process_action_set (
6: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
7: , p_action_set_id IN NUMBER
8: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
9: , x_return_status OUT NOCOPY VARCHAR2
10: ) IS

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

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

Line 59: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(

55: l_line_number_tbl(loop_cnt) := loop_cnt;
56: END LOOP;
57:
58: --order lines for both template and project action set
59: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(
60: p_action_set_line_id_tbl => l_line_id_tbl
61: ,p_line_number_tbl => l_line_number_tbl
62: ,x_return_status => x_return_status
63: );

Line 73: -- PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

69: -- --dbms_output.put_line( loop_cnt ||' cond date '|| sysdate );
70: -- l_line_cond_date_tbl(loop_cnt) := sysdate;
71: -- END LOOP;
72: --
73: -- PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
74: -- p_action_line_condition_id_tbl => l_line_cond_id_tbl
75: -- ,p_condition_date_tbl => l_line_cond_date_tbl
76: -- ,x_return_status => l_return_status
77: -- );

Line 99: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'

95:
96: /*----------------------------------------------------------------------------------------
97: -----------------------------------------------------------------------------------------*/
98: PROCEDURE perform_action_set_line(
99: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
100: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
101: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
102: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
103: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type

Line 100: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE

96: /*----------------------------------------------------------------------------------------
97: -----------------------------------------------------------------------------------------*/
98: PROCEDURE perform_action_set_line(
99: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
100: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
101: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
102: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
103: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
104: ,x_action_line_result_code OUT NOCOPY VARCHAR2)

Line 446: ,pa_action_sets ast

442: SELECT lt.object_page_layout_id object_page_layout_id
443: ,ast.action_set_id action_set_id
444: ,lt.report_type_id report_type_id
445: FROM pa_object_page_layouts lt
446: ,pa_action_sets ast
447: WHERE ast.object_type = 'PA_PROJ_STATUS_REPORTS'
448: AND lt.page_type_code = 'PPR'
449: AND lt.object_id = p_project_id_from --c_proj_id_from
450: AND ast.object_id = lt.object_page_layout_id;

Line 492: pa_action_sets_pub.apply_action_set

488: OPEN c_new_proj_layout_ids(p_project_id_to, c_action_set_rec.report_type_id);
489: FETCH c_new_proj_layout_ids into cp_layout_id;
490: if c_new_proj_layout_ids%FOUND then
491:
492: pa_action_sets_pub.apply_action_set
493: (p_action_set_id => c_action_set_rec.action_set_id
494: ,p_object_type => 'PA_PROJ_STATUS_REPORTS'
495: ,p_object_id => cp_layout_id.object_page_layout_id
496: ,p_validate_only => FND_API.G_FALSE

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

528:
529: END copy_action_sets;
530:
531: PROCEDURE delete_action_set
532: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
533: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 533: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'

529: END copy_action_sets;
530:
531: PROCEDURE delete_action_set
532: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
533: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0

Line 534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'

530:
531: PROCEDURE delete_action_set
532: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
533: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0
538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

531: PROCEDURE delete_action_set
532: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
533: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0
538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

532: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
533: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0
538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
540: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

542: ,x_msg_count OUT NOCOPY NUMBER
543: ,x_msg_data OUT NOCOPY VARCHAR2
544: ) IS
545: /*
546: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
547: cp_obj pa_action_sets.object_type%TYPE ) IS
548:
549: select action_set_id,record_version_number
550: from pa_action_sets

Line 547: cp_obj pa_action_sets.object_type%TYPE ) IS

543: ,x_msg_data OUT NOCOPY VARCHAR2
544: ) IS
545: /*
546: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
547: cp_obj pa_action_sets.object_type%TYPE ) IS
548:
549: select action_set_id,record_version_number
550: from pa_action_sets
551: where object_id = cp_object_id

Line 550: from pa_action_sets

546: CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
547: cp_obj pa_action_sets.object_type%TYPE ) IS
548:
549: select action_set_id,record_version_number
550: from pa_action_sets
551: where object_id = cp_object_id
552: AND object_type = cp_obj
553: AND action_set_type_code = cp_type;
554: */

Line 557: from pa_action_sets

553: AND action_set_type_code = cp_type;
554: */
555: CURSOR c_action_set_info(cp_act_set_id NUMBER ) IS
556: select record_version_number
557: from pa_action_sets
558: where action_set_id = cp_act_set_id;
559:
560:
561: l_record_version_number NUMBER;

Line 594: PA_ACTION_SETS_PUB.delete_action_set

590: l_record_version_number := cp_action_set_info.record_version_number;
591: CLOSE c_action_set_info;
592: END IF;
593:
594: PA_ACTION_SETS_PUB.delete_action_set
595: (p_action_set_id => l_action_set_id
596: ,p_action_set_type_code => p_action_set_type_code
597: ,p_object_type => p_object_type
598: ,p_object_id => p_object_id

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

621:
622:
623:
624: PROCEDURE update_action_set
625: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
626: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
627: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
628: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'

Line 626: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'

622:
623:
624: PROCEDURE update_action_set
625: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
626: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
627: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
628: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 627: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'

623:
624: PROCEDURE update_action_set
625: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
626: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
627: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
628: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
631: ,p_api_version IN NUMBER := 1.0

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

624: PROCEDURE update_action_set
625: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
626: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
627: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
628: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
631: ,p_api_version IN NUMBER := 1.0
632: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

626: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
627: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
628: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
631: ,p_api_version IN NUMBER := 1.0
632: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
633: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
634: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 644: from pa_action_sets

640:
641:
642: CURSOR c_action_set_info(cp_act_set_id NUMBER ) IS
643: select record_version_number
644: from pa_action_sets
645: where action_set_id = cp_act_set_id;
646:
647:
648: l_record_version_number NUMBER;

Line 683: PA_ACTION_SETS_PUB.delete_action_set

679: END IF;
680:
681:
682: IF p_action_set_id is NULL AND l_curr_action_set_id is NOT NULL THEN
683: PA_ACTION_SETS_PUB.delete_action_set
684: (p_action_set_id => l_curr_action_set_id
685: ,p_action_set_type_code => p_action_set_type_code
686: ,p_object_type => p_object_type
687: ,p_object_id => p_object_id

Line 697: PA_ACTION_SETS_PUB.apply_action_set

693: ,x_msg_count => x_msg_count
694: ,x_msg_data => x_msg_data);
695: ELSE
696: IF p_action_set_id is NOT NULL AND l_curr_action_set_id is NULL THEN
697: PA_ACTION_SETS_PUB.apply_action_set
698: (p_action_set_id => p_action_set_id
699: ,p_object_type => p_object_type
700: ,p_object_id => p_object_id
701: ,p_perform_action_set_flag => p_perform_action_set_flag

Line 716: PA_ACTION_SETS_PUB.replace_action_set

712: IF l_curr_action_set_id = p_action_set_id THEN
713: RETURN;
714: END IF;
715:
716: PA_ACTION_SETS_PUB.replace_action_set
717: (p_current_action_set_id => l_curr_action_set_id
718: ,p_action_set_type_code => p_action_set_type_code
719: ,p_object_type => p_object_type
720: ,p_object_id => p_object_id