[Home] [Help]
PACKAGE: APPS.PQP_GDS_API
Source
1 Package pqp_gds_api as
2 /* $Header: pqgdsapi.pkh 120.0 2005/10/28 07:31 rvishwan noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_duration_summary >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31
32
33
34
35 --
36 procedure create_duration_summary
37 (p_validate IN BOOLEAN DEFAULT FALSE
38 ,p_date_start IN DATE
39 ,p_date_end IN DATE
40 ,p_assignment_id IN NUMBER
41 ,p_gap_absence_plan_id IN NUMBER
42 ,p_duration_in_days IN NUMBER
43 ,p_duration_in_hours IN NUMBER
44 ,p_summary_type IN VARCHAR2
45 ,p_gap_level IN VARCHAR2
46 ,p_gap_duration_summary_id OUT NOCOPY NUMBER
47 ,p_object_version_number OUT NOCOPY NUMBER
48 );
49 --
50 --
51 -- ----------------------------------------------------------------------------
52 -- |--------------------------< update_duration_summary >------------------|
53 -- ----------------------------------------------------------------------------
54 -- {Start Of Comments}
55 --
56 -- Description:
57 --
58 --
59 -- Prerequisites:
60 --
61 --
62 -- In Parameters:
63 -- Name Reqd Type Description
64 --
65 --
66 -- Post Success:
67 --
68 --
69 -- Name Type Description
70 --
71 -- Post Failure:
72 --
73 --
74 -- Access Status:
75 -- Public.
76 --
77 -- {End Of Comments}
78 --
79 procedure update_duration_summary
80 (p_validate IN BOOLEAN DEFAULT FALSE
81 ,p_gap_duration_summary_id IN NUMBER
82 ,p_date_start IN DATE
83 ,p_date_end IN DATE
84 ,p_assignment_id IN NUMBER
85 ,p_gap_absence_plan_id IN NUMBER
86 ,p_duration_in_days IN NUMBER
87 ,p_duration_in_hours IN NUMBER
88 ,p_summary_type IN VARCHAR2
89 ,p_gap_level IN VARCHAR2
90 ,p_object_version_number IN OUT NOCOPY NUMBER
91 );
92 --
93 --
94 -- ----------------------------------------------------------------------------
95 -- |--------------------------< delete_duration_summary >--------------------------|
96 -- ----------------------------------------------------------------------------
97 -- {Start Of Comments}
98 --
99 -- Description:
100 --
101 --
102 -- Prerequisites:
103 --
104 --
105 -- In Parameters:
106 -- Name Reqd Type Description
107 --
108 --
109 -- Post Success:
110 --
111 --
112 -- Name Type Description
113 --
114 -- Post Failure:
115 --
116 --
117 -- Access Status:
118 -- Public.
119 --
120 -- {End Of Comments}
121 --
122 procedure delete_duration_summary
123 (p_validate IN BOOLEAN DEFAULT FALSE
124 ,p_gap_duration_summary_id IN NUMBER
125 ,p_object_version_number IN NUMBER
126 );
127 --
128 end pqp_gds_api;