APPS.HZ_ORG_INFO_PUB dependencies on HZ_INDUSTRIAL_CLASSES

Line 1763: SELECT hz_industrial_classes_s.nextval

1759: l_industrial_class_id = FND_API.G_MISS_NUM THEN
1760: l_count := 1;
1761:
1762: WHILE l_count >0 LOOP
1763: SELECT hz_industrial_classes_s.nextval
1764: INTO l_industrial_class_id from dual;
1765:
1766: SELECT count(*)
1767: INTO l_count

Line 1768: FROM HZ_INDUSTRIAL_CLASSES

1764: INTO l_industrial_class_id from dual;
1765:
1766: SELECT count(*)
1767: INTO l_count
1768: FROM HZ_INDUSTRIAL_CLASSES
1769: WHERE industrial_class_id = l_industrial_class_id;
1770: END LOOP;
1771:
1772: ELSE

Line 1777: FROM HZ_INDUSTRIAL_CLASSES

1773: l_count := 0;
1774:
1775: SELECT count(*)
1776: INTO l_count
1777: FROM HZ_INDUSTRIAL_CLASSES
1778: WHERE industrial_class_id = l_industrial_class_id;
1779:
1780: if l_count > 0 THEN
1781: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 1805: HZ_INDUSTRIAL_CLASSES_PKG.INSERT_ROW(

1801: -- handler. Need to update p_industrial_classes_rec first.
1802: p_industrial_classes_rec.industrial_class_id := l_industrial_class_id;
1803:
1804: -- call table handler to insert a row
1805: HZ_INDUSTRIAL_CLASSES_PKG.INSERT_ROW(
1806: X_Rowid => l_rowid,
1807: X_INDUSTRIAL_CLASS_ID => p_industrial_classes_rec.industrial_class_id,
1808: X_INDUSTRIAL_CODE_NAME => p_industrial_classes_rec.INDUSTRIAL_CODE_NAME,
1809: X_CODE_PRIMARY_SEGMENT => p_industrial_classes_rec.CODE_PRIMARY_SEGMENT,

Line 1887: FROM HZ_INDUSTRIAL_CLASSES

1883: begin
1884: -- check last update date.
1885: SELECT rowid, last_update_date
1886: INTO l_rowid, l_last_update_date
1887: FROM HZ_INDUSTRIAL_CLASSES
1888: where industrial_class_id
1889: = p_industrial_classes_rec.industrial_class_id
1890: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
1891: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')

Line 1896: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASSES');

1892: FOR UPDATE NOWAIT;
1893:
1894: EXCEPTION WHEN NO_DATA_FOUND THEN
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1896: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASSES');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: end;
1900:

Line 1918: HZ_INDUSTRIAL_CLASSES_PKG.UPDATE_ROW(

1914: -- handler. Need to update p_industrial_classes_rec first.
1915: NULL;
1916:
1917: -- call table handler to update a row
1918: HZ_INDUSTRIAL_CLASSES_PKG.UPDATE_ROW(
1919: X_Rowid => l_rowid,
1920: X_INDUSTRIAL_CLASS_ID => p_industrial_classes_rec.INDUSTRIAL_CLASS_ID,
1921: X_INDUSTRIAL_CODE_NAME => p_industrial_classes_rec.INDUSTRIAL_CODE_NAME,
1922: X_CODE_PRIMARY_SEGMENT => p_industrial_classes_rec.CODE_PRIMARY_SEGMENT,

Line 2029: FROM HZ_INDUSTRIAL_CLASSES

2025: code_primary_segment,
2026: industrial_class_source,
2027: code_description,
2028: wh_update_date
2029: FROM HZ_INDUSTRIAL_CLASSES
2030: WHERE industrial_class_id = p_industrial_class_id;
2031:
2032: lrec c1%ROWTYPE;
2033: l_api_name CONSTANT VARCHAR2(30) := 'get_current_industrial_classes';