[Home] [Help]
359:
360:
361: cursor deliver_cursor(k_id NUMBER, l_id NUMBER) is
362: select start_date, end_date
363: from oke_k_deliverables_b
364: where k_header_id = k_id and k_line_id = l_id;
365: del_rec deliver_cursor%ROWTYPE;
366:
367: CURSOR get_header_dates(p_id NUMBER)
582: FUNCTION CHILD_DELIVERABLE_EXISTS(p_contract_line_id NUMBER)
583: RETURN VARCHAR2 IS
584:
585: cursor c is
586: select 'X' from oke_k_deliverables_b
587: where k_line_id = p_contract_line_id;
588:
589: l_value VARCHAR2(1);
590: l_found boolean;
4908: b.rate_date,
4909: b.exchange_rate,
4910: b.requisition_line_type_id,
4911: b.po_category_id
4912: from oke_k_deliverables_b b, oke_k_deliverables_tl t
4913: where b.deliverable_id = p_id
4914: and t.deliverable_id = p_id
4915: and t.language = userenv('LANG');
4916:
6334: procedure check_opn_code (p_deliverable_id in number,
6335: x_return_status out nocopy varchar2 ) is
6336:
6337: cursor c(p_deliverable_id Number) IS
6338: select okl.sts_code from okc_k_lines_b okl , oke_k_deliverables_b okb
6339: where okl.id = okb.k_line_id
6340: and okb.deliverable_id=p_deliverable_id;
6341:
6342: cursor opn_csr(p_sts_code varchar2, p_opn_code varchar2) is
6384: -------------------------------
6385: procedure check_deliverable_in_progress(p_deliverable_id in number,
6386: x_return_status out nocopy varchar2 ) is
6387: cursor get_del_dtls is
6388: select mps_transaction_id,po_ref_1,shipping_request_id,completed_flag from oke_k_deliverables_b where deliverable_id=p_deliverable_id;
6389:
6390: CURSOR c1(l_mps_id number) IS
6391: SELECT 'X' FROM MRP_SCHEDULE_DATES
6392: WHERE MPS_TRANSACTION_ID = l_mps_id;