eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BISM_EXPORT_WRITER dependencies on BISM_EXPORT

Line 1: PACKAGE BODY BISM_EXPORT_WRITER

1: PACKAGE BODY BISM_EXPORT_WRITER
2: /* $Header: bibexpwb.pls 120.2 2006/04/03 05:23:02 akbansal noship $ */
3: AS
4: FUNCTION get_guid RETURN raw
5: IS

Line 20: v_clob BISM_EXPORT.text%TYPE;

16: FUNCTION insert_object(a_gname raw,a_guid raw, a_filename nvarchar2, a_data nclob,a_binary_data blob)
17: RETURN timestamp
18: IS
19: v_time timestamp;
20: v_clob BISM_EXPORT.text%TYPE;
21: v_blob BISM_EXPORT.binarydata%TYPE;
22: BEGIN
23: IF a_data IS NULL AND a_binary_data IS NULL THEN
24: -- nothing to insert

Line 21: v_blob BISM_EXPORT.binarydata%TYPE;

17: RETURN timestamp
18: IS
19: v_time timestamp;
20: v_clob BISM_EXPORT.text%TYPE;
21: v_blob BISM_EXPORT.binarydata%TYPE;
22: BEGIN
23: IF a_data IS NULL AND a_binary_data IS NULL THEN
24: -- nothing to insert
25: RETURN NULL;

Line 32: SELECT text into v_clob FROM BISM_EXPORT WHERE

28: v_time:= SYSDATE;
29:
30: IF a_data IS NOT NULL THEN
31: BEGIN
32: SELECT text into v_clob FROM BISM_EXPORT WHERE
33: group_name=a_gname AND
34: group_id = a_guid AND
35: file_name = a_filename for update;
36: -- write piece wise

Line 42: INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,a_data,null);

38: EXCEPTION WHEN
39: No_Data_Found then
40: -- data does not exist yet, create it
41: -- insert null for binary data (BLOB)
42: INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,a_data,null);
43: END;
44: ELSIF a_binary_data IS NOT NULL THEN
45: BEGIN
46: SELECT binarydata into v_blob FROM BISM_EXPORT WHERE

Line 46: SELECT binarydata into v_blob FROM BISM_EXPORT WHERE

42: INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,a_data,null);
43: END;
44: ELSIF a_binary_data IS NOT NULL THEN
45: BEGIN
46: SELECT binarydata into v_blob FROM BISM_EXPORT WHERE
47: group_name=a_gname AND
48: group_id = a_guid AND
49: file_name = a_filename for update;
50: -- write piece wise

Line 56: INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,null,a_binary_data);

52: EXCEPTION WHEN
53: No_Data_Found then
54: -- data does not exist yet, create it
55: -- insert null for text data (CLOB)
56: INSERT INTO BISM_EXPORT (GROUP_NAME, GROUP_ID, FILE_NAME, TIME_CREATED, TEXT, BINARYDATA) VALUES(a_gname,a_guid,a_filename,v_time,null,a_binary_data);
57: END;
58:
59: END IF;
60:

Line 86: DELETE FROM BISM_EXPORT WHERE

82: END IF;
83:
84:
85: IF a_gname_is_not_null = TRUE AND a_guid_is_not_null = true AND a_filename_is_not_null = true THEN
86: DELETE FROM BISM_EXPORT WHERE
87: group_name= a_gname AND
88: group_id = a_guid AND
89: file_name=a_filename;
90: ELSIF a_gname_is_not_null = TRUE and a_filename_is_not_null = true THEN

Line 91: DELETE FROM BISM_EXPORT WHERE

87: group_name= a_gname AND
88: group_id = a_guid AND
89: file_name=a_filename;
90: ELSIF a_gname_is_not_null = TRUE and a_filename_is_not_null = true THEN
91: DELETE FROM BISM_EXPORT WHERE
92: group_name= a_gname AND
93: file_name=a_filename;
94: ELSIF a_gname_is_not_null = TRUE THEN
95: DELETE FROM BISM_EXPORT WHERE

Line 95: DELETE FROM BISM_EXPORT WHERE

91: DELETE FROM BISM_EXPORT WHERE
92: group_name= a_gname AND
93: file_name=a_filename;
94: ELSIF a_gname_is_not_null = TRUE THEN
95: DELETE FROM BISM_EXPORT WHERE
96: group_name= a_gname;
97: END IF;
98:
99: COMMIT;

Line 138: delete from bism_export where to_char(time_created, 'DD-MON-YY HH24.MI.SS') < v_temp;

134:
135: SELECT to_timestamp(v_temp, 'DD-MON-YY HH24.MI.SS') into v_timestamp from dual;
136: -- delete the objects
137:
138: delete from bism_export where to_char(time_created, 'DD-MON-YY HH24.MI.SS') < v_temp;
139: COMMIT;
140:
141: END;
142:

Line 148: v_clob bism_export.text%TYPE;

144: FUNCTION get_object(a_gname in raw,a_guid in out nocopy raw, a_filename in nvarchar2)
145: RETURN SchemaCurType
146: IS
147: v_rc SchemaCurType;
148: v_clob bism_export.text%TYPE;
149: a_gname_is_not_null BOOLEAN := FALSE;
150: a_guid_is_not_null BOOLEAN := FALSE;
151: a_filename_is_not_null boolean := FALSE;
152: BEGIN

Line 168: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and

164: END IF;
165:
166: IF a_gname_is_not_null = TRUE AND a_guid_is_not_null = true AND a_filename_is_not_null = true THEN
167: -- no need to fetch groupd_id
168: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and
169: group_id = a_guid and file_name = a_filename;
170: ELSIF a_gname_is_not_null = TRUE and a_filename_is_not_null = true THEN
171: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
172: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;

Line 171: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;

167: -- no need to fetch groupd_id
168: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and
169: group_id = a_guid and file_name = a_filename;
170: ELSIF a_gname_is_not_null = TRUE and a_filename_is_not_null = true THEN
171: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
172: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
173: ELSIF a_gname_is_not_null = TRUE THEN
174: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname;
175: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;

Line 172: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;

168: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and
169: group_id = a_guid and file_name = a_filename;
170: ELSIF a_gname_is_not_null = TRUE and a_filename_is_not_null = true THEN
171: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
172: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
173: ELSIF a_gname_is_not_null = TRUE THEN
174: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname;
175: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
176: END IF;

Line 174: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname;

170: ELSIF a_gname_is_not_null = TRUE and a_filename_is_not_null = true THEN
171: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
172: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
173: ELSIF a_gname_is_not_null = TRUE THEN
174: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname;
175: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
176: END IF;
177: RETURN v_rc;
178: END;

Line 175: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;

171: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
172: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
173: ELSIF a_gname_is_not_null = TRUE THEN
174: SELECT group_id into a_guid FROM BISM_EXPORT WHERE group_name = a_gname;
175: OPEN v_rc FOR SELECT text,binarydata FROM BISM_EXPORT WHERE group_name = a_gname and file_name = a_filename;
176: END IF;
177: RETURN v_rc;
178: END;
179: