[Home] [Help]
PACKAGE: APPS.INV_INVTRVLT_XMLP_PKG
Source
1 PACKAGE "INV_INVTRVLT_XMLP_PKG" AS
2 /* $Header: INVTRVLTS.pls 120.2 2008/02/21 10:58:52 dwkrishn noship $ */
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