PACKAGE: APPS.PA_PAXBUBSS_XMLP_PKG

Source

1 PACKAGE PA_PAXBUBSS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAXBUBSSS.pls 120.0 2008/01/02 11:22:14 krreddy noship $ */
3   PROJ NUMBER;
4   MGR NUMBER;
5   ORG NUMBER;
6   PROJ_TYPE VARCHAR2(40);
7   TOPTASK NUMBER;
8   EXPLODE_SUB_TASKS VARCHAR2(30);
9   P_DEBUG_MODE VARCHAR2(3);
10   P_CONC_REQUEST_ID NUMBER;
11   P_RULE_OPTIMIZER VARCHAR2(3);
12   COST_BGT_CODE VARCHAR2(30);
13   REV_BGT_CODE VARCHAR2(30);
14   C_COMPANY_NAME_HEADER VARCHAR2(50);
15   C_NO_DATA_FOUND VARCHAR2(80);
16   C_ORG VARCHAR2(240);
17   C_PROJ_NUM VARCHAR2(30);
18   C_PROJ_NAME VARCHAR2(30);
19   C_MGR VARCHAR2(30);
20   C_TASK_NUM VARCHAR2(30);
21   C_TASK_NAME VARCHAR2(30);
22   C_EXPLODE VARCHAR2(30);
23   C_PROJ_TYPE VARCHAR2(30);
24   C_COST_BGT_CODE VARCHAR2(30);
25   C_REV_BGT_CODE VARCHAR2(30);
26   C_COST_BGT_NAME VARCHAR2(30);
27   C_REV_BGT_NAME VARCHAR2(30);
28   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
29   FUNCTION BEFOREREPORT RETURN BOOLEAN;
30   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
31   FUNCTION NO_DATA_FOUND_FUNC RETURN BOOLEAN;
32   FUNCTION GET_AR(PROJECT_ID_1 IN NUMBER) RETURN NUMBER;
33   FUNCTION ACCOUNTS_RECEIVABLEFORMULA(PROJECT_ID IN NUMBER) RETURN NUMBER;
34   FUNCTION UNBILLED_RECFORMULA(RETN_ACCOUNTING_FLAG IN VARCHAR2
35                               ,TOTAL_REVENUE_AMOUNT IN NUMBER
36                               ,PFC_TOTAL_INVOICE_AMOUNT IN NUMBER
37                               ,UNBILLED_RETENTION IN NUMBER) RETURN NUMBER;
38   FUNCTION UNEARNED_REVFORMULA(RETN_ACCOUNTING_FLAG IN VARCHAR2
39                               ,PFC_TOTAL_INVOICE_AMOUNT IN NUMBER
40                               ,UNBILLED_RETENTION IN NUMBER
41                               ,TOTAL_REVENUE_AMOUNT IN NUMBER) RETURN NUMBER;
42   FUNCTION AFTERREPORT RETURN BOOLEAN;
43   FUNCTION C_INDENTED_TASK_NUMBERFORMULA(WBS_LEVEL IN NUMBER
44                                         ,TASK_NUMBER IN VARCHAR2) RETURN VARCHAR2;
45   FUNCTION C_INDENTED_TASK_NAMEFORMULA(WBS_LEVEL IN NUMBER
46                                       ,TASK_NAME IN VARCHAR2) RETURN VARCHAR2;
47   FUNCTION UNBILLED_RETNFORMULA(RETN_ACCOUNTING_FLAG IN VARCHAR2
48                                ,UNBILLED_RETENTION IN NUMBER) RETURN NUMBER;
49   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
50   FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
51   FUNCTION C_ORG_P RETURN VARCHAR2;
52   FUNCTION C_PROJ_NUM_P RETURN VARCHAR2;
53   FUNCTION C_PROJ_NAME_P RETURN VARCHAR2;
54   FUNCTION C_MGR_P RETURN VARCHAR2;
55   FUNCTION C_TASK_NUM_P RETURN VARCHAR2;
56   FUNCTION C_TASK_NAME_P RETURN VARCHAR2;
57   FUNCTION C_EXPLODE_P RETURN VARCHAR2;
58   FUNCTION C_PROJ_TYPE_P RETURN VARCHAR2;
59   FUNCTION C_COST_BGT_CODE_P RETURN VARCHAR2;
60   FUNCTION C_REV_BGT_CODE_P RETURN VARCHAR2;
61   FUNCTION C_COST_BGT_NAME_P RETURN VARCHAR2;
62   FUNCTION C_REV_BGT_NAME_P RETURN VARCHAR2;
63 END PA_PAXBUBSS_XMLP_PKG;