APPS.XNP_WF_STANDARD SQL Statements

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

Line: 372

PROCEDURE SMS_DELETE_PORTED_NUMBER
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT  OUT NOCOPY VARCHAR2
 )
IS
l_WORKITEM_INSTANCE_ID     NUMBER;

Line: 384

e_SMS_DELETE_PORTED_NUMBER EXCEPTION;

Line: 408

    XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
     (l_WORKITEM_INSTANCE_ID
     ,l_error_code
     ,l_error_message
     );

Line: 415

      raise e_SMS_DELETE_PORTED_NUMBER;

Line: 454

       ,P_PROC_NAME            => 'SMS_DELETE_PORTED_NUMBER'
       ,P_MSG_NAME             => 'SMS_DELETE_PORTED_NUMBER_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 463

END SMS_DELETE_PORTED_NUMBER;

Line: 471

PROCEDURE SOA_UPDATE_CUTOFF_DATE
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                 NUMBER;

Line: 489

e_SOA_UPDATE_CUTOFF_DATE   EXCEPTION;

Line: 520

    XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE
     (l_ORDER_ID ,
      L_LINEITEM_ID,
      l_WORKITEM_INSTANCE_ID,
      l_FA_INSTANCE_ID,
      l_CUR_STATUS_TYPE_CODE,
      l_error_code,
      l_error_message
     );

Line: 531

      raise e_SOA_UPDATE_CUTOFF_DATE;

Line: 571

       ,P_PROC_NAME            => 'SOA_UPDATE_CUTOFF_DATE'
       ,P_MSG_NAME             => 'SOA_UPDATE_CUTOFF_DATE_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 579

END SOA_UPDATE_CUTOFF_DATE;

Line: 710

