DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FA_RX_SHARED_PKG

Line 947: l_cat_segs fa_rx_shared_pkg.Seg_Array;

943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
944:
945: l_cat_struct number;
946: l_concat_cat varchar2(210);
947: l_cat_segs fa_rx_shared_pkg.Seg_Array;
948: i integer:= 0;
949: l_seg varchar2(30);
950: l_err_stage varchar2(100);
951:

Line 979: segarray fa_rx_shared_pkg.Seg_Array;

975: h_flex_code varchar2(10) := 'CAT#';
976: h_appl_id number := 140;
977: h_appl_short_name varchar2(10) := 'OFA';
978: concat_string varchar2(210); ---modified length to 210 for Bug:16276033
979: segarray fa_rx_shared_pkg.Seg_Array;
980: cursor segcolumns is
981: select distinct g.application_column_name, g.segment_num
982: from fnd_columns c, fnd_id_flex_segments g
983: WHERE g.application_id = h_appl_id

Line 1001: l_err_stage:= 'fa_rx_shared_pkg.concat_category';

997: select category_flex_structure
998: into l_cat_struct
999: from fa_system_controls;
1000:
1001: l_err_stage:= 'fa_rx_shared_pkg.concat_category';
1002: -- dbms_output.put_line(l_err_stage);
1003:
1004: -- bug 3225015
1005: -- Replacing call to fa_rx_shared_pkg, with code underneatch

Line 1005: -- Replacing call to fa_rx_shared_pkg, with code underneatch

1001: l_err_stage:= 'fa_rx_shared_pkg.concat_category';
1002: -- dbms_output.put_line(l_err_stage);
1003:
1004: -- bug 3225015
1005: -- Replacing call to fa_rx_shared_pkg, with code underneatch
1006: -- due to specific requirement, not to be shared.
1007: /* fa_rx_shared_pkg.concat_category (
1008: struct_id => l_cat_struct,
1009: ccid => px_asset_cat_rec_new.category_id,

Line 1007: /* fa_rx_shared_pkg.concat_category (

1003:
1004: -- bug 3225015
1005: -- Replacing call to fa_rx_shared_pkg, with code underneatch
1006: -- due to specific requirement, not to be shared.
1007: /* fa_rx_shared_pkg.concat_category (
1008: struct_id => l_cat_struct,
1009: ccid => px_asset_cat_rec_new.category_id,
1010: concat_string => l_concat_cat,
1011: segarray => l_cat_segs, p_log_level_rec => p_log_level_rec);

Line 1084: -- End replacing fa_rx_shared_pkg. This is what we finally need.

1080: concat_string := rtrim(concat_string,delim);
1081:
1082: dbms_sql.close_cursor(v_cursorid);
1083:
1084: -- End replacing fa_rx_shared_pkg. This is what we finally need.
1085: l_concat_cat := concat_string;
1086:
1087: --
1088: -- determine whether balancing seg of old and new cat is same