APPS.HZ_SECONDARY_TRANSFORM_PKG dependencies on HZ_SECONDARY_TRANS

Line 1: PACKAGE BODY HZ_SECONDARY_TRANSFORM_PKG AS

1: PACKAGE BODY HZ_SECONDARY_TRANSFORM_PKG AS
2: /*$Header: ARHDQSTB.pls 120.4 2005/10/30 04:19:22 appldev noship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 20: CURSOR C2 IS SELECT HZ_SECONDARY_TRANS_S.nextval FROM sys.dual;

16: p_LAST_UPDATE_DATE DATE,
17: p_LAST_UPDATED_BY NUMBER,
18: p_OBJECT_VERSION_NUMBER NUMBER)
19: IS
20: CURSOR C2 IS SELECT HZ_SECONDARY_TRANS_S.nextval FROM sys.dual;
21: l_success VARCHAR2(1) := 'N';
22: BEGIN
23: WHILE l_success = 'N' LOOP
24: BEGIN

Line 31: INSERT INTO HZ_SECONDARY_TRANS(

27: FETCH C2 INTO px_SECONDARY_TRANSFORM_ID;
28: CLOSE C2;
29: END IF;
30:
31: INSERT INTO HZ_SECONDARY_TRANS(
32: SECONDARY_TRANSFORM_ID,
33: SECONDARY_ATTRIBUTE_ID,
34: FUNCTION_ID,
35: TRANSFORMATION_WEIGHT ,

Line 109: UPDATE hz_SECONDARY_trans

105: BEGIN
106:
107: l_object_version_number := NVL(p_object_version_number, 1) + 1;
108:
109: UPDATE hz_SECONDARY_trans
110: SET
111: SECONDARY_ATTRIBUTE_ID = decode(p_SECONDARY_ATTRIBUTE_ID ,FND_API.G_MISS_NUM,SECONDARY_ATTRIBUTE_ID,
112: p_SECONDARY_ATTRIBUTE_ID),
113: FUNCTION_ID = decode(p_FUNCTION_ID ,FND_API.G_MISS_NUM,FUNCTION_ID,

Line 148: DELETE FROM HZ_SECONDARY_TRANS

144: END Update_Row;
145:
146: PROCEDURE Delete_Row(p_SECONDARY_TRANSFORM_ID NUMBER) IS
147: BEGIN
148: DELETE FROM HZ_SECONDARY_TRANS
149: WHERE SECONDARY_transform_id = p_SECONDARY_transform_id;
150:
151: If (SQL%NOTFOUND) then
152: RAISE NO_DATA_FOUND;

Line 163: FROM hz_SECONDARY_trans

159: ) IS
160: CURSOR C IS
161:
162: SELECT OBJECT_VERSION_NUMBER
163: FROM hz_SECONDARY_trans
164: WHERE SECONDARY_TRANSFORM_ID = p_SECONDARY_TRANSFORM_ID
165: FOR UPDATE OF SECONDARY_TRANSFORM_ID NOWAIT;
166: Recinfo C%ROWTYPE;
167: BEGIN

Line 189: END HZ_SECONDARY_TRANSFORM_PKG;

185: APP_EXCEPTION.RAISE_EXCEPTION;
186: End If;
187: END Lock_Row;
188:
189: END HZ_SECONDARY_TRANSFORM_PKG;