[Home] [Help]
PACKAGE: APPS.POS_SUPP_PUB_RAISE_EVENT_PKG
Source
1 PACKAGE pos_supp_pub_raise_event_pkg AUTHID CURRENT_USER AS
2 /* $Header: POSSPPBES.pls 120.1 2010/11/25 12:13:52 puppulur noship $ */
3 -- Author : JAYASANKAR
4 -- Created : 8/19/2009 2:42:12 PM
5 -- Purpose : Supplier Publish Event
6 g_curr_supp_publish_event_id NUMBER := 0;
7 --PROCEDURE raise_publish_supplier_event;
8 PROCEDURE create_supp_publish_event(p_api_version IN INTEGER,
9 p_init_msg_list IN VARCHAR2,
10 p_party_id IN pos_tbl_number,
11 p_published_by IN INTEGER,
12 p_publish_detail IN VARCHAR,
13 x_publication_event_id OUT NOCOPY NUMBER,
14 x_actions_request_id OUT NOCOPY NUMBER,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2);
18
19 PROCEDURE create_supp_publish_event_hist (p_api_version IN INTEGER,
20 p_init_msg_list IN VARCHAR2,
21 p_publication_event_id IN pos_tbl_number,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2);
25
26 PROCEDURE create_supp_publish_resp(p_publication_event_id IN NUMBER,
27 p_party_id IN NUMBER,
28 p_target_system IN VARCHAR2,
29 p_pub_req_process_id IN NUMBER,
30 p_pub_req_process_stats IN VARCHAR2);
31
32 PROCEDURE update_supp_pub_resp(p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2,
34 p_commit IN VARCHAR2,
35 p_validation_level IN NUMBER,
36 p_publication_event_id IN NUMBER,
37 p_party_id IN NUMBER,
38 p_target_system IN NUMBER,
39 p_pub_resp_process_id IN NUMBER,
40 p_pub_resp_process_stats IN VARCHAR2,
41 p_target_system_resp_date IN DATE,
42 p_error_message IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46 FUNCTION get_curr_supp_pub_event_id RETURN NUMBER;
47 FUNCTION raise_publish_supplier_event(p_publication_event_id NUMBER)
48 RETURN NUMBER;
49 PROCEDURE populate_bo_and_save_concur(x_errbuf OUT NOCOPY VARCHAR2,
50 x_retcode OUT NOCOPY NUMBER,
51 p_party_id_cs_1 IN VARCHAR2 DEFAULT '',
52 p_party_id_cs_2 IN VARCHAR2 DEFAULT '',
53 p_party_id_cs_3 IN VARCHAR2 DEFAULT '',
54 p_published_by IN VARCHAR2 DEFAULT '',
55 p_publish_detail IN VARCHAR2 DEFAULT '',
56 p_publication_event_id_in IN VARCHAR2 DEFAULT '');
57 PROCEDURE get_bo_and_insert(p_party_id IN pos_tbl_number,
58 p_publication_event_id IN NUMBER,
59 p_published_by IN NUMBER,
60 p_publish_detail IN VARCHAR);
61
62 FUNCTION test_event_subscription(p_subscription_guid IN RAW,
63 p_event IN OUT NOCOPY wf_event_t)
64 RETURN VARCHAR2;
65
66 END pos_supp_pub_raise_event_pkg;