DBA Data[Home] [Help]

APPS.FFDICT dependencies on DBMS_SQL

Line 374: ,p_formula_ids out nocopy dbms_sql.number_table

370: (p_tl_user_name in varchar2
371: ,p_user_name in varchar2
372: ,p_user_entity_id in number
373: ,p_language in varchar2
374: ,p_formula_ids out nocopy dbms_sql.number_table
375: ,p_formula_names out nocopy dbms_sql.varchar2s
376: ,p_eff_start_dates out nocopy dbms_sql.date_table
377: ,p_eff_end_dates out nocopy dbms_sql.date_table
378: ,p_bus_group_ids out nocopy dbms_sql.number_table

Line 375: ,p_formula_names out nocopy dbms_sql.varchar2s

371: ,p_user_name in varchar2
372: ,p_user_entity_id in number
373: ,p_language in varchar2
374: ,p_formula_ids out nocopy dbms_sql.number_table
375: ,p_formula_names out nocopy dbms_sql.varchar2s
376: ,p_eff_start_dates out nocopy dbms_sql.date_table
377: ,p_eff_end_dates out nocopy dbms_sql.date_table
378: ,p_bus_group_ids out nocopy dbms_sql.number_table
379: ,p_leg_codes out nocopy dbms_sql.varchar2s

Line 376: ,p_eff_start_dates out nocopy dbms_sql.date_table

372: ,p_user_entity_id in number
373: ,p_language in varchar2
374: ,p_formula_ids out nocopy dbms_sql.number_table
375: ,p_formula_names out nocopy dbms_sql.varchar2s
376: ,p_eff_start_dates out nocopy dbms_sql.date_table
377: ,p_eff_end_dates out nocopy dbms_sql.date_table
378: ,p_bus_group_ids out nocopy dbms_sql.number_table
379: ,p_leg_codes out nocopy dbms_sql.varchar2s
380: ) is

Line 377: ,p_eff_end_dates out nocopy dbms_sql.date_table

373: ,p_language in varchar2
374: ,p_formula_ids out nocopy dbms_sql.number_table
375: ,p_formula_names out nocopy dbms_sql.varchar2s
376: ,p_eff_start_dates out nocopy dbms_sql.date_table
377: ,p_eff_end_dates out nocopy dbms_sql.date_table
378: ,p_bus_group_ids out nocopy dbms_sql.number_table
379: ,p_leg_codes out nocopy dbms_sql.varchar2s
380: ) is
381: cursor csr_ref_formulas

Line 378: ,p_bus_group_ids out nocopy dbms_sql.number_table

374: ,p_formula_ids out nocopy dbms_sql.number_table
375: ,p_formula_names out nocopy dbms_sql.varchar2s
376: ,p_eff_start_dates out nocopy dbms_sql.date_table
377: ,p_eff_end_dates out nocopy dbms_sql.date_table
378: ,p_bus_group_ids out nocopy dbms_sql.number_table
379: ,p_leg_codes out nocopy dbms_sql.varchar2s
380: ) is
381: cursor csr_ref_formulas
382: (p_tl_user_name in varchar2

Line 379: ,p_leg_codes out nocopy dbms_sql.varchar2s

375: ,p_formula_names out nocopy dbms_sql.varchar2s
376: ,p_eff_start_dates out nocopy dbms_sql.date_table
377: ,p_eff_end_dates out nocopy dbms_sql.date_table
378: ,p_bus_group_ids out nocopy dbms_sql.number_table
379: ,p_leg_codes out nocopy dbms_sql.varchar2s
380: ) is
381: cursor csr_ref_formulas
382: (p_tl_user_name in varchar2
383: ,p_bus_group_id in number