[Home] [Help]
65: Cursor c_Record_Ver_No Is
66: Select
67: record_version_number
68: From
69: pa_rbs_headers_b
70: Where
71: rbs_header_id=p_rbsHeaderId
72: For Update Of Effective_From_Date NoWait;
73:
253: --Check if Rbs has rules as its elements when use_for_alloc_flag is checked by the user.
254:
255: SELECT use_for_Alloc_Flag
256: INTO l_Use_For_Alloc_Flag
257: FROM pa_rbs_headers_b
258: WHERE rbs_header_id=P_RbsHeaderId;
259:
260:
261: IF(l_use_for_alloc_flag='N' and p_use_for_alloc_flag='Y') Then
364: Effective_From_Date
365: Into
366: l_EffectiveFromDate
367: From
368: Pa_Rbs_Headers_B
369: Where
370: Rbs_Header_Id = P_RbsHeaderId;
371:
372: Pa_Debug.G_Stage := 'Check if trying to change the effective from date of the header.';
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