PACKAGE: APPS.JTF_IH_IMPORT

Source

1 PACKAGE JTF_IH_IMPORT AUTHID CURRENT_USER AS
2 /* $Header: JTFIHIMS.pls 115.13 2002/12/11 15:18:54 ialeshin ship $ */
3 
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_IH_IMPORT';
5 
6 
7     nCntTransRows  NUMBER := 1000; -- Number of rows for per transaction (available for Interactions
8     pnSessionNo  NUMBER := 0;       -- Session Number for Import. Default value is 0
9     excNoSessionNo  EXCEPTION;
10     nNxtSessionNo NUMBER := 0;
11     bTest       BOOLEAN := TRUE;    -- bTest OFF - if you need import only without testing of data.
12     PROCEDURE GO_TEST;
13     PROCEDURE GO_IMPORT(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY VARCHAR2);
14 
15     NO_ACTIVITIES CONSTANT VARCHAR2(254) := 'Activities Not Found';
16     ACTIVITIES_PROBLEMS CONSTANT VARCHAR2(254) := 'This Ineraction has activities problems';
17     NO_MEDIAITEM CONSTANT VARCHAR2(254) := 'Media Items Not Found';
18     NO_ACTMEDIAITEM CONSTANT VARCHAR2(254) := 'Media Items for Activities was Not Found';
19     MEDIA_ITEM_EXISTS CONSTANT VARCHAR(254) := 'Media Item already exists in JTF_IH_MEDIA_ITEMS table';
20 
21     NOTCREATEDINTERACTION CONSTANT VARCHAR(254) := 'Interaction was not created';
22     NOTCREATEDACTIVITY CONSTANT VARCHAR(254) := 'Activity was not created';
23     NOTCREATEDMEDIAITEM CONSTANT VARCHAR(254) := 'Media_Items was not created';
24     NOTCLOSEDINTERACTION CONSTANT VARCHAR(254) := 'Interactions was not closed';
25 END;
26