APPS.HZ_ORG_INFO_PUB dependencies on HZ_INDUSTRIAL_REFERENCE

Line 44: | HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(),HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW,

40: | 16-MAR-01 Suresh P Bug No :1478910 Added the status column in
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(

Line 1540: SELECT hz_industrial_reference_s.nextval

1536: l_industry_reference_id = FND_API.G_MISS_NUM THEN
1537: l_count := 1;
1538:
1539: WHILE l_count >0 LOOP
1540: SELECT hz_industrial_reference_s.nextval
1541: INTO l_industry_reference_id from dual;
1542:
1543: SELECT count(*)
1544: INTO l_count

Line 1545: FROM HZ_INDUSTRIAL_REFERENCE

1541: INTO l_industry_reference_id from dual;
1542:
1543: SELECT count(*)
1544: INTO l_count
1545: FROM HZ_INDUSTRIAL_REFERENCE
1546: WHERE industry_reference_id = l_industry_reference_id;
1547: END LOOP;
1548:
1549: ELSE

Line 1554: FROM HZ_INDUSTRIAL_REFERENCE

1550: l_count := 0;
1551:
1552: SELECT count(*)
1553: INTO l_count
1554: FROM HZ_INDUSTRIAL_REFERENCE
1555: WHERE industry_reference_id = l_industry_reference_id;
1556:
1557: if l_count > 0 THEN
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 1582: HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(

1578: -- handler. Need to update p_industrial_reference_rec first.
1579: p_industrial_reference_rec.industry_reference_id := l_industry_reference_id;
1580:
1581: -- call table handler to insert a row
1582: HZ_INDUSTRIAL_REFERENCE_PKG.INSERT_ROW(
1583: X_Rowid => l_rowid,
1584: X_INDUSTRY_REFERENCE_ID => p_industrial_reference_rec.industry_reference_id,
1585: X_INDUSTRY_REFERENCE => p_industrial_reference_rec.INDUSTRY_REFERENCE,
1586: X_ISSUED_BY_AUTHORITY => p_industrial_reference_rec.ISSUED_BY_AUTHORITY,

Line 1665: FROM HZ_INDUSTRIAL_REFERENCE

1661: begin
1662: -- check last update date.
1663: SELECT rowid, last_update_date
1664: INTO l_rowid, l_last_update_date
1665: FROM HZ_INDUSTRIAL_REFERENCE
1666: where industry_reference_id
1667: = p_industrial_reference_rec.industry_reference_id
1668: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
1669: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')

Line 1674: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_REFERENCE');

1670: FOR UPDATE NOWAIT;
1671:
1672: EXCEPTION WHEN NO_DATA_FOUND THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_REFERENCE');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: end;
1678:

Line 1696: HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW(

1692: -- handler. Need to update p_industrial_reference_rec first.
1693: NULL;
1694:
1695: -- call table handler to update a row
1696: HZ_INDUSTRIAL_REFERENCE_PKG.UPDATE_ROW(
1697: X_Rowid => l_rowid,
1698: X_INDUSTRY_REFERENCE_ID => p_industrial_reference_rec.INDUSTRY_REFERENCE_ID,
1699: X_INDUSTRY_REFERENCE => p_industrial_reference_rec.INDUSTRY_REFERENCE,
1700: X_ISSUED_BY_AUTHORITY => p_industrial_reference_rec.ISSUED_BY_AUTHORITY,