PACKAGE: APPS.BOM_CSTRAIVA_XMLP_PKG

Source

1 PACKAGE BOM_CSTRAIVA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRAIVAS.pls 120.0.12020000.2 2012/07/11 13:14:50 vkatakam ship $ */
3   P_ORG_ID NUMBER;
4   P_COST_GROUP_OPTION_ID NUMBER;
5   P_SORT_OPTION NUMBER;
6   P_ITEM_FROM VARCHAR2(800);
7   P_ITEM_TO VARCHAR2(800);
8   P_CATEGORY_SET NUMBER;
9   P_CAT_NUM NUMBER;
10   P_CAT_FROM VARCHAR2(800);
11   P_CAT_TO VARCHAR2(800);
12   P_CURRENCY_CODE VARCHAR2(15);
13   P_EXCHANGE_RATE_CHAR VARCHAR2(38);
14   P_ZERO_COST NUMBER;
15   P_EXP_ITEM NUMBER;
16   P_EXP_SUBINV NUMBER;
17   P_QTY_PRECISION NUMBER;
18   P_VIEW_COST NUMBER;
19   P_TRACE VARCHAR2(1);
20   PV_ORGANIZATION_NAME VARCHAR2(240);
21   PV_SORT_OPTION VARCHAR2(80);
22   PV_CATEGORY_SET_NAME VARCHAR2(30);
23   PV_CURRENCY_CODE VARCHAR2(50);
24   PV_EXCHANGE_RATE NUMBER := 1;
25   PV_COST_GROUP_OPTION VARCHAR2(80);
26   P_CG VARCHAR2(10);
27   PV_ZERO_COST VARCHAR2(80);
28   PV_EXP_ITEM VARCHAR2(80);
29   PV_EXP_SUBINV VARCHAR2(80);
30   P_CONC_REQUEST_ID NUMBER := 0;
31   P_CAT_SEG VARCHAR2(2400) :='MC.segment1||MC.segment2||MC.segment3||MC.segment4||MC.segment5||MC.segment6||MC.segment7||MC.segment8||MC.segment9||MC.segment10||MC.segment11||MC.segment12||MC.segment13||MC.segment14||MC.segment15
32 				||MC.segment16||MC.segment17||MC.segment18||MC.segment19||MC.segment20';
33   P_CAT_WHERE VARCHAR2(2400);
34   P_ITEM_SEG VARCHAR2(2400):='MSI.segment1||MSI.segment2||MSI.segment3||MSI.segment4||MSI.segment5||MSI.segment6||MSI.segment7||MSI.segment8||MSI.segment9||MSI.segment10||MSI.segment11||MSI.segment12||MSI.segment13||MSI.segment14
35 			||MSI.segment15||MSI.segment16||MSI.segment17||MSI.segment18||MSI.segment19||MSI.segment20';
36   P_ITEM_WHERE VARCHAR2(2400);
37   PV_ROUND_UNIT NUMBER;
38   P_COST_METHOD NUMBER;
39   P_MAIN_QUERY VARCHAR2(1000);
40   P_AS_OF_DATE VARCHAR2(30);
41   P_AS_OF_DATE1 VARCHAR2(30);
42   P_TITLE VARCHAR2(240);
43   P_COST_TYPE_ID NUMBER;
44   P_COST_TYPE VARCHAR2(30);
45   P_ORDER_BY  VARCHAR2(50) := ' '; /*BUG14096363*/
46   FUNCTION CF_ORDERFORMULA(CATEGORY IN VARCHAR2) RETURN CHAR;
47   FUNCTION CF_TOTQTYFORMULA(STKQTY IN NUMBER
48                            ,RCVQTY IN NUMBER
49                            ,INTQTY IN NUMBER) RETURN NUMBER;
50   FUNCTION CF_TOTVALFORMULA(STKVAL IN NUMBER
51                            ,RCVVAL IN NUMBER
52                            ,INTVAL IN NUMBER) RETURN NUMBER;
53   FUNCTION BEFOREREPORT RETURN BOOLEAN;
54   FUNCTION AFTERREPORT RETURN BOOLEAN;
55 END BOM_CSTRAIVA_XMLP_PKG;
56 
57