DBA Data[Home] [Help]

APPS.AST_UWQ_MLIST_WORK_ACTION SQL Statements

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

Line: 25

  PROCEDURE MLIST_UPDATE_OUTCOME
    ( p_action_key     IN  VARCHAR2,
      p_list_header_id IN  NUMBER,
      p_list_entry_id  IN  NUMBER,
      p_outcome_id     IN  NUMBER,
      p_reason_id      IN  NUMBER,
      p_result_id      IN  NUMBER,
      x_msg_count      OUT NOCOPY NUMBER,
      x_msg_data       OUT NOCOPY VARCHAR2,
      x_return_status  OUT NOCOPY VARCHAR2
    ) IS

    l_creation_date     DATE   := SYSDATE;
Line: 38

    l_last_update_date  DATE   := SYSDATE;
Line: 39

    l_last_updated_by   NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
Line: 41

    l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
Line: 46

      UPDATE Ams_list_entries
      SET outcome_id        = p_outcome_id,
          reason_id         = p_reason_id,
          result_id         = p_result_id,
          last_update_date  = l_last_update_date,
          last_updated_by   = l_last_updated_by,
          last_update_login = l_last_update_login
      WHERE list_entry_id   = p_list_entry_id
        AND list_header_id  = p_list_header_id;
Line: 75

  END; -- End procedure MLIST_UPDATE_OUTCOME
Line: 274

    l_last_update_date        DATE   := SYSDATE;
Line: 275

    l_last_updated_by         NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
Line: 277

    l_last_update_login       NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
Line: 363

         MLIST_UPDATE_OUTCOME
          ( p_action_key     => p_action_key,
            p_list_header_id => l_list_header_id,
            p_list_entry_id  => l_list_entry_id,
            p_outcome_id     => l_outcome_id,
            p_reason_id      => l_reason_id,
            p_result_id      => l_result_id,
	        x_return_status  => l_return_status,
	        x_msg_count      => l_msg_count,
	        x_msg_data       => l_msg_data
	      );
Line: 406

              p_entered_by         => l_last_updated_by,
              p_entered_date       => l_last_update_date,
              p_last_update_date   => l_last_update_date,
              p_last_updated_by    => l_last_updated_by,
              p_creation_date      => l_creation_date,
              p_created_by         => l_created_by,
              p_last_update_login  => l_last_update_login,
              p_party_id           => l_party_id,
              x_jtf_note_id        => l_jtf_note_id,
              x_return_status      => l_return_status,
              x_msg_count          => l_msg_count,
              x_msg_data           => l_msg_data
            );
Line: 467

    l_last_update_date        DATE   := SYSDATE;
Line: 468

    l_last_updated_by         NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
Line: 470

    l_last_update_login       NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
Line: 676

        MLIST_UPDATE_OUTCOME
        ( p_action_key     => p_action_key,
          p_list_header_id => l_list_header_id,
          p_list_entry_id  => l_list_entry_id,
          p_outcome_id     => l_outcome_id,
          p_reason_id      => l_reason_id,
          p_result_id      => l_result_id,
          x_return_status  => l_return_status,
          x_msg_count      => l_msg_count,
          x_msg_data       => l_msg_data
        );
Line: 716

              p_entered_by         => l_last_updated_by,
              p_entered_date       => l_last_update_date,
              p_last_update_date   => l_last_update_date,
              p_last_updated_by    => l_last_updated_by,
              p_creation_date      => l_creation_date,
              p_created_by         => l_created_by,
              p_last_update_login  => l_last_update_login,
              p_party_id           => l_party_id,
              x_jtf_note_id        => l_jtf_note_id,
              x_return_status      => l_return_status,
              x_msg_count          => l_msg_count,
              x_msg_data           => l_msg_data
            );
Line: 779

    l_last_update_date          DATE   := SYSDATE;
Line: 780

    l_last_updated_by           NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
Line: 782

    l_last_update_login         NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
Line: 981

    MLIST_UPDATE_OUTCOME
    ( p_action_key     => p_action_key,
      p_list_header_id => l_list_header_id,
      p_list_entry_id  => l_list_entry_id,
      p_outcome_id     => l_outcome_id,
      p_reason_id      => l_reason_id,
      p_result_id      => l_result_id,
      x_return_status  => l_return_status,
      x_msg_count      => l_msg_count,
      x_msg_data       => l_msg_data
    );
