DBA Data[Home] [Help]

APPS.PA_PROJ_STAT_ACTSET dependencies on PA_ACTION_SET_UTILS

Line 13: g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;

9: -- lines in the reminder action set of type PA_PROJ_STATUS_REPORT
10: -- or PA_TASK_PROGRESS on an project.
11:
12: -- global table to store the audit lines
13: g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
14:
15:
16: /*=======================================================================*/
17: -- Procedure

Line 38: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,

34: PROCEDURE perform_action_set_line /* Default value N added for bug#2463257 */
35: (p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE:='PA_PROJ_STATUS_REPORT',
36: p_action_set_details_rec IN pa_action_sets%ROWTYPE,
37: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
38: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
39: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type,
40: x_action_line_result_code OUT NOCOPY VARCHAR2);
41: /*=======================================================================*/
42: -- Procedure

Line 39: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type,

35: (p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE:='PA_PROJ_STATUS_REPORT',
36: p_action_set_details_rec IN pa_action_sets%ROWTYPE,
37: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
38: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
39: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type,
40: x_action_line_result_code OUT NOCOPY VARCHAR2);
41: /*=======================================================================*/
42: -- Procedure
43: -- Validate Project Status Report (Reminder) Action Set Line

Line 53: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

49: /*=======================================================================*/
50: PROCEDURE validate_action_set_line (
51: p_action_set_type_code IN VARCHAR2 := 'PA_PROJ_STATUS_REPORT'
52: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
53: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
54: , x_return_status OUT NOCOPY VARCHAR2
55: );
56: /*=======================================================================*/
57: -- Procedure

Line 97: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

93:
94: FUNCTION ok_to_perform_action (
95: p_report_date IN pa_object_page_layouts.next_reporting_date%TYPE
96: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
97: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
98: ) return BOOLEAN;
99:
100: PROCEDURE perform_selected_action(
101: p_project_id IN NUMBER

Line 106: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

102: ,p_report_type_id IN NUMBER
103: ,p_layout_id IN NUMBER
104: ,p_action_set_type_code IN VARCHAR2
105: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
106: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
107: ,x_action_performed OUT NOCOPY VARCHAR2
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
110: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 122: -- p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

118: ,x_msg_data OUT NOCOPY VARCHAR2);
119:
120:
121: --FUNCTION get_number_of_days(
122: -- p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
123: -- ) return NUMBER;
124:
125: FUNCTION is_action_repeating(
126: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

Line 126: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

122: -- p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
123: -- ) return NUMBER;
124:
125: FUNCTION is_action_repeating(
126: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
127: ) return BOOLEAN;
128:
129: PROCEDURE delete_action_set
130: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL