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 3028: FROM oks_reprocessing_v rep, oe_order_headers oh

3024: CURSOR l_order_line_sub_csr
3025: IS
3026: SELECT ID, order_id, order_line_id, success_flag, source_flag,
3027: rep.order_number
3028: FROM oks_reprocessing_v rep, oe_order_headers oh
3029: WHERE success_flag = 'R'
3030: AND rep.order_id = oh.header_id
3031: AND conc_request_id IS NULL;
3032:

Line 3037: FROM oks_reprocessing_v rep, oe_order_headers oh

3033: CURSOR l_order_line_sel_csr
3034: IS
3035: SELECT ID, order_id, order_line_id, success_flag, source_flag,
3036: rep.order_number
3037: FROM oks_reprocessing_v rep, oe_order_headers oh
3038: WHERE reprocess_yn = 'Y' --success_flag IN ('R','N')
3039: AND rep.order_id = oh.header_id
3040: AND conc_request_id IS NULL;
3041:

Line 3046: FROM oks_reprocessing_v rep, oe_order_headers oh

3042: CURSOR l_order_line_all_csr
3043: IS
3044: SELECT ID, order_id, order_line_id, success_flag, source_flag,
3045: rep.order_number
3046: FROM oks_reprocessing_v rep, oe_order_headers oh
3047: WHERE NVL (success_flag, 'E') IN ('E', 'N') ---IN ('R','N','E')
3048: AND rep.order_id = oh.header_id
3049: AND conc_request_id IS NULL;
3050:

Line 3090: FROM oks_reprocessing rep, oe_order_headers hdr

3086: --mmadhavi modified the cursor for MOAC
3087: CURSOR check_duplicate_csr (p_ordline_id NUMBER)
3088: IS
3089: SELECT 'x'
3090: FROM oks_reprocessing rep, oe_order_headers hdr
3091: WHERE rep.order_line_id = p_ordline_id
3092: AND rep.order_id = hdr.header_id;
3093:
3094: l_ord_line_id NUMBER;

Line 3538: SAVEPOINT oks_reprocessing;

3534: l_req_id := fnd_global.conc_request_id;
3535: fnd_file.put_line (fnd_file.LOG, 'conc_prog_id = ' || l_prog_id);
3536: fnd_file.put_line (fnd_file.LOG, 'conc_req_id = ' || l_req_id);
3537: fnd_file.put_line (fnd_file.LOG, 'Source = ' || NVL (p_source, 'Auto'));
3538: SAVEPOINT oks_reprocessing;
3539: fnd_file.put_line (fnd_file.LOG, 'Start of Reprocessing.....');
3540: fnd_file.put_line (fnd_file.LOG,
3541: 'The parameter value is ..' || p_option
3542: );

Line 4320: FROM oks_reprocessing_v

4316: IS
4317: CURSOR l_order_line_csr
4318: IS
4319: SELECT ID
4320: FROM oks_reprocessing_v
4321: WHERE success_flag = 'S';
4322:
4323: l_repv_tbl oks_rep_pvt.repv_tbl_type;
4324: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

Line 4508: FROM oks_reprocessing

4504:
4505: CURSOR check_ordline_exists (p_ordlineid NUMBER)
4506: IS
4507: SELECT 'x'
4508: FROM oks_reprocessing
4509: WHERE order_line_id = p_ordlineid;
4510:
4511: --Fix for bug 3492335
4512: CURSOR is_ib_trackable (