PACKAGE: APPS.WIP_WIPUTACD_XMLP_PKG

Source

1 PACKAGE WIP_WIPUTACD_XMLP_PKG AS
2 /* $Header: WIPUTACDS.pls 120.2 2008/01/31 13:16:44 npannamp noship $ */
3   P_STRUCT_NUM VARCHAR2(15);
4   P_ORGANIZATION_ID NUMBER;
5   P_FROM_DATE DATE;
6 qty_precision varchar2(20);
7   P_TO_DATE DATE;
8   P_FROM_DATE_DISP VARCHAR2(30);
9   P_TO_DATE_DISP VARCHAR2(30);
10   P_ACCOUNT NUMBER;
11   P_GL_BATCH_ID NUMBER;
12   P_CLASS_CODE VARCHAR2(10);
13   P_ASSEMBLY_ID NUMBER;
14   P_CURRENCY_CODE VARCHAR2(15);
15   P_CONC_REQUEST_ID NUMBER := 0;
16 P_FLEXDATA VARCHAR2(850);
17  P_ASSY_FLEX VARCHAR2(850);
18  -- P_FLEXDATA VARCHAR2(850):='L.SEGMENT1||'\n'||L.SEGMENT2||'\n'||L.SEGMENT3||'\n'||L.SEGMENT4||'\n'||L.SEGMENT5||'\n'||L.SEGMENT6||'\n'||L.SEGMENT7||'\n'||L.SEGMENT8||'\n'||L.SEGMENT9||'\n'||L.SEGMENT10||'\n'||L.SEGMENT11||'\n'||
19 -- L.SEGMENT12||'\n'||L.SEGMENT13||'\n'||L.SEGMENT14||'\n'
20 -- ||L.SEGMENT15||'\n'||L.SEGMENT16||'\n'||L.SEGMENT17||'\n'||L.SEGMENT18||'\n'||L.SEGMENT19||'\n'||L.SEGMENT20||'\n'||L.SEGMENT21||'\n'||L.SEGMENT22||'\n'||L.SEGMENT23||'\n'||L.SEGMENT23||'\n'||L.SEGMENT25||'\n'||L.SEGMENT26||'\n'||
21 -- L.SEGMENT27||'\n'||L.SEGMENT28||'\n'||L.SEGMENT29||'\n'||L.SEGMENT30';
22  -- P_ASSY_FLEX VARCHAR2(850):='MSI.SEGMENT1||'\n'||MSI.SEGMENT2||'\n'||MSI.SEGMENT3||'\n'||MSI.SEGMENT4||'\n'||MSI.SEGMENT5||'\n'||MSI.SEGMENT6||'\n'||MSI.SEGMENT7||'\n'||MSI.SEGMENT8||'\n'||MSI.SEGMENT9||'\n'||MSI.SEGMENT10||'\n'||
23  --MSI.SEGMENT11||'\n'||MSI.SEGMENT12||'\n'||MSI.SEGMENT13||'\n'||MSI.SEGMENT14||'\n'||MSI.SEGMENT15||'\n'||MSI.SEGMENT16||'\n'||MSI.SEGMENT17||'\n'||MSI.SEGMENT18||'\n'||MSI.SEGMENT19||'\n'||MSI.SEGMENT20';
24   P_QTY_PRECISION NUMBER;
25   P_DEPARTMENT NUMBER;
26   P_JOB NUMBER;
27   P_LINE NUMBER;
28   P_TRANS_TYPE NUMBER;
29   P_ACTIVITY NUMBER;
30   P_DEBUG NUMBER;
31   P_LIMIT_ENTITY VARCHAR2(400):='and 1=1';
32   P_LIMIT_ACCOUNT VARCHAR2(400):='and 1=1';
33   P_EXCHANGE_RATE NUMBER;
34   P_CURRENCY_PRECISION NUMBER;
35   P_RATE_PRECISION NUMBER;
36   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
37   P_CATEGORY_SET NUMBER;
38   P_CAT_FROM VARCHAR2(800);
39   P_CAT_TO VARCHAR2(800);
40   P_CAT_NUM NUMBER;
41   P_CAT_WHERE VARCHAR2(2400);
42   P_CAT_SEG VARCHAR2(2400);
43   P_PROJECT_ID NUMBER;
44   P_PROJECT_WHERE VARCHAR2(1400) := '1=1';
45   P_PROJ_WHERE VARCHAR2(1400) := '1=1';
46   FUNCTION LIMIT_DATES RETURN CHARACTER;
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48   FUNCTION AFTERREPORT RETURN BOOLEAN;
49   FUNCTION CLASS(R_CLASS IN VARCHAR2
50                 ,D_CLASS IN VARCHAR2) RETURN CHARACTER;
51   FUNCTION LIMIT_CLASSES RETURN CHARACTER;
52   FUNCTION C_SUBTITLE_CURRENCYFORMULA RETURN VARCHAR2;
53   FUNCTION C_ACCT_DESCRIPFORMULA(C_FLEXDATA IN VARCHAR2
54                                 ,ACCOUNT IN VARCHAR2
55                                 ,C_ACCT_DESCRIP IN VARCHAR2) RETURN VARCHAR2;
56   FUNCTION C_FLEX_SORTFORMULA(C_FLEXDATA IN VARCHAR2
57                              ,ACCOUNT IN VARCHAR2
58                              ,C_FLEX_SORT IN VARCHAR2) RETURN VARCHAR2;
59   FUNCTION AFTERPFORM RETURN BOOLEAN;
60 END WIP_WIPUTACD_XMLP_PKG;
61 
62