APPS.HZ_MERGE_BATCH_PKG dependencies on HZ_MERGE_BATCH

Line 1: PACKAGE BODY HZ_MERGE_BATCH_PKG as

1: PACKAGE BODY HZ_MERGE_BATCH_PKG as
2: /* $Header: ARHMBTBB.pls 120.2 2005/06/16 21:12:21 jhuang noship $ */
3: -- Start of Comments
4: -- Package name : HZ_MERGE_BATCH_PKG
5: -- Purpose :

Line 4: -- Package name : HZ_MERGE_BATCH_PKG

1: PACKAGE BODY HZ_MERGE_BATCH_PKG as
2: /* $Header: ARHMBTBB.pls 120.2 2005/06/16 21:12:21 jhuang noship $ */
3: -- Start of Comments
4: -- Package name : HZ_MERGE_BATCH_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'HZ_MERGE_BATCH_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'HZ_MERGE_BATCH_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'arhtbtbb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_BATCH_ID IN OUT NOCOPY NUMBER,

Line 30: CURSOR C2 IS SELECT HZ_MERGE_BATCH_S.nextval FROM sys.dual;

26: p_LAST_UPDATE_DATE DATE,
27: p_LAST_UPDATED_BY NUMBER)
28:
29: IS
30: CURSOR C2 IS SELECT HZ_MERGE_BATCH_S.nextval FROM sys.dual;
31: BEGIN
32: If (px_BATCH_ID IS NULL) OR (px_BATCH_ID = FND_API.G_MISS_NUM) then
33: OPEN C2;
34: FETCH C2 INTO px_BATCH_ID;

Line 37: INSERT INTO HZ_MERGE_BATCH(

33: OPEN C2;
34: FETCH C2 INTO px_BATCH_ID;
35: CLOSE C2;
36: End If;
37: INSERT INTO HZ_MERGE_BATCH(
38: BATCH_ID,
39: RULE_SET_NAME,
40: BATCH_NAME,
41: REQUEST_ID,

Line 84: Update HZ_MERGE_BATCH

80: p_LAST_UPDATED_BY NUMBER)
81:
82: IS
83: BEGIN
84: Update HZ_MERGE_BATCH
85: SET
86: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
87: BATCH_NAME = decode( p_BATCH_NAME, FND_API.G_MISS_CHAR, BATCH_NAME, p_BATCH_NAME),
88: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 112: DELETE FROM HZ_MERGE_BATCH

108: PROCEDURE Delete_Row(
109: p_BATCH_ID NUMBER)
110: IS
111: BEGIN
112: DELETE FROM HZ_MERGE_BATCH
113: WHERE BATCH_ID = p_BATCH_ID;
114: If (SQL%NOTFOUND) then
115: RAISE NO_DATA_FOUND;
116: End If;

Line 137: FROM HZ_MERGE_BATCH

133:
134: IS
135: CURSOR C IS
136: SELECT *
137: FROM HZ_MERGE_BATCH
138: WHERE BATCH_ID = p_BATCH_ID
139: FOR UPDATE of BATCH_ID NOWAIT;
140: Recinfo C%ROWTYPE;
141: BEGIN

Line 196: End HZ_MERGE_BATCH_PKG;

192: APP_EXCEPTION.RAISE_EXCEPTION;
193: End If;
194: END Lock_Row;
195:
196: End HZ_MERGE_BATCH_PKG;