[Home] [Help]
PACKAGE: APPS.PA_ASGN_CONFLICT_HIST_PKG
Source
1 PACKAGE PA_ASGN_CONFLICT_HIST_PKG AUTHID CURRENT_USER as
2 /* $Header: PARGASNS.pls 120.1.12010000.2 2008/08/04 12:15:14 amehrotr ship $ */
3
4 --
5 -- Procedure : Insert_rows
6 -- Purpose : Create Rows in PA_ASSIGNMENT_CONFLICT_HIST.
7 --
8 PROCEDURE insert_rows
9 ( p_conflict_group_id IN Number := NULL ,
10 p_assignment_id IN Number ,
11 p_conflict_assignment_id IN Number ,
12 p_resolve_conflict_action_code IN VARCHAR2 ,
13 p_intra_txn_conflict_flag IN VARCHAR2 ,
14 p_processed_flag IN VARCHAR2 := 'N' ,
15 p_self_conflict_flag IN VARCHAR2 ,
16 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
17 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
18 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
19
20
21 --
22 -- Procedure : Insert_rows (Overloaded) for single transaction.
23 -- Purpose : Create Rows in PA_ASSIGNMENT_CONFLICT_HIST.
24 --
25 PROCEDURE insert_rows
26 ( p_conflict_group_id IN NUMBER := NULL ,
27 p_assignment_id IN NUMBER ,
28 p_conflict_assignment_id_tbl IN PA_PLSQL_DATATYPES.NumTabTyp ,
29 p_resolve_conflict_action_code IN VARCHAR2 ,
30 p_intra_txn_conflict_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE:=NULL,
31 p_processed_flag IN VARCHAR2 := 'N' ,
32 x_conflict_group_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
33 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
34 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
35 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
36
37
38 --
39 -- Procedure : update_rows (overloaded)
40 -- Purpose : Update rows in pa_assignment_conflict_hist with
41 -- p_resolve_conflict_action_code only. This is
42 -- overloaded procedure.
43 --
44 PROCEDURE update_rows
45 ( p_conflict_group_id IN Number ,
46 p_assignment_id IN Number ,
47 p_conflict_assignment_id IN Number ,
48 p_resolve_conflict_action_code IN VARCHAR2 ,
49 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
50 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
51 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
52
53
54 --
55 -- Procedure : update_rows (overloaded)
56 -- Purpose : Update rows in pa_assignment_conflict_hist with
57 -- p_resolve_conflict_action_code only for the whole
58 -- conflict group. This is overloaded procedure. This
59 -- is called from the Resource Overcommitment page.
60 PROCEDURE update_rows
61 ( p_conflict_group_id IN Number ,
62 p_resolve_conflict_action_code IN VARCHAR2 ,
63 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
64 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
65 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
66
67
68 --
69 -- Procedure : update_rows (overloaded)
70 -- Purpose : Update rows in pa_assignment_conflict_hist with
71 -- p_resolve_conflict_action_code only for the whole
72 -- conflict group. This is overloaded procedure. This
73 -- is called from the View Conflicts page.
74 PROCEDURE update_rows
75 ( p_conflict_group_id IN Number ,
76 p_assignment_id_arr IN SYSTEM.PA_NUM_TBL_TYPE ,
77 p_action_code_arr IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE ,
78 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
79 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
80 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
81
82
83 --
84 -- Procedure : update_rows (overloaded)
85 -- Purpose : Update rows in pa_assignment_conflict_hist with
86 -- p_processed_flag only. This is an overloaded
87 -- procedure.
88 --
89 PROCEDURE update_rows
90 ( p_conflict_group_id IN Number ,
91 p_assignment_id IN Number ,
92 p_processed_flag IN VARCHAR2 ,
93 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
94 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
95 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
96
97
98 --
99 -- Procedure : delete_rows
100 -- Purpose : Deletes rows in PA_ASSIGNMENT_CONFLICT_HIST.
101 --
102 PROCEDURE delete_rows
103 ( p_conflict_group_id IN NUMBER,
104 p_assignment_id IN NUMBER,
105 p_conflict_assignment_id IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
107 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
108 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
109
110 PROCEDURE delete_rows --bug 7118933
111 ( p_assignment_id IN NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2 );
115
116
117 END PA_ASGN_CONFLICT_HIST_PKG;