PROCEDURE SOA_UPDATE_SV_STATUS
 (ITEMTYPE IN VARCHAR2
 ,ITEMKEY IN VARCHAR2
 ,ACTID IN NUMBER
 ,FUNCMODE IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                 NUMBER;

Line: 728

e_SOA_UPDATE_SV_STATUS     EXCEPTION;

Line: 766

    XNP_STANDARD.SOA_UPDATE_SV_STATUS
     (p_ORDER_ID                 => l_ORDER_ID ,
      p_LINEITEM_ID              => l_LINEITEM_ID,
      p_WORKITEM_INSTANCE_ID     => l_WORKITEM_INSTANCE_ID,
      p_FA_INSTANCE_ID           => l_FA_INSTANCE_ID,
      p_NEW_STATUS_TYPE_CODE     => l_NEW_STATUS_TYPE_CODE,
      p_STATUS_CHANGE_CAUSE_CODE => l_STATUS_CHANGE_CAUSE_CODE,
      x_ERROR_CODE               => l_error_code,
      x_ERROR_MESSAGE            => l_error_message
     );

Line: 778

      raise e_SOA_UPDATE_SV_STATUS;

Line: 819

       ,P_PROC_NAME            => 'SOA_UPDATE_SV_STATUS'
       ,P_MSG_NAME             => 'SOA_UPDATE_SV_STATUS_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 827

END SOA_UPDATE_SV_STATUS;

Line: 1610

  SELECT parameter_name,  parameter_value, parameter_ref_value
    FROM xdp_worklist_details
   WHERE workitem_instance_id = cv_wi_instance_id;

Line: 1864

PROCEDURE SOA_UPDATE_CHARGING_INFO
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
x_progress                 VARCHAR2(2000);

Line: 1880

e_UPDATE_CHARGING_INFO     EXCEPTION;

Line: 1906

    XNP_STANDARD.SOA_UPDATE_CHARGING_INFO
     (l_ORDER_ID ,
      l_LINEITEM_ID,
      l_WORKITEM_INSTANCE_ID,
      l_FA_INSTANCE_ID,
      l_CUR_STATUS_TYPE_CODE,
      l_error_code,
      l_error_message
     );

Line: 1917

      raise e_UPDATE_CHARGING_INFO;

Line: 1959

       ,P_PROC_NAME            => 'SOA_UPDATE_CHARGING_INFO'
       ,P_MSG_NAME             => 'SOA_UPDATE_CHARGING_INFO_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 1968

END SOA_UPDATE_CHARGING_INFO;

Line: 2001

    SELECT SNR.fe_id
      FROM xnp_served_num_ranges SNR
     WHERE SNR.feature_type    = l_feature_type
       AND SNR.number_range_id = l_number_range_id;

Line: 2080

      XNP_CORE.SMS_INSERT_FE_MAP
      (p_ORDER_ID              =>   l_ORDER_ID,
       p_LINEITEM_ID           =>   l_LINEITEM_ID,
       p_WORKITEM_INSTANCE_ID  =>   l_WORKITEM_INSTANCE_ID,
       p_FA_INSTANCE_ID        =>   l_FA_INSTANCE_ID,
       p_STARTING_NUMBER       =>   to_number(l_STARTING_NUMBER),
       p_ENDING_NUMBER         =>   to_number(l_ENDING_NUMBER),
       p_FE_ID                 =>   l_TMP_FE.FE_ID,
       p_FEATURE_TYPE          =>   l_FEATURE_TYPE,
       x_ERROR_CODE            =>   l_ERROR_CODE,
       x_ERROR_MESSAGE         =>   l_ERROR_MESSAGE
      );

Line: 3122

 SELECT FE_ID
 FROM XNP_SV_SMS_FE_MAPS
 WHERE SV_SMS_ID  IN
 (SELECT SV_SMS_ID FROM XNP_SV_SMS
 WHERE SUBSCRIPTION_TN
 BETWEEN l_STARTING_NUMBER AND l_ENDING_NUMBER
 )
 AND FEATURE_TYPE=l_FEATURE_TYPE
 ;

Line: 3306

PROCEDURE SMS_DELETE_FE_MAP
 (ITEMTYPE IN VARCHAR2
 ,ITEMKEY IN VARCHAR2
 ,ACTID IN NUMBER
 ,FUNCMODE IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
x_progress VARCHAR2(2000);

Line: 3320

e_SMS_DELETE_FE_MAP EXCEPTION;

Line: 3357

    XNP_STANDARD.SMS_DELETE_FE_MAP
     (l_WORKITEM_INSTANCE_ID
     ,l_FE_ID
     ,l_FEATURE_TYPE
     ,l_error_code
     ,l_error_message
     );

Line: 3367

      raise e_SMS_DELETE_FE_MAP;

Line: 3409

       ,P_PROC_NAME => 'SMS_DELETE_FE_MAP'
       ,P_MSG_NAME => 'SMS_DELETE_FE_MAP_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1 => 'ERROR_TEXT'
       ,P_VAL1 => x_progress
       );

Line: 3418

END SMS_DELETE_FE_MAP;

Line: 3564

PROCEDURE SMS_UPDATE_FE_MAP_STATUS
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                 NUMBER;

Line: 3579

e_SMS_UPDATE_FE_MAP_STATUS EXCEPTION;

Line: 3627

    XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS
     (l_ORDER_ID ,
      l_LINEITEM_ID,
      l_WORKITEM_INSTANCE_ID,
      l_FA_INSTANCE_ID,
      l_FEATURE_TYPE,
      l_FE_ID,
      l_PROV_STATUS,
      l_error_code,
      l_error_message
     );

Line: 3641

      raise e_SMS_UPDATE_FE_MAP_STATUS;

Line: 3682

       ,P_PROC_NAME            => 'SMS_UPDATE_FE_MAP_STATUS'
       ,P_MSG_NAME             => 'SMS_UPDATE_FE_MAP_STATUS_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                  => x_progress
       );

Line: 3690

END SMS_UPDATE_FE_MAP_STATUS;

Line: 3727

    XNP_MESSAGE.UPDATE_STATUS
     (l_MSG_ID
     ,'REJECTED'
     ,l_COMMENT
     );

Line: 4521

 SELECT FE_ID
 FROM XNP_SV_SMS_FE_MAPS
 WHERE SV_SMS_ID  IN
 (SELECT SV_SMS_ID FROM XNP_SV_SMS
 WHERE SUBSCRIPTION_TN
 BETWEEN l_STARTING_NUMBER AND l_ENDING_NUMBER
 )
 AND FEATURE_TYPE=l_FEATURE_TYPE
 ;

Line: 4811

PROCEDURE SOA_UPDATE_NEW_SP_DUE_DATE
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                   NUMBER;

Line: 4830

e_SOA_UPDATE_NEW_SP_DUE_DATE EXCEPTION;

Line: 4869

    XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE
     (p_order_id             => l_order_id ,
      p_lineitem_id          => l_lineitem_id,
      p_workitem_instance_id => l_workitem_instance_id,
      p_fa_instance_id       => l_fa_instance_id,
      p_porting_id           => l_porting_id,
      p_local_sp_id          => l_local_sp_id,
      p_NEW_SP_DUE_DATE      => xnp_utils.canonical_to_date(l_NEW_SP_DUE_DATE),
      x_error_code           => l_error_code,
      x_error_message        => l_error_message
     );

