1 PACKAGE WSMPCOGI AUTHID CURRENT_USER AS
2 /* $Header: WSMCOGIS.pls 120.0 2005/05/24 17:35:50 appldev noship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: get_bill_comp_sequence
6
7 DESCRIPTION: This routine is used to obtain a new
8 sequence for bill_sequence_id and
9 component_sequence_id.
10
11 PARAMETERS: x_result IN OUT NOCOPY NUMBER
12 x_error_code IN OUT NOCOPY NUMBER
13 x_error_msg IN OUT NOCOPY VARCHAR2
14
15 x_error_code : 0 - Successful.
16 Other values: - SQL Error.
17 ===========================================================================*/
18 PROCEDURE get_bill_comp_sequence (x_result IN OUT NOCOPY NUMBER,
19 x_error_code IN OUT NOCOPY NUMBER,
20 x_error_msg IN OUT NOCOPY VARCHAR2);
21
22 /*===========================================================================
23 PROCEDURE NAME: get_coprod_count
24
25 DESCRIPTION: This routine returns the number of co-products
26 in a co-product relationship.
27
28 PARAMETERS: x_co_product_group_id IN NUMBER,
29 x_count IN OUT NOCOPY NUMBER,
30 x_error_code IN OUT NOCOPY NUMBER,
31 x_error_msg IN OUT NOCOPY VARCHAR2
32
33 x_error_code : 0 - Successful.
34 Other values: - SQL Error.
35 ===========================================================================*/
36 PROCEDURE get_coprod_count(x_co_product_group_id IN NUMBER,
37 x_count IN OUT NOCOPY NUMBER,
38 x_error_code IN OUT NOCOPY NUMBER,
39 x_error_msg IN OUT NOCOPY VARCHAR2);
40
41
42 /*===========================================================================
43 FUNCTION NAME: get_alternate_designator
44
45 DESCRIPTION: This function gets the alternate designator
46 used to create the bills associated with the co-products
47 belonging to a specific co-product relationship.
48
49 PARAMETERS: X_co_product_group_id NUMBER
50 ===========================================================================*/
51
52 FUNCTION get_alternate_designator
53 (X_co_product_group_id NUMBER) return varchar2;
54
55
56 /*****************************************************************
57 * Function : Get_Component_Sequence_Id
58 * Parameters IN : Component unique index information
59 * Parameters OUT: Error Text
60 * Returns : Component_Sequence_Id
61 * Purpose : Function will query the component sequence id using
62 * alternate unique key information. If unsuccessfull
63 * function will return a NULL.
64 ********************************************************************/
65 FUNCTION Get_Component_Sequence_Id(p_component_item_id IN NUMBER,
66 p_operation_sequence_num IN VARCHAR2,
67 p_effectivity_date IN DATE,
68 p_bill_sequence_id IN NUMBER,
69 x_err_text OUT NOCOPY VARCHAR2 )
70 RETURN NUMBER;
71
72 /*===========================================================================
73 FUNCTION NAME: get_item_name
74
75 DESCRIPTION: This function does a id to value conversion and
76 returns the item name
77 ===========================================================================*/
78 FUNCTION Get_Item_Name (p_inventory_item_id IN NUMBER,
79 p_organization_id IN NUMBER,
80 x_error_code IN OUT NOCOPY NUMBER,
81 x_error_msg IN OUT NOCOPY VARCHAR2)
82 RETURN VARCHAR2;
83 --bug 4224811 commenting out the following pragma since it causes compilation errors. Also get_alternate_designator is not currently not used
84 --in our code
85 --PRAGMA RESTRICT_REFERENCES (get_alternate_designator,WNDS,RNPS,WNPS);
86
87 END;