1 PACKAGE INV_MEANING_SEL AUTHID CURRENT_USER as
2 /* $Header: INVRPTMS.pls 120.0.12010000.2 2010/02/26 01:38:22 qyou ship $ */
3
4 FUNCTION C_MFG_LOOKUP(lookup_code_val number,lookup_type_val varchar2) RETURN varchar2;
5
6 FUNCTION C_UNIT_MEASURE(uom_code_val in varchar2) RETURN varchar2;
7
8 FUNCTION C_PO_UN_NUMB(un_number_val in number) RETURN varchar2;
9
10 FUNCTION C_PO_HAZARD_CLASS(hazard_val in number) RETURN varchar2;
11
12 FUNCTION C_PER_PEOPLE(person_id_val in number) RETURN varchar2;
13
14 FUNCTION C_LOOKUPS(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2;
15
16 FUNCTION C_PICK_RULES(pick_id_val in number) RETURN varchar2;
17
18 FUNCTION C_ATP_RULES(atp_id_val in number) RETURN varchar2;
19
20 FUNCTION C_ORG_NAME(org_id_val in number) RETURN VARCHAR2;
21
22 FUNCTION C_RA_RULES(rule_id_val in NUMBER) RETURN varchar2;
23
24 FUNCTION C_FND_LOOKUP_VL(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2;
25
26 FUNCTION C_RA_TERMS(term_id_val in NUMBER) RETURN varchar2;
27
28 FUNCTION C_PO_LOOKUP(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2;
29
30 FUNCTION C_FND_LOOKUP(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2;
31
32 FUNCTION C_LOT_LOOKUP(status_id_val in Number) RETURN varchar2;
33
34 FUNCTION C_SERIAL_LOOKUP(status_id_val in Number) RETURN varchar2;
35
36 FUNCTION C_UNITMEASURE(uom_code_val in Varchar2) RETURN varchar2;
37
38 FUNCTION C_FNDCOMMON(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2;
39
40 FUNCTION C_QTY_ON_HAND(Item_Id in Number,Org_Id in Number , Sub_Code in Varchar2, Break_Id in Number) RETURN Number;
41
42 FUNCTION C_ITEM_DESCRIPTION(Item_Id in Number , Org_Id in Number) RETURN varchar2;
43
44 FUNCTION C_ITEM_REV_DESCRIPTION(Item_Id in Number , Org_Id in Number , Rev_Id in Number) RETURN varchar2;
45
46 FUNCTION C_OE_LOOKUP(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2;
47
48 FUNCTION C_COVERAGE_SCHEDULE(COVERAGE_SCHEDULE_ID NUMBER) RETURN VARCHAR2;
49
50 FUNCTION C_ITEM_STATUS (status_code_val in varchar2) RETURN VARCHAR2; --Bug: 1968090
51
52 FUNCTION C_DEFAULT_MATERIAL_STATUS (status_code_val in varchar2) RETURN
53 VARCHAR2; --Bug: 8762354
54
55 END INV_MEANING_SEL;