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.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 913: UPDATE pn_var_bkpts_head_all

909: END IF;
910:
911: END LOOP;
912:
913: UPDATE pn_var_bkpts_head_all
914: SET bkhd_start_date = l_bkhd_start_date,
915: bkhd_end_date = l_bkhd_end_date
916: WHERE bkpt_header_id = l_bkpt_header_id;
917:

Line 1079: UPDATE pn_var_bkpts_head_all

1075: END IF;
1076:
1077: END LOOP;
1078:
1079: UPDATE pn_var_bkpts_head_all
1080: SET bkhd_start_date = l_bkhd_start_date,
1081: bkhd_end_date = l_bkhd_end_date
1082: WHERE bkpt_header_id = l_bkpt_header_id;
1083: END LOOP;

Line 1093: --For Artificial, Update only the ones which made it to pn_var_bkpts_head_all

1089: UPDATE pn_var_bkhd_defaults_all
1090: SET bkpt_update_flag = 'N'
1091: WHERE var_rent_id = x_var_rent_id;
1092:
1093: --For Artificial, Update only the ones which made it to pn_var_bkpts_head_all
1094: /* DBMS_OUTPUT.PUT_LINE(' Step1'); */
1095: UPDATE pn_var_bkdt_defaults_all
1096: SET processed_flag = 1
1097: WHERE var_rent_id = l_var_rent_id

Line 1100: pn_var_bkpts_head_all b

