1 PACKAGE PO_HXC_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVIHXS.pls 120.2 2007/12/24 16:09:42 cvardia ship $*/
3
4 -- Constants used when calling the OTL APIs:
5 g_bld_blk_info_type_PO CONSTANT VARCHAR2(20) := 'PURCHASING';
6 g_bld_blk_info_type_PA CONSTANT VARCHAR2(20) := 'PROJECTS';
7 g_scope_DETAIL CONSTANT VARCHAR2(20) := 'DETAIL';
8 g_retrieval_process_NONE CONSTANT VARCHAR2(20) := 'None';
9 g_field_AMOUNT CONSTANT VARCHAR2(20) := 'PO Billable Amount';
10 g_field_PO_HEADER_ID CONSTANT VARCHAR2(20) := 'PO Header Id';
11 g_field_PO_LINE_ID CONSTANT VARCHAR2(20) := 'PO Line Id';
12 g_field_TASK_ID CONSTANT VARCHAR2(20) := 'Task_Id';
13 g_field_PROJECT_ID CONSTANT VARCHAR2(20) := 'Project_Id';
14 g_status_SUBMITTED CONSTANT VARCHAR2(20) := 'SUBMITTED';
15
16 -- Functions to return the constants, for use from PLDs:
17 FUNCTION field_po_header_id RETURN VARCHAR2;
18 FUNCTION field_po_line_id RETURN VARCHAR2;
19
20 -- See the package body for a detailed description of this function.
21 FUNCTION check_timecard_exists (
22 p_person_id IN NUMBER,
23 po_line_id IN NUMBER)
24 RETURN VARCHAR2;
25
26
27 -- See the package body for a detailed description of this procedure.
28 PROCEDURE get_timecard_amount (
29 p_api_version IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
32 x_amount OUT NOCOPY NUMBER
33 );
34
35 -- See the package body for a detailed description of this procedure.
36 PROCEDURE check_timecard_exists (
37 p_api_version IN NUMBER,
38 x_return_status OUT NOCOPY VARCHAR2,
39 p_field_name IN VARCHAR2,
40 p_field_value IN VARCHAR2,
41 p_end_date IN PO_LINES_ALL.expiration_date%TYPE,
42 x_timecard_exists OUT NOCOPY BOOLEAN
43 );
44
45 PROCEDURE get_pa_timecard_amount (
46 p_api_version IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
49 p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE ,
50 p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE,
51 x_amount OUT NOCOPY NUMBER);
52
53 END PO_HXC_INTERFACE_PVT;