APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISPOSITIONS_B_H_S

Line 627: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL

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

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

1217: status_code = p_x_disposition_rec.status_code
1218: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1219: END IF;
1220:
1221: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
1222: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
1223: x_rowid => l_dummy_char,
1224: x_disposition_h_id => l_disposition_h_id,
1225: x_disposition_id => p_x_disposition_rec.disposition_id,

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

2067: --dbms_output.put_line(SubStr('Update_disp: l_disposition_rec.creation_date ' || l_disposition_rec.creation_date, 1, 255));
2068: --dbms_output.put_line(SubStr('Update_disp: l_disposition_rec.created_by ' || l_disposition_rec.created_by, 1, 255));
2069:
2070:
2071: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
2072: --dbms_output.put_line(SubStr('Update_disp:Before insert into history table', 1, 255));
2073:
2074: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before insert into history table');