[Home] [Help]
PACKAGE: APPS.PER_PERRPRAS_XMLP_PKG
Source
1 PACKAGE PER_PERRPRAS_XMLP_PKG 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;