APPS.PAY_MLS_TRIGGERS dependencies on FF_FORMULAS_F

Line 376: procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,

372: raise;
373: end;
374:
375:
376: procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,
377: p_formula_name_o in ff_formulas_f.formula_name%type,
378: p_formula_name_n in ff_formulas_f.formula_name%type,
379: p_description_o in ff_formulas_f.description%type,
380: p_description_n in ff_formulas_f.description%type) IS

Line 377: p_formula_name_o in ff_formulas_f.formula_name%type,

373: end;
374:
375:
376: procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,
377: p_formula_name_o in ff_formulas_f.formula_name%type,
378: p_formula_name_n in ff_formulas_f.formula_name%type,
379: p_description_o in ff_formulas_f.description%type,
380: p_description_n in ff_formulas_f.description%type) IS
381: l_proc varchar2(30) ;

Line 378: p_formula_name_n in ff_formulas_f.formula_name%type,

374:
375:
376: procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,
377: p_formula_name_o in ff_formulas_f.formula_name%type,
378: p_formula_name_n in ff_formulas_f.formula_name%type,
379: p_description_o in ff_formulas_f.description%type,
380: p_description_n in ff_formulas_f.description%type) IS
381: l_proc varchar2(30) ;
382: l_count binary_integer;

Line 379: p_description_o in ff_formulas_f.description%type,

375:
376: procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,
377: p_formula_name_o in ff_formulas_f.formula_name%type,
378: p_formula_name_n in ff_formulas_f.formula_name%type,
379: p_description_o in ff_formulas_f.description%type,
380: p_description_n in ff_formulas_f.description%type) IS
381: l_proc varchar2(30) ;
382: l_count binary_integer;
383: begin

Line 380: p_description_n in ff_formulas_f.description%type) IS

376: procedure fml_ari ( p_formula_id in ff_formulas_f.formula_id%type,
377: p_formula_name_o in ff_formulas_f.formula_name%type,
378: p_formula_name_n in ff_formulas_f.formula_name%type,
379: p_description_o in ff_formulas_f.description%type,
380: p_description_n in ff_formulas_f.description%type) IS
381: l_proc varchar2(30) ;
382: l_count binary_integer;
383: begin
384: l_proc := 'fml_ari' ;

Line 403: procedure fml_brd (p_formula_id in ff_formulas_f.formula_id%type) IS

399: raise;
400: end;
401:
402:
403: procedure fml_brd (p_formula_id in ff_formulas_f.formula_id%type) IS
404: l_proc varchar2(30) ;
405: l_count binary_integer;
406: begin
407: l_proc := 'fml_brd' ;

Line 425: cursor c_fml (p_formula_id ff_formulas_f.formula_id%type )

421:
422:
423: procedure fml_asi IS
424: l_proc varchar2(30) ;
425: cursor c_fml (p_formula_id ff_formulas_f.formula_id%type )
426: is
427: select 1
428: from ff_formulas_f b
429: where b.formula_id = p_formula_id

Line 428: from ff_formulas_f b

424: l_proc varchar2(30) ;
425: cursor c_fml (p_formula_id ff_formulas_f.formula_id%type )
426: is
427: select 1
428: from ff_formulas_f b
429: where b.formula_id = p_formula_id
430: and not exists
431: -- this is the first insert ; there is no corresponding row in tl table
432: ( select 1

Line 433: from ff_formulas_f_tl tl

429: where b.formula_id = p_formula_id
430: and not exists
431: -- this is the first insert ; there is no corresponding row in tl table
432: ( select 1
433: from ff_formulas_f_tl tl
434: where tl.formula_id = p_formula_id ) ;
435: rec_fml c_fml%rowtype;
436: begin
437: l_proc := 'fml_asi' ;

Line 468: cursor c_fml_del ( p_formula_id ff_formulas_f.formula_id%type )

464:
465:
466: procedure fml_asd IS
467: l_proc varchar2(30) ;
468: cursor c_fml_del ( p_formula_id ff_formulas_f.formula_id%type )
469: is
470: select 1
471: from ff_formulas_f_tl f
472: where f.formula_id = p_formula_id

Line 471: from ff_formulas_f_tl f

467: l_proc varchar2(30) ;
468: cursor c_fml_del ( p_formula_id ff_formulas_f.formula_id%type )
469: is
470: select 1
471: from ff_formulas_f_tl f
472: where f.formula_id = p_formula_id
473: and not exists
474: ( select 1
475: from ff_formulas_f f1

Line 475: from ff_formulas_f f1

471: from ff_formulas_f_tl f
472: where f.formula_id = p_formula_id
473: and not exists
474: ( select 1
475: from ff_formulas_f f1
476: where f1.formula_id = p_formula_id
477:
478: );
479: rec_fml c_fml_del%rowtype;

Line 513: ff_formulas_f_pkg.g_dml_status := hr_general.char_to_bool(status);

509: l_proc := 'set_dml_status' ;
510:
511: hr_utility.set_location('Entering -'||l_proc ,05 ) ;
512:
513: ff_formulas_f_pkg.g_dml_status := hr_general.char_to_bool(status);
514:
515: if(status = 'TRUE') then
516: hr_general.g_data_migrator_mode := 'Y';
517: elsif(status='FALSE') then