17: --Change History:
18: --Who When What
19: --pathipat 27-Jun-2003 Bug: 2992967 - Table based value set for segments
20: -- Removed quotes and concatenation in the vrule string
21: -- SYKRISHN 06/MAR/03 Changed FND_FLEX_KEYVAL callout from validate_ccid to validate_segs
22: -- as per bug 2832607
23: ------------------------------------------------------------------
24:
25: l_v_rule_string VARCHAR2(2000) := 'GL_ACCOUNT\nGL_ACCOUNT_TYPE\nI\nAPPL=IGS;NAME=IGS_FI_ACC_LIABL\nL';
24:
25: l_v_rule_string VARCHAR2(2000) := 'GL_ACCOUNT\nGL_ACCOUNT_TYPE\nI\nAPPL=IGS;NAME=IGS_FI_ACC_LIABL\nL';
26:
27: BEGIN
28: --Invoke FND_FLEX_KEYVAL.validate_segs for validating the CCID (Concat) with appropriate vrule string.
29: --Return FALSE from this function if FND API returns FALSE.
30:
31: IF fnd_flex_keyval.validate_segs(
32: operation =>'CHECK_COMBINATION',
27: BEGIN
28: --Invoke FND_FLEX_KEYVAL.validate_segs for validating the CCID (Concat) with appropriate vrule string.
29: --Return FALSE from this function if FND API returns FALSE.
30:
31: IF fnd_flex_keyval.validate_segs(
32: operation =>'CHECK_COMBINATION',
33: appl_short_name =>'SQLGL',
34: key_flex_code =>'GL#',
35: structure_number => igs_fi_gen_007.get_coa_id,
205: l_b_enabled BOOLEAN := FALSE;
206:
207: BEGIN
208:
209: l_b_enabled := fnd_flex_keyval.validate_segs( operation => 'CHECK_SEGMENTS',
210: appl_short_name => 'SQLGL',
211: key_flex_code => 'GL#',
212: structure_number => igs_fi_gen_007.get_coa_id,
213: displayable => p_n_segment_num,
215: vrule => 'GL_ACCOUNT\nGL_ACCOUNT_TYPE\nI\nAPPL=IGS;NAME=IGS_FI_ACC_REV\nR',
216: concat_segments => p_v_natural_acc_seg
217: );
218:
219: RETURN (fnd_flex_keyval.segment_description(p_n_segment_num)) ;
220:
221: END get_segment_desc;
222:
223: