APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISPOSITIONS_B_H_S

Line 630: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL

626: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
627: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
628:
629: --Insert the same record into the Disposition History table as well
630: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL
631: INTO l_disposition_h_id
632: FROM dual;
633: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
634: X_ROWID => l_dummy_rowid,

Line 1280: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;

1276: status_code = p_x_disposition_rec.status_code
1277: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1278: END IF;
1279:
1280: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
1281: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
1282: x_rowid => l_dummy_char,
1283: x_disposition_h_id => l_disposition_h_id,
1284: x_disposition_id => p_x_disposition_rec.disposition_id,

Line 2327: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;

2323: --dbms_output.put_line(SubStr('Update_disp: l_disposition_rec.creation_date ' || l_disposition_rec.creation_date, 1, 255));
2324: --dbms_output.put_line(SubStr('Update_disp: l_disposition_rec.created_by ' || l_disposition_rec.created_by, 1, 255));
2325:
2326:
2327: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
2328: --dbms_output.put_line(SubStr('Update_disp:Before insert into history table', 1, 255));
2329:
2330: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before insert into history table');