1 PACKAGE IGC_CC_ARCHIVE_PURGE_PKG AS
2 /* $Header: IGCCAPRS.pls 120.3.12000000.4 2007/10/08 05:59:47 smannava ship $ */
3
4 /* ------------------------------------------------------------------------- */
5 /* */
6 /* Archive Purge API for CC whenever there is a request to purge off the */
7 /* Periods that are closed for a fiscal year. */
8 /* Funds Reservation need to be performed. */
9 /* */
10 /* This routine returns SUCCESS or FAILURE. */
11 /* */
12 /* In case of failure, this routine will populate the global Message Stack */
13 /* using FND_MESSAGE. The calling routine will retrieve the message from */
14 /* the Stack */
15 /* */
16 /* External Packages which are being invoked include : */
17 /* */
18 /* FND_MSG_PUB.Check_Msg_Level */
19 /* FND_MSG_PUB.Add_Exc_Msg */
20 /* */
21 /* PO Tables which are being used include : */
22 /* */
23 /* PO_HEADERS_ALL */
24 /* PO_LINES_ALL */
25 /* PO_DISTRIBUTIONS_ALL */
26 /* PO_LINE_LOCATIONS_ALL */
27 /* */
28 /* IGC Tables which are being used include : */
29 /* */
30 /* IGC_CC_ACTIONS */
31 /* IGC_CC_HEADERS */
32 /* IGC_CC_HEADER_HISTORY */
33 /* IGC_CC_ACCT_LINES */
34 /* IGC_CC_ACCT_LINE_HISTORY */
35 /* IGC_CC_DET_PF */
36 /* IGC_CC_DET_PF_HISTORY */
37 /* IGC_CC_MC_HEADERS */
38 /* IGC_CC_MC_HEADER_HISTORY */
39 /* IGC_CC_MC_ACCT_LINES */
40 /* IGC_CC_MC_ACCT_LINE_HISTORY */
41 /* IGC_CC_MC_DET_PF */
42 /* IGC_CC_MC_DET_PF_HISTORY */
43 /* IGC_CC_ARCHIVE_HISTORY */
44 /* IGC_CC_ARC_ACTIONS */
45 /* IGC_CC_ARC_HEADERS */
46 /* IGC_CC_ARC_HEADER_HIST */
47 /* IGC_CC_ARC_ACCT_LINES */
48 /* IGC_CC_ARC_ACCT_LINE_HIST */
49 /* IGC_CC_ARC_DET_PF */
50 /* IGC_CC_ARC_DET_PF_HIST */
51 /* IGC_CC_ARC_MC_HEADERS */
52 /* IGC_CC_ARC_MC_HEADER_HIST */
53 /* IGC_CC_ARC_MC_ACCT_LINES */
54 /* IGC_CC_ARC_MC_ACCT_LINE_HIST */
55 /* IGC_CC_ARC_MC_DET_PF */
56 /* IGC_CC_ARC_MC_DET_PF_HIST */
57 /* */
58 /* ------------------------------------------------------------------------- */
59
60 --
61 -- Main Procedure for Archiving and Purging the CBC tables
62 --
63 -- Parameters :
64 --
65 -- errbuf ==> Error msg buffer returned
66 -- retcode ==> Return status code.
67 -- p_req_last_activity_date ==> last date record activity took place
68 -- p_req_mode ==> Archive ("AR"), Pre-Purge ("PP"), Purge ("PU")
69 -- p_req_commit_work ==> Boolean indicating if this process should commit work or not
70 --
71
72 PROCEDURE Archive_Purge_CC_Request
73 (
74 errbuf OUT NOCOPY VARCHAR2,
75 retcode OUT NOCOPY NUMBER,
76 p_req_mode IN VARCHAR2,
77 p_req_last_activity_date IN VARCHAR2
78 );
79
80
81 --
82 -- Function designed to return the current global value for the SET_OF_BOOKS_ID
83 -- in the package as being run
84 --
85 -- Parameters :
86 --
87 -- None
88 --
89
90 FUNCTION Get_SOB_ID RETURN NUMBER;
91
92
93 --
94 -- Function designed to return the current global value for the ORG_ID
95 -- in the package as being run
96 --
97 -- Parameters :
98 --
99 -- None
100 --
101
102 FUNCTION Get_ORG_ID RETURN NUMBER;
103
104
105 --
106 -- Function designed to return the current global value for the LAST_ACTIVITY_DATE
107 -- that the user input for the package to be run with
108 --
109 -- Parameters :
110 --
111 -- None
112 --
113
114 FUNCTION Get_Last_Activity_Date RETURN DATE;
115
116 END IGC_CC_ARCHIVE_PURGE_PKG;
117