APPS.HZ_WORD_RPL_COND_ATTRIBS_PKG dependencies on HZ_WORD_RPL_COND_ATTRIBS

Line 1: PACKAGE BODY HZ_WORD_RPL_COND_ATTRIBS_PKG as

1: PACKAGE BODY HZ_WORD_RPL_COND_ATTRIBS_PKG as
2: /*$Header: ARHWRCAB.pls 120.0 2004/12/26 04:27:35 cvijayan noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_condition_id IN NUMBER,

Line 10: INSERT INTO HZ_WORD_RPL_COND_ATTRIBS (

6: x_assoc_cond_attrib_id IN NUMBER,
7: x_object_version_number IN NUMBER
8: ) IS
9: BEGIN
10: INSERT INTO HZ_WORD_RPL_COND_ATTRIBS (
11: condition_id,
12: assoc_cond_attrib_id,
13: last_update_date,
14: last_updated_by,

Line 47: UPDATE HZ_WORD_RPL_COND_ATTRIBS set

43: p_object_version_number NUMBER ;
44: BEGIN
45: p_object_version_number := NVL(x_object_version_number, 1) + 1;
46:
47: UPDATE HZ_WORD_RPL_COND_ATTRIBS set
48: assoc_cond_attrib_id = x_new_cond_attrib_id,
49: object_version_number = p_object_version_number,
50: last_update_date = hz_utility_v2pub.last_update_date,
51: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 69: DELETE FROM HZ_WORD_RPL_COND_ATTRIBS

65: )
66: IS
67: BEGIN
68:
69: DELETE FROM HZ_WORD_RPL_COND_ATTRIBS
70: where condition_id = x_condition_id and assoc_cond_attrib_id = x_assoc_cond_attrib_id ;
71:
72: END ;
73:

Line 82: DELETE FROM HZ_WORD_RPL_COND_ATTRIBS

78: )
79: IS
80: BEGIN
81:
82: DELETE FROM HZ_WORD_RPL_COND_ATTRIBS
83: where condition_id = x_condition_id ;
84:
85: END ;
86:

Line 95: from HZ_WORD_RPL_COND_ATTRIBS B

91: )
92: IS
93: cursor c is select
94: object_version_number
95: from HZ_WORD_RPL_COND_ATTRIBS B
96: where condition_id = x_condition_id
97: and assoc_cond_attrib_id = x_assoc_cond_attrib_id
98: for update of condition_id, assoc_cond_attrib_id nowait;
99:

Line 130: END HZ_WORD_RPL_COND_ATTRIBS_PKG ;

126:
127: END Lock_Row ;
128:
129:
130: END HZ_WORD_RPL_COND_ATTRIBS_PKG ;