APPS.BEN_EXT_SORT dependencies on BEN_EXT_FMT

Line 86: l_prmy_val := nvl(substr(ben_ext_fmt.g_val_tab(l_prmy_seq_num),1,l_prmy_val_max),' ');

82: if p_sort1_data_elmt_in_rcd_id is not null then
83: open c_get_seq_num(p_sort1_data_elmt_in_rcd_id);
84: fetch c_get_seq_num into l_prmy_seq_num;
85: close c_get_seq_num;
86: l_prmy_val := nvl(substr(ben_ext_fmt.g_val_tab(l_prmy_seq_num),1,l_prmy_val_max),' ');
87: end if;
88:
89: if p_sort2_data_elmt_in_rcd_id is not null then
90: open c_get_seq_num(p_sort2_data_elmt_in_rcd_id);

Line 93: l_scnd_val := nvl(substr(ben_ext_fmt.g_val_tab(l_scnd_seq_num),1,l_scnd_val_max),' ');

89: if p_sort2_data_elmt_in_rcd_id is not null then
90: open c_get_seq_num(p_sort2_data_elmt_in_rcd_id);
91: fetch c_get_seq_num into l_scnd_seq_num;
92: close c_get_seq_num;
93: l_scnd_val := nvl(substr(ben_ext_fmt.g_val_tab(l_scnd_seq_num),1,l_scnd_val_max),' ');
94: end if;
95:
96: if p_sort3_data_elmt_in_rcd_id is not null then
97: open c_get_seq_num(p_sort3_data_elmt_in_rcd_id);

Line 100: l_thrd_val := nvl(substr(ben_ext_fmt.g_val_tab(l_thrd_seq_num),1,l_thrd_val_max),' ');

96: if p_sort3_data_elmt_in_rcd_id is not null then
97: open c_get_seq_num(p_sort3_data_elmt_in_rcd_id);
98: fetch c_get_seq_num into l_thrd_seq_num;
99: close c_get_seq_num;
100: l_thrd_val := nvl(substr(ben_ext_fmt.g_val_tab(l_thrd_seq_num),1,l_thrd_val_max),' ');
101: end if;
102:
103: if p_sort4_data_elmt_in_rcd_id is not null then
104: open c_get_seq_num(p_sort4_data_elmt_in_rcd_id);

Line 107: l_frth_val := nvl(substr(ben_ext_fmt.g_val_tab(l_frth_seq_num),1,l_frth_val_max),' ');

103: if p_sort4_data_elmt_in_rcd_id is not null then
104: open c_get_seq_num(p_sort4_data_elmt_in_rcd_id);
105: fetch c_get_seq_num into l_frth_seq_num;
106: close c_get_seq_num;
107: l_frth_val := nvl(substr(ben_ext_fmt.g_val_tab(l_frth_seq_num),1,l_frth_val_max),' ');
108: end if;
109:
110: --
111: l_trans_count := lpad(to_char(g_trans_count),l_trans_count_max,'0');