PACKAGE: APPS.CSI_CSICPREP_XMLP_PKG

Source

1 PACKAGE CSI_CSICPREP_XMLP_PKG AS
2 /* $Header: CSICPREPS.pls 120.0 2007/12/24 12:59:25 nchinnam noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4   P_FLEX_ITEM_CODE VARCHAR2(800);
5   P_ITEM_STRUCT_NUM NUMBER;
6   P_SOB_ID NUMBER;
7   P_CUSTOMER_NUMBER_LOW VARCHAR2(30);
8   P_CUSTOMER_NUMBER_HIGH VARCHAR2(30);
9   LP_CUSTOMER_RANGE VARCHAR2(200) :='and 1=1';
10   P_ITEM_LO VARCHAR2(900);
11   P_ITEM_HIGH VARCHAR2(900);
12   LP_ITEM_RANGE VARCHAR2(900) :='and 1=1';
13   P_INSTALL_LOCATION VARCHAR2(40) :='and 1=1';
14   P_CP_STATUS VARCHAR2(30);
15   LP_INSTALL_LOCATION VARCHAR2(200) := 'and 1=1';
16   LP_CP_STATUS VARCHAR2(200) :='and 1=1';
17   P_ITEM_WHERE VARCHAR2(200) :='and 1=1';
18   P_ORDER_BY VARCHAR2(300);
19   P_ORGANIZATION_ID NUMBER;
20   RP_REPORT_NAME VARCHAR2(80) := 'Customer Products - Summary';
21   RP_COMPANY_NAME VARCHAR2(50);
22   FUNCTION BEFOREREPORT RETURN BOOLEAN;
23   FUNCTION AFTERREPORT RETURN BOOLEAN;
24   FUNCTION P_SOB_IDVALIDTRIGGER RETURN BOOLEAN;
25   FUNCTION AFTERPFORM RETURN BOOLEAN;
26   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
27   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
28 END CSI_CSICPREP_XMLP_PKG;
29