APPS.HZ_ORG_INFO_PUB dependencies on HZ_SECURITY_ISSUED

Line 45: | HZ_SECURITY_ISSUED_PKG.INSERT_ROW(),HZ_SECURITY_ISSUED_PKG.UPDATE_ROW.

41: | HZ_CERTIFICATIONS_PKG.INSERT_ROW(),HZ_CERTIFICATION_PKG.UPDATE_ROW(),
42: | HZ_FINANCIAL_REPORTS_PKG.INSERT_ROW(),HZ_FINANCIAL_REPORTS_PKG.UPDATE_ROW(),
43: | HZ_FINANCIAL_NUMBER_PKG.INSERT_ROW(),HZ_FINANCIAL_NUMBER_PKG.UPDATE_ROW(),
44: | HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(),HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW,
45: | HZ_SECURITY_ISSUED_PKG.INSERT_ROW(),HZ_SECURITY_ISSUED_PKG.UPDATE_ROW.
46: +===========================================================================*/
47:
48: procedure do_create_stock_markets(
49: p_stock_markets_rec IN OUT NOCOPY stock_markets_rec_type,

Line 280: SELECT hz_security_issued_s.nextval

276: l_security_issued_id = FND_API.G_MISS_NUM THEN
277: l_count := 1;
278:
279: WHILE l_count > 0 LOOP
280: SELECT hz_security_issued_s.nextval
281: INTO l_security_issued_id from DUAL;
282:
283: SELECT count(*)
284: INTO l_count

Line 285: FROM HZ_SECURITY_ISSUED

281: INTO l_security_issued_id from DUAL;
282:
283: SELECT count(*)
284: INTO l_count
285: FROM HZ_SECURITY_ISSUED
286: WHERE security_issued_id = l_security_issued_id;
287: END LOOP;
288:
289: ELSE

Line 294: FROM HZ_SECURITY_ISSUED

290: l_count := 0;
291:
292: SELECT count(*)
293: INTO l_count
294: FROM HZ_SECURITY_ISSUED
295: WHERE security_issued_id = l_security_issued_id;
296:
297: if l_count > 0 THEN
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 320: HZ_SECURITY_ISSUED_PKG.INSERT_ROW(

316: -- Make sure to use values in p_security_issued_rec.* when calling insert table
317: -- handler. Need to update p_security_issued_rec first.
318: p_security_issued_rec.security_issued_id := l_security_issued_id;
319: -- call table handler to insert a row
320: HZ_SECURITY_ISSUED_PKG.INSERT_ROW(
321: X_Rowid => l_rowid,
322: X_SECURITY_ISSUED_ID => p_security_issued_rec.security_issued_id,
323: X_ESTIMATED_TOTAL_AMOUNT => p_security_issued_rec.ESTIMATED_TOTAL_AMOUNT,
324: X_PARTY_ID => p_security_issued_rec.PARTY_ID,

Line 410: FROM HZ_SECURITY_ISSUED

406: begin
407: -- check last update date.
408: SELECT rowid, last_update_date
409: INTO l_rowid, l_last_update_date
410: FROM HZ_SECURITY_ISSUED
411: where security_issued_id
412: = p_security_issued_rec.security_issued_id
413: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
414: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')

Line 419: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_SECURITY_ISSUED');

415: FOR UPDATE NOWAIT;
416:
417: EXCEPTION WHEN NO_DATA_FOUND THEN
418: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
419: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_SECURITY_ISSUED');
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_ERROR;
422: end;
423:

Line 441: HZ_SECURITY_ISSUED_PKG.UPDATE_ROW(

437: -- handler. Need to update p_security_issued_rec first.
438: NULL;
439:
440: -- call table handler to update a row
441: HZ_SECURITY_ISSUED_PKG.UPDATE_ROW(
442: X_Rowid => l_rowid,
443: X_SECURITY_ISSUED_ID => p_security_issued_rec.SECURITY_ISSUED_ID,
444: X_ESTIMATED_TOTAL_AMOUNT => p_security_issued_rec.ESTIMATED_TOTAL_AMOUNT,
445: X_PARTY_ID => p_security_issued_rec.PARTY_ID,

Line 2257: FROM hz_security_issued

2253: party_id ,
2254: end_date ,
2255: wh_update_date ,
2256: status
2257: FROM hz_security_issued
2258: WHERE security_issued_id = p_security_issued_id;
2259: lrec c1%ROWTYPE;
2260: l_api_name CONSTANT VARCHAR2(30) := 'get_current_security_issued';
2261: l_api_version CONSTANT NUMBER := 1.0;