4: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
6:
7: TYPE program_header_rec_type is RECORD (
8: p_agreement_number okl_k_headers_full_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_contract_category okl_k_headers_full_v.scs_code%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
5: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
6:
7: TYPE program_header_rec_type is RECORD (
8: p_agreement_number okl_k_headers_full_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_contract_category okl_k_headers_full_v.scs_code%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
6:
7: TYPE program_header_rec_type is RECORD (
8: p_agreement_number okl_k_headers_full_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_contract_category okl_k_headers_full_v.scs_code%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
7: TYPE program_header_rec_type is RECORD (
8: p_agreement_number okl_k_headers_full_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_contract_category okl_k_headers_full_v.scs_code%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
8: p_agreement_number okl_k_headers_full_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_contract_category okl_k_headers_full_v.scs_code%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
9: p_contract_category okl_k_headers_full_v.scs_code%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
10: p_start_date okl_k_headers_full_v.start_date%TYPE := OKL_API.G_MISS_DATE,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
11: p_end_date okl_k_headers_full_v.end_date%TYPE := OKL_API.G_MISS_DATE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
12: p_short_description okl_k_headers_full_v.short_description%TYPE := OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
13: p_description okl_k_headers_full_v.description%TYPE := OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
14: p_comments okl_k_headers_full_v.comments%TYPE := OKL_API.G_MISS_CHAR,
15: p_template_yn okl_k_headers_full_v.template_yn%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
16: P_qcl_id okl_k_headers_full_v.qcl_id%TYPE := OKL_API.G_MISS_NUM,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
17: p_issue_or_receive okl_k_headers_full_v.issue_or_receive%TYPE := OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
18: p_workflow_process okc_k_processes_v.pdf_id%TYPE := OKL_API.G_MISS_NUM,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
19: p_referred_id okl_k_headers_full_v.khr_id%TYPE,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
20: p_object1_id1 okc_k_party_roles_v.object1_id1%TYPE :=OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
21: p_object1_id2 okc_k_party_roles_v.object1_id2%TYPE :=OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
22: p_attribute_category okl_k_headers_full_v.attribute_category%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
23: p_attribute1 okl_k_headers_full_v.attribute1%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
24: p_attribute2 okl_k_headers_full_v.attribute2%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
25: p_attribute3 okl_k_headers_full_v.attribute3%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
26: p_attribute4 okl_k_headers_full_v.attribute4%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
27: p_attribute5 okl_k_headers_full_v.attribute5%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
28: p_attribute6 okl_k_headers_full_v.attribute6%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
36: p_attribute14 okl_k_headers_full_v.attribute14%TYPE:= OKL_API.G_MISS_CHAR,
29: p_attribute7 okl_k_headers_full_v.attribute7%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
36: p_attribute14 okl_k_headers_full_v.attribute14%TYPE:= OKL_API.G_MISS_CHAR,
37: p_attribute15 okl_k_headers_full_v.attribute15%TYPE:= OKL_API.G_MISS_CHAR,
30: p_attribute8 okl_k_headers_full_v.attribute8%TYPE:= OKL_API.G_MISS_CHAR,
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
36: p_attribute14 okl_k_headers_full_v.attribute14%TYPE:= OKL_API.G_MISS_CHAR,
37: p_attribute15 okl_k_headers_full_v.attribute15%TYPE:= OKL_API.G_MISS_CHAR,
38: /* sosharma 31-Oct-2006
31: p_attribute9 okl_k_headers_full_v.attribute9%TYPE:= OKL_API.G_MISS_CHAR,
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
36: p_attribute14 okl_k_headers_full_v.attribute14%TYPE:= OKL_API.G_MISS_CHAR,
37: p_attribute15 okl_k_headers_full_v.attribute15%TYPE:= OKL_API.G_MISS_CHAR,
38: /* sosharma 31-Oct-2006
39: Build:R12
32: p_attribute10 okl_k_headers_full_v.attribute10%TYPE:= OKL_API.G_MISS_CHAR,
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
36: p_attribute14 okl_k_headers_full_v.attribute14%TYPE:= OKL_API.G_MISS_CHAR,
37: p_attribute15 okl_k_headers_full_v.attribute15%TYPE:= OKL_API.G_MISS_CHAR,
38: /* sosharma 31-Oct-2006
39: Build:R12
40: p_legal_entity_id added to the record structure
33: p_attribute11 okl_k_headers_full_v.attribute11%TYPE:= OKL_API.G_MISS_CHAR,
34: p_attribute12 okl_k_headers_full_v.attribute12%TYPE:= OKL_API.G_MISS_CHAR,
35: p_attribute13 okl_k_headers_full_v.attribute13%TYPE:= OKL_API.G_MISS_CHAR,
36: p_attribute14 okl_k_headers_full_v.attribute14%TYPE:= OKL_API.G_MISS_CHAR,
37: p_attribute15 okl_k_headers_full_v.attribute15%TYPE:= OKL_API.G_MISS_CHAR,
38: /* sosharma 31-Oct-2006
39: Build:R12
40: p_legal_entity_id added to the record structure
41: */
38: /* sosharma 31-Oct-2006
39: Build:R12
40: p_legal_entity_id added to the record structure
41: */
42: p_legal_entity_id okl_k_headers_full_v.legal_entity_id%TYPE:= OKL_API.G_MISS_NUM
43: );
44:
45:
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VENDOR_PROGRAM_PVT ';
43: );
44:
45:
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VENDOR_PROGRAM_PVT ';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
48:
49:
50: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
51: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VENDOR_PROGRAM_PVT ';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
48:
49:
50: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
51: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
48:
49:
50: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
51: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
55: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
55: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
56: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
57: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
58: G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
59:
60:
58: G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
59:
60:
61: PROCEDURE create_program(p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: p_hdr_rec IN program_header_rec_type,
69: x_k_header_rec OUT NOCOPY khrv_rec_type);
70:
71:
72: PROCEDURE update_program(p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_hdr_rec IN program_header_rec_type,
82: FUNCTION Is_Process_Active(p_chr_id IN okl_k_headers_full_v.id%TYPE) RETURN VARCHAR2;
83:
84:
85: PROCEDURE passed_to_incomplete(p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_program_id IN OKC_K_HEADERS_V.ID%TYPE);