494: l_ProgramId NUMBER;
495: l_ApplicationId NUMBER;
496: BEGIN
497: -- who columns
498: l_UserId := nvl(Fnd_Global.USER_ID, -1);
499: l_LoginId := Fnd_Global.LOGIN_ID;
500: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
501: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
502: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
495: l_ApplicationId NUMBER;
496: BEGIN
497: -- who columns
498: l_UserId := nvl(Fnd_Global.USER_ID, -1);
499: l_LoginId := Fnd_Global.LOGIN_ID;
500: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
501: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
502: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
503:
496: BEGIN
497: -- who columns
498: l_UserId := nvl(Fnd_Global.USER_ID, -1);
499: l_LoginId := Fnd_Global.LOGIN_ID;
500: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
501: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
502: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
503:
504: SAVEPOINT BEGIN_DELETE;
497: -- who columns
498: l_UserId := nvl(Fnd_Global.USER_ID, -1);
499: l_LoginId := Fnd_Global.LOGIN_ID;
500: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
501: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
502: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
503:
504: SAVEPOINT BEGIN_DELETE;
505:
498: l_UserId := nvl(Fnd_Global.USER_ID, -1);
499: l_LoginId := Fnd_Global.LOGIN_ID;
500: l_RequestId := Fnd_Global.CONC_REQUEST_ID;
501: l_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
502: l_ApplicationId := Fnd_Global.PROG_APPL_ID;
503:
504: SAVEPOINT BEGIN_DELETE;
505:
506: For X_DelType in DelGrpType loop