Line: 4882

      raise e_SOA_UPDATE_NEW_SP_DUE_DATE;

Line: 4922

       ,P_PROC_NAME            => 'SOA_UPDATE_NEW_SP_DUE_DATE'
       ,P_MSG_NAME             => 'SOA_UPDATE_NEW_SP_DUE_DATE_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 4930

END SOA_UPDATE_NEW_SP_DUE_DATE;

Line: 4943

PROCEDURE SOA_UPDATE_OLD_SP_DUE_DATE
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                   NUMBER;

Line: 4962

e_SOA_UPDATE_OLD_SP_DUE_DATE EXCEPTION;

Line: 5002

    XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE
     (p_order_id             => l_order_id ,
      p_lineitem_id          => l_lineitem_id ,
      p_workitem_instance_id => l_workitem_instance_id ,
      p_fa_instance_id       => l_fa_instance_id ,
      p_porting_id           => l_porting_id,
      p_local_sp_id          => l_local_sp_id,
      p_OLD_SP_DUE_DATE      => xnp_utils.canonical_to_date(l_OLD_SP_DUE_DATE),
      x_error_code           => l_error_code,
      x_error_message        => l_error_message
     );

Line: 5015

      raise e_SOA_UPDATE_OLD_SP_DUE_DATE;

Line: 5055

       ,P_PROC_NAME            => 'SOA_UPDATE_OLD_SP_DUE_DATE'
       ,P_MSG_NAME             => 'SOA_UPDATE_OLD_SP_DUE_DATE_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 5063

END SOA_UPDATE_OLD_SP_DUE_DATE;

Line: 5354

    XNP_STANDARD.SOA_UPDATE_SV_STATUS
     (p_ORDER_ID                 => l_ORDER_ID ,
      p_LINEITEM_ID              => l_LINEITEM_ID ,
      p_WORKITEM_INSTANCE_ID     => l_WORKITEM_INSTANCE_ID,
      p_FA_INSTANCE_ID           => l_FA_INSTANCE_ID ,
      p_NEW_STATUS_TYPE_CODE     => l_NEW_STATUS_TYPE_CODE,
      p_STATUS_CHANGE_CAUSE_CODE => l_STATUS_CHANGE_CAUSE_CODE,
      x_ERROR_CODE               => l_error_code,
      x_ERROR_MESSAGE            => l_error_message
     );

Line: 5512

       XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG
       (p_order_id                  => l_order_id ,
        p_lineitem_id               => l_lineitem_id,
        p_workitem_instance_id      => l_workitem_instance_id,
        p_fa_instance_id            => l_fa_instance_id,
        p_porting_id                => l_porting_id,
        p_local_sp_id               => l_local_sp_id,
        p_new_sp_authorization_flag => l_flag_value,
        x_error_code                => l_error_code,
        x_error_message             => l_error_message
        );

Line: 5524

       XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG
       (p_order_id                  => l_order_id ,
        p_lineitem_id               => l_lineitem_id,
        p_workitem_instance_id      => l_workitem_instance_id,
        p_fa_instance_id            => l_fa_instance_id,
        p_porting_id                => l_porting_id,
        p_local_sp_id               => l_local_sp_id,
        p_old_sp_authorization_flag => l_flag_value,
        x_error_code                => l_error_code,
        x_error_message             => l_error_message
        );

Line: 5802

PROCEDURE SOA_UPDATE_DATE
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID              NUMBER;

Line: 5822

e_SOA_UPDATE_DATE       EXCEPTION;

Line: 5871

      XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE
       (p_order_id             =>l_order_id,
        p_lineitem_id          =>l_lineitem_id,
        p_workitem_instance_id =>l_workitem_instance_id ,
        p_fa_instance_id       =>l_fa_instance_id,
        p_porting_id           =>l_porting_id,
        p_local_sp_id          =>l_local_sp_id,
        p_new_sp_due_date      =>xnp_utils.canonical_to_date(l_date_value),
        x_error_code           =>l_error_code,
        x_error_message        =>l_error_message
       );

Line: 5891

      XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE
       (p_order_id             =>l_order_id,
        p_lineitem_id          =>l_lineitem_id,
        p_workitem_instance_id =>l_workitem_instance_id ,
        p_fa_instance_id       =>l_fa_instance_id,
        p_porting_id           =>l_porting_id,
        p_local_sp_id          =>l_local_sp_id,
        p_OLD_SP_DUE_DATE      =>xnp_utils.canonical_to_date(l_date_value),
        x_error_code           =>l_error_code,
        x_error_message        =>l_error_message
       );

