APPS.PAY_MLS_TRIGGERS dependencies on FF_GLOBALS_F

Line 248: procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,

244: raise;
245: end;
246:
247:
248: procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,
249: p_global_description_o in ff_globals_f.global_description%type,
250: p_global_description_n in ff_globals_f.global_description%type,
251: p_global_name_o in ff_globals_f.global_name%type,
252: p_global_name_n in ff_globals_f.global_name%type) IS

Line 249: p_global_description_o in ff_globals_f.global_description%type,

245: end;
246:
247:
248: procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,
249: p_global_description_o in ff_globals_f.global_description%type,
250: p_global_description_n in ff_globals_f.global_description%type,
251: p_global_name_o in ff_globals_f.global_name%type,
252: p_global_name_n in ff_globals_f.global_name%type) IS
253: l_proc varchar2(30) := 'glb_ari' ;

Line 250: p_global_description_n in ff_globals_f.global_description%type,

246:
247:
248: procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,
249: p_global_description_o in ff_globals_f.global_description%type,
250: p_global_description_n in ff_globals_f.global_description%type,
251: p_global_name_o in ff_globals_f.global_name%type,
252: p_global_name_n in ff_globals_f.global_name%type) IS
253: l_proc varchar2(30) := 'glb_ari' ;
254: l_count binary_integer;

Line 251: p_global_name_o in ff_globals_f.global_name%type,

247:
248: procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,
249: p_global_description_o in ff_globals_f.global_description%type,
250: p_global_description_n in ff_globals_f.global_description%type,
251: p_global_name_o in ff_globals_f.global_name%type,
252: p_global_name_n in ff_globals_f.global_name%type) IS
253: l_proc varchar2(30) := 'glb_ari' ;
254: l_count binary_integer;
255:

Line 252: p_global_name_n in ff_globals_f.global_name%type) IS

248: procedure glb_ari ( p_global_id in ff_globals_f.global_id%type,
249: p_global_description_o in ff_globals_f.global_description%type,
250: p_global_description_n in ff_globals_f.global_description%type,
251: p_global_name_o in ff_globals_f.global_name%type,
252: p_global_name_n in ff_globals_f.global_name%type) IS
253: l_proc varchar2(30) := 'glb_ari' ;
254: l_count binary_integer;
255:
256: begin

Line 277: procedure glb_brd (p_global_id in ff_globals_f.global_id%type) IS

273: raise;
274: end;
275:
276:
277: procedure glb_brd (p_global_id in ff_globals_f.global_id%type) IS
278: l_proc varchar2(30) ;
279: l_count binary_integer;
280: begin
281:

Line 298: cursor c_glb ( p_global_id ff_globals_f.global_id%type)

294:
295:
296: procedure glb_asi IS
297: l_proc varchar2(30) ;
298: cursor c_glb ( p_global_id ff_globals_f.global_id%type)
299: is
300: select 1
301: from ff_globals_f b
302: where b.global_id = p_global_id

Line 301: from ff_globals_f b

297: l_proc varchar2(30) ;
298: cursor c_glb ( p_global_id ff_globals_f.global_id%type)
299: is
300: select 1
301: from ff_globals_f b
302: where b.global_id = p_global_id
303: and not exists
304: -- this is the first insert; there is no corresponding row in tl table
305: ( select 1

Line 306: from ff_globals_f_tl tl

302: where b.global_id = p_global_id
303: and not exists
304: -- this is the first insert; there is no corresponding row in tl table
305: ( select 1
306: from ff_globals_f_tl tl
307: where tl.global_id = p_global_id ) ;
308: rec_glb c_glb%rowtype;
309: begin
310: l_proc := 'glb_asi' ;

Line 337: cursor c_glb_del ( p_global_id ff_globals_f.global_id%type )

333:
334:
335: procedure glb_asd IS
336: l_proc varchar2(30) ;
337: cursor c_glb_del ( p_global_id ff_globals_f.global_id%type )
338: is
339: select 1
340: from ff_globals_f_tl f
341: where f.global_id = p_global_id

Line 340: from ff_globals_f_tl f

336: l_proc varchar2(30) ;
337: cursor c_glb_del ( p_global_id ff_globals_f.global_id%type )
338: is
339: select 1
340: from ff_globals_f_tl f
341: where f.global_id = p_global_id
342: and not exists
343: ( select 1
344: from ff_globals_f f1

Line 344: from ff_globals_f f1

340: from ff_globals_f_tl f
341: where f.global_id = p_global_id
342: and not exists
343: ( select 1
344: from ff_globals_f f1
345: where f1.global_id = p_global_id
346:
347: );
348: rec_glb c_glb_del%rowtype;