[Home] [Help]
PACKAGE: APPS.PAY_LINK_INPUT_VALUES_PKG
Source
1 package PAY_LINK_INPUT_VALUES_PKG AUTHID CURRENT_USER as
2 /* $Header: pyliv.pkh 115.0 99/07/17 06:15:50 porting ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name
11 Link Input Values Table Handler
12 Purpose
13 To interface with the entity while maintaining its data integrity
14 History
15
16 27 Jan 94 N Simpson Created */
17 --------------------------------------------------------------------------------
18 procedure DELETE_ROW (x_rowid varchar2);
19 --------------------------------------------------------------------------------
20 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
21 X_Link_Input_Value_Id NUMBER,
22 X_Effective_Start_Date DATE,
23 X_Effective_End_Date DATE,
24 X_Element_Link_Id NUMBER,
25 X_Input_Value_Id NUMBER,
26 X_Costed_Flag VARCHAR2,
27 X_Default_Value VARCHAR2,
28 X_Max_Value VARCHAR2,
29 X_Min_Value VARCHAR2,
30 X_Warning_Or_Error VARCHAR2);
31 --------------------------------------------------------------------------------
32 PROCEDURE Update_Row(X_Rowid VARCHAR2,
33 X_Link_Input_Value_Id NUMBER,
34 X_Effective_Start_Date DATE,
35 X_Effective_End_Date DATE,
36 X_Element_Link_Id NUMBER,
37 X_Input_Value_Id NUMBER,
38 X_Costed_Flag VARCHAR2,
39 X_Default_Value VARCHAR2,
40 X_Max_Value VARCHAR2,
41 X_Min_Value VARCHAR2,
42 X_Warning_Or_Error VARCHAR2);
43 --------------------------------------------------------------------------------
44 procedure CREATE_LINK_INPUT_VALUE(
45 --
46 --******************************************************************************
47 --* Creates link input values for a new link.
48 --******************************************************************************
49 --
50 p_element_link_id number,
51 p_costable_type varchar2,
52 p_effective_start_date date,
53 p_effective_end_date date,
54 p_element_type_id number);
55 --------------------------------------------------------------------------------
56 procedure CREATE_LINK_INPUT_VALUE (
57 --
58 --******************************************************************************
59 --* Creates link input values for existing links when a new input value is *
60 --* created at the type level. *
61 --******************************************************************************
62 --
63 p_input_value_id number,
64 p_element_type_id number,
65 p_effective_start_date date,
66 p_effective_end_date date,
67 p_name varchar2,
68 p_hot_default_flag varchar2,
69 p_default_value varchar2,
70 p_min_value varchar2,
71 p_max_value varchar2,
72 p_warning_or_error varchar2);
73 --------------------------------------------------------------------------------
74 procedure CHECK_REQUIRED_DEFAULTS (
75 --
76 p_element_link_id number,
77 p_session_date date);
78 --------------------------------------------------------------------------------
79 function NO_DEFAULT_AT_TYPE (
80 --
81 --******************************************************************************
82 --* Returns TRUE if there is no default value specified at the element type *
83 --******************************************************************************
84 --
85 -- Parameters are:
86 --
87 p_input_value_id number,
88 p_effective_start_date date,
89 p_effective_end_date date,
90 p_error_if_true boolean default FALSE ) return boolean;
91 --------------------------------------------------------------------------------
92 procedure PARENT_DELETED (
93 --
94 --******************************************************************************
95 --* Handles the case when any row referenced by a foreign key of the base *
96 --* is deleted (in whatever Date Track mode). ie If a parent record is zapped *
97 --* then the deletion is cascaded; if it is date-effectively deleted, then the *
98 --* rows referencing it are updated to have the same end-date. *
99 --******************************************************************************
100 --
101 -- Parameters to be passed in are:
102 --
103 p_parent_id number,-- The foreign key for the deleted parent
104 p_session_date date default trunc (sysdate),
105 p_validation_start_date date,
106 p_validation_end_date date,
107 p_delete_mode varchar2,
108 p_parent_name varchar2 );
109 --------------------------------------------------------------------------------
110 function LINK_END_DATE (p_link_id number) return date;
111 --
112 --******************************************************************************
113 --* Returns the end date of the Link.
114 --******************************************************************************
115 --------------------------------------------------------------------------------
116 end PAY_LINK_INPUT_VALUES_PKG;