1 package PAY_ASG_LINK_USAGES_PKG as
2 /* $Header: pyalu.pkh 120.0.12000000.2 2007/02/28 10:44:26 swinton ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Assignment Link Usages Table Handler
13 Purpose
14 To handle DML on the Assignment Link Usages table
15 History
16 16-MAR-1994 N Simpson Created
17 40.2 04-OCT-1994 R Fine Renamed package to start with PAY_
18 115.1 05-SEP-2006 T Habara Added create_alu_asg.
19 115.2 23-FEB-2007 S Winton Added rebuild_alus.
20 115.3 28-FEB-2007 S Winton Doing checkin to propagate changes onto
21 R12 mainline and branch.
22 */
23 --------------------------------------------------------------------------------
24 --
25 -- Global types
26 --
27 type t_pg_link_rec is record
28 (people_group_id number
29 ,element_link_id number
30 ,effective_start_date date
31 ,effective_end_date date
32 );
33 --
34 type t_pg_link_tab is table of t_pg_link_rec
35 index by binary_integer;
36
37 --------------------------------------------------------------------------------
38 procedure INSERT_ALU (
39 --
40 --******************************************************************************
41 --* Inserts Assignment Link Usages for a new element link. *
42 --******************************************************************************
43 --
44 p_business_group_id number,
45 p_people_group_id number,
46 p_element_link_id number,
47 p_effective_start_date date,
48 p_effective_end_date date);
49 --------------------------------------------------------------------------------
50 procedure CASCADE_LINK_DELETION (
51 --
52 --******************************************************************************
53 --* Deletes ALUs for a deleted link. *
54 --******************************************************************************
55 --
56 p_element_link_id number,
57 p_business_group_id number,
58 p_people_group_id number,
59 p_delete_mode varchar2,
60 p_effective_start_date date,
61 p_effective_end_date date,
62 p_validation_start_date date,
63 p_validation_end_date date );
64 --------------------------------------------------------------------------------
65 procedure create_alu_asg
66 --
67 --******************************************************************************
68 --* Creates ALUs for an assignment with the specified element links. *
69 --******************************************************************************
70 --
71 (p_assignment_id in number
72 ,p_pg_link_tab in t_pg_link_tab
73 );
74 --------------------------------------------------------------------------------
75 procedure rebuild_alus
76 --
77 --******************************************************************************
78 --* Name : rebuild_alus *
79 --* Purpose : This procedure rebuilds all ALUs for a given assignment id *
80 --* and is used by the Generic Upgrade Mechanism. *
81 --******************************************************************************
82 --
83 (p_assignment_id in number);
84 --------------------------------------------------------------------------------
85
86 end PAY_ASG_LINK_USAGES_PKG;