PACKAGE: APPS.PJM_COMMITMENT_UTILS

Source

1 PACKAGE PJM_COMMITMENT_UTILS AS
2 /* $Header: PJMCMTUS.pls 120.1 2006/07/10 23:13:25 yliou noship $ */
3 
4 FUNCTION REQ_Type
5 ( X_Org_Id   IN NUMBER
6 , X_Subtype  IN VARCHAR2
7 ) return VARCHAR2;
8 
9 FUNCTION BOM_RESOURCE
10 ( X_resource_id IN NUMBER
11 ) return VARCHAR2;
12 
13 FUNCTION Item_Number
14 ( X_Item_Id         IN NUMBER
15 , X_Organization_Id IN NUMBER
16 ) return VARCHAR2;
17 
18 FUNCTION PO_EXP_ORG
19 ( X_org    IN NUMBER
20 , X_entity IN NUMBER
21 , X_seq    IN NUMBER
22 , X_dest   IN VARCHAR2
23 ) return NUMBER;
24 
25 FUNCTION PO_EXP_TYPE
26 ( X_org     IN NUMBER
27 , X_project IN NUMBER
28 , X_item    IN NUMBER
29 , X_res     IN NUMBER
30 , X_dest    IN VARCHAR2
31 ) return VARCHAR2;
32 
33 FUNCTION PO_TASK_ID
34 ( X_org     IN NUMBER
35 , X_project IN NUMBER
36 , X_dest    IN VARCHAR2
37 , X_item    IN NUMBER
38 , X_subinv  IN VARCHAR2
39 , X_task    IN NUMBER
40 , X_entity  IN NUMBER
41 , X_seq     IN NUMBER
42 ) return NUMBER;
43 
44 FUNCTION Uom_Conversion_Rate
45 ( X_pollookup IN VARCHAR2
46 , X_dest      IN VARCHAR2
47 , X_item      IN NUMBER
48 , X_org       IN NUMBER
49 ) return NUMBER;
50 
51 FUNCTION GET_UNIT
52 ( X_pollookup IN VARCHAR2
53 , X_dest      IN VARCHAR2
54 , X_item      IN NUMBER
55 , X_org       IN NUMBER
56 ) return VARCHAR2;
57 
58 FUNCTION GET_UOM_CODE
59 ( X_pollookup IN VARCHAR2
60 , X_dest      IN VARCHAR2
61 , X_item      IN NUMBER
62 , X_org       IN NUMBER
63 ) return VARCHAR2;
64 
65 FUNCTION GET_UOM_TL
66 ( X_pollookup IN VARCHAR2
67 , X_dest      IN VARCHAR2
68 , X_item      IN NUMBER
69 , X_org       IN NUMBER
70 ) return VARCHAR2;
71 
72 FUNCTION Vendor_Name
73 ( X_Vendor_Id  IN NUMBER
74 ) return VARCHAR2;
75 
76 FUNCTION People_Name
77 ( X_Person_Id IN NUMBER
78 ) return VARCHAR2;
79 
80 FUNCTION PO_Type
81 ( X_Org_Id   IN NUMBER
82 , X_Subtype  IN VARCHAR2
83 ) RETURN VARCHAR2;
84 
85 FUNCTION PO_PROJECT_ID
86 ( X_Org_ID         IN    NUMBER
87 , X_Project_ID     IN    NUMBER
88 ) RETURN NUMBER;
89 
90 FUNCTION MTL_EXPENDITURE_TYPE
91 ( X_Org_ID         IN    NUMBER
92 , X_Item_ID        IN    NUMBER
93 ) RETURN VARCHAR2;
94 
95 FUNCTION RES_EXPENDITURE_TYPE
96 ( X_Resource_ID    IN    NUMBER
97 ) RETURN VARCHAR2;
98 
99 FUNCTION OSP_EXPENDITURE_TYPE
100 ( X_Org_ID         IN    NUMBER
101 , X_Project_ID     IN    NUMBER
102 , X_Resource_ID    IN    NUMBER
103 ) RETURN VARCHAR2;
104 
105 PROCEDURE CREATE_SYNONYMS;
106 
107 END PJM_COMMITMENT_UTILS;