APPS.FV_CFS_PKG dependencies on FND_GLOBAL

Line 814: l_child := l_child || flex_rec.application_column_name || ' between '|| '''' || child_rec.child_flex_value_low || ''' and ''' || child_rec.child_flex_value_high || '''' || fnd_global.local_chr(10);

810: WHEN child_value%NOTFOUND ;
811: IF l_no_of_child > 0 THEN
812: l_child := l_child || ' OR ';
813: END IF;
814: l_child := l_child || flex_rec.application_column_name || ' between '|| '''' || child_rec.child_flex_value_low || ''' and ''' || child_rec.child_flex_value_high || '''' || fnd_global.local_chr(10);
815: l_no_of_child := l_no_of_child + 1;
816: END LOOP;
817: l_child := l_child || ' )' ;
818: l_and := NULL;

Line 819: v_statement := v_statement || l_and || L_CHILD || fnd_global.local_chr(10);

815: l_no_of_child := l_no_of_child + 1;
816: END LOOP;
817: l_child := l_child || ' )' ;
818: l_and := NULL;
819: v_statement := v_statement || l_and || L_CHILD || fnd_global.local_chr(10);
820: CLOSE CHILD_VALUE;
821: ELSE
822: -- 2
823: IF (l_no_of_seg > 0) THEN

Line 826: v_statement := v_statement || l_and || flex_rec.application_column_name || ' = ''' || v_seg(l_segno) || ''' ' || fnd_global.local_chr(10);

822: -- 2
823: IF (l_no_of_seg > 0) THEN
824: l_and := ' AND ';
825: END IF;
826: v_statement := v_statement || l_and || flex_rec.application_column_name || ' = ''' || v_seg(l_segno) || ''' ' || fnd_global.local_chr(10);
827: END IF;
828: -- cnt > 0
829: l_no_of_seg := l_no_of_seg + 1;
830: END IF;

Line 917: l_child := l_child || flex_rec.application_column_name || ' between '|| '''' || child_rec.child_flex_value_low || ''' and ''' || child_rec.child_flex_value_high || '''' || fnd_global.local_chr(10);

913: WHEN child_value%NOTFOUND ;
914: IF l_no_of_child > 0 THEN
915: l_child := l_child || ' OR ';
916: END IF;
917: l_child := l_child || flex_rec.application_column_name || ' between '|| '''' || child_rec.child_flex_value_low || ''' and ''' || child_rec.child_flex_value_high || '''' || fnd_global.local_chr(10);
918: l_no_of_child := l_no_of_child + 1;
919: END LOOP;
920: l_child := l_child || ' )' ;
921: l_and := NULL;

Line 922: v_statement := v_statement || l_and || L_CHILD || fnd_global.local_chr(10);

918: l_no_of_child := l_no_of_child + 1;
919: END LOOP;
920: l_child := l_child || ' )' ;
921: l_and := NULL;
922: v_statement := v_statement || l_and || L_CHILD || fnd_global.local_chr(10);
923: CLOSE CHILD_VALUE;
924: ELSE
925: /* 2 */
926: IF (l_no_of_seg > 0) THEN

Line 929: v_statement := v_statement || l_and || flex_rec.application_column_name || ' = ''' || v_seg(l_segno) || ''' ' || fnd_global.local_chr(10);

925: /* 2 */
926: IF (l_no_of_seg > 0) THEN
927: l_and := ' AND ';
928: END IF;
929: v_statement := v_statement || l_and || flex_rec.application_column_name || ' = ''' || v_seg(l_segno) || ''' ' || fnd_global.local_chr(10);
930: END IF;
931: /* cnt > 0 */
932: l_no_of_seg := l_no_of_seg + 1;
933: END IF;