Line: 1020

          p_entered_by         => l_last_updated_by,
          p_entered_date       => l_last_update_date,
          p_last_update_date   => l_last_update_date,
          p_last_updated_by    => l_last_updated_by,
          p_creation_date      => l_creation_date,
          p_created_by         => l_created_by,
          p_last_update_login  => l_last_update_login,
          p_party_id           => l_party_id,
          x_jtf_note_id        => l_jtf_note_id,
          x_return_status      => l_return_status,
          x_msg_count          => l_msg_count,
          x_msg_data           => l_msg_data
        );
Line: 1079

    l_last_update_date      DATE   := SYSDATE;
Line: 1080

    l_last_updated_by       NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
Line: 1082

    l_last_update_login     NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
Line: 1275

        p_last_update_date       => l_last_update_date,
        p_lead_id                => NULL,
        p_lead_number            => NULL,
        p_description            => l_description,
        p_status_code            => l_status_code,
	p_source_code          => l_source_code,  -- Added by Sumita for bug # 3812865 on 10.14.2004
        p_source_code_id            => l_source_code_id,
        p_customer_id            => l_customer_id,
 	    p_contact_party_id	     => l_contact_party_id,
        p_address_id             => l_address_id,
        p_sales_stage_id         => l_sales_stage_id,
        p_win_probability        => l_win_probability,
        p_total_amount           => NULL,
	p_total_revenue_forecast_amt => l_total_revenue_forecast_amt, --code added for R12
        p_channel_code           => l_channel_code,
        p_decision_date          => l_decision_date,
        p_currency_code          => l_currency_code,
	   p_vehicle_response_code  => l_vehicle_response_code,
	   p_customer_budget        => l_customer_budget,
--Code commented for R12 enhancement --Start
/*        p_close_competitor_code  => l_close_competitor_code,
        p_close_competitor_id    => l_close_competitor_id,
        p_close_competitor       => l_close_competitor, */
--Code commented for R12 enhancement --End
        p_close_comment          => l_close_comment,
        p_parent_project         => l_parent_project,
        p_freeze_flag            => l_freeze_flag,
        p_salesgroup_id          => l_salesgroup_id,
        p_called_node            => l_called_node,
	p_action_key               =>  l_action_key,  -- Added by Sumita for bug # 3812865 on 10.14.2004
        x_return_status          => l_return_status,
        x_msg_count              => l_msg_count,
        x_msg_data               => l_msg_data,
        x_lead_id                => l_lead_id
      );
Line: 1328

    MLIST_UPDATE_OUTCOME
    ( p_action_key     => p_action_key,
      p_list_header_id => l_list_header_id,
      p_list_entry_id  => l_list_entry_id,
      p_outcome_id     => l_outcome_id,
      p_reason_id      => l_reason_id,
      p_result_id      => l_result_id,
      x_return_status  => l_return_status,
      x_msg_count      => l_msg_count,
      x_msg_data       => l_msg_data
    );
Line: 1367

          p_entered_by         => l_last_updated_by,
          p_entered_date       => l_last_update_date,
          p_last_update_date   => l_last_update_date,
          p_last_updated_by    => l_last_updated_by,
          p_creation_date      => l_creation_date,
          p_created_by         => l_created_by,
          p_last_update_login  => l_last_update_login,
          p_party_id           => l_party_id,
          x_jtf_note_id        => l_jtf_note_id,
          x_return_status      => l_return_status,
          x_msg_count          => l_msg_count,
          x_msg_data           => l_msg_data
        );
Line: 1422

    l_last_update_date        DATE   := SYSDATE;
Line: 1423

    l_last_updated_by         NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
Line: 1425

    l_last_update_login       NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
Line: 1526

              p_entered_by         => l_last_updated_by,
              p_entered_date       => l_last_update_date,
              p_last_update_date   => l_last_update_date,
              p_last_updated_by    => l_last_updated_by,
              p_creation_date      => l_creation_date,
              p_created_by         => l_created_by,
              p_last_update_login  => l_last_update_login,
              p_party_id           => l_party_id,
              x_jtf_note_id        => l_jtf_note_id,
              x_return_status      => l_return_status,
              x_msg_count          => l_msg_count,
              x_msg_data           => l_msg_data
            );