APPS.CSD_REPAIRS_UTIL dependencies on OKS_REPROCESSING

Line 3537: -- before calling the API, we need to poll for the order line to appear in the oks_reprocessing table.

3533: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'newly created line id is :'||x_line_tbl(1).line_id);
3534: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Starting the loop!');
3535: END IF;
3536: -- successfully added the service item to order. Call OKS CP to create the warranty contract.
3537: -- before calling the API, we need to poll for the order line to appear in the oks_reprocessing table.
3538: -- This is needed since OM line fulfilment is a deferred workflow activity.
3539:
3540: LOOP
3541: BEGIN

Line 3544: FROM oks_reprocessing

3540: LOOP
3541: BEGIN
3542: SELECT 'Y'
3543: INTO l_dummy
3544: FROM oks_reprocessing
3545: WHERE order_id = l_header_id
3546: AND order_line_id = x_line_tbl(1).line_id;
3547: EXCEPTION
3548: WHEN NO_DATA_FOUND THEN

Line 3592: FROM oks_reprocessing okr,okc_k_headers_all_b okh,okc_k_headers_tl okhtl

3588: -- 1. get the contract number and its short description
3589: BEGIN
3590: SELECT okh.contract_number,okhtl.short_description
3591: INTO l_contract_number,l_contract_description
3592: FROM oks_reprocessing okr,okc_k_headers_all_b okh,okc_k_headers_tl okhtl
3593: WHERE okr.order_line_id = x_line_tbl(1).line_id
3594: AND okr.order_id = l_header_id
3595: AND okr.contract_id = okh.id
3596: AND okh.id = okhtl.id