PACKAGE: APPS.RLM_RLMDPPSR_XMLP_PKG

Source

1 PACKAGE RLM_RLMDPPSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RLMDPPSRS.pls 120.1 2008/01/25 14:35:24 krreddy noship $ */
3   P_SCHEDULE_TYPE VARCHAR2(32767);
4 
5   P_SCHEDULE_REF_NO NUMBER;
6 
7   P_AUTHORIZATION VARCHAR2(32767);
8 
9   P_WHERE_CLAUSE VARCHAR2(40) := ' ';
10 
11   P_WHERE_CLAUSE1 VARCHAR2(32767);
12 
13   P_REQUEST_ID NUMBER;
14 
15   P_EXECUTION_MODE VARCHAR2(32767);
16 
17   P_TRANSLATOR_CODE_FROM VARCHAR2(32767);
18 
19   P_TRANSLATOR_CODE_TO VARCHAR2(32767);
20 
21   P_SHIP_TO_ADDRESS_ID_FROM NUMBER;
22 
23   P_SHIP_TO_ADDRESS_ID_TO NUMBER;
24 
25   P_ISSUE_DATE_FROM VARCHAR2(32767);
26 
27   P_ISSUE_DATE_TO VARCHAR2(32767);
28 
29   P_DELETE_BEYOND_DAYS NUMBER;
30 
31   P_ORG_ID NUMBER;
32 
33   P_CUSTOMER VARCHAR2(30);
34 
35   P_STATUS NUMBER;
36 
37   P_CONC_REQUEST_ID NUMBER;
38 
39   CP_DEFAULT_OU VARCHAR2(240);
40 
41   M_2 VARCHAR2(1);
42 
43   FUNCTION BEFOREREPORT RETURN BOOLEAN;
44 
45   FUNCTION AFTERREPORT RETURN BOOLEAN;
46 
47   FUNCTION CF_SCHEDULE_TYPEFORMULA(SCHEDULE_TYPE IN VARCHAR2) RETURN VARCHAR2;
48 
49   FUNCTION CF_PURGE_STATUSFORMULA(PURGE_STATUS IN VARCHAR2) RETURN VARCHAR2;
50 
51   FUNCTION CF_1FORMULA RETURN NUMBER;
52 
53   FUNCTION CF_COUNT2FORMULA RETURN NUMBER;
54 
55   FUNCTION CF_COUNT3FORMULA RETURN NUMBER;
56 
57   FUNCTION CF_1FORMULA0006 RETURN VARCHAR2;
58 
59   FUNCTION CF_1FORMULA0004 RETURN VARCHAR2;
60 
61   FUNCTION CF_SHIP_TO_TOFORMULA RETURN VARCHAR2;
62 
63   FUNCTION CF_P_SCHED_TYPEFORMULA RETURN VARCHAR2;
64 
65   FUNCTION CF_EXECUTIONFORMULA RETURN VARCHAR2;
66 
67   FUNCTION CF_YES_NOFORMULA RETURN VARCHAR2;
68 
69   FUNCTION CF_PURGE_ELIGIBLEFORMULA(PURGE_STATUS IN VARCHAR2) RETURN VARCHAR2;
70 
71   FUNCTION CF_STATUS RETURN VARCHAR2;
72 
73   FUNCTION CF_CUSTOMERFORMULA RETURN VARCHAR2;
74 
75   FUNCTION CP_DEFAULT_OU_P RETURN VARCHAR2;
76 
77   FUNCTION M_2FORMATTRIGGER RETURN VARCHAR2;
78 
79 END RLM_RLMDPPSR_XMLP_PKG;