1 PACKAGE PO_CATEGORIES_SV1 AS
2 /* $Header: POXPICTS.pls 120.0.12000000.1 2007/07/27 08:33:33 grohit noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_item_category_id()
6
7 DESCRIPTION: This API is used to validate x_category_id specified
8 is valid and active based on item_id and org_id
9 provided from input parameter.
10
11 PARAMETERS: x_category_id IN NUMBER,
12 x_item_id IN NUMBER,
13 x_organization_id IN NUMBER
14
15 DESIGN
16 REFERENCES: 832valapl.doc
17
18 ALGORITHM: API will return TRUE if validation succeeds, FALSE
19 otherwise;
20
21 NOTES:
22
23 OPEN ISSUES:
24
25 CLOSE ISSUES:
26
27 CHANGE
28 HISTORY: Created 19-FEB-1996 DXYU
29
30
31 =======================================================================*/
32 FUNCTION val_item_category_id(x_category_id IN NUMBER,
33 x_item_id IN NUMBER,
34 x_organization_id IN NUMBER) RETURN BOOLEAN;
35
36
37 /*==================================================================
38 FUNCTION NAME: derive_category_id()
39
40 DESCRIPTION: This API is used to derive x_category_id
41 This API will NOT check if the item category is active
42 or not.
43
44 PARAMETERS: x_category IN VARCHAR2
45
46
47 DESIGN
48 REFERENCES: 832dvapl.doc
49
50 ALGORITHM: Returns category_id (NUMBER) if found; NULL otherwise.
51
52 NOTES:
53
54 OPEN ISSUES:
55
56 CLOSE ISSUES:
57
58 CHANGE
59 HISTORY: Created 19-FEB-1996 SODAYAR
60
61
62 =======================================================================*/
63 FUNCTION derive_category_id(X_category IN VARCHAR2) return NUMBER;
64
65 /*==================================================================
66 FUNCTION NAME: get_default_purch_category_id()
67
68 DESCRIPTION: This API can be used to get the default category id
69 for purchasing default category set.
70
71 PARAMETERS:
72
73
74 DESIGN
75 REFERENCES: 832dfapi.doc
76
77 ALGORITHM: Returns category_id (NUMBER) if found; NULL otherwise.
78
79 NOTES:
80
81 OPEN ISSUES:
82
83 CLOSE ISSUES:
84
85 CHANGE
86 HISTORY: Created 03-Mar-1996 Rajan Odayar
87 Modified 12-MAR-1996 Daisy Yu
88
89 =======================================================================*/
90 FUNCTION get_default_purch_category_id RETURN NUMBER;
91
92 /*==================================================================
93 FUNCTION NAME: val_item_category_id()
94
95 DESCRIPTION: This API is used to validate x_category_id specified
96 is valid and active.
97
98 PARAMETERS: x_category_id IN NUMBER,
99
100 DESIGN
101 REFERENCES: 832valapl.doc
102
103 ALGORITHM: API will return TRUE if validation succeeds, FALSE
104 otherwise;
105
106 NOTES:
107
108 OPEN ISSUES:
109
110 CLOSE ISSUES:
111
112 CHANGE
113 HISTORY: Created 19-FEB-1996 SODAYAR
114
115
116 =======================================================================*/
117 FUNCTION val_category_id (X_category_id IN NUMBER) RETURN boolean;
118
119 END PO_CATEGORIES_SV1;