DBA Data[Home] [Help]

APPS.BIS_OBJECT_EXTENSIONS_PVT dependencies on BIS_COMMON_UTILS

Line 19: REM | are BIS_COMMON_UTILS.G_DEF_CHAR |

15: REM | NOTES |
16: REM | 24-NOV-2004 Krishna Created. |
17: REM | 31-Jan-2005 rpenneru Modified for #4153331, BIS_MEASURES_EXTENSION_TL |
18: REM | Name and Description should not be updated, if the values |
19: REM | are BIS_COMMON_UTILS.G_DEF_CHAR |
20: REM | 19-MAY-2005 visuri GSCC Issues bug 4363854 |
21: REM | 24-Aug-2005 hengliu bug#4572274: issue in loading seed data |
22: REM +=======================================================================+
23: */

Line 56: IF ( l_Form_Func_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN

52: END IF;
53: --dbms_output.put_line('i am calling validate from create ');
54: l_Form_Func_Extn_Rec := p_Form_Func_Extn_Rec;
55:
56: IF ( l_Form_Func_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN
57: l_Form_Func_Extn_Rec.Name := NULL;
58: END IF;
59:
60: IF ( l_Form_Func_Extn_Rec.Description = BIS_COMMON_UTILS.G_DEF_CHAR) THEN

Line 60: IF ( l_Form_Func_Extn_Rec.Description = BIS_COMMON_UTILS.G_DEF_CHAR) THEN

56: IF ( l_Form_Func_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN
57: l_Form_Func_Extn_Rec.Name := NULL;
58: END IF;
59:
60: IF ( l_Form_Func_Extn_Rec.Description = BIS_COMMON_UTILS.G_DEF_CHAR) THEN
61: l_Form_Func_Extn_Rec.Description := NULL;
62: END IF;
63:
64: -- Insert into base tables

Line 342: ELSIF ((p_Form_Func_Extn_Rec.Name <> BIS_COMMON_UTILS.G_DEF_CHAR)

338: END IF;
339:
340: IF ( p_Form_Func_Extn_Rec.Name IS NULL ) THEN
341: l_Form_Func_Extn_Rec.Name := NULL;
342: ELSIF ((p_Form_Func_Extn_Rec.Name <> BIS_COMMON_UTILS.G_DEF_CHAR)
343: AND ((l_Form_Func_Extn_Rec.Name IS NULL) OR (l_Form_Func_Extn_Rec.Name <> p_Form_Func_Extn_Rec.Name))) THEN
344: l_Form_Func_Extn_Rec.Name := p_Form_Func_Extn_Rec.Name;
345: END IF;
346:

Line 349: ELSIF ( (p_Form_Func_Extn_Rec.Description <> BIS_COMMON_UTILS.G_DEF_CHAR)

345: END IF;
346:
347: IF ( p_Form_Func_Extn_Rec.Description IS NULL ) THEN
348: l_Form_Func_Extn_Rec.Description := NULL;
349: ELSIF ( (p_Form_Func_Extn_Rec.Description <> BIS_COMMON_UTILS.G_DEF_CHAR)
350: AND ((l_Form_Func_Extn_Rec.Description IS NULL) OR (l_Form_Func_Extn_Rec.Description <> p_Form_Func_Extn_Rec.Description))) THEN
351: l_Form_Func_Extn_Rec.Description := p_Form_Func_Extn_Rec.Description;
352: END IF;
353:

Line 602: -- The value of the Name and Description from BISPMFLD.lct will be BIS_COMMON_UTILS.G_DEF_CHAR

598:
599: -- rpenneru bug#4153331
600: -- Create_Measures_Extension will be called from BISPMFLD.lct (Uploading Measures)
601: -- in the case Name and Description fields should be inserted as NULL values.
602: -- The value of the Name and Description from BISPMFLD.lct will be BIS_COMMON_UTILS.G_DEF_CHAR
603:
604: IF ( l_Meas_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN
605: l_Meas_Extn_Rec.Name := NULL;
606: END IF;

Line 604: IF ( l_Meas_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN

600: -- Create_Measures_Extension will be called from BISPMFLD.lct (Uploading Measures)
601: -- in the case Name and Description fields should be inserted as NULL values.
602: -- The value of the Name and Description from BISPMFLD.lct will be BIS_COMMON_UTILS.G_DEF_CHAR
603:
604: IF ( l_Meas_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN
605: l_Meas_Extn_Rec.Name := NULL;
606: END IF;
607:
608: IF ( l_Meas_Extn_Rec.Description = BIS_COMMON_UTILS.G_DEF_CHAR) THEN

Line 608: IF ( l_Meas_Extn_Rec.Description = BIS_COMMON_UTILS.G_DEF_CHAR) THEN

604: IF ( l_Meas_Extn_Rec.Name = BIS_COMMON_UTILS.G_DEF_CHAR ) THEN
605: l_Meas_Extn_Rec.Name := NULL;
606: END IF;
607:
608: IF ( l_Meas_Extn_Rec.Description = BIS_COMMON_UTILS.G_DEF_CHAR) THEN
609: l_Meas_Extn_Rec.Description := NULL;
610: END IF;
611:
612:

Line 827: -- The value of the Name and Description from BISPMFLD.lct will be BIS_COMMON_UTILS.G_DEF_CHAR

823:
824: -- rpenneru bug#4153331
825: -- Translate_Measures_Extension will be called from BISPMFLD.lct (Uploading Measures)
826: -- in the case Name and Description fields should not be updated.
827: -- The value of the Name and Description from BISPMFLD.lct will be BIS_COMMON_UTILS.G_DEF_CHAR
828: IF ( p_Meas_Extn_Rec.Name IS NULL ) THEN
829: l_Meas_Extn_Rec.Name := NULL;
830: ELSIF ((p_Meas_Extn_Rec.Name <> BIS_COMMON_UTILS.G_DEF_CHAR)
831: AND ((l_Meas_Extn_Rec.Name IS NULL) OR (l_Meas_Extn_Rec.Name <> p_Meas_Extn_Rec.Name))) THEN

Line 830: ELSIF ((p_Meas_Extn_Rec.Name <> BIS_COMMON_UTILS.G_DEF_CHAR)

826: -- in the case Name and Description fields should not be updated.
827: -- The value of the Name and Description from BISPMFLD.lct will be BIS_COMMON_UTILS.G_DEF_CHAR
828: IF ( p_Meas_Extn_Rec.Name IS NULL ) THEN
829: l_Meas_Extn_Rec.Name := NULL;
830: ELSIF ((p_Meas_Extn_Rec.Name <> BIS_COMMON_UTILS.G_DEF_CHAR)
831: AND ((l_Meas_Extn_Rec.Name IS NULL) OR (l_Meas_Extn_Rec.Name <> p_Meas_Extn_Rec.Name))) THEN
832: l_Meas_Extn_Rec.Name := p_Meas_Extn_Rec.Name;
833: END IF;
834:

Line 837: ELSIF ( (p_Meas_Extn_Rec.Description <> BIS_COMMON_UTILS.G_DEF_CHAR)

833: END IF;
834:
835: IF ( p_Meas_Extn_Rec.Description IS NULL ) THEN
836: l_Meas_Extn_Rec.Description := NULL;
837: ELSIF ( (p_Meas_Extn_Rec.Description <> BIS_COMMON_UTILS.G_DEF_CHAR)
838: AND ((l_Meas_Extn_Rec.Description IS NULL) OR (l_Meas_Extn_Rec.Description <> p_Meas_Extn_Rec.Description))) THEN
839: l_Meas_Extn_Rec.Description := p_Meas_Extn_Rec.Description;
840: END IF;
841: