APPS.FND_TXK_TECH_INT_PKG dependencies on FND_PREFERENCE

Line 5: FUNCTION store_into_fnd_preference (p_file_id NUMBER)

1: PACKAGE BODY FND_TXK_TECH_INT_PKG AS
2: /* $Header: fndtxk01b.pls 120.1 2010/07/28 05:20:58 upinjark noship $*/
3:
4:
5: FUNCTION store_into_fnd_preference (p_file_id NUMBER)
6: RETURN NUMBER
7: IS
8: /*
9: || Created By : upinjark

Line 20: fnd_preference.put('#INTERNAL', 'BPEL_INT', 'TXK_BPEL_FILE_ID_' || p_file_id, 'EbsBpelGlobal.properties') ;

16: */
17:
18: BEGIN
19:
20: fnd_preference.put('#INTERNAL', 'BPEL_INT', 'TXK_BPEL_FILE_ID_' || p_file_id, 'EbsBpelGlobal.properties') ;
21: RETURN 1 ;
22:
23: EXCEPTION
24: WHEN OTHERS THEN

Line 27: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_preference');

23: EXCEPTION
24: WHEN OTHERS THEN
25: fnd_file.put_line(fnd_file.log, SQLERRM);
26: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
27: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_preference');
28: fnd_file.put_line(fnd_file.log, fnd_message.get);
29: RETURN(NULL);
30: END store_into_fnd_preference;
31:

Line 30: END store_into_fnd_preference;

26: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
27: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_preference');
28: fnd_file.put_line(fnd_file.log, fnd_message.get);
29: RETURN(NULL);
30: END store_into_fnd_preference;
31:
32: FUNCTION store_into_fnd_lob(p_args_table IN FND_TXK_BPEL_ARGS_TYPE )
33: RETURN NUMBER
34: IS

Line 86: || Purpose : TO remove bpel info from fnd_lobs and fnd_preference

82: IS
83: /*
84: || Created By : upinjark
85: || Created On : 17-JUN-2009
86: || Purpose : TO remove bpel info from fnd_lobs and fnd_preference
87: || Known limitations, enhancements or remarks :
88: || Change History :
89: || Who When What
90: || (reverse chronological order - newest change first)

Line 104: -- find out from fnd_preference if any fnd_preference exists ....

100: l_old_file_id := NULL;
101: l_bpel_count := 0;
102:
103:
104: -- find out from fnd_preference if any fnd_preference exists ....
105: -- if fnd_preference exist, get the file ids
106:
107: BEGIN
108: select substr(preference_name,18) into l_old_file_id

Line 105: -- if fnd_preference exist, get the file ids

101: l_bpel_count := 0;
102:
103:
104: -- find out from fnd_preference if any fnd_preference exists ....
105: -- if fnd_preference exist, get the file ids
106:
107: BEGIN
108: select substr(preference_name,18) into l_old_file_id
109: from fnd_user_preferences

Line 117: -- delete fnd_preference rows for

113:
114: if l_old_file_id is not null then
115: -- delete fnd_lob rows for the file id and file_name = EbsBpelGlobal.properties ...
116: delete from fnd_lobs where file_id = l_old_file_id;
117: -- delete fnd_preference rows for
118: fnd_preference.remove('#INTERNAL', 'BPEL_INT', 'TXK_BPEL_FILE_ID_'|| l_old_file_id );
119: end if;
120:
121: EXCEPTION

Line 118: fnd_preference.remove('#INTERNAL', 'BPEL_INT', 'TXK_BPEL_FILE_ID_'|| l_old_file_id );

114: if l_old_file_id is not null then
115: -- delete fnd_lob rows for the file id and file_name = EbsBpelGlobal.properties ...
116: delete from fnd_lobs where file_id = l_old_file_id;
117: -- delete fnd_preference rows for
118: fnd_preference.remove('#INTERNAL', 'BPEL_INT', 'TXK_BPEL_FILE_ID_'|| l_old_file_id );
119: end if;
120:
121: EXCEPTION
122: when no_data_found then null;

Line 149: || Purpose : Main process which in turn calls fnd_lob and fnd_preference

145:
146: /*
147: || Created By : upinjark
148: || Created On : 17-JUN-2009
149: || Purpose : Main process which in turn calls fnd_lob and fnd_preference
150: || Known limitations, enhancements or remarks :
151: || Change History :
152: || Who When What
153: || (reverse chronological order - newest change first)

Line 167: retcode := store_into_fnd_preference(l_file_id);

163:
164: retcode := remove_bpel_info_if_exists ;
165:
166: l_file_id := store_into_fnd_lob(p_args_table);
167: retcode := store_into_fnd_preference(l_file_id);
168:
169: -- COMMIT;
170:
171: EXCEPTION