APPS.CS_PARTY_ROLE_GROUP_MAPS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  PX_PARTY_ROLE_GROUP_MAPPING_ID in out NOCOPY NUMBER,
  PX_PARTY_ROLE_GROUP_CODE in out NOCOPY VARCHAR2,
  PX_PARTY_ROLE_CODE in out NOCOPY VARCHAR2,
  P_SEEDED_FLAG in VARCHAR2,
  P_START_DATE_ACTIVE in DATE,
  P_END_DATE_ACTIVE in DATE,
  P_CREATION_DATE in DATE,
  P_CREATED_BY in NUMBER,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
) is
  l_object_Version_number number := 1;

Line: 19

  insert into CS_PARTY_ROLE_GROUP_MAPS (
    PARTY_ROLE_GROUP_MAPPING_ID,
    PARTY_ROLE_GROUP_CODE,
    PARTY_ROLE_CODE,
    SEEDED_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    PX_PARTY_ROLE_GROUP_MAPPING_ID,
    PX_PARTY_ROLE_GROUP_CODE,
    PX_PARTY_ROLE_CODE,
    P_SEEDED_FLAG,
    P_START_DATE_ACTIVE,
    P_END_DATE_ACTIVE,
    P_CREATED_BY,
    P_CREATION_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN,
    L_OBJECT_VERSION_NUMBER);

Line: 48

end INSERT_ROW;

Line: 51

procedure UPDATE_ROW (
  P_PARTY_ROLE_GROUP_MAPPING_ID in NUMBER,
  P_PARTY_ROLE_GROUP_CODE in VARCHAR2,
  P_PARTY_ROLE_CODE in VARCHAR2,
  P_SEEDED_FLAG in VARCHAR2,
  P_START_DATE_ACTIVE in DATE,
  P_END_DATE_ACTIVE in DATE,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
) is
begin
  update CS_PARTY_ROLE_GROUP_MAPS set
    SEEDED_FLAG = P_SEEDED_FLAG,
    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
    START_DATE_ACTIVE = P_START_DATE_ACTIVE,
    END_DATE_ACTIVE = P_END_DATE_ACTIVE,
    PARTY_ROLE_GROUP_CODE = P_PARTY_ROLE_GROUP_CODE,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where PARTY_ROLE_GROUP_CODE = P_PARTY_ROLE_GROUP_CODE
  and PARTY_ROLE_CODE = P_PARTY_ROLE_CODE
  and PARTY_ROLE_GROUP_MAPPING_ID = P_PARTY_ROLE_GROUP_MAPPING_ID
  RETURNING OBJECT_VERSION_NUMBER INTO X_OBJECT_VERSION_NUMBER;

Line: 81

end UPDATE_ROW;

Line: 83

procedure DELETE_ROW (
  P_PARTY_ROLE_GROUP_CODE in VARCHAR2,
  P_PARTY_ROLE_CODE in VARCHAR2
) is
begin
  delete from CS_PARTY_ROLE_GROUP_MAPS
  where PARTY_ROLE_GROUP_CODE = P_PARTY_ROLE_GROUP_CODE
  and PARTY_ROLE_CODE = P_PARTY_ROLE_CODE;

Line: 95

end DELETE_ROW;

Line: 107

  P_LAST_UPDATE_DATE           IN VARCHAR2,
  P_LAST_UPDATED_BY            IN NUMBER,
  P_LAST_UPDATE_LOGIN          IN NUMBER,
  P_OBJECT_VERSION_NUMBER      IN NUMBER
)

IS
 -- Out local variables for the update / insert row procedures.
   lx_object_version_number  NUMBER := 0;

Line: 134

   UPDATE_ROW (
     P_PARTY_ROLE_GROUP_MAPPING_ID =>l_PARTY_ROLE_GROUP_MAPPING_ID,
     P_PARTY_ROLE_GROUP_CODE      =>l_PARTY_ROLE_GROUP_CODE,
     P_PARTY_ROLE_CODE            =>l_PARTY_ROLE_CODE,
     P_SEEDED_FLAG                =>p_seeded_flag,
     P_START_DATE_ACTIVE          =>to_date(p_start_date_active,'DD-MM-YYYY'),
     P_END_DATE_ACTIVE            =>to_date(p_end_date_active,'DD-MM-YYYY'),
     P_LAST_UPDATE_DATE           =>nvl(to_date(p_last_update_date,
                                                'DD-MM-YYYY'),sysdate),
     P_LAST_UPDATED_BY            =>l_user_id,
     P_LAST_UPDATE_LOGIN          =>0,
     X_OBJECT_VERSION_NUMBER      =>lx_object_version_number
     );

Line: 150

      INSERT_ROW (
         PX_PARTY_ROLE_GROUP_MAPPING_ID   =>l_PARTY_ROLE_GROUP_MAPPING_ID,
         PX_PARTY_ROLE_GROUP_CODE   =>l_PARTY_ROLE_GROUP_CODE,
         PX_PARTY_ROLE_CODE         =>l_PARTY_ROLE_CODE,
         P_SEEDED_FLAG            =>p_seeded_flag,
         P_START_DATE_ACTIVE      =>to_date(p_start_date_active,'DD-MM-YYYY'),
         P_END_DATE_ACTIVE        =>to_date(p_end_date_active,'DD-MM-YYYY'),
         P_CREATION_DATE          =>nvl(to_date( p_creation_date,
                                                'DD-MM-YYYY'),sysdate),
         P_CREATED_BY             =>l_user_id,
         P_LAST_UPDATE_DATE       =>nvl(to_date( p_last_update_date,
                                                'DD-MM-YYYY'),sysdate),
         P_LAST_UPDATED_BY        =>l_user_id,
         P_LAST_UPDATE_LOGIN      =>0,
         X_OBJECT_VERSION_NUMBER  =>lx_object_version_number
         );