APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISPOSITIONS_B_S

Line 542: SELECT ahl_prd_dispositions_b_s.NEXTVAL

538: --dbms_output.put_line('Before calling table handler API');
539: --Insert the record into the disposition entity table
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,

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 1274: UPDATE AHL_PRD_DISPOSITIONS_B SET primary_service_request_id = p_x_disposition_rec.primary_service_request_id,

1270: p_x_disposition_rec.primary_service_request_id := l_primary_service_request_id;
1271: p_x_disposition_rec.non_routine_workorder_id := l_non_routine_workorder_id;
1272:
1273: --update the just modified field without changing object version number.
1274: UPDATE AHL_PRD_DISPOSITIONS_B SET primary_service_request_id = p_x_disposition_rec.primary_service_request_id,
1275: non_routine_workorder_id = p_x_disposition_rec.non_routine_workorder_id,
1276: status_code = p_x_disposition_rec.status_code
1277: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1278: END IF;