APPS.POS_SURVEY_INTEGRATION SQL Statements

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

Line: 19

 SELECT mapping_id
 FROM pos_supplier_mappings
 WHERE supplier_reg_id = p_supplier_reg_id;

Line: 24

 SELECT mapping_id
 FROM pos_supplier_mappings
 WHERE vendor_id = p_vendor_id;

Line: 31

 SELECT transaction_id, supplier_update_flag
 FROM pos_survey_transactions
 WHERE supplier_mapping_id = l_mapping_id
 AND survey_transaction_id = p_survey_transaction_id;

Line: 37

 l_supplier_update_flag VARCHAR2(1);

Line: 98

 FETCH l_transaction_cur INTO l_transaction_id, l_supplier_update_flag;

Line: 104

    l_supplier_update_flag := 'Y';

Line: 106

    l_supplier_update_flag := 'N';

Line: 111

  INSERT INTO pos_survey_transactions
   (transaction_id, supplier_mapping_id, survey_transaction_id, created_by,
    creation_date, last_updated_by, last_update_date, last_update_login,
    respondent_table_name, respondent_id, supplier_update_flag)
  VALUES
   (pos_survey_transactions_s.NEXTVAL, l_mapping_id, p_survey_transaction_id, fnd_global.user_id,
    sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
    p_respondent_table_name, p_respondent_id, l_supplier_update_flag);

Line: 125

  IF ((l_supplier_update_flag IS NULL OR l_supplier_update_FLAG <> 'Y')
     AND (p_respondent_table_name <> 'POS_CONTACT_REQUESTS')) THEN
    l_supplier_update_flag := 'N';

Line: 129

    l_supplier_update_flag := 'Y';

Line: 134

  UPDATE pos_survey_transactions
  SET last_updated_by = fnd_global.user_id,
      last_update_date = sysdate,
      last_update_login = fnd_global.login_id,
      respondent_table_name = p_respondent_table_name,
      respondent_id = p_respondent_id,
      supplier_update_flag = l_supplier_update_flag
  WHERE transaction_id = l_transaction_id;