1 package PJM_INQUIRY AUTHID CURRENT_USER as
2 /* $Header: PJMWINQS.pls 120.5.12020000.1 2012/06/27 22:04:17 appldev ship $ */
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 x_project_id IN NUMBER DEFAULT NULL,
60 x_task_id IN NUMBER DEFAULT NULL,
61 x_line_id IN NUMBER DEFAULT NULL
62 ) return number;
63
64 function OE_ORG_ADDRESS
65 ( X_Org_ID IN NUMBER
66 , X_Org_Type IN VARCHAR2
67 ) return varchar2;
68
69 function YES_NO
70 ( X_Lookup_Code IN VARCHAR2
71 ) return varchar2;
72
73 function SYS_YES_NO
74 ( X_Lookup_Code IN NUMBER
75 ) return varchar2;
76
77 function LOCATOR_CONTROL
78 ( X_Lookup_Code IN NUMBER
79 ) return varchar2;
80
81 function COMPONENT_SERIAL
82 ( X_Organization_ID IN NUMBER
83 , X_Wip_Entity_ID IN NUMBER
84 , X_Op_Seq_Num IN NUMBER
85 , X_Item_ID IN NUMBER
86 ) return varchar2;
87
88 function TRANSACTION_SOURCE_NAME
89 ( X_Trx_Src_Type_ID IN NUMBER
90 , X_Trx_Source_ID IN NUMBER
91 ) return varchar2;
92
93 end PJM_INQUIRY;