APPS.PN_SOI_VOL_IMPORT dependencies on PN_VOL_HIST_LINES_ITF

Line 49: pn_vol_hist_lines_itf line

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'
53: AND line.status <> 'I'

Line 99: FROM pn_vol_hist_lines_itf

95: CURSOR c_all_lines_imprtd IS
96: SELECT 'Y'
97: FROM DUAL
98: WHERE NOT EXISTS (SELECT NULL
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

Line 155: pn_vol_hist_lines_itf line

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:
159: l_error_message VARCHAR2(2000);

Line 231: DELETE FROM pn_vol_hist_lines_itf line

227: WHERE batch_id = p_batch_id;
228:
229: ELSE
230:
231: DELETE FROM pn_vol_hist_lines_itf line
232: WHERE line.batch_id = p_batch_id
233: AND line.status <>'I'
234: AND line.amount is null;
235:

Line 1063: pnp_debug_pkg.log('before upDATE of table pn_vol_hist_lines_itf');

1059: END IF;
1060:
1061: END IF;
1062:
1063: pnp_debug_pkg.log('before upDATE of table pn_vol_hist_lines_itf');
1064:
1065: UPDATE pn_vol_hist_lines_itf
1066: SET status = 'I',
1067: error_log = NULL,

Line 1065: UPDATE pn_vol_hist_lines_itf

1061: END IF;
1062:
1063: pnp_debug_pkg.log('before upDATE of table pn_vol_hist_lines_itf');
1064:
1065: UPDATE pn_vol_hist_lines_itf
1066: SET status = 'I',
1067: error_log = NULL,
1068: group_DATE = v_group_DATE
1069: WHERE rowid = v_lines.rowid;

Line 1077: UPDATE pn_vol_hist_lines_itf

1073: WHEN INVALID_RECORD THEN
1074:
1075: l_fail := l_fail + 1;
1076: -- UpDATE ERROR_MESSAGE
1077: UPDATE pn_vol_hist_lines_itf
1078: SET error_log = SUBSTR(l_error_message, 1, 240),
1079: status ='E'
1080: WHERE rowid = v_lines.rowid;
1081:

Line 1211: DELETE FROM pn_vol_hist_lines_itf

1207: IF (v_batch.status = 'I') THEN
1208:
1209: pnp_debug_pkg.log ('Deleting Lines with status as I for batch Id:'||v_batch.batch_id);
1210:
1211: DELETE FROM pn_vol_hist_lines_itf
1212: WHERE batch_id = v_batch.batch_id;
1213:
1214: l_total_lines_deleted := l_total_lines_deleted + SQL%ROWCOUNT ;
1215:

Line 1226: DELETE FROM pn_vol_hist_lines_itf

1222:
1223: ELSIF (v_batch.status = 'E') THEN
1224:
1225: pnp_debug_pkg.log ('Deleting Lines with status as I for batch Id of status E:'||v_batch.batch_id);
1226: DELETE FROM pn_vol_hist_lines_itf
1227: WHERE batch_id = v_batch.batch_id
1228: AND status = 'I';
1229:
1230: l_total_lines_deleted := l_total_lines_deleted + SQL%ROWCOUNT ;