1 PACKAGE oke_change_status_pub AUTHID CURRENT_USER AS
2 /* $Header: OKEPCSTS.pls 120.0.12020000.2 2013/02/22 06:44:28 ansraj noship $ */
3
4 /*
5 * This is the public interface to change the status of Project contract.
6 * metalink 234864.1 See OracleMetaLink bulletin 234864.1
7 * scope public
8 * lifecycle active
9 * displayname Create Project Contract Deliverable
10 * category BUSINESS_ENTITY OKE_CONTRACT
11 */
12
13 ---------------------------------------------------------------------------
14 -- GLOBAL CONSTANTS
15 ---------------------------------------------------------------------------
16 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CHANGE_STATUS_PUB';
17 G_MODULE CONSTANT VARCHAR2(200) := 'oke.plsql.'||G_PKG_NAME||'.';
18 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKE';
19 ------------------------------------------------------------------------------
20
21 subtype chrv_tbl_type is OKC_CONTRACT_PUB.chrv_tbl_type;
22 subtype clev_tbl_type is OKC_CONTRACT_PUB.clev_tbl_type;
23 subtype control_rec_type is okc_util.okc_control_tbl_type;
24
25
26 /*
27 chr_sts_type record is the input for the project contract change status APIs
28 k_header_id -- k_header_id of oke_k_headers; the id of the header
29 new_sts_code -- new status code
30 new_ste_code -- new status code type
31 datetime_cancelled -- cancelled datetime ,by default sysdate is considered as datetime_cancelled
32 reason_code -- Status Change Reason lookup OKC_STS_CHG_REASON
33 comments
34 created_by -- who columns;
35 creation_date
36 last_updated_by
37 last_update_date
38 last_update_login
39 */
40
41 TYPE chr_sts_type IS RECORD(
42 k_header_id NUMBER := OKC_API.G_MISS_NUM,
43 new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
44 new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
45 datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
46 reason_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
47 comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR ,
48 created_by NUMBER := OKE_API.G_MISS_NUM,
49 creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKE_API.G_MISS_DATE,
50 last_updated_by NUMBER := OKE_API.G_MISS_NUM,
51 last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKE_API.G_MISS_DATE,
52 last_update_login NUMBER := OKE_API.G_MISS_NUM
53 );
54
55 TYPE chr_sts_tbl_type IS TABLE OF chr_sts_type INDEX BY BINARY_INTEGER;
56
57 /*
58 * This procedure accepts multiple contracts for status change.
59 * The plsql table chr_sts_tbl_type should be passed to the API containing
60 * the contract which needs status change.
61 * metalink 234864.1 See OracleMetaLink bulletin 234864.1
62 * scope public
63 * lifecycle active
64 * displayname Create Project Contract Deliverable
65 * category BUSINESS_ENTITY OKE_CONTRACT
66 */
67
68 procedure Update_header_status(p_api_version IN NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 p_init_msg_list in varchar2 default FND_API.G_FALSE,
73 p_chr_sts_tbl in OUT NOCOPY chr_sts_tbl_type
74 );
75
76 /*
77 * To change the status of Project contract
78 * This procedure accepts contract_id and the new_sts_code ,new_ste_code and
79 * changes the status of the Contract, the lines are also updated to the same status.
80 * metalink 234864.1 See OracleMetaLink bulletin 234864.1
81 * scope public
82 * lifecycle active
83 * displayname Create Project Contract Deliverable
84 * category BUSINESS_ENTITY OKE_CONTRACT
85 */
86
87
88 procedure Update_header_status(p_api_version IN NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 p_init_msg_list in varchar2 default FND_API.G_FALSE,
93 p_chr_sts_rec in OUT NOCOPY chr_sts_type
94 );
95
96
97
98 END oke_change_status_pub;