1 PACKAGE OKE_KCOPY_PKG AUTHID CURRENT_USER AS
2 /*$Header: OKEKCPYS.pls 120.2.12000000.1 2007/01/17 06:50:09 appldev ship $ */
3
4
5 -- GLOBAL VARIABLES
6
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_KCOPY_PKG';
8 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
9 g_proj_copy_allowed VARCHAR2(1) := 'Y';
10
11 SUBTYPE cimv_rec_type IS OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
12
13 /* copies contracts and details.
14
15 p_copy_lines 'Y' if lines are to be copied
16 p_copy_parties 'Y' if party roles are to be copied
17 p_copy_tncs 'Y' if terms and conditions to be copied
18 p_copy_articles 'Y' if articles to be copied
19 p_copy_standard_notes 'Y' if standard_notes to be copied
20 p_copy_admin_yn 'Y' if admin info to be copied
21 'N' if otherwise for all above
22 p_dest_doc_type the new contract type
23 p_dest_doc_number new contract number
24 p_dest_buy_or_sell new buy or sell contract?
25 p_dest_currency_code new currency_code for contract
26 p_dest_start_date new start date
27 p_dest_end_date new end date
28 p_dest_template_yn new contract is template?
29 p_dest_authoring_org_id new authoring org_id,
30 p_dest_inv_organization_id new item master org_id,
31 p_dest_boa_id k_header_id of boa related to delivery order,
32
33 p_source_k_header_id source k_header_id
34 p_copy_user_attributes 'Y' if user attributes are to be copied
35 x_dest_k_header_id new id for new contract returned
36 */
37
38
39 PROCEDURE copy_contract(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45
46 p_copy_lines IN VARCHAR2,
47 p_copy_parties IN VARCHAR2,
48 p_copy_tncs IN VARCHAR2,
49 p_copy_articles IN VARCHAR2,
50 p_copy_standard_notes IN VARCHAR2,
51 p_copy_user_attributes IN VARCHAR2,
52 p_copy_admin_yn IN VARCHAR2 DEFAULT 'Y',
53 p_copy_projecttask_yn IN VARCHAR2 DEFAULT 'N',
54 p_dest_doc_type IN VARCHAR2,
55 p_dest_doc_number IN VARCHAR2,
56 p_dest_buy_or_sell IN VARCHAR2,
57 p_dest_currency_code IN VARCHAR2,
58 p_dest_start_date IN DATE,
59 p_dest_end_date IN DATE,
60 p_dest_template_yn IN VARCHAR2,
61 p_dest_authoring_org_id IN NUMBER,
62 p_dest_inv_organization_id IN NUMBER,
63 p_dest_boa_id IN NUMBER,
64 p_source_k_header_id IN NUMBER,
65 x_dest_k_header_id OUT NOCOPY NUMBER
66 );
67
68 END OKE_KCOPY_PKG;
69
[Home] [Help]