1 package BEN_BENEFIT_CONTRIBUTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pybco.pkh 115.0 99/07/17 05:45:30 porting ship $ */
3 ------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved |
9 +==============================================================================+
10
11 Name
12 Benefit Contributions Table Handler
13 Purpose
14 To interface with the Benefit Contributions entity and maintain its
15 integrity
16 History
17 27 Jan 94 N Simpson Created
18 */
19 --------------------------------------------------------------------------------
20 procedure PARENT_DELETED (
21 --
22 --***************************************************************************
23 --* Handles the case when a referenced master entity has one of its records *
24 --* deleted or shut down *
25 --***************************************************************************
26 --
27 -- Parameters are:
28 --
29 -- Identifier of parent record
30 p_parent_id number,
31 --
32 -- Date Track deletion mode
33 p_delete_mode varchar2 default 'DELETE',
34 --
35 -- Effective date
36 p_session_date date default trunc(sysdate),
37 --
38 -- Name of parent entity from which a deletion has been made
39 p_parent_name varchar2
40 --
41 );
42 --------------------------------------------------------------------------------
43 end BEN_BENEFIT_CONTRIBUTIONS_PKG;