APPS.OKS_OCINT_PUB dependencies on OKS_REPROCESSING

Line 160: FROM oks_reprocessing

156:
157: CURSOR check_ordline_exists (p_ordlineid NUMBER)
158: IS
159: SELECT 'x'
160: FROM oks_reprocessing
161: WHERE order_line_id = p_ordlineid;
162:
163: --Fix for bug 3492335
164: CURSOR is_ib_trackable (

Line 536: FROM oks_reprocessing_v

532: IS
533: CURSOR l_old_repv_csr (p_id NUMBER)
534: IS
535: SELECT object_version_number
536: FROM oks_reprocessing_v
537: WHERE ID = p_id;
538:
539: --l_old_repv_rec l_old_repv_csr%ROWTYPE;
540: l_obj_vers_num NUMBER;

Line 2384: FROM oks_reprocessing_v rep, oe_order_headers oh

2380: CURSOR l_order_line_sub_csr
2381: IS
2382: SELECT ID, order_id, order_line_id, success_flag, source_flag,
2383: rep.order_number
2384: FROM oks_reprocessing_v rep, oe_order_headers oh
2385: WHERE success_flag = 'R'
2386: AND rep.order_id = oh.header_id
2387: AND conc_request_id IS NULL;
2388:

Line 2393: FROM oks_reprocessing_v rep, oe_order_headers oh

2389: CURSOR l_order_line_sel_csr
2390: IS
2391: SELECT ID, order_id, order_line_id, success_flag, source_flag,
2392: rep.order_number
2393: FROM oks_reprocessing_v rep, oe_order_headers oh
2394: WHERE reprocess_yn = 'Y' --success_flag IN ('R','N')
2395: AND rep.order_id = oh.header_id
2396: AND conc_request_id IS NULL;
2397:

Line 2402: FROM oks_reprocessing_v rep, oe_order_headers oh

2398: CURSOR l_order_line_all_csr
2399: IS
2400: SELECT ID, order_id, order_line_id, success_flag, source_flag,
2401: rep.order_number
2402: FROM oks_reprocessing_v rep, oe_order_headers oh
2403: WHERE NVL (success_flag, 'E') IN ('E', 'N') ---IN ('R','N','E')
2404: AND rep.order_id = oh.header_id
2405: AND conc_request_id IS NULL;
2406:

Line 2446: FROM oks_reprocessing rep, oe_order_headers hdr

2442: --mmadhavi modified the cursor for MOAC
2443: CURSOR check_duplicate_csr (p_ordline_id NUMBER)
2444: IS
2445: SELECT 'x'
2446: FROM oks_reprocessing rep, oe_order_headers hdr
2447: WHERE rep.order_line_id = p_ordline_id
2448: AND rep.order_id = hdr.header_id;
2449:
2450: l_ord_line_id NUMBER;

Line 2894: SAVEPOINT oks_reprocessing;

2890: l_req_id := fnd_global.conc_request_id;
2891: fnd_file.put_line (fnd_file.LOG, 'conc_prog_id = ' || l_prog_id);
2892: fnd_file.put_line (fnd_file.LOG, 'conc_req_id = ' || l_req_id);
2893: fnd_file.put_line (fnd_file.LOG, 'Source = ' || NVL (p_source, 'Auto'));
2894: SAVEPOINT oks_reprocessing;
2895: fnd_file.put_line (fnd_file.LOG, 'Start of Reprocessing.....');
2896: fnd_file.put_line (fnd_file.LOG,
2897: 'The parameter value is ..' || p_option
2898: );

Line 3676: FROM oks_reprocessing_v

3672: IS
3673: CURSOR l_order_line_csr
3674: IS
3675: SELECT ID
3676: FROM oks_reprocessing_v
3677: WHERE success_flag = 'S';
3678:
3679: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3680: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

Line 3864: FROM oks_reprocessing

3860:
3861: CURSOR check_ordline_exists (p_ordlineid NUMBER)
3862: IS
3863: SELECT 'x'
3864: FROM oks_reprocessing
3865: WHERE order_line_id = p_ordlineid;
3866:
3867: --Fix for bug 3492335
3868: CURSOR is_ib_trackable (