APPS.PN_SOI_VOL_IMPORT dependencies on PN_VOL_HIST_BATCH_ITF

Line 48: FROM pn_vol_hist_batch_itf batch,

44: line.vol_hist_status_code,
45: line.reporting_date,
46: line.certified_by,
47: line.vol_deduct_id
48: FROM pn_vol_hist_batch_itf batch,
49: pn_vol_hist_lines_itf line
50: WHERE batch.batch_id = line.batch_id
51: AND batch.batch_id = p_batch_id
52: AND batch.status <>'I'

Line 103: FROM pn_vol_hist_batch_itf

99: FROM pn_vol_hist_lines_itf
100: WHERE status in ('E','P')
101: AND batch_id = p_batch_id)
102: AND EXISTS (SELECT NULL
103: FROM pn_vol_hist_batch_itf
104: WHERE status = 'E'
105: AND batch_id = p_batch_id);
106:
107: --added the cusror 08/07/2003

Line 154: FROM pn_vol_hist_batch_itf batch,

150: -- Get the details of lines updated.
151: CURSOR get_vr_lines_c(ip_batch_id NUMBER
152: ) IS
153: SELECT distinct(line.line_item_id)
154: FROM pn_vol_hist_batch_itf batch,
155: pn_vol_hist_lines_itf line
156: WHERE batch.batch_id = line.batch_id
157: AND batch.batch_id = ip_batch_id;
158:

Line 225: UPDATE pn_vol_hist_batch_itf

221: CLOSE c_all_lines_imprtd;
222:
223: IF l_imp_flag = 'Y' THEN
224:
225: UPDATE pn_vol_hist_batch_itf
226: SET status = 'I'
227: WHERE batch_id = p_batch_id;
228:
229: ELSE

Line 1104: UPDATE pn_vol_hist_batch_itf

1100: ELSE
1101: v_status_code := 'E';
1102: END IF;
1103:
1104: UPDATE pn_vol_hist_batch_itf
1105: SET status = v_status_code
1106: WHERE batch_id = p_batch_id;
1107:
1108:

Line 1172: FROM pn_vol_hist_batch_itf

1168: CURSOR c_batch IS
1169: SELECT batch_id,
1170: batch_name,
1171: status
1172: FROM pn_vol_hist_batch_itf
1173: WHERE ((p_batch_id IS NOT NULL AND batch_id = p_batch_id) OR (p_batch_id IS NULL))
1174: AND ((fnd_DATE.canonical_to_DATE(p_start_DATE) IS NOT NULL
1175: AND min_rep_DATE >= fnd_DATE.canonical_to_DATE(p_start_DATE))
1176: OR (p_start_DATE IS NULL))

Line 1218: DELETE FROM pn_vol_hist_batch_itf

1214: l_total_lines_deleted := l_total_lines_deleted + SQL%ROWCOUNT ;
1215:
1216: pnp_debug_pkg.log ('Deleting batch with status as I for Batch Id:'||v_batch.batch_id);
1217:
1218: DELETE FROM pn_vol_hist_batch_itf
1219: WHERE batch_id = v_batch.batch_id;
1220:
1221: l_total_batch_deleted := l_total_batch_deleted + 1;
1222: