eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_DISPOSITION_PVT dependencies on DUAL

Line 544: FROM dual;

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

Line 632: FROM dual;

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,
635: X_DISPOSITION_H_ID => l_disposition_h_id,
636: X_DISPOSITION_ID => l_disposition_id,

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

1161:
1162: p_x_disposition_Rec.status_code := l_calculated_status;
1163:
1164: --prepare for insert
1165: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;
1166: --setting object version number for create
1167: p_x_disposition_rec.object_version_number := 1;
1168: --setting up user/create/update information
1169: p_x_disposition_rec.created_by := fnd_global.user_id;

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