1 PACKAGE JA_CN_DFF_ASSIGNMENTS_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNDFAS.pls 120.0.12000000.1 2007/08/13 14:09:31 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNDFAS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package provides table handers for |
13 --| table JA_CN_DFF_ASSIGNMENTS, these handlers |
14 --| will be called by 'DFF Assignments' form to operate data in table|
15 --| JA_CN_DFF_ASSIGNMENTS |
16 --| |
17 --| HISTORY |
18 --| 2006/03/01 Jackey Li Created |
19 --+======================================================================*/
20
21 --Declare global variable for package name
22 --G_MODULE_PREFIX VARCHAR2(50) :='ja.pl/sql.JA_CN_DFF_ASSIGNMENTS_PKG';
23
24 --==========================================================================
25 -- PROCEDURE NAME:
26 --
27 -- Insert_Row Public
28 --
29 -- DESCRIPTION:
30 --
31 -- This procedure is to insert data that are passed in by parameters into
32 -- table JA_CN_DFF_ASSIGNMENTS to create a new record
33 --
34 -- PARAMETERS:
35 -- In: p_application_id Application ID
36 -- p_dff_name Descriptive Flexfield Name
37 -- p_dff_title_code DFF title lookup code
38 -- p_context_code DFF context
39 -- p_attribute_column DFF column
40 -- p_creation_date Creation date
41 -- p_created_by Identifier of user that creates
42 -- the record
43 -- p_last_update_date Last update date of the record
44 -- p_last_updated_by Last update by
45 -- p_last_update_login Last update login
46 --
47 -- In Out: p_row_id Row id of a table record
48 --
49 --
50 -- DESIGN REFERENCES:
51 -- CNAO_DFF_ASSIGNMENT_FORM_TD.doc
52 --
53 -- CHANGE HISTORY:
54 --
55 -- 01-MAR-2006 Jackey Li created
56 -- 16-MAy-2007 yanbo liu changed
57 -- add chart_of_accounts_id column.
58 --===========================================================================
59 PROCEDURE Insert_Row(p_row_id IN OUT NOCOPY VARCHAR2
60 ,P_application_id IN NUMBER
61 ,p_dff_name IN VARCHAR2
62 ,p_dff_title_code IN VARCHAR2
63 ,p_context_code IN VARCHAR2
64 ,p_attribute_column IN VARCHAR2
65 ,p_creation_date IN DATE
66 ,p_created_by IN NUMBER
67 ,p_last_update_date IN DATE
68 ,p_last_updated_by IN NUMBER
69 ,p_last_update_login IN NUMBER
70 ,p_chart_of_accounts_id In NUMBER
71 );
72
73 --==========================================================================
74 -- PROCEDURE NAME:
75 --
76 -- Update_Row Public
77 --
78 -- DESCRIPTION:
79 --
80 -- This procedure is used to update data in table JA_CN_DFF_ASSIGNMENTS
81 -- according to parameters passed in
82 --
83 -- PARAMETERS:
84 -- In: p_application_id Application ID
85 -- p_dff_name Descriptive Flexfield Name
86 -- p_dff_title_code DFF title lookup code
87 -- p_context_code DFF context
88 -- p_attribute_column DFF column
89 -- p_creation_date Creation date
90 -- p_created_by Identifier of user that creates
91 -- the record
92 -- p_last_update_date Last update date of the record
93 -- p_last_updated_by Last update by
94 -- p_last_update_login Last update login
95 --
96 -- In Out: p_row_id Row id of a table record
97 --
98 --
99 -- DESIGN REFERENCES:
100 -- CNAO_DFF_ASSIGNMENT_FORM_TD.doc
101 --
102 -- CHANGE HISTORY:
103 --
104 -- 01-MAR-2006 Jackey Li created
105 -- 16-MAy-2007 yanbo liu changed
106 -- add chart_of_accounts_id column.
107 --===========================================================================
108 PROCEDURE Update_Row(p_row_id IN OUT NOCOPY VARCHAR2
109 ,P_application_id IN NUMBER
110 ,p_dff_name IN VARCHAR2
111 ,p_dff_title_code IN VARCHAR2
112 ,p_context_code IN VARCHAR2
113 ,p_attribute_column IN VARCHAR2
114 ,p_creation_date IN DATE
115 ,p_created_by IN NUMBER
116 ,p_last_update_date IN DATE
117 ,p_last_updated_by IN NUMBER
118 ,p_last_update_login IN NUMBER
119 ,p_chart_of_accounts_id In NUMBER
120 );
121
122 --==========================================================================
123 -- PROCEDURE NAME:
124 --
125 -- Lock_Row Public
126 --
127 -- DESCRIPTION:
128 --
129 -- This procedure is used to implement lock on row level on table
130 -- JA_CN_DFF_ASSIGNMENTS
131 --
132 -- PARAMETERS:
133 -- In: p_application_id Application ID
134 -- p_dff_name Descriptive Flexfield Name
135 -- p_dff_title_code DFF title lookup code
136 -- p_context_code DFF context
137 -- p_attribute_column DFF column
138 -- p_creation_date Creation date
139 -- p_created_by Identifier of user that creates
140 -- the record
141 -- p_last_update_date Last update date of the record
142 -- p_last_updated_by Last update by
143 -- p_last_update_login Last update login
144 --
145 -- In Out: p_row_id Row id of a table record
146 --
147 --
148 -- DESIGN REFERENCES:
149 -- CNAO_DFF_ASSIGNMENT_FORM_TD.doc
150 --
151 -- CHANGE HISTORY:
152 --
153 -- 01-MAR-2006 Jackey Li created
154 -- 16-MAy-2007 yanbo liu changed
155 -- add chart_of_accounts_id column.
156 --===========================================================================
157 PROCEDURE Lock_Row(p_row_id IN OUT NOCOPY VARCHAR2
158 ,P_application_id IN NUMBER
159 ,p_dff_name IN VARCHAR2
160 ,p_dff_title_code IN VARCHAR2
161 ,p_context_code IN VARCHAR2
162 ,p_attribute_column IN VARCHAR2
163 ,p_creation_date IN DATE
164 ,p_created_by IN NUMBER
165 ,p_last_update_date IN DATE
166 ,p_last_updated_by IN NUMBER
167 ,p_last_update_login IN NUMBER
168 ,p_chart_of_accounts_id In NUMBER
169 );
170
171 END JA_CN_DFF_ASSIGNMENTS_PKG;