1 PACKAGE PA_R_PROJECT_RESOURCES_PVT
2 -- $Header: PARCPRVS.pls 120.3 2006/11/09 09:02:07 msachan noship $
3 AS
4
5 --Global Variables
6 G_user_id NUMBER := fnd_profile.value('USER_ID');
7 G_login_id NUMBER := fnd_profile.value('LOGIN_ID');
8 G_request_id NUMBER := fnd_global.conc_request_id;
9 G_program_id NUMBER := fnd_global.conc_program_id;
10 G_application_id NUMBER := fnd_global.prog_appl_id;
11
12 PROCEDURE INSERT_INTO_CRM(
13 P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
14 P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
15 P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
16 P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
17 P_ASSIGNMENT_START_DATE IN DATE,
18 P_ASSIGNMENT_END_DATE IN DATE,
19 P_CALENDAR_ID IN NUMBER,
20 P_COUNT IN NUMBER,
21 X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
22 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23 P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24 P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25 P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26 P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27 P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28 P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29 P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30 P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31 P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32 P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33 P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34 P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35 P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36 P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37 P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38 P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39 P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
40 P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
41 P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;
42
43 PROCEDURE INSERT_INTO_PA(
44 P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
45 P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
46 X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
47 P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
48 P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49 P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
50 PERSON_ID%TYPE DEFAULT NULL,
51 P_NAME IN PA_RESOURCES.NAME%TYPE,
52 P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
53 PARTY_ID%TYPE DEFAULT NULL,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
55
56 PROCEDURE CHECK_OU(
57 P_DEFAULT_OU IN PA_RESOURCES_DENORM.RESOURCE_ORG_ID%TYPE,
58 P_EXP_ORG IN VARCHAR2,
59 X_EXP_OU OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
61
62
63 PROCEDURE CREATE_INTERNAL_RESOURCE(
64 P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,
65 P_NAME IN PA_RESOURCES.NAME%TYPE,
66 P_ORGANIZATION_ID IN PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
67 P_ASSIGNMENT_START_DATE IN DATE,
68 P_ASSIGNMENT_END_DATE IN DATE,
69 P_START_DATE IN DATE,
70 P_DEFAULT_OU IN NUMBER,
71 P_CALENDAR_ID IN NUMBER,
72 P_SYSTEM_TYPE IN PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE,
73 P_USER_TYPE IN PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE,
74 P_RES_EXISTS IN VARCHAR2,
75 P_COUNT IN NUMBER,
76 P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
77 X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
78 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79 P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80 P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81 P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82 P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83 P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84 P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85 P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86 P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87 P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88 P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89 P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90 P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91 P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92 P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93 P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94 P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95 P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
96 P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
97 P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);
98
99 PROCEDURE CREATE_RESOURCE(
100 P_COMMIT IN VARCHAR2,
101 P_VALIDATE_ONLY IN VARCHAR2,
102 P_INTERNAL IN VARCHAR2,
103 P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,
104 P_INDIVIDUAL IN VARCHAR2,
105 P_CHECK_RESOURCE IN VARCHAR2,
106 P_SCHEDULED_MEMBER_FLAG IN VARCHAR2,
107 P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
108 P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE,
109 P_FROM_EMP_NUM IN VARCHAR2,
110 P_TO_EMP_NUM IN VARCHAR2,
111 P_ORGANIZATION_ID IN NUMBER,
112 P_REFRESH IN VARCHAR2,
113 P_PULL_TERM_RES IN VARCHAR2 DEFAULT 'N',
114 P_TERM_RANGE_DATE IN DATE DEFAULT NULL,
115 P_PERSON_TYPE IN VARCHAR2 DEFAULT 'ALL',
116 P_START_DATE IN DATE DEFAULT NULL, -- Bug 5337454
117 -- Added parameters for PJR Resource Pull Enhancements - Bug 5130414
118 P_SELECTION_OPTION IN VARCHAR2 DEFAULT NULL,
119 P_ORG_STR_VERSION_ID IN NUMBER DEFAULT NULL,
120 P_START_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
121 -- End of parameters added for PJR Resource Pull Enhancements - Bug 5130414
122 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123 X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE); --File.Sql.39 bug 4440895
124
125 PROCEDURE create_future_crm_resource
126 (itemtype IN VARCHAR2
127 , itemkey IN VARCHAR2
128 , actid IN NUMBER
129 , funcmode IN VARCHAR2
130 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131 );
132
133 END PA_R_PROJECT_RESOURCES_PVT;