APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_BKPTS_DET_ALL

Line 1174: DELETE FROM pn_var_bkpts_det_all

1170: x_bkpt_header_id IN NUMBER DEFAULT NULL) IS
1171: begin
1172:
1173: IF x_bkhd_default_id IS NULL AND x_bkpt_header_id IS NULL THEN
1174: DELETE FROM pn_var_bkpts_det_all
1175: WHERE var_rent_id = X_VAR_RENT_ID;
1176:
1177: DELETE FROM pn_var_bkpts_head_all
1178: WHERE var_rent_id = X_VAR_RENT_ID;

Line 1211: FROM pn_var_bkpts_det_all det,

1207: IF x_bkhd_default_id IS NOT NULL THEN
1208: /*DELETE FROM pn_var_transactions_all
1209: WHERE var_rent_id = X_VAR_RENT_ID
1210: AND bkpt_detail_id IN (SELECT det.bkpt_detail_id
1211: FROM pn_var_bkpts_det_all det,
1212: pn_var_bkpts_head_all head
1213: WHERE det.var_rent_id = X_VAR_RENT_ID
1214: AND det.var_rent_id = head.var_rent_id
1215: AND det.bkpt_header_id = head.bkpt_header_id

Line 1242: DELETE FROM pn_var_bkpts_det_all

1238: FROM pn_var_bkpts_head_all
1239: WHERE var_rent_id = X_VAR_RENT_ID
1240: AND bkhd_default_id <> x_bkhd_default_id); */
1241:
1242: DELETE FROM pn_var_bkpts_det_all
1243: WHERE var_rent_id = X_VAR_RENT_ID
1244: AND bkpt_header_id IN (SELECT bkpt_header_id
1245: FROM pn_var_bkpts_head_all
1246: WHERE bkhd_default_id = x_bkhd_default_id);

Line 1271: FROM pn_var_bkpts_det_all

1267: ELSE
1268: /*DELETE FROM pn_var_transactions_all
1269: WHERE var_rent_id = X_VAR_RENT_ID
1270: AND bkpt_detail_id IN (SELECT bkpt_detail_id
1271: FROM pn_var_bkpts_det_all
1272: WHERE var_rent_id = X_VAR_RENT_ID
1273: AND bkpt_header_id = x_bkpt_header_id);*/
1274:
1275: /* DELETE FROM pn_var_vol_hist_all

Line 1297: DELETE FROM pn_var_bkpts_det_all

1293: FROM pn_var_bkpts_head_all
1294: WHERE var_rent_id = X_VAR_RENT_ID
1295: AND bkpt_header_id <> x_bkpt_header_id);*/
1296:
1297: DELETE FROM pn_var_bkpts_det_all
1298: WHERE var_rent_id = X_VAR_RENT_ID
1299: AND bkpt_header_id = x_bkpt_header_id;
1300:
1301:

Line 1389: FROM pn_var_bkpts_det_all det,

1385: IF x_bkhd_default_id IS NOT NULL THEN
1386: DELETE FROM pn_var_transactions_all
1387: WHERE var_rent_id = X_VAR_RENT_ID
1388: AND bkpt_detail_id IN (SELECT det.bkpt_detail_id
1389: FROM pn_var_bkpts_det_all det,
1390: pn_var_bkpts_head_all head
1391: WHERE det.var_rent_id = X_VAR_RENT_ID
1392: AND det.var_rent_id = head.var_rent_id
1393: AND det.bkpt_header_id = head.bkpt_header_id

Line 1399: FROM pn_var_bkpts_det_all

1395: ELSE
1396: DELETE FROM pn_var_transactions_all
1397: WHERE var_rent_id = X_VAR_RENT_ID
1398: AND bkpt_detail_id IN (SELECT bkpt_detail_id
1399: FROM pn_var_bkpts_det_all
1400: WHERE var_rent_id = X_VAR_RENT_ID
1401: AND bkpt_header_id = x_bkpt_header_id);
1402: END IF;
1403: END IF;*/