1 PACKAGE BODY PA_CLIENT_EXTN_CIP_ACCT_OVR AS
2 -- $Header: PACCXCOB.pls 115.2 2003/08/18 14:30:57 ajdas noship $
3
4 FUNCTION CIP_ACCT_OVERRIDE(p_cdl_cip_ccid IN NUMBER,
5 p_expenditure_item_id IN NUMBER,
6 p_cdl_line_number IN NUMBER) RETURN NUMBER IS
7
8 BEGIN
9 /* This is a client extension function called by the GENERATE_PROJ_ASSET_LINES procedure,
10 which groups CDLs into Asset Lines using the CIP Account CCID as one of the grouping
11 criteria. The extension will be called once for every CDL processed by that program.
12
13 The intended use of this extension is to provide clients with the ability to override
14 the CIP account on the CDL line with a DIFFERENT code combination id value, in order
15 to generate and interface lines to Oracle Assets with different Asset Clearing Account
16 than the CIP Account credited in Oracle Projects. The reason that a customer would want
17 to credit a different account than the original account that was debited is that there
18 are customers who wish to maintain CIP details in the GL (i.e., CIP costs by Cost Center,
19 Activity, etc.), and credit out the CIP account at a higher level (i.e., Balancing Segment
20 and Account only). This allows clients to maintain visibility of CIP spending details
21 over time, rather than having them cleared out as soon as assets are posted in Oracle Assets.
22
23 Note that this extension will ALSO be called by the Generate Retirement Cost Lines process,
24 for similar purposes.
25
26 */
27
28 RETURN(p_cdl_cip_ccid);
29
30 EXCEPTION
31 WHEN OTHERS THEN
32 RAISE;
33 END;
34
35 END;
[Home] [Help]