1 PACKAGE PO_GMS_INTEGRATION_PVT AS
2 /* $Header: POXVGMSS.pls 120.1 2005/08/31 16:24:37 jmellen noship $ */
3
4 c_DML_OPERATION_INSERT CONSTANT VARCHAR2(10) := 'INSERT';
5 c_DML_OPERATION_DELETE CONSTANT VARCHAR2(10) := 'DELETE';
6 c_DML_OPERATION_UPDATE CONSTANT VARCHAR2(10) := 'UPDATE';
7
8 -------------------------------------------------------------------------------
9 --Start of Comments
10 --Name: maintain_adl (ADL stands for Award Distribution Lines in Grants)
11 --Pre-reqs:
12 -- None.
13 --Modifies:
14 -- GMS_AWARD_DISTRIBUTIONS
15 --Locks:
16 -- None.
17 --Function:
18 -- When PO/Req distribution lines are created from CopyDoc, Autocreate,
19 -- PO Release Process, or Change PO, we need to call Grants API to generate
20 -- new award distribution lines if the parent distribution record
21 -- references an award.
22 --Parameters:
23 --IN:
24 --p_api_version
25 -- Specifies the GMS API version.
26 --p_caller
27 -- Specifies who the caller is.
28 -- Possible values for p_caller are:
29 -- AUTOCREATE, CHANGEPO, COPYDOC, CREATE_RELEASE
30 --OUT:
31 --x_return_status
32 -- Represents the result returned by the GMS API and
33 -- will have one of the following values:
34 -- G_RET_STS_SUCCESS = 'S'
35 -- G_RET_STS_ERROR = 'E'
36 -- G_RET_STS_UNEXP_ERROR= 'U'
37 --x_msg_count
38 -- Holds the number of messages in the GMS API message list.
39 --x_msg_data
40 -- Holds the error messages returned by the GMS API.
41 --IN OUT
42 --x_po_gms_interface_obj
43 -- Is of type gms_po_interface_type.
44 -- gms_po_interface_type is a SQL object having the following table
45 -- elements:
46 -- distribution_id Holds distribution id's
47 -- distribution_num Holds distribution numbers
48 -- project_id Holds project id's
49 -- task_id Holds task id's
50 -- award_set_id_in Holds award set id references
51 -- award_set_id_out Holds new award distribution line references
52 -- as returned by GMS API's.
53 --Testing:
54 -- None
55 --End of Comments
56 -------------------------------------------------------------------------------
57
58 PROCEDURE maintain_adl (
59 p_api_version IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_caller IN VARCHAR2,
64 x_po_gms_interface_obj IN OUT NOCOPY gms_po_interface_type
65 );
66
67 FUNCTION get_gms_enabled_flag(
68 p_org_id IN NUMBER
69 ) RETURN VARCHAR2;
70
71 FUNCTION is_gms_enabled
72 RETURN BOOLEAN;
73
74 PROCEDURE validate_award_data(
75 p_dist_id_tbl IN PO_TBL_NUMBER
76 , p_project_id_tbl IN PO_TBL_NUMBER
77 , p_task_id_tbl IN PO_TBL_NUMBER
78 , p_award_number_tbl IN PO_TBL_VARCHAR2000
79 , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
80 , p_expenditure_item_date_tbl IN PO_TBL_DATE
81 , x_failure_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER
82 , x_failure_message_tbl OUT NOCOPY PO_TBL_VARCHAR4000
83 );
84
85 PROCEDURE get_award_id(
86 p_award_number_tbl IN PO_TBL_VARCHAR2000
87 , x_award_id_tbl OUT NOCOPY PO_TBL_NUMBER
88 );
89
90 PROCEDURE maintain_po_adl(
91 p_dml_operation IN VARCHAR2
92 , p_dist_id IN NUMBER
93 , p_award_number IN VARCHAR2
94 , p_project_id IN NUMBER
95 , p_task_id IN NUMBER
96 , x_award_set_id OUT NOCOPY NUMBER
97 );
98
99 FUNCTION get_number_from_award_set_id(
100 p_award_set_id IN NUMBER
101 ) RETURN VARCHAR2;
102
103 PROCEDURE is_award_required_for_project(
104 p_project_id IN NUMBER
105 , x_award_required_flag OUT NOCOPY VARCHAR2
106 );
107
108 END PO_GMS_INTEGRATION_PVT;