[Home] [Help]
PACKAGE: APPS.BOM_CSTRAIVA_XMLP_PKG
Source
1 PACKAGE BOM_CSTRAIVA_XMLP_PKG AS
2 /* $Header: CSTRAIVAS.pls 120.0 2007/12/24 09:52:14 dwkrishn noship $ */
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 FUNCTION CF_ORDERFORMULA(CATEGORY IN VARCHAR2) RETURN CHAR;
46 FUNCTION CF_TOTQTYFORMULA(STKQTY IN NUMBER
47 ,RCVQTY IN NUMBER
48 ,INTQTY IN NUMBER) RETURN NUMBER;
49 FUNCTION CF_TOTVALFORMULA(STKVAL IN NUMBER
50 ,RCVVAL IN NUMBER
51 ,INTVAL IN NUMBER) RETURN NUMBER;
52 FUNCTION BEFOREREPORT RETURN BOOLEAN;
53 FUNCTION AFTERREPORT RETURN BOOLEAN;
54 END BOM_CSTRAIVA_XMLP_PKG;
55
56