Line: 5911

      XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE
       (p_order_id             =>l_order_id,
        p_lineitem_id          =>l_lineitem_id,
        p_workitem_instance_id =>l_workitem_instance_id ,
        p_fa_instance_id       =>l_fa_instance_id,
        p_porting_id           =>l_porting_id,
        p_local_sp_id          =>l_local_sp_id,
        p_ACTIVATION_DUE_DATE  =>xnp_utils.canonical_to_date(l_date_value),
        x_error_code           =>l_error_code,
        x_error_message        =>l_error_message
       );

Line: 5931

      XNP_CORE.SOA_UPDATE_DISCONN_DUE_DATE
       (p_order_id             =>l_order_id,
        p_lineitem_id          =>l_lineitem_id,
        p_workitem_instance_id =>l_workitem_instance_id ,
        p_fa_instance_id       =>l_fa_instance_id,
        p_porting_id           =>l_porting_id,
        p_disconnect_due_date  =>xnp_utils.canonical_to_date(l_date_value),
        x_error_code           =>l_error_code,
        x_error_message        =>l_error_message
       );

Line: 5950

      XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE
       (p_order_id                    =>l_order_id,
        p_lineitem_id                 =>l_lineitem_id,
        p_workitem_instance_id        =>l_workitem_instance_id ,
        p_fa_instance_id              =>l_fa_instance_id,
        p_porting_id                  =>l_porting_id,
        p_effective_release_due_date  =>xnp_utils.canonical_to_date(l_date_value),
        x_error_code                  =>l_error_code,
        x_error_message               =>l_error_message
       );

Line: 5969

      XNP_CORE.SOA_UPDATE_NUM_RETURN_DUE_DATE
       (p_order_id                    =>l_order_id,
        p_lineitem_id                 =>l_lineitem_id,
        p_workitem_instance_id        =>l_workitem_instance_id ,
        p_fa_instance_id              =>l_fa_instance_id,
        p_porting_id                  =>l_porting_id,
        p_number_returned_due_date    =>xnp_utils.canonical_to_date(l_date_value),
        x_error_code                  =>l_error_code,
        x_error_message               =>l_error_message
       );

Line: 5984

      raise e_SOA_UPDATE_DATE;

Line: 6024

       ,P_PROC_NAME            => 'SOA_UPDATE_DATE'
       ,P_MSG_NAME             => 'SOA_UPDATE_DATE_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       ,P_TOK2                 => 'DATE_NAME'
       ,P_VAL2                 => l_date_name
       );

Line: 6034

END SOA_UPDATE_DATE;

Line: 6327

PROCEDURE SOA_UPDATE_NOTES_INFO
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID              NUMBER;

Line: 6342

e_SOA_UPDATE_NOTES_INFO EXCEPTION;

Line: 6364

    XNP_STANDARD.SOA_UPDATE_NOTES_INFO
     (l_order_id,
      l_lineitem_id,
      l_WORKITEM_INSTANCE_ID,
      l_fa_instance_id,
      l_error_code,
      l_error_message
     );

Line: 6374

      raise e_SOA_UPDATE_NOTES_INFO;

Line: 6415

       ,P_PROC_NAME            => 'SOA_UPDATE_NOTES_INFO'
       ,P_MSG_NAME             => 'SOA_UPDATE_NOTES_INFO_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 6424

END SOA_UPDATE_NOTES_INFO;

Line: 6427

