4 ExpOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
1 PACKAGE PA_CC_IDENT
2 -- $Header: PACCINTS.pls 120.1.12020000.3 2012/10/05 10:41:57 bdixit ship $ |
3 AS
5 ExpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6 ProjectIdTab PA_PLSQL_DATATYPES.IdTabTyp;
7 TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
8 ExpItemDateTab PA_PLSQL_DATATYPES.DateTabTyp;
9 ExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
10 ExpTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
11 SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
12 PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
13 PrjOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
14 PrjorgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
15 TransSourceTab PA_PLSQL_DATATYPES.Char30TabTyp;
16 NLROrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
17 PrvdrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
18 RecvrLEIdTab PA_PLSQL_DATATYPES.IdTabTyp;
19 CrossChargeCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
20 CrossChargeTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
21 PrvdrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
22 RecvrOrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
23 PrvdrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
24 RecvrOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
25 ErrorStageTab PA_PLSQL_DATATYPES.Char150TabTyp;
26 ErrorCodeTab PA_PLSQL_DATATYPES.Char150TabTyp;
30 -- to bug# 951161 currently we are createing this table with
27 AcctRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
28 --
29 -- AcctRateDateTab is supposed to be of datatype data. But due
31 -- datatype varchar2.
32 --
33 AcctRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
34 AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
35 AcctRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
36 ProjRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
37 --
38 -- ProjRateDateTab is supposed to be of datatype data. But due
39 -- to bug# 951161 currently we are createing this table with
40 -- datatype varchar2.
41 --
42 ProjRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
43 ProjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
44 ProjRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
45 /** EPP **/
46 ProjFuncRawCostTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
47 ProjFuncRateDateTab PA_PLSQL_DATATYPES.Char30TabTyp;
48 ProjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
49 ProjFuncRateTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
50 /** EPP **/
51 -- StageTab PA_PLSQL_DATATYPES.NewAmtTabTyp;
52 DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
53 StatusTab PA_PLSQL_DATATYPES.Char30TabTyp;
54
55
56 PROCEDURE PA_CC_IDENTIFY_TXN_FI(
57 P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
58 P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
59 P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
60 P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
61 P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
62 P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
63 P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
64 P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
65 P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
66 P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
67 P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
68 P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
69 P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
70 P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
71 P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
72 /* Added nocopy for 2672653 */
73 X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
74 X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
75 X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
76 X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
77 X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
78 X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
79 X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
80 X_Error_Stage OUT NOCOPY VARCHAR2,
81 X_Error_Code OUT NOCOPY NUMBER);
82
83 PROCEDURE PA_CC_IDENTIFY_TXN_ADJ (
84 P_ExpOrganizationId IN NUMBER,
85 P_ExpOrgid IN NUMBER,
86 P_ProjectId IN NUMBER,
87 P_TaskId IN NUMBER,
88 P_ExpItemDate IN DATE,
89 P_ExpItemId IN NUMBER,
90 P_ExpType IN VARCHAR2,
91 P_PersonId IN NUMBER,
92 P_SysLink IN VARCHAR2,
93 P_PrjOrganizationId IN NUMBER,
94 P_PrjOrgId IN NUMBER,
95 P_TransSource IN VARCHAR2,
96 P_NLROrganizationId IN NUMBER,
97 P_PrvdrLEId IN NUMBER,
98 P_RecvrLEId IN NUMBER,
99 X_Status IN OUT NOCOPY VARCHAR2,
100 X_CrossChargeType IN OUT NOCOPY VARCHAR2,
101 X_CrossChargeCode IN OUT NOCOPY VARCHAR2,
102 X_PrvdrOrganizationId IN OUT NOCOPY NUMBER,
103 X_RecvrOrganizationId IN OUT NOCOPY NUMBER,
104 X_RecvrOrgId IN OUT NOCOPY NUMBER,
105 X_Error_Stage OUT NOCOPY VARCHAR2,
106 X_Error_Code OUT NOCOPY NUMBER,
107 /* Added calling module for 3234973 */
108 X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
109
110 PROCEDURE PA_CC_IDENTIFY_TXN(
111 P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
112 P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
113 P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
114 P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
115 P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
116 P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
117 P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
118 P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
119 P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
120 P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
121 P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
122 P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
123 P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
124 P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
125 P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
126 /* Added nocopy for 2672653 */
127 X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128 X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
132 X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
129 X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
130 X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
131 X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
133 X_Error_Stage OUT NOCOPY VARCHAR2,
134 X_Error_Code OUT NOCOPY NUMBER,
135 /* Added calling module for 3234973 */
136 X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION') ;
137
138 PROCEDURE PA_CC_GET_PRVDR_RECVR_ORGS (
139 P_ExpOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
140 P_ExpOrgidTab IN PA_PLSQL_DATATYPES.IdTabTyp,
141 P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
142 P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
143 P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
144 P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
145 P_NLROrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
146 P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
147 P_ExpTypeTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
148 P_PrjOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
149 P_PrjOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
150 /* Added nocopy for 2672653 */
151 P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp, -- added bug 14173646
152 X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
153 X_PrvdrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
154 X_RecvrOrganizationIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
155 X_RecvrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
156 X_CCProcessIOCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
157 X_CCProcessIUCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
158 X_CCPrjFlagTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
159 X_Error_Stage OUT NOCOPY VARCHAR2,
160 X_Error_Code OUT NOCOPY NUMBER,
161 /* Added calling module for 3234973 */
162 X_Calling_Module IN VARCHAR2 DEFAULT 'TRANSACTION');
163
164 PROCEDURE PA_CC_GET_CROSS_CHARGE_TYPE (
165 P_PrvdrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
166 P_RecvrOrganizationIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
167 P_ProjectIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
168 P_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
169 P_SysLinkTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
170 P_ExpItemIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
171 P_PersonIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
172 P_ExpItemDateTab IN PA_PLSQL_DATATYPES.DateTabTyp,
173 P_PrvdrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
174 P_RecvrOrgIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
175 P_PrvdrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
176 P_RecvrLEIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
177 P_TransSourceTab IN PA_PLSQL_DATATYPES.Char30TabTyp,
178 P_CCProcessIOCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
179 P_CCProcessIUCodeTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
180 P_CCPrjFlagTab IN PA_PLSQL_DATATYPES.Char1TabTyp,
181 P_calling_mode IN VARCHAR2 default 'TRANSACTION',
182 /* Added nocopy for 2672653 */
183 X_StatusTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
184 X_CrossChargeTypeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char3TabTyp,
185 X_CrossChargeCodeTab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
186 X_Error_Stage OUT NOCOPY VARCHAR2,
187 X_Error_Code OUT NOCOPY NUMBER);
188
189 FUNCTION GetLegalEntity( p_org_id IN NUMBER ) RETURN NUMBER;
190 --pragma RESTRICT_REFERENCES ( GetLegalEntity, WNDS, WNPS);
191
192 /* Funtion GET_ORG_LEGAL_ENTITY added for Bug 14657202: IC Enhancement*/
193 FUNCTION GET_ORG_LEGAL_ENTITY( p_org_id NUMBER,
194 p_organization_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE)
195 RETURN NUMBER;
196
197
198 END PA_CC_IDENT;