1 PACKAGE PA_CAP_INT_PVT AS
2 -- $Header: PACINTTS.pls 120.1 2005/08/17 12:56:11 ramurthy noship $
3
4 /*
5 This package contains the procedures and functions required to process Capitalized
6 Interest. The functions performed are:
7
8 Generation of Capitalized Interest (concurrent request)
9 Generation and Auto-Release of Capitalized Interest (concurrent request)
10 Release of Capitalized Interest (from form button)
11 Purge of Capitalized Interest Source Details (concurrent request)
12
13 When the main procedure, GENERATE_CAP_INTEREST, is called from an Oracle Report, the
14 following parameters are used:
15
16 p_from_project_num => Low project to calculate (NULL if no lower bound)
17 p_to_project_num => High project to calculate (NULL if no higher bound)
18 p_gl_period => GL Period for the calculated interest (required)
19 p_exp_item_date => Expenditure Item Date for the calculated interest (required)
20 p_source_details => Y = create source details
21 p_autorelease => Y = auto-release each run batch
22
23 All interest rates setup for the submitter's M/O ORG_ID that exist in schedules associated
24 with projects between the parameter project numbers will be processed. Each rate processed
25 will create a single run row. If any problem are encountered on a project, no transactions
26 for that project will be created. A project can only be successfully processed once per
27 month. Summarized control numbers are reported on the log while the calling report shows
28 more detailed results.
29
30 If the release of a Capitalized Interest run is requested from the form, the run_id is
31 passed to the GENERATE_CAP_INTEREST procedure through a parameter.
32
33 When the main procedure, PURGE_SOURCE_DETAIL, is called from an Oracle Report, the
34 following parameters are used:
35 p_gl_period => GL Period for the source details (required)
36 p_from_project_num => Low project to calculate (NULL if no lower bound)
37 p_to_project_num => High project to calculate (NULL if no higher bound)
38
39 The source details from the earliest period through the parameter GL period that belong
40 to projects between the parameter project numbers will be purged. Summarized control
41 numbers are reported on the log while the calling report shows more detailed results.
42
43 */
44 PROCEDURE generate_cap_interest
45 (p_from_project_num IN VARCHAR2 DEFAULT NULL
46 ,p_to_project_num IN VARCHAR2 DEFAULT NULL
47 ,p_gl_period IN VARCHAR2
48 ,p_exp_item_date IN DATE
49 ,p_source_details IN VARCHAR2 DEFAULT 'N'
50 ,p_autorelease IN VARCHAR2 DEFAULT 'N'
51 ,p_mode IN VARCHAR2 DEFAULT 'G'
52 ,x_run_id IN OUT NOCOPY NUMBER
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_error_msg_count OUT NOCOPY NUMBER
55 ,x_error_msg_code OUT NOCOPY VARCHAR2);
56
57
58 PROCEDURE purge_source_detail
59 (p_gl_period IN VARCHAR2
60 ,p_from_project_num IN VARCHAR2 DEFAULT NULL
61 ,p_to_project_num IN VARCHAR2 DEFAULT NULL
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_error_msg_count OUT NOCOPY NUMBER
64 ,x_error_msg_code OUT NOCOPY VARCHAR2);
65
66
67 FUNCTION exclude_expenditure_type
68 (p_exp_type IN VARCHAR2
69 ,p_rate_name IN VARCHAR2
70 ,p_interest_calc_method IN VARCHAR2)
71 RETURN VARCHAR2;
72
73
74 FUNCTION cdl_status
75 (p_cutoff_date IN DATE
76 ,p_expenditure_item_id IN NUMBER
77 ,p_line_num IN NUMBER)
78 RETURN VARCHAR2;
79
80
81 FUNCTION task_capital_flag
82 (p_project_id IN NUMBER
83 ,p_task_id IN NUMBER
84 ,p_task_bill_flag IN VARCHAR2)
85 RETURN VARCHAR2;
86
87 FUNCTION gl_period RETURN VARCHAR2;
88
89 FUNCTION period_end_date RETURN DATE;
90
91 FUNCTION project_id RETURN NUMBER;
92
93 FUNCTION rate_name RETURN VARCHAR2;
94
95
96 END PA_CAP_INT_PVT;
[Home] [Help]