24: SUBTYPE cimv_rec_type IS OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
25:
26:
27: TYPE header_rec_type IS RECORD (
28: id okl_k_headers_full_v.id%TYPE,
29: inv_organization_id okl_k_headers_full_v.inv_organization_id%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
25:
26:
27: TYPE header_rec_type IS RECORD (
28: id okl_k_headers_full_v.id%TYPE,
29: inv_organization_id okl_k_headers_full_v.inv_organization_id%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
26:
27: TYPE header_rec_type IS RECORD (
28: id okl_k_headers_full_v.id%TYPE,
29: inv_organization_id okl_k_headers_full_v.inv_organization_id%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
27: TYPE header_rec_type IS RECORD (
28: id okl_k_headers_full_v.id%TYPE,
29: inv_organization_id okl_k_headers_full_v.inv_organization_id%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
28: id okl_k_headers_full_v.id%TYPE,
29: inv_organization_id okl_k_headers_full_v.inv_organization_id%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
29: inv_organization_id okl_k_headers_full_v.inv_organization_id%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
30: sts_code okl_k_headers_full_v.sts_code%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
31: qcl_id okl_k_headers_full_v.qcl_id%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
39: term_duration okl_k_headers_full_v.term_duration%TYPE,
32: scs_code okl_k_headers_full_v.scs_code%TYPE,
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
39: term_duration okl_k_headers_full_v.term_duration%TYPE,
40: authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE
33: contract_number okl_k_headers_full_v.contract_number%TYPE,
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
39: term_duration okl_k_headers_full_v.term_duration%TYPE,
40: authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE
41: );
34: currency_code okl_k_headers_full_v.currency_code%TYPE,
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
39: term_duration okl_k_headers_full_v.term_duration%TYPE,
40: authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE
41: );
42:
35: cust_po_number okl_k_headers_full_v.cust_po_number%TYPE,
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
39: term_duration okl_k_headers_full_v.term_duration%TYPE,
40: authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE
41: );
42:
43: -- Cursors
36: short_description okl_k_headers_full_v.short_description%TYPE,
37: start_date okl_k_headers_full_v.start_date%TYPE,
38: end_date okl_k_headers_full_v.end_date%TYPE,
39: term_duration okl_k_headers_full_v.term_duration%TYPE,
40: authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE
41: );
42:
43: -- Cursors
44: --Fixed Bug # 5484903
463: PROCEDURE get_contract_header(
464: x_return_status OUT NOCOPY VARCHAR2,
465: x_msg_count OUT NOCOPY NUMBER,
466: x_msg_data OUT NOCOPY VARCHAR2,
467: p_chr_id IN okl_k_headers_full_v.id%TYPE,
468: x_header_rec OUT NOCOPY header_rec_type
469: ) IS
470: CURSOR header_csr (p_chr_id okl_k_headers_full_v.id%TYPE) IS
471: SELECT id,
466: x_msg_data OUT NOCOPY VARCHAR2,
467: p_chr_id IN okl_k_headers_full_v.id%TYPE,
468: x_header_rec OUT NOCOPY header_rec_type
469: ) IS
470: CURSOR header_csr (p_chr_id okl_k_headers_full_v.id%TYPE) IS
471: SELECT id,
472: inv_organization_id,
473: sts_code,
474: qcl_id,
480: start_date,
481: end_date,
482: term_duration,
483: authoring_org_id
484: FROM okl_k_headers_full_v
485: WHERE id = p_chr_id;
486:
487: header_failed EXCEPTION;
488: l_proc_name VARCHAR2(35) := 'GET_CONTRACT_HEADER';