1 package PJM_INQUIRY as
2 /* $Header: PJMWINQS.pls 120.4 2006/08/08 20:08:33 yliou noship $ */
3
4 FUNCTION get_req_total
5 (p_header_id number
6 ) return number;
7
8 FUNCTION BR_Type
9 ( X_Org_Id IN NUMBER
10 , X_Sybtype IN VARCHAR2
11 ) return VARCHAR2;
12
13 FUNCTION Vendor_Contact
14 ( X_Contact_Id IN NUMBER
15 ) return VARCHAR2;
16
17 FUNCTION OE_Lookup
18 ( X_Lookup_Code IN VARCHAR2
19 , X_Lookup_Type IN VARCHAR2
20 ) return VARCHAR2;
21
22 FUNCTION Item_Number
23 ( X_Item_Id IN NUMBER
24 , X_Organization_Id IN NUMBER
25 ) return VARCHAR2;
26
27 FUNCTION Payment_Term
28 ( X_Term_Id IN NUMBER
29 ) return VARCHAR2;
30
31 FUNCTION People_Name
32 ( X_Person_Id IN NUMBER
33 ) return VARCHAR2;
34
35 FUNCTION Get_Lookup
36 ( X_Lookup_Code IN VARCHAR2
37 , X_Lookup_Type IN VARCHAR2
38 ) return VARCHAR2;
39
40 FUNCTION Location_Code
41 ( X_Location_Id IN NUMBER
42 ) return VARCHAR2;
43
44 FUNCTION Vendor_Site
45 ( X_Vendor_Id IN NUMBER
46 , X_Vendor_Site_Id IN NUMBER
47 ) return VARCHAR2;
48
49 FUNCTION Vendor_Name
50 ( X_Vendor_Id IN NUMBER
51 ) return VARCHAR2;
52
53 FUNCTION PO_Type
54 ( X_Org_Id IN NUMBER
55 ) return VARCHAR2;
56
57 function OE_ORDER_TOTAL
58 ( X_Header_ID IN NUMBER
59 ) return number;
60
61 function OE_ORG_ADDRESS
62 ( X_Org_ID IN NUMBER
63 , X_Org_Type IN VARCHAR2
64 ) return varchar2;
65
66 function YES_NO
67 ( X_Lookup_Code IN VARCHAR2
68 ) return varchar2;
69
70 function SYS_YES_NO
71 ( X_Lookup_Code IN NUMBER
72 ) return varchar2;
73
74 function LOCATOR_CONTROL
75 ( X_Lookup_Code IN NUMBER
76 ) return varchar2;
77
78 function COMPONENT_SERIAL
79 ( X_Organization_ID IN NUMBER
80 , X_Wip_Entity_ID IN NUMBER
81 , X_Op_Seq_Num IN NUMBER
82 , X_Item_ID IN NUMBER
83 ) return varchar2;
84
85 function TRANSACTION_SOURCE_NAME
86 ( X_Trx_Src_Type_ID IN NUMBER
87 , X_Trx_Source_ID IN NUMBER
88 ) return varchar2;
89
90 end PJM_INQUIRY;