[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_EXPDIST_PKG
Source
1 PACKAGE AP_WEB_DB_EXPDIST_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdbeds.pls 120.6.12010000.3 2009/11/19 09:26:03 rveliche ship $ */
3
4 --------------------------------------------------------------------------------------------------
5 SUBTYPE expDist_REPORT_HEADER_ID IS AP_EXP_REPORT_DISTS.REPORT_HEADER_ID%TYPE;
6 SUBTYPE expDist_REPORT_LINE_ID IS AP_EXP_REPORT_DISTS.REPORT_LINE_ID%TYPE;
7 SUBTYPE expDist_REPORT_DISTRIBUTION_ID IS AP_EXP_REPORT_DISTS.REPORT_DISTRIBUTION_ID%TYPE;
8 SUBTYPE expDist_ORG_ID IS AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
9 SUBTYPE expDist_SEQUENCE_NUM IS AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
10 SUBTYPE expDist_LAST_UPDATE_DATE IS AP_EXP_REPORT_DISTS.LAST_UPDATE_DATE%TYPE;
11 SUBTYPE expDist_LAST_UPDATED_BY IS AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
12 SUBTYPE expDist_CREATION_DATE IS AP_EXP_REPORT_DISTS.CREATION_DATE%TYPE;
13 SUBTYPE expDist_CREATED_BY IS AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
14 SUBTYPE expDist_LAST_UPDATE_LOGIN IS AP_EXP_REPORT_DISTS.LAST_UPDATE_LOGIN%TYPE;
15 SUBTYPE expDist_CODE_COMBINATION_ID IS AP_EXP_REPORT_DISTS.CODE_COMBINATION_ID%TYPE;
16 SUBTYPE expDist_SEGMENT1 IS AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
17 SUBTYPE expDist_SEGMENT2 IS AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
18 SUBTYPE expDist_SEGMENT3 IS AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
19 SUBTYPE expDist_SEGMENT4 IS AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
20 SUBTYPE expDist_SEGMENT5 IS AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
21 SUBTYPE expDist_SEGMENT6 IS AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
22 SUBTYPE expDist_SEGMENT7 IS AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
23 SUBTYPE expDist_SEGMENT8 IS AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
24 SUBTYPE expDist_SEGMENT9 IS AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
25 SUBTYPE expDist_SEGMENT10 IS AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
26 SUBTYPE expDist_SEGMENT11 IS AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
27 SUBTYPE expDist_SEGMENT12 IS AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
28 SUBTYPE expDist_SEGMENT13 IS AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
29 SUBTYPE expDist_SEGMENT14 IS AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
30 SUBTYPE expDist_SEGMENT15 IS AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
31 SUBTYPE expDist_SEGMENT16 IS AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
32 SUBTYPE expDist_SEGMENT17 IS AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
33 SUBTYPE expDist_SEGMENT18 IS AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
34 SUBTYPE expDist_SEGMENT19 IS AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
35 SUBTYPE expDist_SEGMENT20 IS AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
36 SUBTYPE expDist_SEGMENT21 IS AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
37 SUBTYPE expDist_SEGMENT22 IS AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
38 SUBTYPE expDist_SEGMENT23 IS AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
39 SUBTYPE expDist_SEGMENT24 IS AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
40 SUBTYPE expDist_SEGMENT25 IS AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
41 SUBTYPE expDist_SEGMENT26 IS AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
42 SUBTYPE expDist_SEGMENT27 IS AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
43 SUBTYPE expDist_SEGMENT28 IS AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
44 SUBTYPE expDist_SEGMENT29 IS AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
45 SUBTYPE expDist_SEGMENT30 IS AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
46
47
48 --------------------------------------------------------------------------------
49
50 FUNCTION foundCCID(p_report_distribution_id IN expDist_REPORT_DISTRIBUTION_ID,
51 x_line_ccid OUT NOCOPY expDist_CODE_COMBINATION_ID)
52 RETURN BOOLEAN;
53 --------------------------------------------------------------------------------
54
55 FUNCTION foundDistributions(p_report_distribution_id IN expDist_REPORT_DISTRIBUTION_ID)
56 RETURN BOOLEAN;
57 --------------------------------------------------------------------------------
58 FUNCTION SetDistCCID(
59 p_report_header_id IN expDist_REPORT_HEADER_ID,
60 p_report_line_id IN expDist_REPORT_LINE_ID,
61 p_exp_line_ccid IN expDist_CODE_COMBINATION_ID)
62 RETURN BOOLEAN;
63 --------------------------------------------------------------------------------
64 --------------------------------------------------------------------------------------------
65 FUNCTION UpdateDistCCID(
66 p_report_header_id IN expDist_REPORT_HEADER_ID,
67 p_report_distribution_id IN expDist_REPORT_DISTRIBUTION_ID,
68 p_exp_dist_ccid IN expDist_CODE_COMBINATION_ID
69 ) RETURN BOOLEAN;
70 --------------------------------------------------------------------------------------------
71
72
73 -------------------------------------------------------------------
74 -- Name: DeleteReportDistributions
75 -- Desc: Deletes Expense Report Distributions associated with a report
76 -- Input: p_report_id - expense report header id
77 --------------------------------------------------------------------------------------------
78 PROCEDURE DeleteReportDistributions(P_ReportID IN expDist_report_header_ID);
79 --------------------------------------------------------------------------------------------
80
81 -------------------------------------------------------------------
82 -- Name: MoveDistributions
83 -- Desc: moves Expense Report Distributions from souce to destination
84 -- Input: p_target_report_header_id - target expense report header id
85 -- Input: p_source_report_line_id - source expense report line id
86 -- Input: p_target_report_line_id - target expense report line id
87 -------------------------------------------------------------------
88 PROCEDURE MoveDistributions(
89 p_target_report_header_id IN expDist_report_header_ID,
90 p_source_report_line_id IN expDist_report_line_ID,
91 p_target_report_line_id IN expDist_report_line_ID);
92
93 -------------------------------------------------------------------
94 -- Name: DuplicateDistributions
95 -- Desc: duplicates Expense Report Distributions
96 -- Input: p_target_report_header_id - target expense report header id
97 -- Input: p_source_report_line_id - source expense report line id
98 -- Input: p_target_report_line_id - target expense report line id
99 -------------------------------------------------------------------
100 PROCEDURE DuplicateDistributions(
101 p_user_id IN NUMBER,
102 p_target_report_header_id IN expDist_report_header_ID,
103 p_source_report_line_id IN expDist_report_line_ID,
104 p_target_report_line_id IN expDist_report_line_ID);
105
106 --------------------------------------------------------------------------------
107 PROCEDURE updateDistAccountValues(
108 p_report_header_id IN expDist_report_header_ID);
109 --------------------------------------------------------------------------------
110 PROCEDURE updateDistAcctValuesForForms(
111 p_report_header_id IN expDist_report_header_ID);
112 --------------------------------------------------------------------------------
113 PROCEDURE updateAccountValues(
114 p_report_header_id IN expDist_report_header_ID,
115 p_report_line_id IN expDist_REPORT_LINE_ID,
116 p_report_distribution_id IN expDist_REPORT_DISTRIBUTION_ID,
117 p_ccid IN expDist_CODE_COMBINATION_ID);
118 --------------------------------------------------------------------------------
119 PROCEDURE AddDistributionLine(
120 p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE);
121 --------------------------------------------------------------------------------
122 PROCEDURE AddDistributionLine(
123 p_segments IN AP_OIE_KFF_SEGMENTS_T,
124 p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE,
125 p_chart_of_accounts_id IN NUMBER);
126
127 --------------------------------------------------------------------------------
128
129 --------------------------------------------------------------------------------
130 FUNCTION ContainsProjectRelatedDist(
131 p_report_header_id IN expDist_report_header_ID
132 ) RETURN BOOLEAN;
133
134
135 --------------------------------------------------------------------------------
136 FUNCTION ContainsNonProjectRelatedDist(
137 p_report_header_id IN expDist_report_header_ID
138 ) RETURN BOOLEAN;
139 --------------------------------------------------------------------------------
140
141 --------------------------------------------------------------------------------
142 PROCEDURE ResplitDistAmounts(p_report_line_id IN NUMBER,
143 p_line_amt IN NUMBER,
144 p_currency_code IN VARCHAR2);
145 --------------------------------------------------------------------------------
146
147 --------------------------------------------------------------------------------
148 FUNCTION GetCCSegmentValue(p_ccid IN expDist_CODE_COMBINATION_ID) RETURN VARCHAR2;
149 --------------------------------------------------------------------------------
150
151 END AP_WEB_DB_EXPDIST_PKG;