PACKAGE: APPS.WSM_WSMPNTXN_XMLP_PKG

Source

1 PACKAGE WSM_WSMPNTXN_XMLP_PKG AS
2 /* $Header: WSMPNTXNS.pls 120.0 2007/12/21 12:21:32 krreddy noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_ACCT_CLASS_TYPE NUMBER;
6 
7   P_FROM_CLASS VARCHAR2(10);
8 
9   P_TO_CLASS VARCHAR2(10);
10 
11   P_FROM_JOB VARCHAR2(240);
12 
13   P_TO_JOB VARCHAR2(240);
14 
15   P_FROM_RELEASE_DATE DATE;
16 
17   P_TO_RELEASE_DATE DATE;
18 
19   P_TO_START_DATE DATE;
20 
21   P_FROM_START_DATE DATE;
22 
23   P_FROM_COMPLETE_DATE DATE;
24 
25   P_TO_COMPLETE_DATE DATE;
26 
27   P_STATUS NUMBER;
28 
29   P_EXCLUDE_RESERVED_JOBS NUMBER;
30 
31   P_EXCLUDE_UNCOMPLETE_JOBS NUMBER;
32 
33   P_ENTITY_TYPE NUMBER;
34 
35   P_CLASS_RANGE VARCHAR2(240);
36 
37   P_CLASS_TYPE VARCHAR2(120);
38 
39   P_DATE_COMPLETE VARCHAR2(240);
40 
41 
42   TYPE PTXN_REC IS RECORD (WIP_ENTITY_ID NUMBER);
43 
44   TYPE PTXN_JOB_TYPE IS REF CURSOR;
45 
46   TYPE PTXN_CT_REC IS RECORD (WIP_ENTITY_ID NUMBER,PTXN_TABLE VARCHAR2(30));
47 
48   TYPE PTXN_CT_TYPE IS REF CURSOR;
49 
50   TYPE WSM_PEND_TXN_REP_PL_TBL IS TABLE OF WSM_PEND_TXN_REP_TMP%ROWTYPE
51    INDEX BY BINARY_INTEGER;
52 
53   G_WSM_PEND_TXN_REP_PL_TBL WSM_PEND_TXN_REP_PL_TBL;
54 
55   TYPE WIP_ENTITY_ID_PL_TBL IS TABLE OF WIP_DISCRETE_JOBS.wip_entity_id%TYPE
56    INDEX BY BINARY_INTEGER;
57 
58   G_WIP_ENTITY_ID_PL_TBL WIP_ENTITY_ID_PL_TBL;
59 
60   P_JOB_NAME VARCHAR2(240);
61 
62   P_RELEASE_DATE VARCHAR2(240);
63 
64   P_START_DATE VARCHAR2(240);
65 
66   P_CONC_REQUEST_ID NUMBER;
67 
68   FUNCTION QR_PTXN_JOBREFCURDS RETURN number;
69 
70 --  FUNCTION QR_PTXN_CTREFCURDS(WIP_ENTITY_ID_1 IN NUMBER) RETURN PTXN_CT_TYPE;
71 
72   FUNCTION CF_EXCLUDE_RESERVEFORMULA RETURN CHAR;
73 
74   FUNCTION CF_EXCLUDE_UNCOMPFORMULA RETURN CHAR;
75 
76   FUNCTION CF_ORG_CODEFORMULA RETURN CHAR;
77 
78   FUNCTION CF_JOB_TYPEFORMULA RETURN CHAR;
79 
80   FUNCTION AFTERPFORM RETURN BOOLEAN;
81 
82   FUNCTION P_DATE_COMPLETEVALIDTRIGGER RETURN BOOLEAN;
83 
84   FUNCTION CF_TIMEZONEFORMULA RETURN CHAR;
85 
86   FUNCTION AFTERREPORT RETURN BOOLEAN;
87 
88   FUNCTION BEFOREREPORT RETURN BOOLEAN;
89 
90   FUNCTION BEFOREPFORM RETURN BOOLEAN;
91 
92 END WSM_WSMPNTXN_XMLP_PKG;
93 
94