[Home] [Help]
PACKAGE: APPS.BOM_CSTRPICR_XMLP_PKG
Source
1 PACKAGE BOM_CSTRPICR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTRPICRS.pls 120.0 2007/12/24 10:13:43 dwkrishn noship $ */
3 P_CONC_REQUEST_ID VARCHAR2(32767) := '0';
4 P_CURRENCY_CODE VARCHAR2(15);
5 P_EXCHANGE_RATE NUMBER := 1;
6 P_SORT_OPTION NUMBER;
7 P_RPT_OPTION NUMBER;
8 P_ITEM_FROM VARCHAR2(800);
9 P_ITEM_TO VARCHAR2(800);
10 P_CATEGORY_SET NUMBER;
11 P_CAT_NUM NUMBER;
12 P_CAT_FROM VARCHAR2(800);
13 P_CAT_TO VARCHAR2(800);
14 ROUND_UNIT NUMBER;
15 P_ITEM_SEG VARCHAR2(2400);
16 P_CAT_SEG VARCHAR2(2400);
17 P_ITEM_WHERE VARCHAR2(2400);
18 P_CAT_WHERE VARCHAR2(2400);
19 P_SORT_BY VARCHAR2(80);
20 P_CAT_SET_NAME VARCHAR2(40);
21 P_DETAIL_LEVEL VARCHAR2(80);
22 P_COST_TYPE_ID NUMBER;
23 P_DEF_COST_TYPE NUMBER;
24 P_COST_TYPE VARCHAR2(10);
25 P_EXT_PREC NUMBER;
26 P_QTY_WHERE VARCHAR2(1440);
27 P_QTY_PRECISION NUMBER;
28 P_SESSIONID NUMBER;
29 P_CURRENCY_DSP VARCHAR2(50);
30 P_VIEW_COST NUMBER;
31 P_REPORT_NAME VARCHAR2(80);
32 P_TRACE VARCHAR2(1);
33 P_COST_ORG_ID NUMBER;
34 P_PRECISION NUMBER;
35 P_LEGAL_ENTITY VARCHAR2(240);
36 P_COST_GROUP_ID NUMBER;
37 P_LEGAL_ENTITY_ID NUMBER;
38 P_COST_GROUP VARCHAR2(10);
39 P_PERIOD_NAME VARCHAR2(30);
40 P_ITEM_MASTER_ORG_ID NUMBER;
41 P_PERIOD_ID NUMBER;
42 P_EXCHANGE_RATE_CHAR VARCHAR2(38);
43 FUNCTION AFTERREPORT RETURN BOOLEAN;
44 FUNCTION BEFOREREPORT RETURN BOOLEAN;
45 FUNCTION BEFOREPFORM RETURN BOOLEAN;
46 FUNCTION IC_REP_TOTAL_RFORMULA(IC_REP_TOTAL IN NUMBER) RETURN NUMBER;
47 FUNCTION IC_ORDERFORMULA(IC_CATEGORY IN VARCHAR2
48 ,IC_CATEGORY_SEGMENT IN VARCHAR2
49 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
50 FUNCTION IC_CAT_TOTAL_RFORMULA(IC_CAT_TOTAL IN NUMBER) RETURN NUMBER;
51 FUNCTION IC_ITEM_PSEGFORMULA(IC_ITEM_NUMBER IN VARCHAR2
52 ,IC_ITEM_SEGMENT IN VARCHAR2
53 ,IC_ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
54 FUNCTION IC_CAT_PSEGFORMULA(IC_CATEGORY IN VARCHAR2
55 ,IC_CATEGORY_SEGMENT IN VARCHAR2
56 ,IC_CAT_PSEG IN VARCHAR2) RETURN VARCHAR2;
57 FUNCTION IC_TOTAL_COST_RFORMULA(IC_TOTAL_COST IN NUMBER) RETURN NUMBER;
58 FUNCTION IC_MATL_COST_RFORMULA(IC_MATL_COST IN NUMBER) RETURN NUMBER;
59 FUNCTION IC_MO_COST_RFORMULA(IC_MO_COST IN NUMBER) RETURN NUMBER;
60 FUNCTION IC_RES_COST_RFORMULA(IC_RES_COST IN NUMBER) RETURN NUMBER;
61 FUNCTION IC_OVHD_COST_RFORMULA(IC_OVHD_COST IN NUMBER) RETURN NUMBER;
62 FUNCTION IC_OSP_COST_RFORMULA(IC_OSP_COST IN NUMBER) RETURN NUMBER;
63 FUNCTION IC_TOT_MATL_COST_RFORMULA(IC_TOT_MATL_COST IN NUMBER) RETURN NUMBER;
64 FUNCTION IC_TOT_MO_COST_RFORMULA(IC_TOT_MO_COST IN NUMBER) RETURN NUMBER;
65 FUNCTION IC_TOT_RES_COST_RFORMULA(IC_TOT_RES_COST IN NUMBER) RETURN NUMBER;
66 FUNCTION IC_TOT_OVHD_COST_RFORMULA(IC_TOT_OVHD_COST IN NUMBER) RETURN NUMBER;
67 FUNCTION IC_TOT_OSP_COST_RFORMULA(IC_TOT_OSP_COST IN NUMBER) RETURN NUMBER;
68 FUNCTION P_LEGAL_ENTITYVALIDTRIGGER RETURN BOOLEAN;
69 FUNCTION P_CAT_NUMVALIDTRIGGER RETURN BOOLEAN;
70 FUNCTION P_DETAIL_LEVELVALIDTRIGGER RETURN BOOLEAN;
71 FUNCTION P_PERIOD_IDVALIDTRIGGER RETURN BOOLEAN;
72 FUNCTION P_SORT_BYVALIDTRIGGER RETURN BOOLEAN;
73 FUNCTION CF_RCV_VALUEFORMULA(CS_IC_QUANTITY_TOTAL2 IN NUMBER
74 ,CS_ACQUISITION_COST2 IN NUMBER) RETURN NUMBER;
75 FUNCTION CF_TOTAL_VALUEFORMULA(CF_RCV_VALUE IN NUMBER
76 ,IC_TOTAL_COST_R IN NUMBER) RETURN NUMBER;
77 FUNCTION IC_ACQUISITION_COST_RFORMULA(IC_ACQUISITION_COST IN NUMBER) RETURN NUMBER;
78 FUNCTION IC_VALUE_RFORMULA(IC_VALUE IN NUMBER) RETURN NUMBER;
79 FUNCTION CF_IC_VALUE_TOTAL2_RFORMULA(CS_IC_VALUE_TOTAL2 IN NUMBER) RETURN NUMBER;
80 FUNCTION CF_ACQUISITION_COST2_RFORMULA(CS_ACQUISITION_COST2 IN NUMBER) RETURN NUMBER;
81 FUNCTION CF_RCV_VALUE_RFORMULA(CF_RCV_VALUE IN NUMBER) RETURN NUMBER;
82 FUNCTION CF_TOTAL_VALUE_RFORMULA(CF_TOTAL_VALUE IN NUMBER) RETURN NUMBER;
83 END BOM_CSTRPICR_XMLP_PKG;
84