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_SUBLINES_TEMP

Line 25: DELETE FROM oks_sublines_temp

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;
27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: EXCEPTION

Line 185: FROM oks_sublines_temp

181: reason_code,
182: status,
183: new_status,
184: comments
185: FROM oks_sublines_temp
186: WHERE status_change_flag = 'Y'
187: AND dnz_chr_id = to_number(p_contract_id));
188:
189: IF l_mass_update_status_tbl.Count > 0 THEN

Line 213: UPDATE oks_sublines_temp

209: ' is not a valid status for the existing status type ' ||
210: l_old_ste_code
211: WHERE id = l_mass_update_status_tbl(i).line_id;
212: ELSE
213: UPDATE oks_sublines_temp
214: SET status_error_flag = 'Y',
215: status_err_message = l_new_ste_code ||
216: ' is not a valid status for the existing status type ' ||
217: l_old_ste_code

Line 226: UPDATE oks_sublines_temp

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
227: SET status_error_flag = 'N', error_message = NULL
228: WHERE id = l_mass_update_status_tbl(i).sub_line_id;
229: END IF;
230:

Line 273: FROM oks_sublines_temp

269: lse_id,
270: line_number,
271: start_date,
272: end_date
273: FROM oks_sublines_temp
274: WHERE (start_dt_eff_change_flag = 'Y' OR
275: end_dt_eff_change_flag = 'Y')
276: AND dnz_chr_id = to_number(p_contract_id));
277:

Line 325: UPDATE oks_sublines_temp

321: IF (l_mass_update_eff_tbl(i)
322: .start_date < l_kl_start_date OR l_mass_update_eff_tbl(i)
323: .start_date > l_kl_end_date) THEN
324:
325: UPDATE oks_sublines_temp
326: SET start_dt_error_flag = 'Y',
327: st_dt_err_message = Nvl2(st_dt_err_message, st_dt_err_message || ' - Subline Start Date is out of Contract line''s Effectivity, subline_number: ' || l_mass_update_eff_tbl(i).line_number,
328: 'Subline Start Date is out of Contract line''s Effectivity, subline_number: ' || l_mass_update_eff_tbl(i).line_number )
329: WHERE id = l_mass_update_eff_tbl(i).sub_line_id;

Line 338: UPDATE oks_sublines_temp

334: IF (l_mass_update_eff_tbl(i)
335: .end_date < l_kl_start_date OR l_mass_update_eff_tbl(i)
336: .end_date > l_kl_end_date) THEN
337:
338: UPDATE oks_sublines_temp
339: SET end_dt_error_flag = 'Y',
340: end_dt_err_message = Nvl2(end_dt_err_message , end_dt_err_message || ' - Subline End Date is out of Contract line''s Effectivity, subline_number: '|| l_mass_update_eff_tbl(i).line_number,
341: 'Subline End Date is out of Contract line''s Effectivity, subline_number: '|| l_mass_update_eff_tbl(i).line_number)
342: WHERE id = l_mass_update_eff_tbl(i).sub_line_id;

Line 356: UPDATE oks_sublines_temp

352: IF (l_mass_update_eff_tbl(i)
353: .start_date < l_k_start_date OR l_mass_update_eff_tbl(i)
354: .start_date > l_k_end_date) THEN
355:
356: UPDATE oks_sublines_temp
357: SET start_dt_error_flag = 'Y',
358: st_dt_err_message = Nvl2(st_dt_err_message, st_dt_err_message ||' - Subline Start Date is out of Contract''s Effectivity, subline_number: '|| l_mass_update_eff_tbl(i).line_number,
359: 'Subline Start Date is out of Contract''s Effectivity, subline_number: '|| l_mass_update_eff_tbl(i).line_number)
360: WHERE id = l_mass_update_eff_tbl(i).sub_line_id;

Line 369: UPDATE oks_sublines_temp

365: IF (l_mass_update_eff_tbl(i)
366: .end_date < l_k_start_date OR l_mass_update_eff_tbl(i)
367: .end_date > l_k_end_date) THEN
368:
369: UPDATE oks_sublines_temp
370: SET end_dt_error_flag = 'Y',
371: end_dt_err_message = Nvl2(end_dt_err_message, end_dt_err_message || ' - Subline End Date is out of Contract''s Effectivity, subline_number: '|| l_mass_update_eff_tbl(i).line_number,
372: 'Subline End Date is out of Contract''s Effectivity, subline_number: '|| l_mass_update_eff_tbl(i).line_number)
373: WHERE id = l_mass_update_eff_tbl(i).sub_line_id;

Line 966: FROM oks_sublines_temp

