[Home] [Help]
PACKAGE: APPS.PA_PAXMGSLS_XMLP_PKG
Source
1 PACKAGE PA_PAXMGSLS_XMLP_PKG AS
2 /* $Header: PAXMGSLSS.pls 120.0 2008/01/02 11:37:56 krreddy noship $ */
3 P_RULE_OPTIMIZER VARCHAR2(3);
4 P_DEBUG_MODE VARCHAR2(3);
5 P_CONC_REQUEST_ID NUMBER;
6 P_FROM_GL_DATE DATE;
7 P_TO_GL_DATE DATE;
8 P_FROM_ACCOUNT VARCHAR2(1000);
9 P_TO_ACCOUNT VARCHAR2(1000);
10 P_TO_PROJECT VARCHAR2(25);
11 CP_FROM_GL_DATE varchar2(25);
12 CP_TO_GL_DATE varchar2(25);
13 P_FROM_PROJECT VARCHAR2(25);
14 P_COA_ID NUMBER;
15 P_CA_SET_OF_BOOKS_ID NUMBER;
16 C_COMPANY_NAME_HEADER VARCHAR2(50);
17 C_NO_DATA_FOUND VARCHAR2(80);
18 C_DUMMY_DATA NUMBER;
19 C_WHERE VARCHAR2(4000) := '''1'' = ''1''';
20 C_ACCOUNT_DESC1 VARCHAR2(2000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' ||
21 SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' ||
22 SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' ||
23 SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' ||
24 SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' ||
25 SEGMENT29 || ''\n'' || SEGMENT30)';
26 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
27 FUNCTION BEFOREREPORT RETURN BOOLEAN;
28 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
29 FUNCTION C_ACCOUNT_IDFORMULA(CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
30 FUNCTION C_RAW_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
31 ,RAW_COST IN NUMBER) RETURN VARCHAR2;
32 FUNCTION C_BURDEN_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
33 ,BURDEN_COST IN NUMBER) RETURN VARCHAR2;
34 FUNCTION C_TOTAL_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
35 ,TOTAL_COST IN NUMBER) RETURN VARCHAR2;
36 FUNCTION MFG_RELATEDFORMULA(MANUFACTURING_RELATED IN VARCHAR2) RETURN VARCHAR2;
37 FUNCTION CA_RAW_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
38 ,A_RAW_COST IN NUMBER) RETURN VARCHAR2;
39 FUNCTION CA_BURDEN_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
40 ,A_BURDEN_COST IN NUMBER) RETURN VARCHAR2;
41 FUNCTION CA_TOTAL_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
42 ,A_TOTAL_COST IN NUMBER) RETURN VARCHAR2;
43 FUNCTION CP_RAW_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
44 ,P_RAW_COST IN NUMBER) RETURN VARCHAR2;
45 FUNCTION CP_BURDEN_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
46 ,P_BURDEN_COST IN NUMBER) RETURN VARCHAR2;
47 FUNCTION CP_TOTAL_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
48 ,P_TOTAL_COST IN NUMBER) RETURN VARCHAR2;
49 FUNCTION CM_RAW_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
50 ,M_RAW_COST IN NUMBER) RETURN VARCHAR2;
51 FUNCTION CM_BURDEN_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
52 ,M_BURDEN_COST IN NUMBER) RETURN VARCHAR2;
53 FUNCTION CM_TOTAL_COSTFORMULA(CF_ACCT_CURRENCY_CODE IN VARCHAR2
54 ,M_TOTAL_COST IN NUMBER) RETURN VARCHAR2;
55 FUNCTION C_SYS_LINKAGEFORMULA(SYSTEM_LINKAGE IN VARCHAR2) RETURN VARCHAR2;
56 FUNCTION CF_TO_DATEFORMULA RETURN DATE;
57 FUNCTION CF_FROM_DATEFORMULA RETURN DATE;
58 FUNCTION CF_ACCT_CURRENCY_CODEFORMULA RETURN VARCHAR2;
59 FUNCTION AFTERREPORT RETURN BOOLEAN;
60 FUNCTION AFTERPFORM RETURN BOOLEAN;
61 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
62 FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
63 FUNCTION C_DUMMY_DATA_P RETURN NUMBER;
64 FUNCTION C_WHERE_P RETURN VARCHAR2;
65 FUNCTION C_ACCOUNT_DESC1_P RETURN VARCHAR2;
66 FUNCTION GET_CURRENCY_CODE RETURN VARCHAR2;
67 FUNCTION ROUND_CURRENCY_AMT(X_AMOUNT IN NUMBER) RETURN NUMBER;
68 FUNCTION CURRENCY_FMT_MASK(X_LENGTH IN NUMBER) RETURN VARCHAR2;
69 FUNCTION RPT_CURRENCY_FMT_MASK(X_ORG_ID IN NUMBER
70 ,X_LENGTH IN NUMBER) RETURN VARCHAR2;
71 FUNCTION GET_DELIMITER(APPLICATION_SHORT_NAME IN VARCHAR2
72 ,KEY_FLEX_CODE IN VARCHAR2
73 ,STRUCTURE_NUMBER IN NUMBER) RETURN VARCHAR2;
74 FUNCTION GET_CCID(APPLICATION_SHORT_NAME IN VARCHAR2
75 ,KEY_FLEX_CODE IN VARCHAR2
76 ,STRUCTURE_NUMBER IN NUMBER
77 ,VALIDATION_DATE IN VARCHAR2
78 ,CONCATENATED_SEGMENTS IN VARCHAR2) RETURN NUMBER;
79 FUNCTION GET_SEGS(APPLICATION_SHORT_NAME IN VARCHAR2
80 ,KEY_FLEX_CODE IN VARCHAR2
81 ,STRUCTURE_NUMBER IN NUMBER
82 ,COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
83 END PA_PAXMGSLS_XMLP_PKG;