[Home] [Help]
174: Name
175: Into
176: l_Name
177: From
178: Pa_Rbs_Headers_TL
179: Where
180: Rbs_Header_Id = P_RbsHeaderId
181: And language = USERENV('LANG');
182:
188: Count(*)
189: Into
190: l_Count
191: From
192: Pa_Rbs_Headers_TL
193: Where
194: Name = P_Name
195: And language = USERENV('LANG');
196:
525: -- : This API will be called from following page:
526: -- : 1.Rbs Header Page
527:
528: -- Note : This API will does all the business validations.
529: -- : -- If no errors are encounterd it inserts the Rbs header into pa_rbs_headers_b and pa_rbs_headers_tl table.
530: -- : -- The validations made are
531: -- : -- Rbs Header name should be unique
532: -- : -- Rbs Header name should not be null
533: -- : -- Rbs From date cannot be null
665: Count(*)
666: Into
667: l_Count
668: From
669: Pa_Rbs_Headers_TL
670: Where
671: Name = P_Name
672: And language = USERENV('LANG');
673: