[Home] [Help]
PACKAGE: APPS.EGO_DEMO_PUB
Source
1 package EGO_DEMO_PUB AS
2 /*$Header: EGODEMOS.pls 120.1 2007/05/09 15:03:17 dsakalle noship $ */
3 ----------------------------------------------------------------------------
4 -- 0. Calculate_Total_Effort
5 ----------------------------------------------------------------------------
6 FUNCTION Calculate_Grade (
7 p_component_risk IN NUMBER
8 , p_lead_time IN NUMBER
9 , p_cost IN NUMBER
10 , p_supplier_risk IN NUMBER
11 ) RETURN NUMBER;
12 ----------------------------------------------------------------------------
13 -- 1. Generate_Item_Number
14 ----------------------------------------------------------------------------
15
16 FUNCTION Generate_Item_Number (
17 p_Section_Code IN VARCHAR2
18 , p_Model_Code IN VARCHAR2
19 , p_Prototype_Code IN VARCHAR2
20 ) RETURN VARCHAR2;
21
22 ----------------------------------------------------------------------------
23 -- 1. Generate_Item_Desc
24 ----------------------------------------------------------------------------
25
26 FUNCTION Generate_Item_Desc (
27 p_Section_Code IN VARCHAR2
28 , p_Model_Code IN VARCHAR2
29 , p_Product_Line IN VARCHAR2
30 ) RETURN VARCHAR2;
31
32
33 ----------------------------------------------------------------------------
34 PROCEDURE Calculate_Weightage (
35 p_param1 IN VARCHAR2
36 , p_param2 IN VARCHAR2
37 , p_param3 IN VARCHAR2
38 , p_result1 IN OUT NOCOPY NUMBER
39 , p_result2 IN OUT NOCOPY NUMBER
40 , p_result3 IN OUT NOCOPY NUMBER
41 );
42 ----------------------------------------------------------------------------
43 -- GenCapacitorItemDesc
44 ----------------------------------------------------------------------------
45 FUNCTION GenCapacitorItemDesc (
46 p1 IN VARCHAR2
47 , p2 IN NUMBER
48 , p3 IN NUMBER
49 , p4 IN NUMBER
50 , p5 IN VARCHAR2
51 , p6 IN VARCHAR2
52 , p7 IN VARCHAR2
53 ) RETURN VARCHAR2;
54
55 -----------------------------------------------------------------------------------
56 -- ClassifyECO
57 -----------------------------------------------------------------------------------
58 PROCEDURE ClassifyECO (
59 pA1 IN VARCHAR2
60 , pB1 IN VARCHAR2
61 , pB2 IN VARCHAR2
62 , pB3 IN VARCHAR2
63 , pChangeId IN NUMBER
64 ) ;
65 ------------------------------------------------------------------------------
66 FUNCTION Gen_Item_Num_With_Key_Attrs( p_Section_Code IN VARCHAR2
67 ,p_Model_Code IN VARCHAR2
68 ,p_Prototype_Code IN VARCHAR2
69 ,p_col_name_value_array IN EGO_COL_NAME_VALUE_PAIR_ARRAY
70 )
71 RETURN VARCHAR2;
72
73 END EGO_DEMO_PUB;