1 PACKAGE MSD_ITEM_RELATIONSHIPS_PKG AS
2 /* $Header: msdsupss.pls 120.1 2005/11/22 03:37:27 amitku noship $ */
3 /* This procedure to collect supersession data from source instance to DP tables*/
4
5 PROCEDURE collect_supersession_data (
6 errbuf out NOCOPY varchar2,
7 retcode out NOCOPY varchar2,
8 p_instance_id in number
9 );
10
11 /* This procedure to delete events data by instance */
12
13 PROCEDURE delete_events_data (
14 errbuf out NOCOPY varchar2,
15 retcode out NOCOPY varchar2,
16 p_instance_id in number,
17 p_event_id in number
18 );
19
20 /* This procedure to update supersession events in DP events table */
21
22 PROCEDURE update_supersession_events (
23 errbuf out NOCOPY varchar2,
24 retcode out NOCOPY varchar2,
25 p_event_name in varchar2
26 );
27
28 /* This procedure to create supersession events in DP events table */
29
30 PROCEDURE create_supersession_events (
31 errbuf out NOCOPY varchar2,
32 retcode out NOCOPY varchar2,
33 p_instance_id in number,
34 p_event_name in varchar2
35 );
36
37 /* This procedure to pull supersession data from DP staging table */
38
39 PROCEDURE pull_supersession_data (
40 errbuf out NOCOPY varchar2,
41 retcode out NOCOPY varchar2
42 );
43
44
45 /* This procedure will insert supersession data in to DP table */
46
47 PROCEDURE insert_event_products (
48 errbuf out NOCOPY varchar2,
49 retcode out NOCOPY varchar2,
50 p_instance_id in number,
51 l_event_id in number,
52 l_seq_id in number,
53 l_level_id in number,
54 l_inventory_item in varchar2,
55 l_inventory_item_id in varchar2,
56 l_start_time in date, --bug 4707819
57 l_end_time in date --bug 4707819
58 );
59
60 /* This procedure will insert supersession data in to DP table */
61
62 PROCEDURE insert_evt_prod_relationships (
63 errbuf out NOCOPY varchar2,
64 retcode out NOCOPY varchar2,
65 p_instance_id in number,
66 l_event_id in number,
67 l_seq_id in number,
68 l_relation_id in number,
69 l_level_id in number,
70 l_related_item in varchar2,
71 l_related_item_id in varchar2,
72 l_qty_mod_type in number,
73 l_qty_mod_factor in number,
74 l_npi_prd_relshp in number,
75 l_start_time in date, --bug 4707819
76 l_end_time in date --bug 4707819
77 );
78
79
80 /* This procedure will insert supersession data in to DP table */
81
82 PROCEDURE insert_evt_product_details (
83 errbuf out NOCOPY varchar2,
84 retcode out NOCOPY varchar2,
85 p_instance_id in number,
86 l_event_id in number,
87 l_seq_id in number,
88 l_detail_id in number,
89 l_relation_id in number,
90 l_level_id in number,
91 l_related_item in varchar2,
92 l_related_item_id in varchar2,
93 l_qty_mod_type in number,
94 l_qty_mod_factor in number
95 );
96
97
98
99 END MSD_ITEM_RELATIONSHIPS_PKG;