1 PACKAGE PO_LINK_REQ_DIST_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_LINK_REQ_DIST_PVT.pls 120.3.12020000.2 2013/02/10 12:06:21 vegajula ship $ */
3
4 C_RESULT_TYPE_FATAL CONSTANT VARCHAR2(30) := 'FATAL';
5 C_RESULT_TYPE_FAILURE CONSTANT VARCHAR2(30) := 'FAILURE';
6 C_RESULT_TYPE_WARNING CONSTANT VARCHAR2(30) := 'WARNING';
7 C_RESULT_TYPE_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
8
9 --START OF COMMENTS
10 --NAME: CREATE_LINK_REQ_DIST_GT
11 --PRE-REQS:
12 -- NONE.
13 --MODIFIES:
14 -- NONE.
15 --LOCKS:
16 -- NONE.
17 --FUNCTION:
18 -- IT CREATES(DEFAULTS) THE NEW DISTRIBUTIONS FOR THE SELECTED SCHEDULES AND THE REQUISITIONS AND CALCULATES THE DEFAULT VALUES, UPDATES THE
19 -- DISTRIBUTION NUMBER
20 --PARAMETERS:
21 --IN:
22 --P_TOTAL_DIST_AMT_REQUIRED
23 -- TOTAL DISTRIBUTION AMOUNT REQUIRED FROM THE SCHEDULES
24 --P_TOTAL_FUNDS_TO_USE
25 -- TOTAL FUNDS TO USE FROM REQUISITIONS
26 --P_LINK_REQ_DIST_FU_TBL
27 -- COMBINATION OF DISTRIBUTION ID AND THE FUNDS TO USE FOR SELECTED REQUISITIONS DISTRIBUTIONS
28 --IN OUT:
29 --X_RESULT
30 -- SUCCESS FAILURE RESPONSE
31 --X_ERROR_MESSAGE
32 -- ERROR MESSAGE
33 --TESTING:
34 -- NONE.
35 --END OF COMMENTS
36
37 PROCEDURE CREATE_LINK_REQ_DIST_GT
38 (
39 -- STANDARD API PARAMS
40 P_API_VERSION IN NUMBER,
41 -- INPUT PARAMS
42 P_TOTAL_DIST_AMT_REQUIRED IN NUMBER,
43 P_TOTAL_FUNDS_TO_USE IN NUMBER,
44 -- TABLE PARAMS IN
45 X_RESULT IN OUT NOCOPY NUMBER,
46 X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
47 P_LINK_REQ_DIST_FU_TBL IN OUT NOCOPY PO_LINK_REQ_DIST_FU_TAB
48 -- SOME MORE INPUT PARAMS
49 );
50
51
52 --START OF COMMENTS
53 --NAME: CREATE_AND_VAL_LINKED_REQ_DIST
54 --PRE-REQS:
55 -- NONE.
56 --MODIFIES:
57 -- NONE.
58 --LOCKS:
59 -- NONE.
60 --FUNCTION:
61 -- IT VALIDATES THE NEW DISTRIBUTIONS FOR CALCULATED VALUES, QUANTITY, DISTRIBUTION AMOUNT, FUNDED VALUE,
62 -- WITH THE SPECIFIC SOURCE REQUISITION IT WAS CREATED. ON SUCCESSFULL VALIDATION IT WILL MERGER(MOVE) THE NEWLY CREATED DISTRIBUTIONS INTO
63 -- PO_DISTRIBUTIONS_ALL OR PO_DISTRIBUTIONS_DRAFT_ALL BASED ON THE DRAFT ID. THEN UPDATES THE VALUES, LIKE AWARD, CALIBRATE QUANTITY/AMOUNT, CALCULATE LOCAL
64 -- AND DEFAULTS ACRN VALUES.
65 --PARAMETERS:
66 --IN:
67 --X_RESULTS
68 -- HOLDS THE VALIDATION MESSAGES
69 --OUT:
70 --X_RESULT_TYPE
71 -- RETURNS THE SUCCESS FAILURE STATUS
72 --TESTING:
73 -- NONE.
74 --END OF COMMENTS
75
76 PROCEDURE CREATE_AND_VAL_LINKED_REQ_DIST
77 (
78 -- STANDARD API PARAMS
79 X_RESULT_TYPE OUT NOCOPY VARCHAR2,
80 X_RESULTS IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
81
82 );
83
84
85 FUNCTION GET_GL_DATE(p_gl_date DATE, p_sob_id NUMBER) RETURN DATE;
86
87 FUNCTION GET_GL_PERIOD_NAME RETURN VARCHAR2;
88
89
90 END PO_LINK_REQ_DIST_PVT;