PACKAGE: APPS.PJM_COMMITMENT_UTILS

Source

1 PACKAGE PJM_COMMITMENT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PJMCMTUS.pls 120.2 2011/04/26 22:05:26 yaoli ship $ */
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 , x_category_id IN NUMBER DEFAULT NULL  /*Bug 10370776 - transfer project invoice charges (r12) - the expenditure type is not correct. Added one new parameter for purchase category*/
32 ) return VARCHAR2;
33 
34 FUNCTION PO_TASK_ID
35 ( X_org     IN NUMBER
36 , X_project IN NUMBER
37 , X_dest    IN VARCHAR2
38 , X_item    IN NUMBER
39 , X_subinv  IN VARCHAR2
40 , X_task    IN NUMBER
41 , X_entity  IN NUMBER
42 , X_seq     IN NUMBER
43 ) return NUMBER;
44 
45 FUNCTION Uom_Conversion_Rate
46 ( X_pollookup IN VARCHAR2
47 , X_dest      IN VARCHAR2
48 , X_item      IN NUMBER
49 , X_org       IN NUMBER
50 ) return NUMBER;
51 
52 FUNCTION GET_UNIT
53 ( X_pollookup IN VARCHAR2
54 , X_dest      IN VARCHAR2
55 , X_item      IN NUMBER
56 , X_org       IN NUMBER
57 ) return VARCHAR2;
58 
59 FUNCTION GET_UOM_CODE
60 ( X_pollookup IN VARCHAR2
61 , X_dest      IN VARCHAR2
62 , X_item      IN NUMBER
63 , X_org       IN NUMBER
64 ) return VARCHAR2;
65 
66 FUNCTION GET_UOM_TL
67 ( X_pollookup IN VARCHAR2
68 , X_dest      IN VARCHAR2
69 , X_item      IN NUMBER
70 , X_org       IN NUMBER
71 ) return VARCHAR2;
72 
73 FUNCTION Vendor_Name
74 ( X_Vendor_Id  IN NUMBER
75 ) return VARCHAR2;
76 
77 FUNCTION People_Name
78 ( X_Person_Id IN NUMBER
79 ) return VARCHAR2;
80 
81 FUNCTION PO_Type
82 ( X_Org_Id   IN NUMBER
83 , X_Subtype  IN VARCHAR2
84 ) RETURN VARCHAR2;
85 
86 FUNCTION PO_PROJECT_ID
87 ( X_Org_ID         IN    NUMBER
88 , X_Project_ID     IN    NUMBER
89 ) RETURN NUMBER;
90 
91 FUNCTION MTL_EXPENDITURE_TYPE
92 ( X_Org_ID         IN    NUMBER
93 , X_Item_ID        IN    NUMBER
94 ) RETURN VARCHAR2;
95 
96 FUNCTION RES_EXPENDITURE_TYPE
97 ( X_Resource_ID    IN    NUMBER
98 ) RETURN VARCHAR2;
99 
100 FUNCTION OSP_EXPENDITURE_TYPE
101 ( X_Org_ID         IN    NUMBER
102 , X_Project_ID     IN    NUMBER
103 , X_Resource_ID    IN    NUMBER
104 , x_category_id IN NUMBER DEFAULT NULL  /*Bug 10370776 - transfer project invoice charges (r12) - the expenditure type is not correct. Added one new parameter for purchase category*/
105 ) RETURN VARCHAR2;
106 
107 PROCEDURE CREATE_SYNONYMS;
108 
109 END PJM_COMMITMENT_UTILS;