PACKAGE: APPS.PER_PERRPRAS_XMLP_PKG

Source

1 PACKAGE PER_PERRPRAS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERRPRASS.pls 120.1 2007/12/06 11:31:52 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	P_SESSION_DATE1 varchar2(240);
6 	P_CONC_REQUEST_ID	number;
7 	P_PERSON_TYPE	varchar2(30);
8 	P_PEOPLE_GROUP_FLEX_ID	number;
9 	P_PEOPLE_GROUP_ID	varchar2(240);
10 	P_JOB_ID	number;
11 	P_POSITION_ID	number;
12 	P_PAYROLL_ID	number;
13 	P_PRIMARY_FLAG	varchar2(1);
14 	P_ASG_STATUS_TYPE_ID1	number;
15 	P_ASG_STATUS_TYPE_ID2	number;
16 	P_ASG_STATUS_TYPE_ID3	number;
17 	P_ASG_STATUS_TYPE_ID4	number;
18 	P_LEGISLATION_CODE	varchar2(2);
19 	P_GRADE_ID	number;
20 	--P_MATCHING_CRITERIA	varchar2(400);
21 	P_MATCHING_CRITERIA	varchar2(400) := 'AND 1=1';
22 	P_STATUS_MATCHING	varchar2(240);
23 	P_ORGANIZATION_STRUCTURE_ID	number;
24 	P_ORG_STRUCTURE_VERSION_ID	number;
25 	P_PARENT_ORGANIZATION_ID	number;
26 	--P_ORG_MATCHING	varchar2(400);
27 	P_ORG_MATCHING	varchar2(400) := ' ';
28 	P_APL_ORDER	varchar2(240);
29 	P_EMP_ORDER	varchar2(240);
30 	--P_JOB_MATCHING	varchar2(80);
31 	P_JOB_MATCHING	varchar2(80) := ' ';
32 	--P_POSITION_MATCHING	varchar2(80);
33 	P_POSITION_MATCHING	varchar2(80) := ' ';
34 	--P_GRADE_MATCHING	varchar2(80);
35 	P_GRADE_MATCHING	varchar2(80) := ' ';
36 	--P_PAYROLL_MATCHING	varchar2(80);
37 	P_PAYROLL_MATCHING	varchar2(80) := ' ';
38 	C_BUSINESS_GROUP_NAME	varchar2(240);
39 	C_REPORT_SUBTITLE	varchar2(60);
40 	C_PERSON_TYPE_DESC	varchar2(80);
41 	C_JOB_DESC	varchar2(240);
42 	C_POSITION_DESC	varchar2(240);
43 	C_GRADE_DESC	varchar2(240);
44 	C_PAYROLL_DESC	varchar2(80);
45 	C_PRIMARY_FLAG_DESC	varchar2(30);
46 	C_ASG_STATUS_DESC1	varchar2(100);
47 	C_ASG_STATUS_DESC2	varchar2(100);
48 	C_ASG_STATUS_DESC3	varchar2(100);
49 	C_ASG_STATUS_DESC4	varchar2(100);
50 	C_ORG_STRUCTURE_DESC	varchar2(80);
51 	C_ORG_STRUCTURE_VERSION_DESC	number;
52 	C_VERSION_FROM_DESC	date;
53 	C_VERSION_TO_DESC	date;
54 	C_ORGANIZATION_DESC	varchar2(240);
55 	C_STATUS_LIST	varchar2(500);
56 	C_SESSION_DATE	date;
57 	--C_GLOBAL_HIERARCHY	varchar2(80) := := 'Global Organization Hierarchy' ;
58 	C_GLOBAL_HIERARCHY	varchar2(80) := 'Global Organization Hierarchy' ;
59 	--added
60 	p_status_matching_1 varchar2(240);
61 	function BeforeReport return boolean  ;
62 	function c_status_start_dateformula(p_assignment_id in number, p_assignment_status_type_id in number) return date  ;
63 	function c_status_end_dateformula(p_assignment_id in number, p_assignment_status_type_id in number) return date  ;
64 	function AfterReport return boolean  ;
65 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
66 	Function C_REPORT_SUBTITLE_p return varchar2;
67 	Function C_PERSON_TYPE_DESC_p return varchar2;
68 	Function C_JOB_DESC_p return varchar2;
69 	Function C_POSITION_DESC_p return varchar2;
70 	Function C_GRADE_DESC_p return varchar2;
71 	Function C_PAYROLL_DESC_p return varchar2;
72 	Function C_PRIMARY_FLAG_DESC_p return varchar2;
73 	Function C_ASG_STATUS_DESC1_p return varchar2;
74 	Function C_ASG_STATUS_DESC2_p return varchar2;
75 	Function C_ASG_STATUS_DESC3_p return varchar2;
76 	Function C_ASG_STATUS_DESC4_p return varchar2;
77 	Function C_ORG_STRUCTURE_DESC_p return varchar2;
78 	Function C_ORG_STRUCTURE_VERSION_DESC_p return number;
79 	Function C_VERSION_FROM_DESC_p return date;
80 	Function C_VERSION_TO_DESC_p return date;
81 	Function C_ORGANIZATION_DESC_p return varchar2;
82 	Function C_STATUS_LIST_p return varchar2;
83 	Function C_SESSION_DATE_p return date;
84 	Function C_GLOBAL_HIERARCHY_p return varchar2;
85 END PER_PERRPRAS_XMLP_PKG;