1096: SET processed_flag = 1
1097: WHERE var_rent_id = l_var_rent_id
1098: AND bkhd_default_id IN (SELECT a.bkhd_default_id
1099: FROM pn_var_bkhd_defaults_all a,
1100: pn_var_bkpts_head_all b
1101: WHERE a.var_rent_id = b.var_rent_id
1102: AND a.var_rent_id = l_var_rent_id
1103: AND a.bkhd_default_id = b.bkhd_default_id
1104: AND a.break_type = b.break_type

Line 1133: DELETE FROM pn_var_bkpts_head_all

1129: END IF;
1130: END LOOP;
1131:
1132: /* Need to be revisited */
1133: DELETE FROM pn_var_bkpts_head_all
1134: WHERE var_rent_id = l_var_rent_id
1135: AND bkhd_start_date IS NULL
1136: AND bkhd_end_date IS NULL;
1137: --PNP_DEBUG_PKG.disable_file_debug;

Line 1177: DELETE FROM pn_var_bkpts_head_all

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;
1179:
1180: /*DELETE FROM pn_var_vol_hist_all
1181: WHERE line_item_id IN (SELECT line_item_id

Line 1212: pn_var_bkpts_head_all head

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
1216: AND head.bkhd_default_id = x_bkhd_default_id);*/

Line 1223: FROM pn_var_bkpts_head_all

1219: DELETE FROM pn_var_vol_hist_all
1220: --WHERE vol_hist_status_code <> 'APPROVED'
1221: WHERE actual_exp_code = 'N'
1222: AND line_item_id IN (SELECT line_item_id
1223: FROM pn_var_bkpts_head_all
1224: WHERE var_rent_id = X_VAR_RENT_ID
1225: AND bkhd_default_id = x_bkhd_default_id)
1226: AND line_item_id NOT IN (SELECT line_item_id
1227: FROM pn_var_bkpts_head_all

Line 1227: FROM pn_var_bkpts_head_all

1223: FROM pn_var_bkpts_head_all
1224: WHERE var_rent_id = X_VAR_RENT_ID
1225: AND bkhd_default_id = x_bkhd_default_id)
1226: AND line_item_id NOT IN (SELECT line_item_id
1227: FROM pn_var_bkpts_head_all
1228: WHERE var_rent_id = X_VAR_RENT_ID
1229: AND bkhd_default_id <> x_bkhd_default_id); */
1230:
1231: /* commented by parag

Line 1235: FROM pn_var_bkpts_head_all

1231: /* commented by parag
1232: DELETE FROM pn_var_lines_all
1233: WHERE var_rent_id = X_VAR_RENT_ID
1234: AND line_item_id IN (SELECT line_item_id
1235: FROM pn_var_bkpts_head_all
1236: WHERE bkhd_default_id = x_bkhd_default_id)
1237: AND line_item_id NOT IN (SELECT line_item_id
1238: FROM pn_var_bkpts_head_all
1239: WHERE var_rent_id = X_VAR_RENT_ID

Line 1238: FROM pn_var_bkpts_head_all

1234: AND line_item_id IN (SELECT line_item_id
1235: FROM pn_var_bkpts_head_all
1236: WHERE bkhd_default_id = x_bkhd_default_id)
1237: AND line_item_id NOT IN (SELECT line_item_id
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

Line 1245: FROM pn_var_bkpts_head_all

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);
1247:
1248: DELETE FROM pn_var_bkpts_head_all
1249: WHERE var_rent_id = X_VAR_RENT_ID

Line 1248: DELETE FROM pn_var_bkpts_head_all

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);
1247:
1248: DELETE FROM pn_var_bkpts_head_all
1249: WHERE var_rent_id = X_VAR_RENT_ID
1250: AND bkhd_default_id = x_bkhd_default_id;
1251: -- COMMIT;
1252:

Line 1279: FROM pn_var_bkpts_head_all

1275: /* DELETE FROM pn_var_vol_hist_all
1276: --WHERE vol_hist_status_code <> 'APPROVED'
1277: WHERE actual_exp_code = 'N'
1278: AND line_item_id IN (SELECT line_item_id
1279: FROM pn_var_bkpts_head_all
1280: WHERE var_rent_id = X_VAR_RENT_ID
1281: AND bkpt_header_id = x_bkpt_header_id)
1282: AND line_item_id NOT IN (SELECT line_item_id
1283: FROM pn_var_bkpts_head_all

Line 1283: FROM pn_var_bkpts_head_all

1279: FROM pn_var_bkpts_head_all
1280: WHERE var_rent_id = X_VAR_RENT_ID
1281: AND bkpt_header_id = x_bkpt_header_id)
1282: AND line_item_id NOT IN (SELECT line_item_id
1283: FROM pn_var_bkpts_head_all
1284: WHERE var_rent_id = X_VAR_RENT_ID
1285: AND bkpt_header_id <> x_bkpt_header_id);
1286:
1287: DELETE FROM pn_var_lines_all

Line 1290: FROM pn_var_bkpts_head_all

1286:
1287: DELETE FROM pn_var_lines_all
1288: WHERE var_rent_id = X_VAR_RENT_ID
1289: AND line_item_id IN (SELECT line_item_id
1290: FROM pn_var_bkpts_head_all
1291: WHERE bkpt_header_id = x_bkpt_header_id)
1292: AND line_item_id NOT IN (SELECT line_item_id
1293: FROM pn_var_bkpts_head_all
1294: WHERE var_rent_id = X_VAR_RENT_ID

Line 1293: FROM pn_var_bkpts_head_all

1289: AND line_item_id IN (SELECT line_item_id
1290: FROM pn_var_bkpts_head_all
1291: WHERE bkpt_header_id = x_bkpt_header_id)
1292: AND line_item_id NOT IN (SELECT line_item_id
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

Line 1302: DELETE FROM pn_var_bkpts_head_all

1298: WHERE var_rent_id = X_VAR_RENT_ID
1299: AND bkpt_header_id = x_bkpt_header_id;
1300:
1301:
1302: DELETE FROM pn_var_bkpts_head_all
1303: WHERE var_rent_id = X_VAR_RENT_ID
1304: AND bkpt_header_id = x_bkpt_header_id;
1305:
1306: --COMMIT;

Line 1390: pn_var_bkpts_head_all head

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
1394: AND head.bkhd_default_id = x_bkhd_default_id);