DBA Data[Home] [Help]

APPS.PA_PROJ_STAT_ACTSET dependencies on PA_ACTION_SETS

Line 26: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

22: -- set or action lines on the requirement are updated, or an action
23: -- set is started on a requirement.
24: /*=======================================================================*/
25: PROCEDURE Process_Action_Set (
26: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
27: , p_action_set_id IN NUMBER
28: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
29: , x_return_status OUT NOCOPY VARCHAR2
30: );

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

24: /*=======================================================================*/
25: PROCEDURE Process_Action_Set (
26: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
27: , p_action_set_id IN NUMBER
28: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
29: , x_return_status OUT NOCOPY VARCHAR2
30: );
31:
32:

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

31:
32:
33: /*=======================================================================*/
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,

Line 36: p_action_set_details_rec IN pa_action_sets%ROWTYPE,

32:
33: /*=======================================================================*/
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);

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

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
131: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
132: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
133: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
134: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

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

127: ) return BOOLEAN;
128:
129: PROCEDURE delete_action_set
130: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
131: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
132: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
133: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
134: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
135: ,p_api_version IN NUMBER := 1.0

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

128:
129: PROCEDURE delete_action_set
130: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
131: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
132: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
133: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
134: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
135: ,p_api_version IN NUMBER := 1.0
136: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

129: PROCEDURE delete_action_set
130: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
131: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
132: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
133: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
134: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
135: ,p_api_version IN NUMBER := 1.0
136: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
137: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

130: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
131: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
132: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
133: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
134: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
135: ,p_api_version IN NUMBER := 1.0
136: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
137: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
138: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

142: );
143:
144:
145: PROCEDURE update_action_set
146: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
147: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
148: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
149: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
150: ,p_perform_action_set_flag IN VARCHAR2 := 'N'

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

143:
144:
145: PROCEDURE update_action_set
146: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
147: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
148: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
149: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
150: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
151: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

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

144:
145: PROCEDURE update_action_set
146: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
147: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
148: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
149: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
150: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
151: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
152: ,p_api_version IN NUMBER := 1.0

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

145: PROCEDURE update_action_set
146: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
147: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
148: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
149: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
150: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
151: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
152: ,p_api_version IN NUMBER := 1.0
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

147: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
148: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
149: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
150: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
151: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
152: ,p_api_version IN NUMBER := 1.0
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
155: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE