DBA Data[Home] [Help]

PACKAGE: APPS.BEN_BENEFIT_CONTRIBUTIONS_PKG

Source


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;