DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_ACTION_SETS

Line 22: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

18: -- Validate a single action line of an advertisement action set
19: -- template or an advertisement action set on a requirement.
20: ----------------------------------------------------------------------
21: PROCEDURE Validate_Action_Set_Line (
22: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
23: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
24: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
25: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: );

Line 41: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

37: -- set or action lines on the requirement are updated, or an action
38: -- set is started on a requirement.
39: ----------------------------------------------------------------------
40: PROCEDURE Process_Action_Set (
41: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
42: , p_action_set_id IN NUMBER
43: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
44: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: );

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

39: ----------------------------------------------------------------------
40: PROCEDURE Process_Action_Set (
41: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
42: , p_action_set_id IN NUMBER
43: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
44: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: );
46:
47:

Line 57: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

53: -- Invoked by the generic perform action set API to perform an action
54: -- line in the advertisement action set on an object.
55: ----------------------------------------------------------------------
56: PROCEDURE Perform_Action_Set_Line (
57: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
58: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
59: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
60: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
61: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619

Line 58: , p_action_set_details_rec IN pa_action_sets%ROWTYPE

54: -- line in the advertisement action set on an object.
55: ----------------------------------------------------------------------
56: PROCEDURE Perform_Action_Set_Line (
57: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
58: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
59: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
60: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
61: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619
62: , x_action_line_result_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 76: p_object_id IN pa_action_sets.object_id%TYPE

72: -- updating the statuses of the action lines based on the
73: -- condition and the new requirement start date.
74: ----------------------------------------------------------------------
75: PROCEDURE Reevaluate_Adv_Action_Set (
76: p_object_id IN pa_action_sets.object_id%TYPE
77: , p_object_type IN pa_action_sets.object_type%TYPE
78: , p_new_object_start_date IN DATE
79: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
80: , p_api_version IN NUMBER := 1.0

Line 77: , p_object_type IN pa_action_sets.object_type%TYPE

73: -- condition and the new requirement start date.
74: ----------------------------------------------------------------------
75: PROCEDURE Reevaluate_Adv_Action_Set (
76: p_object_id IN pa_action_sets.object_id%TYPE
77: , p_object_type IN pa_action_sets.object_type%TYPE
78: , p_new_object_start_date IN DATE
79: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
80: , p_api_version IN NUMBER := 1.0
81: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 94: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE

90: -- Purpose
91: -- Check if the action set should be started upon application.
92: ----------------------------------------------------------------------
93: FUNCTION Is_Action_Set_Started_On_Apply(
94: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
95: ,p_object_type IN pa_action_sets.object_type%TYPE
96: ,p_object_id IN pa_action_sets.object_id%TYPE
97: ) RETURN VARCHAR2;
98:

Line 95: ,p_object_type IN pa_action_sets.object_type%TYPE

91: -- Check if the action set should be started upon application.
92: ----------------------------------------------------------------------
93: FUNCTION Is_Action_Set_Started_On_Apply(
94: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
95: ,p_object_type IN pa_action_sets.object_type%TYPE
96: ,p_object_id IN pa_action_sets.object_id%TYPE
97: ) RETURN VARCHAR2;
98:
99:

Line 96: ,p_object_id IN pa_action_sets.object_id%TYPE

92: ----------------------------------------------------------------------
93: FUNCTION Is_Action_Set_Started_On_Apply(
94: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
95: ,p_object_type IN pa_action_sets.object_type%TYPE
96: ,p_object_id IN pa_action_sets.object_id%TYPE
97: ) RETURN VARCHAR2;
98:
99:
100: END PA_ADVERTISEMENTS_PUB;