1 PACKAGE PA_ADVERTISEMENTS_PUB AS
2 --$Header: PARAVPBS.pls 120.1 2005/08/19 16:48:50 mwasowic noship $
3 --
4
5 -- global variable to store the audit lines to be returned
6 -- to the generic action set api when an action line is performed
7 g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
8
9 -- global variable to store the start advertisement action set flag
10 g_start_adv_action_set_flag VARCHAR2(1) := NULL;
11
12 ----------------------------------------------------------------------
13 -- Procedure
14 -- Validate Advertisement Action Line
15 --
16 -- Purpose
17 -- This API is currently empty.
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 );
27
28
29 ----------------------------------------------------------------------
30 -- Procedure
31 -- Process Advertisement Action Set
32 --
33 -- Purpose
34 -- Re-order the action lines and validate the advertisement
35 -- action set or advertisement action lines on a requirement.
36 -- Invoked when a new action set is created, an existing action
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 );
46
47
48 ----------------------------------------------------------------------
49 -- Procedure
50 -- Perform Advertisement Action Set Line
51 --
52 -- Purpose
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
62 , x_action_line_result_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63 );
64
65
66 ----------------------------------------------------------------------
67 -- Procedure
68 -- Reevaluate Advertisement Action Set
69 --
70 -- Purpose
71 -- Re-evaluate the advertisement action lines on the requirement by
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
81 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
82 , p_commit IN VARCHAR2 := FND_API.G_FALSE
83 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
84 );
85
86 ----------------------------------------------------------------------
87 -- Function
88 -- Is Action Set Started On Apply
89 --
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
99
100 END PA_ADVERTISEMENTS_PUB;