DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on FND_FLEX_KEYVAL

Line 654: /*-------table fnd_id_flex_segments. The column determines how long the segment descriptions FND_FLEX_KEYVAL.concated_description will take.---------*/

650: ---
651:
652: /*-------Fix bug #819605: use AOL package to obtain segment descriptions-------*/
653: /*-------Note: if the output concatenated segment descriptions are truncated, modify the values in column concatenation_description_len of -----------*/
654: /*-------table fnd_id_flex_segments. The column determines how long the segment descriptions FND_FLEX_KEYVAL.concated_description will take.---------*/
655: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN
656: t_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions, 1, 1000);
657: return(t_desc);
658: END IF;

Line 655: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN

651:
652: /*-------Fix bug #819605: use AOL package to obtain segment descriptions-------*/
653: /*-------Note: if the output concatenated segment descriptions are truncated, modify the values in column concatenation_description_len of -----------*/
654: /*-------table fnd_id_flex_segments. The column determines how long the segment descriptions FND_FLEX_KEYVAL.concated_description will take.---------*/
655: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN
656: t_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions, 1, 1000);
657: return(t_desc);
658: END IF;
659: END get_gl_description;

Line 656: t_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions, 1, 1000);

652: /*-------Fix bug #819605: use AOL package to obtain segment descriptions-------*/
653: /*-------Note: if the output concatenated segment descriptions are truncated, modify the values in column concatenation_description_len of -----------*/
654: /*-------table fnd_id_flex_segments. The column determines how long the segment descriptions FND_FLEX_KEYVAL.concated_description will take.---------*/
655: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN
656: t_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions, 1, 1000);
657: return(t_desc);
658: END IF;
659: END get_gl_description;
660:

Line 1201: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN

1197: ELSIF t_nc = -2 THEN
1198: RETURN('** Invalid GL CCID '||to_char(a_code_combination_id)||' :: No Such Code Exists **');
1199: END IF;
1200: ---
1201: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN
1202: t_values := FND_FLEX_KEYVAL.concatenated_values;
1203: return(t_values);
1204: END IF;
1205: END get_gl_values;

Line 1202: t_values := FND_FLEX_KEYVAL.concatenated_values;

1198: RETURN('** Invalid GL CCID '||to_char(a_code_combination_id)||' :: No Such Code Exists **');
1199: END IF;
1200: ---
1201: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', x_chart_of_accts, a_code_combination_id ) THEN
1202: t_values := FND_FLEX_KEYVAL.concatenated_values;
1203: return(t_values);
1204: END IF;
1205: END get_gl_values;
1206: