DBA Data[Home] [Help]

APPS.FFDICT dependencies on DBMS_SQL

Line 373: ,p_formula_ids out nocopy dbms_sql.number_table

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

Line 374: ,p_formula_names out nocopy dbms_sql.varchar2s

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

Line 375: ,p_eff_start_dates out nocopy dbms_sql.date_table

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

Line 376: ,p_eff_end_dates out nocopy dbms_sql.date_table

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

Line 377: ,p_bus_group_ids out nocopy dbms_sql.number_table

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

Line 378: ,p_leg_codes out nocopy dbms_sql.varchar2s

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