APPS.HZ_ORG_INFO_PUB dependencies on HZ_INDUSTRIAL_CLASS_APP

Line 2509: SELECT hz_industrial_class_app_s.nextval

2505: l_code_applied_id = FND_API.G_MISS_NUM THEN
2506: l_count := 1;
2507:
2508: WHILE l_count >0 LOOP
2509: SELECT hz_industrial_class_app_s.nextval
2510: INTO l_code_applied_id from dual;
2511:
2512: SELECT count(*)
2513: INTO l_count

Line 2514: FROM HZ_INDUSTRIAL_CLASS_APP

2510: INTO l_code_applied_id from dual;
2511:
2512: SELECT count(*)
2513: INTO l_count
2514: FROM HZ_INDUSTRIAL_CLASS_APP
2515: WHERE code_applied_id = l_code_applied_id;
2516: END LOOP;
2517:
2518: ELSE

Line 2523: FROM HZ_INDUSTRIAL_CLASS_APP

2519: l_count := 0;
2520:
2521: SELECT count(*)
2522: INTO l_count
2523: FROM HZ_INDUSTRIAL_CLASS_APP
2524: WHERE code_applied_id = l_code_applied_id;
2525:
2526: if l_count > 0 THEN
2527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 2551: HZ_INDUSTRIAL_CLASS_APP_PKG.INSERT_ROW(

2547: -- handler. Need to update p_industrial_class_app_rec first.
2548: p_industrial_class_app_rec.code_applied_id := l_code_applied_id;
2549:
2550: -- call table handler to insert a row
2551: HZ_INDUSTRIAL_CLASS_APP_PKG.INSERT_ROW(
2552: X_Rowid => l_rowid,
2553: X_CODE_APPLIED_ID => p_industrial_class_app_rec.code_applied_id,
2554: X_BEGIN_DATE => p_industrial_class_app_rec.BEGIN_DATE,
2555: X_PARTY_ID => p_industrial_class_app_rec.PARTY_ID,

Line 2635: FROM HZ_INDUSTRIAL_CLASS_APP

2631: begin
2632: -- check last update date.
2633: SELECT rowid, last_update_date
2634: INTO l_rowid, l_last_update_date
2635: FROM HZ_INDUSTRIAL_CLASS_APP
2636: where code_applied_id
2637: = p_industrial_class_app_rec.code_applied_id
2638: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
2639: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')

Line 2644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASS_APP');

2640: FOR UPDATE NOWAIT;
2641:
2642: EXCEPTION WHEN NO_DATA_FOUND THEN
2643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASS_APP');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: end;
2648:

Line 2666: HZ_INDUSTRIAL_CLASS_APP_PKG.UPDATE_ROW(

2662: -- handler. Need to update p_industrial_class_app_rec first.
2663: NULL;
2664:
2665: -- call table handler to update a row
2666: HZ_INDUSTRIAL_CLASS_APP_PKG.UPDATE_ROW(
2667: X_Rowid => l_rowid,
2668: X_CODE_APPLIED_ID => p_industrial_class_app_rec.CODE_APPLIED_ID,
2669: X_BEGIN_DATE => p_industrial_class_app_rec.BEGIN_DATE,
2670: X_PARTY_ID => p_industrial_class_app_rec.PARTY_ID,