DBA Data[Home] [Help]

PACKAGE: APPS.ITG_SYNCITEMINBOUND_PVT

Source


1 PACKAGE ITG_SyncItemInbound_PVT AS
2 /* ARCS: $Header: itgvsiis.pls 120.1 2005/10/06 02:08:17 bsaratna noship $
3  * CVS:  itgvsiis.pls,v 1.8 2002/12/23 21:20:30 ecoe Exp
4  */
5 
6   PROCEDURE Sync_Item(
7     x_return_status    OUT NOCOPY VARCHAR2,
8     x_msg_count        OUT NOCOPY NUMBER,
9     x_msg_data         OUT NOCOPY VARCHAR2,
10 
11     p_syncind          IN         VARCHAR2,		/* (1) */
12     p_org_id           IN         NUMBER,		/* poentity */
13     p_hazrdmatl        IN         VARCHAR2,
14     p_create_date      IN         DATE     := NULL,
15     p_item             IN         VARCHAR2,
16     p_uom              IN         VARCHAR2,
17     p_itemdesc         IN         VARCHAR2,
18     p_itemstatus       IN         VARCHAR2,
19     p_itemtype         IN         VARCHAR2,
20     p_rctrout          IN         VARCHAR2,		/* ref_rctrout */
21     p_commodity1       IN         VARCHAR2,
22     p_commodity2       IN         VARCHAR2
23   );
24 
25   /*
26    * DO NOT USE!!
27    * The following procedures and functions are not part of the ABO API.
28    * They are internal callbacks from the batch management package.
29    */
30 
31   FUNCTION Get_NextProcessSetId RETURN NUMBER;
32 
33   /* Returns CCM request id. */
34   FUNCTION Start_BatchProcess(
35     p_process_set_id    NUMBER,
36     p_syncind		VARCHAR2,
37     p_org_id	      VARCHAR2
38   ) RETURN NUMBER;
39 
40   FUNCTION Reap_BatchResults(
41     p_request_id        NUMBER,
42     p_msii_rid		ROWID,
43     p_mici_rid		ROWID
44 ) RETURN VARCHAR2;
45 
46 PROCEDURE error_transactions(p_request_id VARCHAR2,p_table_name VARCHAR2);
47 
48 
49 END ITG_SyncItemInbound_PVT;