62: select max(ASSIGNMENT_STATUS_TYPE_ID)
63: from per_assignment_status_types;
64:
65: cursor CSR_SEQUENCE is
66: select PER_ASSIGNMENT_STATUS_TYPES_S.nextval
67: from dual;
68: L_BUSINESS_GROUP_ID NUMBER;
69: L_MAX_SEQ NUMBER;
70: begin
562: -- is not changed when updating the record.
563:
564: if X_BUSINESS_GROUP_ID is not null then
565:
566: update PER_ASSIGNMENT_STATUS_TYPES set
567: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
568: LEGISLATION_CODE = X_LEGISLATION_CODE,
569: USER_STATUS = X_USER_STATUS, -- Bug 2731841
570: ACTIVE_FLAG = X_ACTIVE_FLAG,
578: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
579:
580: else
581:
582: update PER_ASSIGNMENT_STATUS_TYPES set
583: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
584: LEGISLATION_CODE = X_LEGISLATION_CODE,
585: -- USER_STATUS = X_USER_STATUS, -- Bug 2731841
586: ACTIVE_FLAG = X_ACTIVE_FLAG,