962: begin
963:
964: SELECT cle_id, id, dnz_chr_id, lse_id,line_number,price_negotiated BULK COLLECT
965: INTO l_mass_update_price_tbl
966: FROM oks_sublines_temp
967: WHERE price_change_flag = 'Y'
968: AND dnz_chr_id = To_Number(p_contract_id);
969:
970: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;

Line 1050: FROM oks_sublines_temp

1046: AND dnz_chr_id = To_Number(p_contract_id)
1047: UNION ALL
1048: SELECT line_number,
1049: status_err_message
1050: FROM oks_sublines_temp
1051: WHERE (status_change_flag = 'Y' AND status_error_flag = 'Y')
1052: AND dnz_chr_id = to_number(p_contract_id)) LOOP
1053:
1054: IF l_count = 0 THEN

Line 1092: FROM oks_sublines_temp

1088: reason_code,
1089: status,
1090: new_status,
1091: comments
1092: FROM oks_sublines_temp
1093: WHERE (status_change_flag = 'Y' AND status_error_flag = 'N')
1094: AND dnz_chr_id = to_number(p_contract_id));
1095:
1096: IF l_mass_update_status_tbl.Count > 0 THEN

Line 1190: FROM oks_sublines_temp

1186: DECODE(end_dt_error_flag,
1187: 'Y',
1188: 'End Date Error: ' || end_dt_err_message,
1189: '') end_dt_err
1190: FROM oks_sublines_temp
1191: WHERE ((start_dt_eff_change_flag = 'Y' AND
1192: start_dt_error_flag = 'Y') OR (end_dt_eff_change_flag = 'Y' AND
1193: end_dt_error_flag = 'Y'))
1194: AND dnz_chr_id = to_number(p_contract_id)) LOOP

Line 1239: FROM oks_sublines_temp lin

1235: lse_id,
1236: line_number,
1237: start_date,
1238: end_date
1239: FROM oks_sublines_temp lin
1240: WHERE ((start_dt_eff_change_flag = 'Y' AND
1241: start_dt_error_flag = 'N') OR
1242: (end_dt_eff_change_flag = 'Y' AND end_dt_error_flag = 'N'))
1243: AND dnz_chr_id = to_number(p_contract_id));

Line 1780: UPDATE oks_sublines_temp

1776: AND sl.cle_id = l.id;
1777:
1778: IF (p_start_date < l_kl_start_date OR p_start_date > l_kl_end_date) THEN
1779:
1780: UPDATE oks_sublines_temp
1781: SET start_dt_error_flag = 'Y',
1782: st_dt_err_message = Nvl2(st_dt_err_message, st_dt_err_message || ' - Subline Start Date is out of Contract line''s Effectivity, subline number: ' || p_line_number,
1783: 'Subline Start Date is out of Contract line''s Effectivity, subline number: ' || p_line_number )
1784: WHERE id = p_subline_id;

Line 1790: UPDATE oks_sublines_temp

1786: exception_yn := 'Y';
1787: END IF;
1788: IF (p_end_date < l_kl_start_date OR p_end_date > l_kl_end_date) THEN
1789:
1790: UPDATE oks_sublines_temp
1791: SET end_dt_error_flag = 'Y',
1792: end_dt_err_message = Nvl2(end_dt_err_message , end_dt_err_message || ' - Subline End Date is out of Contract line''s Effectivity, subline number: ' || p_line_number,
1793: 'Subline End Date is out of Contract line''s Effectivity, subline number: ' || p_line_number)
1794: WHERE id = p_subline_id;

Line 1806: UPDATE oks_sublines_temp

1802: WHERE id = l_chr_id;
1803:
1804: IF (p_start_date < l_k_start_date OR p_start_date > l_k_end_date) THEN
1805:
1806: UPDATE oks_sublines_temp
1807: SET start_dt_error_flag = 'Y',
1808: st_dt_err_message = Nvl2(st_dt_err_message, st_dt_err_message ||' - Subline Start Date is out of Contract''s Effectivity, subline number: ' || p_line_number,
1809: 'Subline Start Date is out of Contract''s Effectivity, subline number: ' || p_line_number)
1810: WHERE id = p_subline_id;

Line 1817: UPDATE oks_sublines_temp

1813: END IF;
1814:
1815: IF (p_end_date < l_k_start_date OR p_end_date > l_k_end_date) THEN
1816:
1817: UPDATE oks_sublines_temp
1818: SET end_dt_error_flag = 'Y',
1819: end_dt_err_message = Nvl2(end_dt_err_message, end_dt_err_message || ' - Subline End Date is out of Contract''s Effectivity, subline number: ' || p_line_number,
1820: 'Subline End Date is out of Contract''s Effectivity, subline number: ' || p_line_number)
1821: WHERE id = p_subline_id;

