[Home] [Help]
PACKAGE: APPS.CS_GET_CONTRACT_VALUES_PUB
Source
1 PACKAGE CS_GET_CONTRACT_VALUES_PUB AUTHID CURRENT_USER AS
2 /* $Header: csctvals.pls 115.3 99/07/16 08:55:38 porting ship $ */
3
4 /*******************************************************************************
5 -- GLOBAL VARIABLES
6 *******************************************************************************/
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTRACT_VALUES_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := 'CS';
10
11 /*******************************************************************************
12 -- Procedures and Functions
13 *******************************************************************************/
14
15 PROCEDURE Get_PO_Required (
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_contract_id IN NUMBER,
20 p_cp_service_id IN NUMBER,
21 x_PO_required_for_service OUT VARCHAR2,
22 x_return_status OUT VARCHAR2,
23 x_msg_count OUT NUMBER,
24 x_msg_data OUT VARCHAR2 );
25
26 PROCEDURE Get_Pre_Payment_Required (
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29 p_commit IN VARCHAR2 := FND_API.G_FALSE,
30 p_contract_id IN NUMBER,
31 p_cp_service_id IN NUMBER,
32 x_pre_payment_required OUT VARCHAR2,
33 x_return_status OUT VARCHAR2,
34 x_msg_count OUT NUMBER,
35 x_msg_data OUT VARCHAR2 );
36
37 PROCEDURE Get_Address (
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_cp_service_id IN NUMBER,
42 x_bill_address_id OUT NUMBER,
43 x_bill_address1 OUT VARCHAR2,
44 x_bill_address2 OUT VARCHAR2,
45 x_bill_address3 OUT VARCHAR2,
46 x_ship_address_id OUT NUMBER,
47 x_ship_address1 OUT VARCHAR2,
48 x_ship_address2 OUT VARCHAR2,
49 x_ship_address3 OUT VARCHAR2,
50 x_return_status OUT VARCHAR2,
51 x_msg_count OUT NUMBER,
52 x_msg_data OUT VARCHAR2 );
53
54 PROCEDURE Get_Salesperson (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_contract_id IN NUMBER,
59 p_cp_service_id IN NUMBER,
60 x_salesperson_id OUT NUMBER,
61 x_salesperson OUT VARCHAR2,
62 x_return_status OUT VARCHAR2,
63 x_msg_count OUT NUMBER,
64 x_msg_data OUT VARCHAR2 );
65
66 PROCEDURE Get_Auto_Renewal_Flag (
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE,
70 p_contract_id IN NUMBER,
71 p_cp_service_id IN NUMBER,
72 x_auto_renewal_flag OUT VARCHAR2,
73 x_return_status OUT VARCHAR2,
74 x_msg_count OUT NUMBER,
75 x_msg_data OUT VARCHAR2 );
76
77 END CS_GET_CONTRACT_VALUES_PUB;