PROCEDURE SOA_UPDATE_NETWORK_INFO
 (ITEMTYPE IN VARCHAR2
 ,ITEMKEY IN VARCHAR2
 ,ACTID IN NUMBER
 ,FUNCMODE IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                 NUMBER;

Line: 6442

e_SOA_UPDATE_NETWORK_INFO  EXCEPTION;

Line: 6464

    XNP_STANDARD.SOA_UPDATE_NETWORK_INFO
     (l_order_id,
      l_lineitem_id,
      l_WORKITEM_INSTANCE_ID,
      l_fa_instance_id,
      l_error_code,
      l_error_message
     );

Line: 6474

      raise e_SOA_UPDATE_NETWORK_INFO;

Line: 6515

       ,P_PROC_NAME            => 'SOA_UPDATE_NETWORK_INFO'
       ,P_MSG_NAME             => 'SOA_UPDATE_NETWORK_INFO_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 6525

END SOA_UPDATE_NETWORK_INFO;

Line: 6528

PROCEDURE SOA_UPDATE_CUSTOMER_INFO
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                 NUMBER;

Line: 6543

e_SOA_UPDATE_CUSTOMER_INFO EXCEPTION;

Line: 6565

    XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO
     (l_order_id,
      l_lineitem_id,
      l_workitem_instance_id,
      l_fa_instance_id,
      l_error_code,
      l_error_message
     );

Line: 6575

      raise e_SOA_UPDATE_CUSTOMER_INFO;

Line: 6616

       ,P_PROC_NAME            => 'SOA_UPDATE_CUSTOMER_INFO'
       ,P_MSG_NAME             => 'SOA_UPDATE_CUSTOMER_INFO_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 6625

END SOA_UPDATE_CUSTOMER_INFO;

Line: 6747

PROCEDURE SOA_UPDATE_CUR_SV_STATUS
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                 NUMBER;

Line: 6765

e_SOA_UPDATE_CUR_SV_STATUS EXCEPTION;

Line: 6807

    XNP_STANDARD.SOA_UPDATE_SV_STATUS
     (p_ORDER_ID                 => L_ORDER_ID,
      p_LINEITEM_ID              =>l_LINEITEM_ID,
      p_WORKITEM_INSTANCE_ID     => l_WORKITEM_INSTANCE_ID,
      p_FA_INSTANCE_ID           => l_FA_INSTANCE_ID,
      p_CUR_STATUS_TYPE_CODE     => l_CUR_STATUS_TYPE_CODE,
      p_NEW_STATUS_TYPE_CODE     => l_NEW_STATUS_TYPE_CODE,
      p_STATUS_CHANGE_CAUSE_CODE => l_STATUS_CHANGE_CAUSE_CODE,
      x_ERROR_CODE               => l_error_code,
      x_ERROR_MESSAGE            => l_error_message
     );

Line: 6820

      raise e_SOA_UPDATE_CUR_SV_STATUS;

Line: 6861

       ,P_PROC_NAME            => 'SOA_UPDATE_CUR_SV_STATUS'
       ,P_MSG_NAME             => 'SOA_UPDATE_SV_STATUS_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 6869

END SOA_UPDATE_CUR_SV_STATUS;

Line: 6871

PROCEDURE SMS_UPDATE_PROV_DONE_DATE
 (ITEMTYPE   IN VARCHAR2
 ,ITEMKEY    IN VARCHAR2
 ,ACTID      IN NUMBER
 ,FUNCMODE   IN VARCHAR2
 ,RESULTOUT OUT NOCOPY VARCHAR2
 )
IS
l_ORDER_ID                  NUMBER;

Line: 6888

e_SMS_UPDATE_PROV_DONE_DATE exception;

Line: 6921

    XNP_CORE.SMS_UPDATE_PROV_DONE_DATE
	(p_order_id             => l_order_id,
         p_lineitem_id          => l_lineitem_id,
         p_workitem_instance_id => l_workitem_instance_id,
         p_fa_instance_id       => l_fa_instance_id,
         p_starting_number      => l_starting_number,
	 p_ending_number        => l_ending_number,
	 x_error_code           => l_error_code,
	 x_error_message        => l_error_message
	);

Line: 6933

	raise e_SMS_UPDATE_PROV_DONE_DATE;

Line: 6972

       ,P_PROC_NAME            => 'SMS_UPDATE_PROV_DONE_DATE'
       ,P_MSG_NAME             => 'SMS_UPDATE_PROV_DONE_DATE_ERR'
       ,P_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
       ,P_TOK1                 => 'ERROR_TEXT'
       ,P_VAL1                 => x_progress
       );

Line: 6981

END SMS_UPDATE_PROV_DONE_DATE;

Line: 7607

 SELECT parameter_name
   FROM xdp_worklist_details
   WHERE workitem_instance_id = cv_wi_instance_id
   FOR UPDATE;

Line: 7633

     UPDATE xdp_worklist_details
        SET parameter_value = l_param_val,
            LAST_UPDATE_DATE = sysdate,
            LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
            LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
      WHERE current of c_get_params;

Line: 7665

  SELECT parameter_name
    FROM xdp_fa_details
   WHERE fa_instance_id = cv_fa_instance_id
     FOR UPDATE;

Line: 7689

      UPDATE xdp_fa_details
         SET parameter_value = l_param_value,
             LAST_UPDATE_DATE = sysdate,
             LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
             LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
       WHERE current of c_get_fa_params;

Line: 7721

  SELECT parameter_name, parameter_value
    FROM xdp_fa_details
   WHERE fa_instance_id = cv_fa_instance_id;