[Home] [Help]
PACKAGE: APPS.OKL_VENDOR_PROGRAM_PVT
Source
1 PACKAGE OKL_VENDOR_PROGRAM_PVT AUTHID CURRENT_USER AS
2 /*$Header: OKLRPRMS.pls 120.5 2006/11/03 10:55:11 sosharma noship $*/
3
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,
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,
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,
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
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 ';
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';
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
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,
67 p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL,
68 x_header_rec OUT NOCOPY chrv_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,
78 p_program_id IN okl_k_headers_full_v.id%TYPE,
79 p_parent_agreement_id IN okc_k_headers_v.ID%TYPE DEFAULT NULL);
80
81
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);
91
92
93 END OKL_VENDOR_PROGRAM_PVT;