1 PACKAGE PA_TRANS_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PATRUTLS.pls 115.3 2003/02/14 07:21:27 riyengar noship $
3 /* This api validates the actuals (EI) exists for the given assignment_id
4 * when assignment dates are modified / updated /inserted/ deleted
5 * if the EI exists for the given assignment and transaction date not
6 * falling between current start and end dates of the assignments OR
7 * if the transaction date doesnot falls between the new assignment start and end dates
8 * it returns the following error message depending on the calling modes
9 * calling mode error message return_status
10 * ---------------------------------------------------------------------------
11 * CANCEL / DELETE PA_EI_ASSGN_EXISTS E
12 * UPDATE / INSERT PA_EI_ASSGN_DATE_OUTOFRANGE E
13 * PA_EI_ASSGN_INVALID_PARAMS E
14 * If success then x_return_status is 'S' and x_error_message_code will be null
15 *
16 */
17 PROCEDURE check_txn_exists (p_assignment_id IN NUMBER
18 ,p_old_start_date IN DATE
19 ,p_old_end_date IN DATE
20 ,p_new_start_date IN DATE
21 ,p_new_end_date IN DATE
22 ,p_calling_mode IN VARCHAR2 default 'CANCEL'
23 ,p_project_id IN NUMBER
24 ,p_person_id IN NUMBER
25 ,x_error_message_code OUT NOCOPY VARCHAR2
26 ,x_return_status OUT NOCOPY VARCHAR2 );
27
28 END PA_TRANS_UTILS;