[Home] [Help]
PACKAGE: APPS.JA_CN_PS_HRMS_EXPORT_PKG
Source
1 PACKAGE JA_CN_PS_HRMS_EXPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNPHRS.pls 120.0 2010/08/24 05:49:23 wuliu noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNPHRS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| To export department records, employee records |
13 --| and Employee Category for public sector |
14 --| |
15 --| |
16 --| PROCEDURE LIST |
17 --| PROCEDURE Add_Department_Records |
18 --| PROCEDURE Add_Employee_Records |
19 --| PROCEDURE Add_Employee_Category |
20 --| FUNCTION Get_Lookup_Meaning |
21 --| FUNCTION Get_Doc_Details |
22 --| FUNCTION Get_Parent_Org_ID |
23 --| FUNCTION Get_Cadre_Job_details |
24 --| FUNCTION Get_Tech_Post_Details |
25 --| |
26 --| |
27 --| |
28 --| HISTORY |
29 --| 13-AUG-2010 Wuhua Liu Created |
30 --+======================================================================*/
31 GV_MODULE_PREFIX VARCHAR2(30) := 'JA_CN_PS_HRMS_EXPORT_PKG';
32 --==========================================================================
33 -- PROCEDURE NAME:
34 --
35 -- Add_Department_Records Public
36 --
37 -- DESCRIPTION:
38 --
39 -- This procedure is to export department records
40 --
41 -- PARAMETERS:
42 -- In: pn_legal_entity_id NUMBER identifier of legal entity
43 -- pn_ledger_id NUMBER identifier of ledger
44 -- pv_accounting_year VARCHAR2 accounting year
45 --
46 -- DESIGN REFERENCES:
47 -- TDD_1213_FIN_GL_P_CNAOV2_SI.doc
48 --
49 -- CHANGE HISTORY:
50 -- 13-AUG-2010 Wuhua Liu created
51 --==========================================================================
52
53 PROCEDURE Add_Department_Records
54 ( pn_legal_entity_id IN NUMBER
55 , pn_ledger_id IN NUMBER
56 , pv_accounting_year IN VARCHAR2
57 );
58
59 --==========================================================================
60 -- PROCEDURE NAME:
61 --
62 -- Add_Employee_Records Public
63 --
64 -- DESCRIPTION:
65 --
66 -- This procedure is to export employee records
67 --
68 -- PARAMETERS:
69 -- In: pn_legal_entity_id NUMBER identifier of legal entity
70 -- pn_ledger_id NUMBER identifier of ledger
71 -- pv_accounting_year VARCHAR2 accounting year
72 --
73 -- DESIGN REFERENCES:
74 -- TDD_1213_FIN_GL_P_CNAOV2_SI.doc
75 --
76 -- CHANGE HISTORY:
77 -- 13-Aug-2010 Wuhua Liu created
78 --==========================================================================
79
80 PROCEDURE Add_Employee_Records
81 ( pn_legal_entity_id IN NUMBER
82 , pn_ledger_id IN NUMBER
83 , pv_accounting_year IN VARCHAR2
84 );
85
86 --==========================================================================
87 -- PROCEDURE NAME:
88 --
89 -- Add_Employee_Category Public
90 --
91 -- DESCRIPTION:
92 --
93 -- This procedure is to export employee Category
94 --
95 -- PARAMETERS:
96 -- In: pn_legal_entity_id NUMBER identifier of legal entity
97 -- pn_ledger_id NUMBER identifier of ledger
98 -- pv_accounting_year VARCHAR2 accounting year
99 --
100 -- DESIGN REFERENCES:
101 -- TDD_1213_FIN_GL_P_CNAOV2_SI.doc
102 --
103 -- CHANGE HISTORY:
104 -- 13-Aug-2010 Wuhua Liu created
105 --==========================================================================
106
107 PROCEDURE Add_Employee_Category
108 ( pn_legal_entity_id IN NUMBER
109 , pn_ledger_id IN NUMBER
110 , pv_accounting_year IN VARCHAR2
111 );
112 END JA_CN_PS_HRMS_EXPORT_PKG;
113