APPS.HZ_CODE_ASSIGNMENTS_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 1: PACKAGE BODY HZ_CODE_ASSIGNMENTS_PKG AS

1: PACKAGE BODY HZ_CODE_ASSIGNMENTS_PKG AS
2: /*$Header: ARHCASTB.pls 120.10 2010/07/12 10:17:07 rgokavar ship $ */
3:
4: -- SSM SST Integration and Extension
5: G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';

Line 37: INSERT INTO HZ_CODE_ASSIGNMENTS (

33: BEGIN
34:
35: WHILE l_success = 'N' LOOP
36: BEGIN
37: INSERT INTO HZ_CODE_ASSIGNMENTS (
38: CODE_ASSIGNMENT_ID,
39: OWNER_TABLE_NAME,
40: OWNER_TABLE_ID,
41: OWNER_TABLE_KEY_1,

Line 65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),

61: APPLICATION_ID,
62: ACTUAL_CONTENT_SOURCE
63: )
64: VALUES (
65: DECODE( X_CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, NULL, HZ_CODE_ASSIGNMENTS_S.NEXTVAL, X_CODE_ASSIGNMENT_ID ),
66: DECODE( X_OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
67: DECODE( X_OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
68: DECODE( X_OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),
69: DECODE( X_OWNER_TABLE_KEY_2, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_2 ),

Line 101: IF INSTRB( SQLERRM, 'HZ_CODE_ASSIGNMENTS_U1' ) <> 0 OR

97: l_success := 'Y';
98:
99: EXCEPTION
100: WHEN DUP_VAL_ON_INDEX THEN
101: IF INSTRB( SQLERRM, 'HZ_CODE_ASSIGNMENTS_U1' ) <> 0 OR
102: INSTRB( SQLERRM, 'HZ_CODE_ASSIGNMENTS_PK' ) <> 0
103: THEN
104: DECLARE
105: l_count NUMBER;

Line 102: INSTRB( SQLERRM, 'HZ_CODE_ASSIGNMENTS_PK' ) <> 0

98:
99: EXCEPTION
100: WHEN DUP_VAL_ON_INDEX THEN
101: IF INSTRB( SQLERRM, 'HZ_CODE_ASSIGNMENTS_U1' ) <> 0 OR
102: INSTRB( SQLERRM, 'HZ_CODE_ASSIGNMENTS_PK' ) <> 0
103: THEN
104: DECLARE
105: l_count NUMBER;
106: l_dummy VARCHAR2(1);

Line 110: SELECT HZ_CODE_ASSIGNMENTS_S.NEXTVAL

106: l_dummy VARCHAR2(1);
107: BEGIN
108: l_count := 1;
109: WHILE l_count > 0 LOOP
110: SELECT HZ_CODE_ASSIGNMENTS_S.NEXTVAL
111: INTO X_CODE_ASSIGNMENT_ID FROM dual;
112: BEGIN
113: SELECT 'Y' INTO l_dummy
114: FROM HZ_CODE_ASSIGNMENTS

Line 114: FROM HZ_CODE_ASSIGNMENTS

110: SELECT HZ_CODE_ASSIGNMENTS_S.NEXTVAL
111: INTO X_CODE_ASSIGNMENT_ID FROM dual;
112: BEGIN
113: SELECT 'Y' INTO l_dummy
114: FROM HZ_CODE_ASSIGNMENTS
115: WHERE CODE_ASSIGNMENT_ID = X_CODE_ASSIGNMENT_ID;
116: l_count := 1;
117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN

Line 158: UPDATE HZ_CODE_ASSIGNMENTS SET

154: ) IS
155:
156: BEGIN
157:
158: UPDATE HZ_CODE_ASSIGNMENTS SET
159: CODE_ASSIGNMENT_ID = DECODE( X_CODE_ASSIGNMENT_ID, NULL, CODE_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, X_CODE_ASSIGNMENT_ID ),
160: OWNER_TABLE_NAME = DECODE( X_OWNER_TABLE_NAME, NULL, OWNER_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_NAME ),
161: OWNER_TABLE_ID = DECODE( X_OWNER_TABLE_ID, NULL, OWNER_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_OWNER_TABLE_ID ),
162: OWNER_TABLE_KEY_1 = DECODE( X_OWNER_TABLE_KEY_1, NULL, OWNER_TABLE_KEY_1, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE_KEY_1 ),

Line 226: SELECT * FROM HZ_CODE_ASSIGNMENTS

222: X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
223: ) IS
224:
225: CURSOR C IS
226: SELECT * FROM HZ_CODE_ASSIGNMENTS
227: WHERE ROWID = x_Rowid
228: FOR UPDATE NOWAIT;
229: Recinfo C%ROWTYPE;
230:

Line 392: FROM HZ_CODE_ASSIGNMENTS

388: X_CREATED_BY_MODULE,
389: X_RANK,
390: X_APPLICATION_ID,
391: X_ACTUAL_CONTENT_SOURCE
392: FROM HZ_CODE_ASSIGNMENTS
393: WHERE CODE_ASSIGNMENT_ID = X_CODE_ASSIGNMENT_ID;
394:
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN

Line 411: DELETE FROM HZ_CODE_ASSIGNMENTS

407: ) IS
408:
409: BEGIN
410:
411: DELETE FROM HZ_CODE_ASSIGNMENTS
412: WHERE CODE_ASSIGNMENT_ID = X_CODE_ASSIGNMENT_ID;
413:
414: IF ( SQL%NOTFOUND ) THEN
415: RAISE NO_DATA_FOUND;

Line 420: END HZ_CODE_ASSIGNMENTS_PKG;

416: END IF;
417:
418: END Delete_Row;
419:
420: END HZ_CODE_ASSIGNMENTS_PKG;