228: PROCEDURE VALIDATE_ASSIGNMENT_DATES_BULK
229: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
230: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
231: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
232: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
233: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
234: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
235: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
236:
229: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
230: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
231: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
232: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
233: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
234: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
235: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
236:
237: /* NISINHA Updatable Scheduled people ER */
230: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
231: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
232: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
233: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
234: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
235: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
236:
237: /* NISINHA Updatable Scheduled people ER */
238:
231: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
232: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
233: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
234: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
235: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
236:
237: /* NISINHA Updatable Scheduled people ER */
238:
239:
242: PROCEDURE Validate_Resource_Dates_Bulk
243: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
244: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
245: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
246: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
247: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
248: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
249: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
250:
243: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
244: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
245: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
246: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
247: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
248: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
249: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
250:
251: /* PRABSING Bug 7693634 Start */
244: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
245: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
246: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
247: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
248: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
249: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
250:
251: /* PRABSING Bug 7693634 Start */
252:
245: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
246: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
247: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
248: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
249: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
250:
251: /* PRABSING Bug 7693634 Start */
252:
253: PROCEDURE Validate_Template_Team_Dates