APPS.CN_CREDIT_CONV_FCTS_PKG dependencies on CN_CREDIT_CONV_FCTS

Line 1: package body CN_CREDIT_CONV_FCTS_PKG as

1: package body CN_CREDIT_CONV_FCTS_PKG as
2: /* $Header: cncrtcvb.pls 115.2 2001/10/29 17:06:15 pkm ship $ */
3:
4: PROCEDURE Insert_Row
5: ( x_credit_conv_fct_id NUMBER ,

Line 34: INSERT INTO cn_credit_conv_fcts

30: x_last_update_date DATE ,
31: x_last_updated_by NUMBER
32: ) IS
33: BEGIN
34: INSERT INTO cn_credit_conv_fcts
35: ( object_version_number,
36: credit_conv_fct_id,
37: from_credit_type_id,
38: to_credit_type_id,

Line 127: UPDATE cn_credit_conv_fcts

123: x_last_update_date DATE ,
124: x_last_updated_by NUMBER
125: ) IS
126: BEGIN
127: UPDATE cn_credit_conv_fcts
128: SET
129: object_version_number = x_object_version +1,
130: from_credit_type_id = x_from_credit_type_id,
131: to_credit_type_id = x_to_credit_type_id,

Line 193: FROM cn_credit_conv_fcts

189: x_last_updated_by NUMBER
190: ) IS
191: CURSOR C IS
192: SELECT *
193: FROM cn_credit_conv_fcts
194: WHERE credit_conv_fct_id = x_credit_conv_fct_id
195: FOR UPDATE of credit_conv_fct_id NOWAIT;
196: Recinfo C%ROWTYPE;
197: BEGIN

Line 298: DELETE FROM CN_CREDIT_CONV_FCTS

294: END Lock_Row;
295:
296: PROCEDURE Delete_Row(x_credit_conv_fct_id NUMBER) IS
297: BEGIN
298: DELETE FROM CN_CREDIT_CONV_FCTS
299: WHERE credit_conv_fct_id = x_credit_conv_fct_id;
300: IF (SQL%NOTFOUND) THEN
301: Raise NO_DATA_FOUND;
302: END IF;

Line 305: end CN_CREDIT_CONV_FCTS_PKG;

301: Raise NO_DATA_FOUND;
302: END IF;
303: END Delete_Row;
304:
305: end CN_CREDIT_CONV_FCTS_PKG;