APPS.AHL_PRD_DISPOSITION_PVT dependencies on DUAL

Line 541: FROM dual;

537: IF (l_route_mtl_req_tbl.EXISTS(i)) THEN
538: BEGIN
539: SELECT ahl_prd_dispositions_b_s.NEXTVAL
540: INTO l_disposition_id
541: FROM dual;
542: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
544: G_LOG_PREFIX||l_api_name||': Before calling table handler',
545: 'disposition_id = '||l_disposition_id);

Line 629: FROM dual;

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,
632: X_DISPOSITION_H_ID => l_disposition_h_id,
633: X_DISPOSITION_ID => l_disposition_id,

Line 1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;

1102:
1103: p_x_disposition_Rec.status_code := l_calculated_status;
1104:
1105: --prepare for insert
1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;
1107: --setting object version number for create
1108: p_x_disposition_rec.object_version_number := 1;
1109: --setting up user/create/update information
1110: p_x_disposition_rec.created_by := fnd_global.user_id;

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');