136:
137:
138: Is
139:
140: l_Created_By Number := Fnd_Global.User_Id;
141: l_Creation_Date Date := SysDate;
142: l_Last_Update_Date Date := SysDate;
143: l_Last_Updated_By Number := Fnd_Global.User_Id;
144: l_Last_Update_Login Number := Fnd_Global.Login_Id;
139:
140: l_Created_By Number := Fnd_Global.User_Id;
141: l_Creation_Date Date := SysDate;
142: l_Last_Update_Date Date := SysDate;
143: l_Last_Updated_By Number := Fnd_Global.User_Id;
144: l_Last_Update_Login Number := Fnd_Global.Login_Id;
145:
146: --This cursor sets the value for rbs_version_id from pa_rbs_versions_s sequence
147: Cursor c_Rbs_Version_Id_Seq Is
140: l_Created_By Number := Fnd_Global.User_Id;
141: l_Creation_Date Date := SysDate;
142: l_Last_Update_Date Date := SysDate;
143: l_Last_Updated_By Number := Fnd_Global.User_Id;
144: l_Last_Update_Login Number := Fnd_Global.Login_Id;
145:
146: --This cursor sets the value for rbs_version_id from pa_rbs_versions_s sequence
147: Cursor c_Rbs_Version_Id_Seq Is
148: Select
368: Null,
369: Null,
370: Null,
371: SysDate,
372: Fnd_Global.User_Id,
373: SysDate,
374: Fnd_Global.User_Id,
375: Fnd_Global.Login_Id,
376: 1);
370: Null,
371: SysDate,
372: Fnd_Global.User_Id,
373: SysDate,
374: Fnd_Global.User_Id,
375: Fnd_Global.Login_Id,
376: 1);
377:
378: X_Rbs_Element_Id := l_Rbs_Element_Id;
371: SysDate,
372: Fnd_Global.User_Id,
373: SysDate,
374: Fnd_Global.User_Id,
375: Fnd_Global.Login_Id,
376: 1);
377:
378: X_Rbs_Element_Id := l_Rbs_Element_Id;
379:
497:
498: Is
499:
500: l_Last_Update_Date Date := SysDate;
501: l_Last_Updated_By Number := Fnd_Global.User_Id;
502: l_Last_Update_Login Number := Fnd_Global.Login_Id;
503: l_Rbs_Version_Id Number := Null;
504:
505: BEGIN
498: Is
499:
500: l_Last_Update_Date Date := SysDate;
501: l_Last_Updated_By Number := Fnd_Global.User_Id;
502: l_Last_Update_Login Number := Fnd_Global.Login_Id;
503: l_Rbs_Version_Id Number := Null;
504:
505: BEGIN
506: