PACKAGE: APPS.INV_INVTRVLT_XMLP_PKG

Source

1 PACKAGE INV_INVTRVLT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVTRVLTS.pls 120.3 2011/04/05 08:11:53 viiyer ship $ */
3   P_ITEM_NUM VARCHAR2(15);
4   P_GL_NUM VARCHAR2(15);
5   P_MDSP_NUM VARCHAR2(15);
6   P_MKTS_NUM VARCHAR2(15);
7   P_ITEM_FLEXDATA VARCHAR2(800);
8   P_GL_FLEXDATA VARCHAR2(480);
9   P_MDSP_FLEXDATA VARCHAR2(480);
10   P_MKTS_FLEXDATA VARCHAR2(480):='(MKTS.SEGMENT1||MKTS.SEGMENT2||MKTS.SEGMENT3||MKTS.SEGMENT4||MKTS.SEGMENT5||MKTS.SEGMENT6||MKTS.SEGMENT7||MKTS.SEGMENT8||MKTS.SEGMENT9||MKTS.SEGMENT10)';
11   P_ORG VARCHAR2(22);
12   P_ITEM_WHERE VARCHAR2(400):= '1=1';
13   P_START_DATE DATE;
14   P_START_DATE_1 VARCHAR2(20);
15   P_END_DATE DATE;
16   P_END_DATE_1 varchar2(50);
17   CP_END_DATE VARCHAR2(20);
18   P_CONC_REQUEST_ID NUMBER := 0;
19   P_SORT_ID NUMBER;
20   P_VEND_LOT_NUMBER VARCHAR2(30);
21   P_ITEM_LO VARCHAR2(300);
22   P_ITEM_HI VARCHAR2(300);
23   P_LOT_NUMBER_LO VARCHAR2(80);
24   P_LOT_NUMBER_HI VARCHAR2(80);
25   P_QTY_PRECISION NUMBER;
26   P_ITEM_ORDER_BY VARCHAR2(820):= 'character" defaultValue="msi.segment1, msi.segment2, msi.segment3';
27   P_TRACE_FLAG NUMBER;
28   P_OPTIMIZER_CODE NUMBER;
29   FUNCTION BEFOREREPORT RETURN BOOLEAN;
30   FUNCTION P_ITEM_WHEREVALIDTRIGGER RETURN BOOLEAN;
31   FUNCTION WHERE_LOT RETURN VARCHAR2;
32   FUNCTION P_TRACE_FLAGVALIDTRIGGER RETURN BOOLEAN;
33   FUNCTION AFTERPFORM RETURN BOOLEAN;
34   FUNCTION AFTERREPORT RETURN BOOLEAN;
35 END INV_INVTRVLT_XMLP_PKG;
36