APPS.HZ_LOC_ASSIGNMENTS_PKG dependencies on HZ_LOC_ASSIGNMENTS

Line 1: PACKAGE BODY HZ_LOC_ASSIGNMENTS_PKG AS

1: PACKAGE BODY HZ_LOC_ASSIGNMENTS_PKG AS
2: /*$Header: ARHTLATB.pls 115.4 2002/11/21 19:44:33 sponnamb ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_LOCATION_ID IN NUMBER,

Line 15: INSERT INTO HZ_LOC_ASSIGNMENTS (

11: ) IS
12:
13: BEGIN
14:
15: INSERT INTO HZ_LOC_ASSIGNMENTS (
16: LOCATION_ID,
17: LOC_ID,
18: ORG_ID,
19: CREATED_BY,

Line 65: UPDATE HZ_LOC_ASSIGNMENTS SET

61: ) IS
62:
63: BEGIN
64:
65: UPDATE HZ_LOC_ASSIGNMENTS SET
66: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
67: LOC_ID = DECODE( X_LOC_ID, NULL, LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
69: CREATED_BY = CREATED_BY,

Line 110: SELECT * FROM HZ_LOC_ASSIGNMENTS

106: X_APPLICATION_ID IN NUMBER
107: ) IS
108:
109: CURSOR C IS
110: SELECT * FROM HZ_LOC_ASSIGNMENTS
111: WHERE ROWID = x_Rowid
112: FOR UPDATE NOWAIT;
113: Recinfo C%ROWTYPE;
114:

Line 204: FROM HZ_LOC_ASSIGNMENTS

200: X_LOC_ID,
201: X_ORG_ID,
202: X_CREATED_BY_MODULE,
203: X_APPLICATION_ID
204: FROM HZ_LOC_ASSIGNMENTS
205: WHERE LOCATION_ID = X_LOCATION_ID
206: AND ORG_ID = X_ORG_ID;
207:
208: EXCEPTION

Line 224: DELETE FROM HZ_LOC_ASSIGNMENTS

220: ) IS
221:
222: BEGIN
223:
224: DELETE FROM HZ_LOC_ASSIGNMENTS
225: WHERE LOCATION_ID = X_LOCATION_ID;
226:
227: IF ( SQL%NOTFOUND ) THEN
228: RAISE NO_DATA_FOUND;

Line 233: END HZ_LOC_ASSIGNMENTS_PKG;

229: END IF;
230:
231: END Delete_Row;
232:
233: END HZ_LOC_ASSIGNMENTS_PKG;