PACKAGE: APPS.FND_LOADER_OPEN_INTERFACE_PKG

Source

1 package FND_LOADER_OPEN_INTERFACE_PKG AUTHID CURRENT_USER as
2 /* $Header: FNDOFACS.pls 120.2 2005/08/31 13:13:04 rsekaran noship $ */
3 
4 TYPE FND_LCT_TAB        is table of VARCHAR2(400) index by binary_integer;
5 TYPE FND_LDT_TAB        is table of VARCHAR2(400) index by binary_integer;
6 TYPE FND_BATCH_ID_TAB   is table of NUMBER index by binary_integer;
7 TYPE FND_SEQ_IN_BATCH_TAB is table of NUMBER index by binary_integer;
8 TYPE FND_LOADER_MODE_TAB is table of VARCHAR2(30) index by binary_integer;
9 TYPE FND_ENTITY_TAB     is table of VARCHAR2(30) index by binary_integer;
10 TYPE FND_PARAMS_TAB     is table of VARCHAR2(1000) index by binary_integer;
11 
12 --
13 -- Function
14 --   INSERT_BATCH
15 --
16 -- Purpose
17 --   Insert a batch of record into fnd_loader_open_interface table.
18 --
19 -- Arguments:
20 --   IN:
21 --      X_LCT           -- lct file name
22 --      X_LDT           -- ldt file name
23 --      X_LOADER_MODE   -- UPLOAD,DOWNLOAD,UPLOAD_PARTIAL
24 --      X_ENTITY        -- Entity name
25 --      X_PARAMS        -- optional parameters
26 --
27 FUNCTION INSERT_BATCH RETURN INTEGER;
28 
29 FUNCTION INSERT_BATCH
30 (
31 X_LCT             IN      FND_LCT_TAB ,
32 X_LDT             IN      FND_LDT_TAB ,
33 X_LOADER_MODE     IN      FND_LOADER_MODE_TAB,
34 X_ENTITY          IN      FND_ENTITY_TAB ,
35 X_PARAMS          IN      FND_PARAMS_TAB
36 ) RETURN INTEGER ;
37 
38 --
39 -- Procedure
40 --  DELETE_BATCH
41 --
42 -- Purpose
43 --  Purge record with specific batch_id from fnd_loader_open_interface table;
44 --
45 -- Arguments
46 --   IN:
47 --     X_BATCH_ID       -- Batch_id
48 --
49 PROCEDURE DELETE_BATCH(
50 X_BATCH_ID        IN      INTEGER
51 );
52 
53 --
54 -- Procedure
55 --  ADD_ROW_TO_BATCH
56 --
57 -- Purpose
58 --  Add a list of records to fnd_loader_open_interface table with given batch_id
59 --
60 -- Arguments:
61 --  IN:
62 --    X_BATCH_ID        -- Batch_id
63 --    X_LCT             -- lct name
64 --    X_LDT             -- ldt name
65 --    X_LOADER_MODE     -- UPLOAD,DOWNLOAD,UPLOAD_PARTIAL
66 --    X_ENTITY          -- Entity name
67 --    X_PARAMS          -- options parameters.
68 --
69 PROCEDURE ADD_ROW_TO_BATCH
70 (
71 X_BATCH_ID	  IN	  INTEGER,
72 X_LCT             IN      FND_LCT_TAB,
73 X_LDT             IN      FND_LDT_TAB,
74 X_LOADER_MODE     IN      FND_LOADER_MODE_TAB,
75 X_ENTITY          IN      FND_ENTITY_TAB,
76 X_PARAMS          IN      FND_PARAMS_TAB
77 );
78 
79 
80 --
81 -- Procedure (Overloaded)
82 --  ADD_ROW_TO_BATCH
83 --
84 -- Purpose
85 --  Add a record to fnd_loader_open_interface table with given batch_id
86 --
87 -- Arguments:
88 --  IN:
89 --    X_BATCH_ID        -- Batch_id
90 --    X_LCT             -- lct name
91 --    X_LDT             -- ldt name
92 --    X_LOADER_MODE     -- UPLOAD,DOWNLOAD,UPLOAD_PARTIAL
93 --    X_ENTITY          -- Entity name
94 --    X_PARAMS          -- options parameters.
95 --
96 PROCEDURE ADD_ROW_TO_BATCH
97 (
98 X_BATCH_ID	  IN	  INTEGER,
99 X_LCT             IN      VARCHAR2,
100 X_LDT             IN      VARCHAR2,
101 X_LOADER_MODE     IN      VARCHAR2,
102 X_ENTITY          IN      VARCHAR2,
103 X_PARAMS          IN      VARCHAR2
104 );
105 
106 
107 --
108 -- Procedure
109 --   LOCK_BATCH
110 --
111 -- Purpose
112 --   Check to see if specific batch has been locked by other users, if not, try to lock it.
113 --
114 -- Arguments:
115 --   IN:
116 --      X_batch_id - Batch_id
117 --   OUT:
118 --      X_return_status:
119 --         0:   Success
120 --         1:   Timed out
121 --         2:   Deadlock
122 --         3:   Parameter error
123 --         4:   Do not own lock; cannot convert
124 --         5:   Illegal lockhandle
125 --
126 PROCEDURE LOCK_BATCH
127 (
128 X_BATCH_ID        IN      	INTEGER,
129 X_RETURN_STATUS   OUT 	NOCOPY  INTEGER
130 );
131 
132 end FND_LOADER_OPEN_INTERFACE_PKG;