1 PACKAGE PJM_TRANSFER_CHARGES_PKG AUTHID CURRENT_USER AS
2 /* $Header: PJMTFCGS.pls 120.1.12020000.2 2012/07/25 20:33:22 yaoli ship $ */
3
4 -- Start of comments
5 -- API name : Batch_Name
6 -- Type : Public
7 -- Pre-reqs : None.
8 -- Function : Get the batch name for the batch process
9 -- Parameters :
10 -- IN : N/A
11 -- Version : Current version 1.0
12 -- Previous version 1.0
13 -- Initial version 1.0
14 -- End of comments
15
16 Function Batch_Name return varchar2;
17
18 -- Start of comments
19 -- API name : Get_Charges_Expenditure_Type
20 -- Type : Public
21 -- Pre-reqs : None.
22 -- Function : Get the expenture type for IPV,ERV and special
23 -- : charges
24 -- Parameters :
25 -- IN : X_Type VARCHAR2
26 -- IN : X_Project_ID NUMBER
27 -- IN : X_Org_ID NUMBER
28 -- Version : Current version 1.0
29 -- Previous version 1.0
30 -- Initial version 1.0
31 -- End of comments
32
33 Function get_charges_expenditure_type( X_Type IN VARCHAR2,
34 X_Project_Id IN NUMBER,
35 X_Org_Id IN NUMBER) return varchar2;
36
37
38 -- Start of comments
39 -- API name : Transfer_Charges_To_PA
40 -- Type : Public
41 -- Pre-reqs : None.
42 -- Function : Get the expenditure and costing data from invoice
43 -- : distributions which has amount for IPV, ERV and
44 -- : special charges, and the destination type is
45 -- : INVENTORY or SHOP FLOOR, then push data to PA
46 -- Parameters :
47 -- IN : X_Project_ID NUMBER
48 -- IN : X_Start_Date DATE
49 -- IN : X_End_Date DATE
50 -- IN : X_Submit_Trx_Import VARCHAR2
51 -- IN : X_Trx_Status_Code VARCHAR2
52 -- OUT : ERRBUF NUMBER
53 -- OUT : RETCODE NUMBER
54 -- Version : Current version 1.0
55 -- Previous version 1.0
56 -- Initial version 1.0
57 -- End of comments
58
59 PROCEDURE Transfer_Charges_to_PA
60 ( ERRBUF OUT NOCOPY VARCHAR2
61 , RETCODE OUT NOCOPY NUMBER
62 , X_Project_Id IN NUMBER
63 , X_Start_Date IN VARCHAR2
64 , X_End_Date IN VARCHAR2
65 , X_Submit_Trx_Import IN VARCHAR2
66 , X_Trx_Status_Code IN VARCHAR2
67 , X_Exp_Type_Bsd_On_Pur_Ctgy IN VARCHAR2 DEFAULT 'N' -- bug fix 12835119(FP of 7372638)
68 );
69
70 -- bug fix 12835119(FP of 7372638)
71 FUNCTION get_ExpType_for_DirectItem
72 ( P_Invoice_ID IN NUMBER
73 , P_PO_category_id IN NUMBER) RETURN VARCHAR2;
74 -- bug fix 12835119(FP of 7372638)
75
76 END PJM_TRANSFER_CHARGES_PKG;
[Home] [Help]