APPS.OKC_XPRT_CZ_INT_PVT SQL Statements

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

Line: 324

PROCEDURE delete_ui_def
(
 p_api_version      IN  NUMBER,
 p_ui_def_id        IN  NUMBER,
 x_return_status    OUT NOCOPY VARCHAR2,
 x_msg_data	     OUT	NOCOPY VARCHAR2,
 x_msg_count	     OUT	NOCOPY NUMBER
) IS


l_api_version              CONSTANT NUMBER := 1;

Line: 335

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

Line: 361

                 'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');

Line: 373

       fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');

Line: 381

      CZ_contracts_api_grp.delete_ui_def
       (
        p_api_version          => l_api_version,
	   p_ui_def_id            => p_ui_def_id,
	   x_return_status        => x_return_status,
	   x_msg_count            => x_msg_count,
	   x_msg_data             => x_msg_data
	  );

Line: 398

                 'After Calling CZ_CONTRACTS_API_GRP.delete_ui_def ');

Line: 410

       fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');

Line: 445

END delete_ui_def;

Line: 612

SELECT logtime,
       caller,
       message
FROM cz_db_logs
WHERE run_id = p_run_id
ORDER BY logtime;

Line: 758

PROCEDURE delete_publication
(
 p_api_version      IN  NUMBER,
 p_init_msg_lst     IN  VARCHAR2,
 p_publication_id   IN  NUMBER,
 x_return_status    OUT NOCOPY VARCHAR2,
 x_msg_data	    OUT	NOCOPY VARCHAR2,
 x_msg_count	    OUT	NOCOPY NUMBER
) IS

l_api_version              CONSTANT NUMBER := 1;

Line: 769

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

Line: 799

                 'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');

Line: 811

       fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');

Line: 820

      CZ_CONTRACTS_API_GRP.delete_publication
       (
        p_api_version          => l_api_version,
        publicationid          => p_publication_id,
        x_return_status        => x_return_status,
        x_msg_count      	   => x_msg_count,
        x_msg_data             => x_msg_data
       );

Line: 836

                 'After Calling CZ_CONTRACTS_API_GRP.delete_publication ');

Line: 854

       fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');

Line: 887

END delete_publication;

Line: 904

SELECT publication_id
FROM cz_model_publications
WHERE model_id = p_devl_project_id
AND deleted_flag = '0'
AND publication_mode ='t';

Line: 911

SELECT L.LANGUAGE_CODE
  FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');

Line: 972

    	          delete_publication
		     (
		      p_api_version           => l_api_version,
		      p_init_msg_lst          => p_init_msg_lst,
		      p_publication_id        => l_publication_id,
		      x_return_status         => x_return_status,
		      x_msg_count      	      => x_msg_count,
		      x_msg_data              => x_msg_data
		      );

Line: 1213

                  handle_deleted_flag => 0, -- undelete new config if source config was deleted
                  new_name            => NULL);

Line: 1285

  Procedure Name : delete_configuration
  Description    : Calls CZ's delete_configuration API.

  +====================================================================*/
  PROCEDURE delete_configuration(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    p_config_header_id             IN NUMBER,
    p_config_rev_nbr               IN NUMBER,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2)

  IS

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

Line: 1306

     l_x_delete_status NUMBER; -- 1 if delete was successful; otherwise 0

Line: 1307

     l_x_error_message VARCHAR2(2000); -- error message if l_x_delete_status = 0

Line: 1339

    CZ_CF_API.delete_configuration(
                     config_hdr_id  => p_config_header_id,
                     config_rev_nbr => p_config_rev_nbr,
                     usage_exists   => l_x_usage_exists,
                     error_message  => l_x_error_message,
                     return_value   => l_x_delete_status);

Line: 1346

    IF (l_x_delete_status = 0)
    THEN

      IF (l_x_error_message is NOT NULL)
      THEN
        x_msg_data := l_x_error_message;

Line: 1404

  END delete_configuration;

Line: 1666

SELECT L.LANGUAGE_CODE
  FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');

Line: 1848

SELECT logtime,
       caller,
       message
FROM cz_db_logs
WHERE run_id = p_run_id
ORDER BY logtime;