APPS.HZ_ORG_INFO_PUB dependencies on HZ_CERTIFICATIONS

Line 41: | HZ_CERTIFICATIONS_PKG.INSERT_ROW(),HZ_CERTIFICATION_PKG.UPDATE_ROW(),

37: | 'IN OUT' in order to pass the changed record
38: | to caller.
39: |
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.

Line 1314: SELECT hz_certifications_s.nextval

1310: l_certification_id = FND_API.G_MISS_NUM THEN
1311: l_count := 1;
1312:
1313: WHILE l_count >0 LOOP
1314: SELECT hz_certifications_s.nextval
1315: INTO l_certification_id from dual;
1316:
1317: SELECT count(*)
1318: INTO l_count

Line 1319: FROM HZ_CERTIFICATIONS

1315: INTO l_certification_id from dual;
1316:
1317: SELECT count(*)
1318: INTO l_count
1319: FROM HZ_CERTIFICATIONS
1320: WHERE certification_id = l_certification_id;
1321: END LOOP;
1322:
1323: ELSE

Line 1328: FROM HZ_CERTIFICATIONS

1324: l_count := 0;
1325:
1326: SELECT count(*)
1327: INTO l_count
1328: FROM HZ_CERTIFICATIONS
1329: WHERE certification_id = l_certification_id;
1330:
1331: if l_count > 0 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 1355: HZ_CERTIFICATIONS_PKG.INSERT_ROW(

1351: -- Make sure to use values in p_certifications_rec.* when calling insert table
1352: -- handler. Need to update p_certifications_rec first.
1353: p_certifications_rec.certification_id := l_certification_id;
1354: -- call table handler to insert a row
1355: HZ_CERTIFICATIONS_PKG.INSERT_ROW(
1356: X_Rowid => l_rowid,
1357: X_CERTIFICATION_ID => p_certifications_rec.certification_id,
1358: X_CERTIFICATION_NAME => p_certifications_rec.CERTIFICATION_NAME,
1359: X_CURRENT_STATUS => p_certifications_rec.CURRENT_STATUS,

Line 1440: FROM HZ_CERTIFICATIONS

1436: begin
1437: -- check last update date.
1438: SELECT rowid, last_update_date
1439: INTO l_rowid, l_last_update_date
1440: FROM HZ_CERTIFICATIONS
1441: where certification_id
1442: = p_certifications_rec.certification_id
1443: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
1444: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')

Line 1449: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CERTIFICATIONS');

1445: FOR UPDATE NOWAIT;
1446:
1447: EXCEPTION WHEN NO_DATA_FOUND THEN
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1449: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CERTIFICATIONS');
1450: FND_MSG_PUB.ADD;
1451: RAISE FND_API.G_EXC_ERROR;
1452: end;
1453:

Line 1471: HZ_CERTIFICATIONS_PKG.UPDATE_ROW(

1467: -- handler. Need to update p_certifications_rec first.
1468: NULL;
1469:
1470: -- call table handler to update a row
1471: HZ_CERTIFICATIONS_PKG.UPDATE_ROW(
1472: X_Rowid => l_rowid,
1473: X_CERTIFICATION_ID => p_certifications_rec.CERTIFICATION_ID,
1474: X_CERTIFICATION_NAME => p_certifications_rec.CERTIFICATION_NAME,
1475: X_CURRENT_STATUS => p_certifications_rec.CURRENT_STATUS,

Line 2381: FROM hz_certifications

2377: issued_by_authority ,
2378: issued_on_date ,
2379: wh_update_date ,
2380: status
2381: FROM hz_certifications
2382: WHERE certification_id = p_certification_id;
2383: lrec c1%ROWTYPE;
2384: l_api_name CONSTANT VARCHAR2(30) := 'get_current_certifications';
2385: l_api_version CONSTANT NUMBER := 1.0;

Line 4238: HZ_POPULATE_BOT_PKG.pop_hz_certifications(

4234: END IF;
4235:
4236: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4237: -- populate function for integration service
4238: HZ_POPULATE_BOT_PKG.pop_hz_certifications(
4239: p_operation => 'I',
4240: p_certification_id => x_certification_id);
4241: END IF;
4242: END IF;

Line 4428: HZ_POPULATE_BOT_PKG.pop_hz_certifications(

4424: END IF;
4425:
4426: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4427: -- populate function for integration service
4428: HZ_POPULATE_BOT_PKG.pop_hz_certifications(
4429: p_operation => 'U',
4430: p_certification_id => l_certifications_rec.certification_id);
4431: END IF;
4432: END IF;