APPS.PV_LEADLOG_PVT SQL Statements

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

Line: 44

PROCEDURE InsertAssignLogRow (
        X_Rowid                   OUT NOCOPY    ROWID     ,
        x_assignlog_ID            OUT NOCOPY    NUMBER       ,
        p_Lead_assignment_ID      IN     NUMBER       ,
        p_Last_Updated_By         IN     NUMBER       ,
        p_Last_Update_Date        IN     DATE         ,
	p_Object_Version_number   IN     NUMBER       ,
        p_Last_Update_Login       IN     NUMBER       ,
        p_Created_By              IN     NUMBER       ,
        p_Creation_Date           IN     DATE         ,
        p_lead_id                 IN     NUMBER       ,
	p_duration                IN     NUMBER       ,
        p_partner_id              IN     NUMBER       ,
        p_assign_sequence         IN     NUMBER       ,
        p_status_date             IN     DATE         ,
        p_status                  IN     VARCHAR2     ,
        p_cm_id                   IN     NUMBER       ,
        p_wf_pt_user              IN     VARCHAR2     ,
        p_wf_cm_user              IN     VARCHAR2     ,
        p_wf_item_type            IN     VARCHAR2     ,
        p_wf_item_key             IN     VARCHAR2     ,
        p_trans_type              IN     NUMBER       ,
        p_error_txt               IN     VARCHAR2     ,
        p_status_change_comments  IN     VARCHAR2     ,
        x_return_status           OUT NOCOPY    VARCHAR2) IS


     CURSOR C IS
        SELECT  rowid
        FROM    pv_assignment_logs
        WHERE   assignment_ID  = X_assignlog_ID;

Line: 83

  select pv_assignment_logs_s.nextval
  into   l_assignment_ID
  from   sys.dual;

Line: 89

   insert into pv_assignment_logs (
	    ASSIGNMENT_ID  ,
	    LAST_UPDATE_DATE,
	    LAST_UPDATED_BY,
	    CREATION_DATE,
	    CREATED_BY,
	    OBJECT_VERSION_NUMBER,
	    LAST_UPDATE_LOGIN,
	    LEAD_ID,
	    DURATION,
	    LEAD_ASSIGNMENT_ID,
	    PARTNER_ID,
	    ASSIGN_SEQUENCE,
	    CM_ID,
	    WF_PT_USER,
	    WF_CM_USER,
	    WF_ITEM_TYPE,
	    WF_ITEM_KEY,
	    STATUS_DATE,
	    STATUS,
	    TRANS_TYPE,
	    ERROR_TXT,
	    STATUS_CHANGE_COMMENTS)
	 Values (
	    l_assignment_id       ,
	    p_Last_Update_Date    ,
	    p_Last_Updated_By     ,
	    p_Creation_Date       ,
	    p_Created_By          ,
	    p_Object_version_number,
	    p_Last_Update_Login   ,
	    p_lead_id             ,
	    p_duration            ,
	    p_Lead_assignment_ID  ,
	    p_partner_id          ,
	    p_assign_sequence     ,
	    p_cm_id               ,
	    p_wf_pt_user          ,
	    p_wf_cm_user          ,
	    p_wf_item_type        ,
	    p_wf_item_key         ,
	    p_status_date         ,
	    p_status              ,
	    p_trans_type          ,
	    p_error_txt           ,
	    p_status_change_comments);

Line: 151

END InsertAssignLogRow;

Line: 252

    InsertAssignLogRow (
           X_Rowid                   =>  l_rowid                         ,
           x_assignlog_ID            =>  l_assignment_id                 ,
           p_Lead_assignment_ID      =>  l_assignlog_rec.Lead_assignment_ID ,
           p_Last_Updated_By         =>  G_USER_ID                       ,
           p_Last_Update_Date        =>  SYSDATE                         ,
           p_Last_Update_Login       =>  G_LOGIN_ID                      ,
           p_Created_By              =>  G_USER_ID                       ,
           p_Creation_Date           =>  SYSDATE                         ,
           p_Object_Version_Number   =>  l_assignlog_rec.object_version_number,
           p_lead_id                 =>  l_assignlog_rec.lead_id         ,
           p_duration                =>  l_assignlog_rec.duration        ,
           p_partner_id              =>  l_assignlog_rec.partner_id      ,
           p_assign_sequence         =>  l_assignlog_rec.assign_sequence ,
           p_status_date             =>  l_assignlog_rec.status_date     ,
           p_status                  =>  l_assignlog_rec.status          ,
           p_cm_id                   =>  l_assignlog_rec.cm_id           ,
           p_wf_pt_user              =>  l_assignlog_rec.wf_pt_user      ,
           p_wf_cm_user              =>  l_assignlog_rec.wf_cm_user      ,
           p_wf_item_type            =>  l_assignlog_rec.wf_item_type    ,
           p_wf_item_key             =>  l_assignlog_rec.wf_item_key     ,
           p_trans_type              =>  l_assignlog_rec.trans_type      ,
           p_error_txt               =>  l_assignlog_rec.error_txt       ,
           p_status_change_comments  =>  l_assignlog_rec.status_change_comments,
           x_return_status           =>  l_return_status);

Line: 289

      fnd_message.Set_Name('PV', 'Pvt Acc API: Insert Addr Rec');

Line: 373

PROCEDURE InsertLeadStatusLogRow (
   X_Rowid                   OUT NOCOPY    ROWID     ,
   x_assignlog_ID            OUT NOCOPY    NUMBER       ,
   p_Last_Updated_By         IN     NUMBER       ,
   p_Last_Update_Date        IN     DATE         ,
	p_Object_Version_number   IN     NUMBER       ,
   p_Last_Update_Login       IN     NUMBER       ,
   p_Created_By              IN     NUMBER       ,
   p_Creation_Date           IN     DATE         ,
   p_lead_id                 IN     NUMBER       ,
   p_partner_id              IN     NUMBER       ,
   p_status_date             IN     DATE         ,
   p_from_status             IN     VARCHAR2     ,
   p_to_status               IN     VARCHAR2     ,
   x_return_status       OUT NOCOPY  VARCHAR2,
   x_msg_count           OUT NOCOPY  NUMBER,
   x_msg_data            OUT NOCOPY  VARCHAR2) IS

     CURSOR C IS
        SELECT  rowid
        FROM    pv_assignment_logs
        WHERE   assignment_ID  = X_assignlog_ID;

Line: 397

    l_api_name              CONSTANT VARCHAR2(30) := 'InsertLeadStatusLogRow';

Line: 404

  select pv_assignment_logs_s.nextval
  into   l_assignment_ID
  from   sys.dual;

Line: 409

   insert into pv_assignment_logs (
	    ASSIGNMENT_ID  ,
	    LAST_UPDATE_DATE,
	    LAST_UPDATED_BY,
	    CREATION_DATE,
	    CREATED_BY,
	    OBJECT_VERSION_NUMBER,
	    LAST_UPDATE_LOGIN,
	    LEAD_ID,
	    PARTNER_ID,
	    STATUS_DATE,
	    FROM_LEAD_STATUS,
	    TO_LEAD_STATUS)
	 Values (
	    l_assignment_id       ,
	    p_Last_Update_Date    ,
	    p_Last_Updated_By     ,
	    p_Creation_Date       ,
	    p_Created_By          ,
	    p_Object_version_number,
	    p_Last_Update_Login   ,
	    p_lead_id             ,
	    p_partner_id          ,
	    p_status_date         ,
	    p_from_status         ,
	    p_to_status);

Line: 460

END InsertLeadStatusLogRow;