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.OKS_MASS_UPD_PVT dependencies on OKS_LINES_TEMP

Line 22: DELETE FROM oks_lines_temp

18:
19: DELETE FROM oks_headers_temp
20: WHERE chr_id = p_contract_id;
21:
22: DELETE FROM oks_lines_temp
23: WHERE dnz_chr_id = p_contract_id;
24:
25: DELETE FROM oks_sublines_temp
26: WHERE dnz_chr_id = p_contract_id;

Line 172: FROM oks_lines_temp

168: reason_code,
169: status,
170: new_status,
171: comments
172: FROM oks_lines_temp
173: WHERE status_change_flag = 'Y'
174: AND dnz_chr_id = To_Number(p_contract_id)
175: UNION ALL
176: SELECT cle_id line_id,

Line 206: UPDATE oks_lines_temp

202: l_return_status := check_ste_code(l_old_ste_code, l_new_ste_code);
203:
204: IF l_return_status <> 'S' THEN
205: IF l_mass_update_status_tbl(i).sub_line_id is null then
206: UPDATE oks_lines_temp
207: SET status_error_flag = 'Y',
208: status_err_message = l_new_ste_code ||
209: ' is not a valid status for the existing status type ' ||
210: l_old_ste_code

Line 222: UPDATE oks_lines_temp

218: WHERE id = l_mass_update_status_tbl(i).sub_line_id;
219: END IF;
220: ELSE
221: IF l_mass_update_status_tbl(i).sub_line_id is null then
222: UPDATE oks_lines_temp
223: SET status_error_flag = 'N', error_message = NULL
224: WHERE id = l_mass_update_status_tbl(i).line_id;
225: ELSE
226: UPDATE oks_sublines_temp

Line 261: FROM oks_lines_temp

257: lse_id,
258: line_number,
259: start_date,
260: end_date
261: FROM oks_lines_temp
262: WHERE (start_dt_eff_change_flag = 'Y' OR
263: end_dt_eff_change_flag = 'Y')
264: AND dnz_chr_id = to_number(p_contract_id)
265: UNION ALL

Line 291: UPDATE oks_lines_temp

287:
288: IF (l_mass_update_eff_tbl(i)
289: .start_date < l_k_start_date OR l_mass_update_eff_tbl(i)
290: .start_date > l_k_end_date) THEN
291: UPDATE oks_lines_temp
292: SET start_dt_error_flag = 'Y',
293: st_dt_err_message = Nvl2(st_dt_err_message, st_dt_err_message ||'- Line Start Date is out of Contract''s Effectivity, line_number: ' || l_mass_update_eff_tbl(i).line_number,
294: 'Line Start Date is out of Contract''s Effectivity, line_number: ' || l_mass_update_eff_tbl(i).line_number)
295: WHERE id = l_mass_update_eff_tbl(i).line_id;

Line 304: UPDATE oks_lines_temp

300:
301: IF (l_mass_update_eff_tbl(i)
302: .end_date < l_k_start_date OR l_mass_update_eff_tbl(i)
303: .end_date > l_k_end_date) THEN
304: UPDATE oks_lines_temp
305: SET end_dt_error_flag = 'Y',
306: end_dt_err_message = Nvl2(end_dt_err_message, end_dt_err_message || ' - Line End Date is out of Contract''s Effectivity, line_number: '|| l_mass_update_eff_tbl(i).line_number,
307: 'Line End Date is out of Contract''s Effectivity, line_number: '|| l_mass_update_eff_tbl(i).line_number)
308: WHERE id = l_mass_update_eff_tbl(i).line_id;

Line 318: FROM oks_lines_temp l

