DBA Data[Home] [Help]

APPS.IGS_GE_GEN_001 dependencies on FND_GLOBAL

Line 96: IF INSTR(UPPER(REPLACE(REPLACE(v_search_condition, fnd_global.local_chr(32)), fnd_global.local_chr(09))),

92: -- Check if the column is constained to uppercase.
93: -- Search for: column_name=UPPER(column_name)
94: -- Eg. SURNAME=UPPER(SURNAME)
95: -- Spaces and tabs are removed from the search string.
96: IF INSTR(UPPER(REPLACE(REPLACE(v_search_condition, fnd_global.local_chr(32)), fnd_global.local_chr(09))),
97: v_column_name || '=UPPER(' || v_column_name || ')') > 0 THEN
98: CLOSE c_uc;
99: RETURN TRUE;
100: END IF;

Line 989: v_addr := v_addr || fnd_global.local_chr(10) || v_line_1;

985: END IF;
986: -- Use p_inc_addr to append address lnies that are not null
987: IF p_inc_addr = 'Y' THEN
988: IF v_line_1 IS NOT NULL THEN
989: v_addr := v_addr || fnd_global.local_chr(10) || v_line_1;
990: END IF;
991: IF v_line_2 IS NOT NULL THEN
992: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;
993: END IF;

Line 992: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;

988: IF v_line_1 IS NOT NULL THEN
989: v_addr := v_addr || fnd_global.local_chr(10) || v_line_1;
990: END IF;
991: IF v_line_2 IS NOT NULL THEN
992: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;
993: END IF;
994: IF v_line_3 IS NOT NULL THEN
995: v_addr := v_addr || ' ' || v_line_3;
996: END IF;