1 PACKAGE PER_US_ASG_EXT_INFO_CHK AS
2 /* $Header: peuseitd.pkh 120.0 2005/05/31 22:37:11 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : PER_US_ASG_EXT_INFO_CHK
21
22 Description : This package checks for unique combination of state and involuntary
23 deduction category entered from EIT. This package is called by
24 before process hooks of create_assignment_extra_info and
25 update_assignment_extra_info APIs.
26
27 Change List
28 -----------
29 Date Name Vers Bug No Description
30 ----------- ---------- ------ ------- -------------------------------
31 26-MAY-2004 sdahiya 115.0 Created.
32 *****************************************************************************/
33
34 /*******************************************************************************
35 Name : chk_dup_proration_ins
36 Purpose : This procedure checks for unique combination of state and involuntary
37 deduction category while inserting assignment EIT records.
38 *******************************************************************************/
39
40 PROCEDURE CHK_DUP_PRORATION_INS(
41 p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
42 p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
43 p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
44 p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
45 );
46
47
48 /*******************************************************************************
49 Name : chk_dup_proration_upd
50 Purpose : This procedure checks for unique combination of state and involuntary
51 deduction category while updating assignment EIT records.
52 *******************************************************************************/
53
54 PROCEDURE CHK_DUP_PRORATION_UPD(
55 p_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE,
56 p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
57 p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
58 p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
59 );
60
61 GLB_MODE varchar2(10);
62 GLB_ASG_EXTRA_INFO_ID per_assignment_extra_info.assignment_extra_info_id%type;
63
64 END PER_US_ASG_EXT_INFO_CHK;