314: --l_mass_update_eff_tbl(i).subline_id
315:
316: SELECT l.START_DATE, l.END_DATE
317: INTO l_kl_start_date, l_kl_end_date
318: FROM oks_lines_temp l
319: WHERE l.id = l_mass_update_eff_tbl(i).line_id;
320:
321: IF (l_mass_update_eff_tbl(i)
322: .start_date < l_kl_start_date OR l_mass_update_eff_tbl(i)

Line 1044: FROM oks_lines_temp

1040: /*log*/
1041:
1042: FOR i IN (SELECT line_number,
1043: status_err_message
1044: FROM oks_lines_temp
1045: WHERE (status_change_flag = 'Y' AND status_error_flag = 'Y')
1046: AND dnz_chr_id = To_Number(p_contract_id)
1047: UNION ALL
1048: SELECT line_number,

Line 1079: FROM oks_lines_temp

1075: reason_code,
1076: status,
1077: new_status,
1078: comments
1079: FROM oks_lines_temp
1080: WHERE (status_change_flag = 'Y' AND status_error_flag = 'N')
1081: AND dnz_chr_id = To_Number(p_contract_id)
1082: UNION ALL
1083: SELECT cle_id line_id,

Line 1175: FROM oks_lines_temp

1171: DECODE(end_dt_error_flag,
1172: 'Y',
1173: 'End Date Error: ' || end_dt_err_message,
1174: '') end_dt_err
1175: FROM oks_lines_temp
1176: WHERE ((start_dt_eff_change_flag = 'Y' AND
1177: start_dt_error_flag = 'Y') OR (end_dt_eff_change_flag = 'Y' AND
1178: end_dt_error_flag = 'Y'))
1179: AND dnz_chr_id = to_number(p_contract_id)

Line 1226: FROM oks_lines_temp

1222: lse_id,
1223: line_number,
1224: start_date,
1225: end_date
1226: FROM oks_lines_temp
1227: WHERE ((start_dt_eff_change_flag = 'Y' AND
1228: start_dt_error_flag = 'N') OR
1229: (end_dt_eff_change_flag = 'Y' AND end_dt_error_flag = 'N'))
1230: AND dnz_chr_id = to_number(p_contract_id)

Line 1705: UPDATE oks_lines_temp

1701: FROM okc_k_headers_all_b
1702: where id = p_chr_id;
1703:
1704: IF (p_start_date < l_k_start_date OR p_start_date > l_k_end_date) THEN
1705: UPDATE oks_lines_temp
1706: SET start_dt_error_flag = 'Y',
1707: st_dt_err_message = Nvl2(st_dt_err_message, st_dt_err_message ||'- Line Start Date is out of Contract''s Effectivity, line_number: ' || p_line_number,
1708: 'Line Start Date is out of Contract''s Effectivity, line number: ' || p_line_number)
1709: WHERE id = p_line_id;

Line 1716: UPDATE oks_lines_temp

1712: --RETURN;
1713: END IF;
1714:
1715: IF (p_end_date < l_k_start_date OR p_end_date > l_k_end_date) THEN
1716: UPDATE oks_lines_temp
1717: SET end_dt_error_flag = 'Y',
1718: end_dt_err_message = Nvl2(end_dt_err_message, end_dt_err_message || ' - Line End Date is out of Contract''s Effectivity, line_number: '|| p_line_number,
1719: 'Line End Date is out of Contract''s Effectivity, line number: '|| p_line_number)
1720: WHERE id = p_line_id;

Line 2784: INSERT INTO oks_lines_temp

2780: FND_GLOBAL.LOGIN_ID
2781: FROM okc_k_headers_all_b
2782: WHERE id = p_contract_id;
2783:
2784: INSERT INTO oks_lines_temp
2785: (id,id_char,
2786: dnz_chr_id, dnz_chr_id_char,
2787: line_number,
2788: lse_id,

Line 3380: FROM oks_lines_temp

3376: l_global_comments VARCHAR2(2000);
3377:
3378: CURSOR c_sel_lines IS
3379: SELECT id, start_date, end_date, new_status, reason_code, comments, old_start_date, old_end_date, old_status
3380: FROM oks_lines_temp
3381: WHERE dnz_chr_id = p_contract_id
3382: AND (Nvl(select_flag,'N') = 'Y' OR Nvl(cascade_flag,'N') = 'Y');
3383:
3384:

Line 3404: OR EXISTS (SELECT 1 FROM oks_lines_temp lines

3400: AND top_lvl_parent = -99
3401: AND (
3402: Nvl(select_flag,'N') = 'Y'
3403: OR Nvl(cascade_flag,'N') = 'Y'
3404: OR EXISTS (SELECT 1 FROM oks_lines_temp lines
3405: WHERE lines.id = sublines.cle_id
3406: AND lines.dnz_chr_id = sublines.dnz_chr_id
3407: AND Nvl(lines.cascade_flag,'N') = 'Y' )
3408: );

Line 3429: OR EXISTS (SELECT 1 FROM oks_lines_temp lines

3425: WHERE dnz_chr_id = p_contract_id
3426: AND top_lvl_parent <> -99
3427: AND (
3428: Nvl(select_flag,'N') = 'Y'
3429: OR EXISTS (SELECT 1 FROM oks_lines_temp lines
3430: WHERE lines.id = sublineschild.cle_id
3431: AND lines.dnz_chr_id = sublineschild.dnz_chr_id
3432: AND Nvl(lines.cascade_flag,'N') = 'Y' )
3433: OR EXISTS (SELECT 1 FROM oks_sublines_temp sublines

Line 3471: FROM oks_lines_temp tmp, okc_k_lines_b lin

3467: FROM okc_statuses_b sts
3468: WHERE sts.code = lin.sts_code),
3469: 'N',
3470: 'Y') status_change
3471: FROM oks_lines_temp tmp, okc_k_lines_b lin
3472: WHERE tmp.id = lin.id
3473: AND tmp.dnz_chr_id = p_contract_id;
3474:
3475: CURSOR c_get_error_records IS

Line 3479: FROM oks_lines_temp

3475: CURSOR c_get_error_records IS
3476: SELECT 'SOME_WITH_ERROR'
3477: FROM dual
3478: WHERE EXISTS (SELECT 1
3479: FROM oks_lines_temp
3480: WHERE dnz_chr_id = p_contract_id
3481: AND (start_dt_error_flag = 'Y' OR end_dt_error_flag = 'Y' OR status_error_flag = 'Y')
3482: UNION
3483: SELECT 1

Line 3501: UPDATE oks_lines_temp

3497: CLOSE c_get_hdr_attrs;
3498:
3499: FOR line IN c_sel_lines LOOP
3500:
3501: UPDATE oks_lines_temp
3502: SET start_date = nvl(l_global_start_date,start_date),
3503: end_date = Nvl(l_global_end_date,end_date),
3504: new_status = Nvl(l_global_new_status,new_status),
3505: new_ste_code = Nvl(l_global_status_code,new_ste_code),

Line 3559: UPDATE oks_lines_temp tmp

3555: END LOOP;
3556:
3557: FOR modified IN c_modified_line LOOP
3558:
3559: UPDATE oks_lines_temp tmp
3560: SET start_dt_eff_change_flag = modified.start_date_change,
3561: end_dt_eff_change_flag = modified.end_date_change,
3562: status_change_flag = modified.status_change
3563: WHERE tmp.dnz_chr_id = p_contract_id

Line 3568: UPDATE oks_lines_temp

3564: AND tmp.id = modified.id;
3565:
3566: END LOOP;
3567:
3568: UPDATE oks_lines_temp
3569: SET start_dt_error_flag = 'N',
3570: end_dt_error_flag = 'N',
3571: status_error_flag = 'N',
3572: st_dt_err_message = NULL,

Line 3588: UPDATE oks_lines_temp

3584: WHERE dnz_chr_id = p_contract_id;
3585:
3586: vld_massupd_data_prc(l_retcode, p_contract_id);
3587:
3588: UPDATE oks_lines_temp
3589: SET undo_start_date = old_start_date,
3590: old_start_date = start_date
3591: WHERE dnz_chr_id = p_contract_id
3592: AND start_dt_eff_change_flag = 'Y'

Line 3595: UPDATE oks_lines_temp

3591: WHERE dnz_chr_id = p_contract_id
3592: AND start_dt_eff_change_flag = 'Y'
3593: AND start_dt_error_flag = 'N';
3594:
3595: UPDATE oks_lines_temp
3596: SET undo_start_date = old_start_date
3597: WHERE dnz_chr_id = p_contract_id
3598: AND start_dt_eff_change_flag = 'Y'
3599: AND start_dt_error_flag = 'Y';

Line 3601: UPDATE oks_lines_temp

3597: WHERE dnz_chr_id = p_contract_id
3598: AND start_dt_eff_change_flag = 'Y'
3599: AND start_dt_error_flag = 'Y';
3600:
3601: UPDATE oks_lines_temp
3602: SET undo_end_date = old_end_date,
3603: old_end_date = end_date
3604: WHERE dnz_chr_id = p_contract_id
3605: AND end_dt_eff_change_flag = 'Y'

Line 3608: UPDATE oks_lines_temp

3604: WHERE dnz_chr_id = p_contract_id
3605: AND end_dt_eff_change_flag = 'Y'
3606: AND end_dt_error_flag = 'N';
3607:
3608: UPDATE oks_lines_temp
3609: SET undo_end_date = old_end_date
3610: WHERE dnz_chr_id = p_contract_id
3611: AND end_dt_eff_change_flag = 'Y'
3612: AND end_dt_error_flag = 'Y';

Line 3614: UPDATE oks_lines_temp

3610: WHERE dnz_chr_id = p_contract_id
3611: AND end_dt_eff_change_flag = 'Y'
3612: AND end_dt_error_flag = 'Y';
3613:
3614: UPDATE oks_lines_temp
3615: SET undo_status = old_status,
3616: old_status = status
3617: WHERE dnz_chr_id = p_contract_id
3618: AND status_change_flag = 'Y'

Line 3621: UPDATE oks_lines_temp

3617: WHERE dnz_chr_id = p_contract_id
3618: AND status_change_flag = 'Y'
3619: AND status_error_flag = 'N';
3620:
3621: UPDATE oks_lines_temp
3622: SET undo_status = old_status
3623: WHERE dnz_chr_id = p_contract_id
3624: AND status_change_flag = 'Y'
3625: AND status_error_flag = 'Y';

Line 3688: UPDATE oks_lines_temp lin

3684: SET select_flag = NULL,
3685: cascade_flag = NULL
3686: WHERE dnz_chr_id = p_contract_id;
3687:
3688: UPDATE oks_lines_temp lin
3689: SET select_flag = NULL,
3690: cascade_flag = NULL,
3691: price_negotiated = (SELECT Sum(price_negotiated)
3692: FROM oks_sublines_temp sub

Line 3733: DELETE FROM oks_lines_temp WHERE dnz_chr_id = p_contract_id;

3729:
3730: PROCEDURE delete_changes(p_contract_id NUMBER) IS
3731: BEGIN
3732:
3733: DELETE FROM oks_lines_temp WHERE dnz_chr_id = p_contract_id;
3734: DELETE FROM oks_sublines_temp WHERE dnz_chr_id = p_contract_id;
3735: DELETE FROM oks_headers_temp WHERE Chr_id = p_contract_id;
3736: COMMIT;
3737: