1 PACKAGE PO_STORE_TIMECARD_PKG_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGSTCS.pls 115.2 2004/04/23 19:35:05 jmojnida noship $ */
3
4
5 /*
6
7 */
8 g_cur_po_header_id number := null;
9
10 /*
11
12 */
13 g_cur_po_line_id number := null;
14
15 /*
16 This procedure initializes the global variables to null.
17 */
18 procedure initGlobals;
19
20 function isFirstOccurance(p_po_header_id number, p_po_line_id number)
21 return number;
22
23 -- Start of comments
24 -- API name : store_time_card_details
25 -- Type : Public
26 -- Pre-reqs : None.
27 -- Function : inserts, deletes or updates the given timecard details information.
28 -- Note: This API will not commit. It is the responsibility
29 -- of the calling program to commit or rollback. The
30 -- rollback should include the modifications done to
31 -- related tables like RCV_TRANSACTIONS_HDR also.
32 -- Parameters : IN
33 -- p_action : this parameter specifies the action to be carried out.
34 -- INSERT for inserting a new timecard details
35 -- UPDATE for updating --time, rate type, rate-- for existing rec
36 -- DELETE for deleting an existing record.
37 -- OUT
38 -- x_return_status : This parameter will have one of
39 -- FND_API.G_RET_STS_UNEXP_ERROR,
40 -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_SUCCESS.
41 -- The calling code should not commit if there is an error;
42 -- Commit otherwise.
43 -- Version : Initial version 1.0
44 --
45 -- End of comments
46
47 procedure store_timecard_details
48 (
49 p_api_version number,
50 x_return_status out NOCOPY varchar2,
51 x_msg_data out NOCOPY varchar2,
52 p_vendor_id number,
53 p_vendor_site_id number,
54 p_vendor_contact_id number,
55 p_po_num varchar2,
56 p_po_line_number number,
57 p_org_id number,
58 p_project_id number,
59 p_task_id number,
60 p_tc_id number, --building_block_id for timecards
61 p_tc_day_id number, --building_block_id for timecard days
62 p_tc_detail_id number, -- building_block_id for details
63 p_tc_uom varchar2, --mostly Hours
64 p_tc_Start_date date, --Timecard start date
65 p_tc_end_date date, --Timecard end date
66 p_tc_entry_date date, --date the worker worked
67 p_tc_time_received number, --number of hours worked
68 p_tc_approval_status varchar2,
69 p_tc_approval_date date,
70 p_tc_submission_date date,
71 p_contingent_worker_id number, --worker id
72 p_tc_comment_text varchar2, --tc comment
73 p_line_rate_type varchar2, -- Regular, Overtime
74 p_line_rate number,
75 p_action VARCHAR2,
76 p_interface_transaction_id number
77
78 );
79
80
81 -- Start of comments
82 -- API name : reconcile_actions
83 -- Type : Public
84 -- Pre-reqs : None.
85 -- Function : inserts, deletes or updates the given timecard details information.
86 -- Note: This API will not commit. It is the responsibility
87 -- of the calling program to commit or rollback. The
88 -- rollback should include the modifications done to
89 -- related tables like RCV_TRANSACTIONS_HDR also.
90 -- Parameters : OUT
91 -- x_return_status : This parameter will have one of
92 -- FND_API.G_RET_STS_UNEXP_ERROR,
93 -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_SUCCESS.
94 -- The calling code should not commit if there is an error;
95 -- Commit otherwise.
96 -- Version : Initial version 1.0
97 --
98 -- End of comments
99
100
101
102 procedure reconcile_actions (p_api_version number,
103 x_return_status out NOCOPY varchar2,
104 x_msg_data out NOCOPY varchar2
105 );
106
107
108
109 --For details see the comments above.
110
111 procedure store_timecard_details_rec (p_api_version number,
112 x_return_status out NOCOPY varchar2,
113 x_msg_data out NOCOPY varchar2,
114 p_rtrvd_tc PO_RTRVD_TC_REC,
115 p_action VARCHAR2
116 );
117
118
119
120
121 --If there are errors, the procedure tries to loop through all the elements
122 -- and collect all the errors before returning. The errors are in x_errs.
123 /* Does not work with 8i.
124 procedure store_timecard_details_bulk (p_api_version number,
125 x_return_status out NOCOPY varchar2,
126 --if x_msg_data is empty (''), then look at x_errs.
127 x_msg_data out NOCOPY varchar2,
128 p_rtrvd_tcs PO_RTRVD_TCS_REC,
129 p_action VARCHAR2,
130 x_errs out NOCOPY PO_RTRVD_TCS_ERR_REC);
131 */
132 end PO_STORE_TIMECARD_PKG_GRP;