PACKAGE: APPS.IGI_IGIIACAR_XMLP_PKG

Source

1 PACKAGE IGI_IGIIACAR_XMLP_PKG AS
2 /* $Header: IGIIACARS.pls 120.0.12010000.1 2008/07/29 08:58:26 appldev ship $ */
3   P_CATEGORY_ID NUMBER;
4 
5   P_BOOK_TYPE_CODE VARCHAR2(40);
6 
7   P_PERIOD_COUNTER_FROM NUMBER;
8 
9   P_PERIOD_COUNTER_TO NUMBER;
10 
11   P_TRANSACTION_TYPE VARCHAR2(40);
12 
13   P_CONC_REQUEST_ID NUMBER;
14 
15   P_CAT_STRUCT_ID NUMBER;
16 
17   CP_DR_AMOUNT NUMBER;
18 
19   CP_CR_AMOUNT NUMBER;
20 
21   CP_PERIOD_FROM VARCHAR2(42);
22 
23   CP_PERIOD_TO VARCHAR2(42);
24 
25   CP_CURR_CODE VARCHAR2(20);
26 
27   STRUCT_NUM VARCHAR2(20) := '50105';
28 
29   CP_FLEX_DATA_ITEM VARCHAR2(5000) := '(gl_item.segment1||''\n''||gl_item.segment2||''\n''
30   ||gl_item.segment3||''\n''||gl_item.segment4||''\n''||gl_item.segment5||''\n''||gl_item.segment6||
31   ''\n''||gl_item.segment7||''\n''||gl_item.segment8||''\n''||gl_item.segment9||''\n''||gl_item.segment10||
32   ''\n''||gl_item.segment11||''\n''||gl_item.segment12||''\n''||gl_item.segment13||''\n''||gl_item.segment14||
33   ''\n''||gl_item.segment15||''\n''||gl_item.segment16||''\n''||gl_item.segment17||''\n''||gl_item.segment18||
34   ''\n''||gl_item.segment19||''\n''||gl_item.segment20||''\n''||gl_item.segment21||''\n''||gl_item.segment22||
35   ''\n''||gl_item.segment23||''\n''||gl_item.segment24||''\n''||gl_item.segment25||''\n''||gl_item.segment26||
36   ''\n''||gl_item.segment27||''\n''||gl_item.segment28||''\n''||gl_item.segment29||''\n''||gl_item.segment30)';
37 
38   RP_DATA_FOUND VARCHAR2(20);
39 
40   FUNCTION AFTERREPORT RETURN BOOLEAN;
41 
42   FUNCTION CF_DATA_FOUNDFORMULA(CATEGORY_ID IN NUMBER) RETURN NUMBER;
43 
44   FUNCTION CF_PERIOD_FROMFORMULA RETURN NUMBER;
45 
46   FUNCTION CF_PERIOD_TOFORMULA RETURN NUMBER;
47 
48   FUNCTION CF_CURR_CODEFORMULA RETURN NUMBER;
49 
50   FUNCTION CF_DR_AMOUNTFORMULA(DR_CR_FLAG IN VARCHAR2
51                               ,AMOUNT IN NUMBER) RETURN NUMBER;
52 
53   FUNCTION CF_CR_AMOUNTFORMULA(DR_CR_FLAG IN VARCHAR2
54                               ,AMOUNT IN NUMBER) RETURN NUMBER;
55 
56   FUNCTION CP_DR_AMOUNT_P RETURN NUMBER;
57 
58   FUNCTION CP_CR_AMOUNT_P RETURN NUMBER;
59 
60   FUNCTION CP_PERIOD_FROM_P RETURN VARCHAR2;
61 
62   FUNCTION CP_PERIOD_TO_P RETURN VARCHAR2;
63 
64   FUNCTION CP_CURR_CODE_P RETURN VARCHAR2;
65 
66   FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
67 
68   FUNCTION CP_FLEX_DATA_ITEM_P RETURN VARCHAR2;
69 
70   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
71   function BeforeReport return boolean;
72 
73 END IGI_IGIIACAR_XMLP_PKG;