APPS.HZ_ORIG_SYSTEMS_PKG dependencies on HZ_ORIG_SYSTEMS_B

Line 54: insert into HZ_ORIG_SYSTEMS_B (

50: FETCH C2 INTO X_ORIG_SYSTEM_ID;
51: CLOSE C2;
52: END IF;
53:
54: insert into HZ_ORIG_SYSTEMS_B (
55: ORIG_SYSTEM_ID,
56: ORIG_SYSTEM,
57: ORIG_SYSTEM_TYPE,
58: SST_FLAG,

Line 143: FROM HZ_ORIG_SYSTEMS_B

139: SELECT HZ_ORIG_SYSTEMS_S.NEXTVAL
140: INTO X_ORIG_SYSTEM_ID FROM dual;
141: BEGIN
142: SELECT 'Y' INTO l_dummy
143: FROM HZ_ORIG_SYSTEMS_B
144: WHERE ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;
145: l_count := 1;
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN

Line 195: from HZ_ORIG_SYSTEMS_B

191: X_OBJECT_VERSION_NUMBER in NUMBER
192: ) is
193: cursor c is select
194: OBJECT_VERSION_NUMBER
195: from HZ_ORIG_SYSTEMS_B
196: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID
197: for update of ORIG_SYSTEM_ID nowait;
198: recinfo c%rowtype;
199:

Line 271: update HZ_ORIG_SYSTEMS_B set

267: begin
268:
269: --p_object_version_number := NVL(X_OBJECT_VERSION_NUMBER, 1) + 1;
270:
271: update HZ_ORIG_SYSTEMS_B set
272: ORIG_SYSTEM = DECODE(X_ORIG_SYSTEM, FND_API.G_MISS_CHAR, NULL,NULL,ORIG_SYSTEM, X_ORIG_SYSTEM),
273: ORIG_SYSTEM_TYPE = DECODE(X_ORIG_SYSTEM_TYPE, FND_API.G_MISS_CHAR, NULL,NULL,ORIG_SYSTEM_TYPE, X_ORIG_SYSTEM_TYPE),
274: SST_FLAG = DECODE(X_SST_FLAG, FND_API.G_MISS_CHAR, NULL,NULL,SST_FLAG, X_SST_FLAG),
275: STATUS = DECODE(X_STATUS, FND_API.G_MISS_CHAR, NULL,NULL,STATUS, X_STATUS),

Line 335: delete from HZ_ORIG_SYSTEMS_B

331: if (sql%notfound) then
332: raise no_data_found;
333: end if;
334:
335: delete from HZ_ORIG_SYSTEMS_B
336: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;
337:
338: if (sql%notfound) then
339: raise no_data_found;

Line 349: from HZ_ORIG_SYSTEMS_B B

345: begin
346: delete from HZ_ORIG_SYSTEMS_TL T
347: where not exists
348: (select NULL
349: from HZ_ORIG_SYSTEMS_B B
350: where B.ORIG_SYSTEM_ID = T.ORIG_SYSTEM_ID
351: );
352:
353: update HZ_ORIG_SYSTEMS_TL T set (