[Home] [Help]
PACKAGE: APPS.PV_ATTR_VALIDATION_PUB
Source
1 package PV_ATTR_VALIDATION_PUB AUTHID CURRENT_USER as
2 /* $Header: pvvatvts.pls 115.2 2002/12/10 22:36:02 vansub ship $*/
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'PV_ATTR_VALIDATION_PUB';
5
6
7 g_wf_itemtype_notify CONSTANT VARCHAR2(30) := 'PVOPTYHK';
8 g_wf_pcs_notify_cm CONSTANT varchar2(30) := 'PV_ATTR_CHG_CM_NOTIFY_PCS';
9
10 g_wf_status_open CONSTANT VARCHAR2(20) := 'OPEN';
11 g_wf_status_closed CONSTANT VARCHAR2(20) := 'CLOSED';
12
13
14 g_wf_attr_partner_name CONSTANT varchar2(30) := 'PV_PARTNER_NAME_ATTR';
15 g_wf_attr_attribute_name CONSTANT varchar2(30) := 'PV_ATTRIBUTE_NAME_ATTR';
16 g_wf_attr_prtnr_cont_name CONSTANT varchar2(30) := 'PV_PARTNER_CONTACT_NAME_ATTR';
17
18 g_wf_attr_cm_notify_role CONSTANT VARCHAR2(30) := 'PV_NOTIFY_CM_NEW_OPPTY_ROLE';
19
20
21 g_wf_attr_send_url CONSTANT varchar2(30) := 'PV_CM_RESPOND_URL_ATTR';
22
23 g_partner_entity CONSTANT varchar2(30) := 'PARTNER';
24
25 PROCEDURE attribute_validate(
26 p_api_version_number IN NUMBER,
27 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
28 p_commit IN VARCHAR2 := FND_API.g_false,
29 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30 p_attribute_id IN NUMBER,
31 p_entity IN VARCHAR2,
32 p_entity_id IN VARCHAR2,
33 p_user_id IN VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39
40 procedure StartWorkflow
41 (
42 p_api_version_number IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_user_name_tbl IN JTF_VARCHAR2_TABLE_1000,
47 p_attribute_id IN VARCHAR2,
48 p_attribute_name IN VARCHAR2,
49 p_partner_name IN VARCHAR2,
50 p_pt_contact_name IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56
57
58
59
60
61
62
63 END PV_ATTR_VALIDATION_PUB;