APPS.HZ_ORG_INFO_PUB dependencies on HZ_STOCK_MARKETS

Line 63: SELECT hz_stock_markets_s.nextval

59: l_stock_exchange_id = FND_API.G_MISS_NUM THEN
60: l_count := 1;
61:
62: WHILE l_count >0 LOOP
63: SELECT hz_stock_markets_s.nextval
64: INTO l_stock_exchange_id from dual;
65:
66: SELECT count(*)
67: INTO l_count

Line 68: FROM HZ_STOCK_MARKETS

64: INTO l_stock_exchange_id from dual;
65:
66: SELECT count(*)
67: INTO l_count
68: FROM HZ_STOCK_MARKETS
69: WHERE stock_exchange_id = l_stock_exchange_id;
70: END LOOP;
71:
72: ELSE

Line 77: FROM HZ_STOCK_MARKETS

73: l_count := 0;
74:
75: SELECT count(*)
76: INTO l_count
77: FROM HZ_STOCK_MARKETS
78: WHERE stock_exchange_id = l_stock_exchange_id;
79:
80: if l_count > 0 THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 105: HZ_STOCK_MARKETS_PKG.INSERT_ROW(

101: -- handler. Need to update p_stock_markets_rec first.
102: p_stock_markets_rec.stock_exchange_id := l_stock_exchange_id;
103:
104: -- call table handler to insert a row
105: HZ_STOCK_MARKETS_PKG.INSERT_ROW(
106: X_Rowid => l_rowid,
107: X_STOCK_EXCHANGE_ID => p_stock_markets_rec.stock_exchange_id,
108: X_COUNTRY_OF_RESIDENCE => p_stock_markets_rec.COUNTRY_OF_RESIDENCE,
109: X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,

Line 186: FROM HZ_STOCK_MARKETS

182:
183: begin
184: SELECT rowid, last_update_date
185: INTO l_rowid, l_last_update_date
186: FROM HZ_STOCK_MARKETS
187: WHERE stock_exchange_id = p_stock_markets_rec.stock_exchange_id
188: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
189: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
190: FOR UPDATE NOWAIT;

Line 194: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_STOCK_MARKETS');

190: FOR UPDATE NOWAIT;
191:
192: EXCEPTION WHEN NO_DATA_FOUND THEN
193: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
194: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_STOCK_MARKETS');
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: end;
198:

Line 216: HZ_STOCK_MARKETS_PKG.UPDATE_ROW(

212: -- handler. Need to update p_stock_markets_rec first.
213: NULL;
214:
215: -- call table handler to update a row
216: HZ_STOCK_MARKETS_PKG.UPDATE_ROW(
217: X_Rowid => l_rowid,
218: X_STOCK_EXCHANGE_ID => p_stock_markets_rec.STOCK_EXCHANGE_ID,
219: X_COUNTRY_OF_RESIDENCE => p_stock_markets_rec.COUNTRY_OF_RESIDENCE,
220: X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,

Line 2142: FROM hz_stock_markets

2138: country_of_residence,
2139: stock_exchange_code,
2140: stock_exchange_name,
2141: wh_update_date
2142: FROM hz_stock_markets
2143: WHERE stock_exchange_id = p_stock_exchange_id;
2144: lrec c1%ROWTYPE;
2145: l_api_name CONSTANT VARCHAR2(30) := 'get_current_stock_markets';
2146: l_api_version CONSTANT NUMBER := 1.0;