APPS.IEM_MC_PUB SQL Statements

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

Line: 142

  select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;

Line: 144

  insert into IEM_MC_PARAMETERS
  (
    MC_PARAMETER_ID,
    ACTION,
    MASTER_ACCOUNT_ID,
    ACTIVITY_ID,
    TO_ADDRESS_LIST,
    CC_ADDRESS_LIST,
    BCC_ADDRESS_LIST,
    SUBJECT,
    SR_ID,
    CUSTOMER_ID,
    CONTACT_ID,
    RELATIONSHIP_ID,
    MES_DOC_ID,
    MES_CATEGORY_ID,
    INTERACTION_ID,
    DELETE_FLAG_Y_N,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  )
  values
  (
    x_mc_parameters_id,
    l_action,
    l_master_account_id,
    l_activity_id,
    l_to_address_list,
    l_cc_address_list,
    l_bcc_address_list,
    l_subject,
    l_sr_id,
    l_customer_id,
    l_contact_id,
    l_relationship_id,
    l_mes_document_id,
    l_mes_category_id,
    l_interaction_id,
    'N',
    FND_GLOBAL.USER_ID,
    SYSDATE,
    FND_GLOBAL.USER_ID,
    SYSDATE,
    FND_GLOBAL.LOGIN_ID
  );

Line: 198

        insert into IEM_MC_CUSTOM_PARAMS
        (
          MC_PARAMETER_ID,
          NAME,
          VALUE
        )
        values
        (
          x_mc_parameters_id,
          p_qualifiers(i).QUALIFIER_NAME,
          p_qualifiers(i).QUALIFIER_VALUE
        );

Line: 302

  l_last_updated_by        NUMBER:=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

Line: 303

  l_last_update_login      NUMBER:= NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

Line: 341

  select IEM_MC_PARAMETERS_S1.NEXTVAL into x_mc_parameters_id from sys.dual;

Line: 343

  insert into IEM_MC_PARAMETERS
  (
    MC_PARAMETER_ID,
    ACTION,
    MASTER_ACCOUNT_ID,
    ACTIVITY_ID,
    TO_ADDRESS_LIST,
    CC_ADDRESS_LIST,
    BCC_ADDRESS_LIST,
    SUBJECT,
    SR_ID,
    CUSTOMER_ID,
    CONTACT_ID,
    MES_DOC_ID,
    MES_CATEGORY_ID,
    INTERACTION_ID,
    DELETE_FLAG_Y_N,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    ENCODE,
    CHAR_SET,
    MSG_TYPE,
    RELATIONSHIP_ID
  )
  values
  (
    x_mc_parameters_id,
    l_action,
    p_master_account_id,
    decode(p_activity_id, fnd_api.g_miss_num, null, p_activity_id),
    p_to_address_list,
    p_cc_address_list,
    p_bcc_address_list,
    p_subject,
    p_sr_id,
    p_customer_id,
    p_contact_id,
    decode (p_mes_document_id, FND_API.G_MISS_NUM, NULL, p_mes_document_id),
    decode (p_mes_category_id, FND_API.G_MISS_NUM, NULL, p_mes_category_id),
    p_interaction_id,
    'N',
    l_created_by,
    SYSDATE,
    l_last_updated_by,
    SYSDATE,
    l_last_update_login,
    decode(p_encoding, fnd_api.g_miss_char, null, p_encoding),
    decode(p_character_set, fnd_api.g_miss_char, null, p_character_set),
    p_message_type, p_relationship_id );

Line: 401

        insert into IEM_MC_CUSTOM_PARAMS
        (
          MC_PARAMETER_ID,
          NAME,
          VALUE
        )
        values
        (
          x_mc_parameters_id,
          p_qualifiers(i).QUALIFIER_NAME,
          p_qualifiers(i).QUALIFIER_VALUE
        );