Line 2839: INSERT INTO oks_sublines_temp

2835: AND lin.lse_id IN (1, 12, 14, 19)
2836: AND lin.dnz_chr_id = p_contract_id
2837: ORDER BY To_Number(lin.line_number);
2838:
2839: INSERT INTO oks_sublines_temp
2840: (id,
2841: cle_id,
2842: dnz_chr_id,
2843: id_char,

Line 3336: UPDATE oks_sublines_temp

3332: ORDER BY To_Number((SELECT line_number
3333: FROM okc_k_lines_b line
3334: WHERE line.id = lin.cle_id)),To_Number(lin.line_number); */
3335:
3336: UPDATE oks_sublines_temp
3337: SET top_lvl_parent = -99
3338: WHERE top_lvl_parent <> -99
3339: AND dnz_chr_id = p_contract_id
3340: AND top_lvl_parent NOT IN

Line 3342: FROM oks_sublines_temp

3338: WHERE top_lvl_parent <> -99
3339: AND dnz_chr_id = p_contract_id
3340: AND top_lvl_parent NOT IN
3341: (SELECT customer_product_id
3342: FROM oks_sublines_temp
3343: WHERE dnz_chr_id = p_contract_id
3344: AND Nvl(top_lvl_parent, -99) = -99
3345: AND customer_product_id IS NOT NULL);
3346:

Line 3398: FROM oks_sublines_temp sublines

3394: old_start_date,
3395: old_end_date,
3396: old_status,
3397: old_price_negotiated
3398: FROM oks_sublines_temp sublines
3399: WHERE dnz_chr_id = p_contract_id
3400: AND top_lvl_parent = -99
3401: AND (
3402: Nvl(select_flag,'N') = 'Y'

Line 3424: FROM oks_sublines_temp sublineschild

3420: old_start_date,
3421: old_end_date,
3422: old_status,
3423: old_price_negotiated
3424: FROM oks_sublines_temp sublineschild
3425: WHERE dnz_chr_id = p_contract_id
3426: AND top_lvl_parent <> -99
3427: AND (
3428: Nvl(select_flag,'N') = 'Y'

Line 3433: OR EXISTS (SELECT 1 FROM oks_sublines_temp sublines

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
3434: WHERE sublines.customer_product_id = sublineschild.top_lvl_parent
3435: AND sublines.dnz_chr_id = sublineschild.dnz_chr_id
3436: AND sublines.cle_id = sublineschild.cle_id
3437: AND Nvl(sublines.cascade_flag,'N') = 'Y' )

Line 3456: FROM oks_sublines_temp tmp, okc_k_lines_b lin

3452: FROM okc_statuses_b sts
3453: WHERE sts.code = lin.sts_code),
3454: 'N',
3455: 'Y') status_change
3456: FROM oks_sublines_temp tmp, okc_k_lines_b lin
3457: WHERE tmp.id = lin.id
3458: AND tmp.dnz_chr_id = p_contract_id;
3459:
3460:

Line 3484: FROM oks_sublines_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
3484: FROM oks_sublines_temp
3485: WHERE dnz_chr_id = p_contract_id
3486: AND (start_dt_error_flag = 'Y' OR end_dt_error_flag = 'Y' OR status_error_flag = 'Y'));
3487:
3488: l_sel_lines_exist VARCHAR2(1);

Line 3515: UPDATE oks_sublines_temp

3511: END LOOP;
3512:
3513: FOR subline IN c_sel_config LOOP
3514:
3515: UPDATE oks_sublines_temp
3516: SET start_date = nvl(l_global_start_date,start_date),
3517: end_date = Nvl(l_global_end_date,end_date),
3518: price_negotiated = Nvl(l_global_price, price_negotiated),
3519: new_status = Nvl(l_global_new_status,new_status),

Line 3530: UPDATE oks_sublines_temp

3526: END LOOP;
3527:
3528: FOR sublinechild IN c_sel_component LOOP
3529:
3530: UPDATE oks_sublines_temp
3531: SET start_date = nvl(l_global_start_date,start_date),
3532: end_date = Nvl(l_global_end_date,end_date),
3533: price_negotiated = Nvl(l_global_price, price_negotiated),
3534: new_status = Nvl(l_global_new_status,new_status),

Line 3547: UPDATE oks_sublines_temp tmp

