1 PACKAGE CLN_SYNCITEM_PKG AS
2 /* $Header: CLNSYITS.pls 120.0 2005/05/24 16:18:55 appldev noship $ */
3
4 -- Package
5 -- CLN_SYNCITEM_PKG
6 --
7 -- Purpose
8 -- Specs of package CLN_SYNCITEM_PKG.
9 --
10 -- History
11 -- July-21-2003 Rahul Krishan Created
12
13
14 -- Name
15 -- GET_PARTY_ID
16 -- Purpose
17 -- This function returns the trading party id where the Payload needs to be sent
18 --
19 -- Arguments
20 --
21 -- Notes
22 -- No specific notes.
23
24 FUNCTION GET_PARTY_ID
25 RETURN NUMBER;
26
27
28 -- Name
29 -- GET_CUST_ACCT_ID
30 -- Purpose
31 -- This function returns the customer account id
32 --
33 -- Arguments
34 --
35 -- Notes
36 -- No specific notes.
37 FUNCTION GET_CUST_ACCT_ID
38 RETURN NUMBER;
39
40
41
42 -- Name
43 -- SET_PARTY_ID
44 -- Purpose
45 -- This procedure is called from the 2A12 XGM and while the inprocessing mode
46 -- is carried out. This makes sure that the view cln_2a12_party_v gets value
47 -- This procedure sets the party id so as to maintain the
48 -- context from within the XGM.
49 --
50 -- Arguments
51 --
52 -- Notes
53 -- No specific notes.
54
55 PROCEDURE SET_PARTY_ID ( p_tp_party_id IN NUMBER) ;
56
57
58 -- Name
59 -- RAISE_SYNCITEM_EVENT
60 -- Purpose
61 -- This procedure is called from the 2A12 concurrent program.
62 -- This captures the user input and after processing raises an event for
63 -- for outbound processing.
64 -- Arguments
65 --
66 -- Notes
67 -- No specific notes.
68
69 PROCEDURE Raise_Syncitem_Event(
70 errbuf OUT NOCOPY VARCHAR2,
71 retcode OUT NOCOPY VARCHAR2,
72 p_tp_header_id IN NUMBER,
73 p_inventory_org_id IN NUMBER,
74 p_category_set_id IN NUMBER,
75 p_category_id IN NUMBER,
76 p_catalog_category_id IN NUMBER,
77 p_item_status IN VARCHAR2,
78 p_from_items IN VARCHAR2,
79 p_to_items IN VARCHAR2,
80 p_numitems_per_payload IN NUMBER);
81
82 -- Name
83 -- SEND_SYNCITEM_DELETE
84 -- Purpose
85 -- This procedure is called from the 2A12 Workflow.
86 -- This procedure checks for the Trading Partner setup. Also, sets the WF Item
87 -- attributes and raises the Sync Item event.
88 --
89 -- Arguments
90 --
91 -- Notes
92 -- No specific notes.
93
94 PROCEDURE Send_Syncitem_Delete(
95 itemtype IN VARCHAR2,
96 itemkey IN VARCHAR2,
97 actid IN NUMBER,
98 funcmode IN VARCHAR2,
99 resultout IN OUT NOCOPY VARCHAR2);
100
101
102 -- Name
103 -- ARCHIVE_DELETED_ITEMS
104 -- Purpose
105 -- This procedure is called from the 2A12 Workflow.
106 -- This procedure archives the deleted items into 'cln_itemmst_deleted_items' table.
107 --
108 -- Arguments
109 --
110 -- Notes
111 -- No specific notes.
112
113 PROCEDURE Archive_Deleted_Items(
114 itemtype IN VARCHAR2,
115 itemkey IN VARCHAR2,
116 actid IN NUMBER,
117 funcmode IN VARCHAR2,
118 resultout IN OUT NOCOPY VARCHAR2);
119
120 -- Name
121 -- DELETE_ARCHIVED_ITEMS
122 -- Purpose
123 -- This procedure is called from the 2A12 Workflow.
124 -- This procedure deletes the archived items from the 'cln_itemmst_deleted_items'.
125 --
126 -- Arguments
127 --
128 -- Notes
129 -- Commented the code for fixing bug 3875383
130
131 PROCEDURE Delete_Archived_Items(
132 itemtype IN VARCHAR2,
133 itemkey IN VARCHAR2,
134 actid IN NUMBER,
135 funcmode IN VARCHAR2,
136 resultout IN OUT NOCOPY VARCHAR2);
137
138 END CLN_SYNCITEM_PKG;