3543:
3544: FOR modified IN c_modified LOOP
3545:
3546:
3547: UPDATE oks_sublines_temp tmp
3548: SET start_dt_eff_change_flag = modified.start_date_change,
3549: end_dt_eff_change_flag = modified.end_date_change,
3550: price_change_flag = modified.price_change,
3551: status_change_flag = modified.status_change

Line 3577: UPDATE oks_sublines_temp

3573: end_dt_err_message = NULL,
3574: status_err_message = NULL
3575: WHERE dnz_chr_id = p_contract_id;
3576:
3577: UPDATE oks_sublines_temp
3578: SET start_dt_error_flag = 'N',
3579: end_dt_error_flag = 'N',
3580: status_error_flag = 'N',
3581: st_dt_err_message = NULL,

Line 3627: UPDATE oks_sublines_temp

3623: WHERE dnz_chr_id = p_contract_id
3624: AND status_change_flag = 'Y'
3625: AND status_error_flag = 'Y';
3626:
3627: UPDATE oks_sublines_temp
3628: SET undo_start_date = old_start_date,
3629: old_start_date = start_date
3630: WHERE dnz_chr_id = p_contract_id
3631: AND start_dt_eff_change_flag = 'Y'

Line 3634: UPDATE oks_sublines_temp

3630: WHERE dnz_chr_id = p_contract_id
3631: AND start_dt_eff_change_flag = 'Y'
3632: AND start_dt_error_flag = 'N';
3633:
3634: UPDATE oks_sublines_temp
3635: SET undo_start_date = old_start_date
3636: WHERE dnz_chr_id = p_contract_id
3637: AND start_dt_eff_change_flag = 'Y'
3638: AND start_dt_error_flag = 'Y';

Line 3640: UPDATE oks_sublines_temp

3636: WHERE dnz_chr_id = p_contract_id
3637: AND start_dt_eff_change_flag = 'Y'
3638: AND start_dt_error_flag = 'Y';
3639:
3640: UPDATE oks_sublines_temp
3641: SET undo_end_date = old_end_date,
3642: old_end_date = end_date
3643: WHERE dnz_chr_id = p_contract_id
3644: AND end_dt_eff_change_flag = 'Y'

Line 3647: UPDATE oks_sublines_temp

3643: WHERE dnz_chr_id = p_contract_id
3644: AND end_dt_eff_change_flag = 'Y'
3645: AND end_dt_error_flag = 'N';
3646:
3647: UPDATE oks_sublines_temp
3648: SET undo_end_date = old_end_date
3649: WHERE dnz_chr_id = p_contract_id
3650: AND end_dt_eff_change_flag = 'Y'
3651: AND end_dt_error_flag = 'Y';

Line 3653: UPDATE oks_sublines_temp

3649: WHERE dnz_chr_id = p_contract_id
3650: AND end_dt_eff_change_flag = 'Y'
3651: AND end_dt_error_flag = 'Y';
3652:
3653: UPDATE oks_sublines_temp
3654: SET undo_status = old_status,
3655: old_status = status
3656: WHERE dnz_chr_id = p_contract_id
3657: AND status_change_flag = 'Y'

Line 3660: UPDATE oks_sublines_temp

3656: WHERE dnz_chr_id = p_contract_id
3657: AND status_change_flag = 'Y'
3658: AND status_error_flag = 'N';
3659:
3660: UPDATE oks_sublines_temp
3661: SET undo_status = old_status
3662: WHERE dnz_chr_id = p_contract_id
3663: AND status_change_flag = 'Y'
3664: AND status_error_flag = 'Y';

Line 3666: UPDATE oks_sublines_temp

3662: WHERE dnz_chr_id = p_contract_id
3663: AND status_change_flag = 'Y'
3664: AND status_error_flag = 'Y';
3665:
3666: UPDATE oks_sublines_temp
3667: SET undo_price_negotiated = old_price_negotiated,
3668: old_price_negotiated = price_negotiated
3669: WHERE dnz_chr_id = p_contract_id
3670: AND price_change_flag = 'Y'

Line 3683: UPDATE oks_sublines_temp

3679: global_comments = NULL,
3680: saved_flag = 'Y'
3681: WHERE chr_id = p_contract_id;
3682:
3683: UPDATE oks_sublines_temp
3684: SET select_flag = NULL,
3685: cascade_flag = NULL
3686: WHERE dnz_chr_id = p_contract_id;
3687:

Line 3692: FROM oks_sublines_temp sub

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
3693: WHERE sub.cle_id = lin.id)
3694: WHERE dnz_chr_id = p_contract_id;
3695:
3696: OPEN c_get_error_records;

Line 3734: DELETE FROM oks_sublines_temp WHERE dnz_chr_id = p_contract_id;

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:
3738: END delete_changes;