eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_ACTIVITIES_PUB SQL Statements

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

Line: 7


 * Contents: INSERT_ACTIVITY 	                                           *
 *	   UPDATE_ACTIVITY	                                           *
 *                   DELETE_ACTIVITY	                                   *
 *                                                                         *
 * Use      This is the public layer of the GMD Activity API               *
 *                                                                         *
 *                                                                         *
 * History                                                                 *
 *         Written by Sandra Dulyk, OPM Development                        *
 *     25-NOV-2002  Thomas Daniel   Bug# 2679110                           *
 *                                  Rewrote the procedures to handle the   *
 *                                  errors properly and also to handle     *
 *                                  further validations                    *
 *    20-FEB-2004  Bug 3222090, NSRIVAST                                   *
 *                      Removed call to FND_PROFILE.VALUE('AFLOG_ENABLED') *
 **************************************************************************
*/

--Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN
--Forward declaration.
   FUNCTION set_debug_flag RETURN VARCHAR2;

Line: 44


   insert_activity
Description
  This particular procedure is used to insert an activity
Parameters
================================================ */
 PROCEDURE insert_activity (
     p_api_version 			IN 	NUMBER
   , p_init_msg_list 			IN 	BOOLEAN
   , p_commit				IN 	BOOLEAN
   , p_activity_tbl			IN 	gmd_activities_pub.gmd_activities_tbl_type
   , x_message_count	 		OUT NOCOPY  	NUMBER
   , x_message_list 			OUT NOCOPY  	VARCHAR2
   , x_return_status			OUT NOCOPY  	VARCHAR2)         IS

   l_retn_status	VARCHAR2(1);

Line: 67


    SAVEPOINT insert_activity;

Line: 91


                                       ,'insert_activity'
                                       ,'gmd_activities_pub') THEN
      RAISE invalid_version;

Line: 147


      GMD_ACTIVITIES_PVT.insert_activity(p_activity_tbl  =>  p_activity_tbl,
  	     				 x_message_count =>  x_message_count,
        				 x_message_list  =>  x_message_list,
      				         x_return_status =>  l_retn_status);

Line: 169


      ROLLBACK TO SAVEPOINT insert_activity;

Line: 174


      ROLLBACK TO SAVEPOINT insert_activity;

Line: 178


      ROLLBACK TO SAVEPOINT insert_activity;

Line: 185


  END Insert_Activity;

Line: 190


    update_activity
  Description
    This particular procedure is used to update an activity
  Parameters
  ================================================ */
  PROCEDURE update_activity (
   p_api_version 		IN 	NUMBER
  ,p_init_msg_list 		IN 	BOOLEAN
  ,p_commit			IN 	BOOLEAN
  ,p_activity			IN 	gmd_activities.activity%TYPE
  ,p_update_table		IN	gmd_activities_pub.update_tbl_type
  ,x_message_count 		OUT NOCOPY  	NUMBER
  ,x_message_list 		OUT NOCOPY  	VARCHAR2
  ,x_return_status		OUT NOCOPY  	VARCHAR2 )  IS

   l_retn_status		VARCHAR2(1);

Line: 213


     SELECT 1
     FROM   gmd_activities_b
     WHERE  activity = v_activity;

Line: 220


    SAVEPOINT update_activity;

Line: 241


                                       ,'update_activity'
                                       ,'gmd_activities_pub') THEN
      RAISE invalid_version;

Line: 250


      gmd_debug.put_line('Start of update_activity PUB');

Line: 273


    /* Loop thru cols to be updated - verify col and value are present */
    FOR i in 1 .. p_update_table.count LOOP
      /* Col_to_update and value must be passed, otherwise give error */
      IF p_update_table(i).p_col_to_update IS NULL THEN
        FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line: 278


        FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');

Line: 281


      ELSIF p_update_table(i).p_value IS NULL THEN
        FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line: 286


      ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN
        GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark    => p_update_table(i).p_value,
                                        x_return_status => l_retn_status);

Line: 290


          FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');

Line: 294


      ELSIF UPPER(p_update_table(i).p_col_to_update) = 'ACTIVITY_DESC' THEN
        IF p_update_table(i).p_value IS NULL THEN
          FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line: 301


      ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
        IF p_update_table(i).p_value IS NULL THEN
          FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line: 308


          IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_update_table(i).p_value) <> 0 THEN
            FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');

Line: 318


      GMD_ACTIVITIES_PVT.update_activity(p_activity	  => p_activity
         				, p_update_table  => p_update_table
        				, x_message_count => x_message_count
        				, x_message_list  => x_message_list
        				, x_return_status => l_retn_status);

Line: 341


      ROLLBACK to SAVEPOINT update_activity;

Line: 346


      ROLLBACK to SAVEPOINT update_activity;

Line: 350


      ROLLBACK to SAVEPOINT update_activity;

Line: 358


END update_activity;

Line: 362


    delete_activity
  Description
    This particular procedure is used to set delete_mark = 1 for an activity
  Parameters
  ================================================ */
  PROCEDURE delete_activity (
     p_api_version 		IN 	NUMBER
    ,p_init_msg_list 		IN 	BOOLEAN
    ,p_commit			IN 	BOOLEAN
    ,p_activity			IN 	gmd_activities.activity%TYPE
    ,x_message_count 		OUT NOCOPY  	NUMBER
    ,x_message_list 		OUT NOCOPY  	VARCHAR2
    ,x_return_status		OUT NOCOPY  	VARCHAR2  )  IS

    v_update_table   gmd_activities_pub.update_tbl_type;

Line: 380


    SAVEPOINT delete_activity;

Line: 389


    v_update_table(1).p_col_to_update := 'DELETE_MARK';

Line: 390


    v_update_table(1).p_value := '1';

Line: 392


    update_activity(p_api_version    => p_api_version
                   ,p_init_msg_list  => p_init_msg_list
                   ,p_activity	     => p_activity
       		   ,p_update_table   => v_update_table
                   , x_message_count => x_message_count
       		   , x_message_list  => x_message_list
       		   , x_return_status => l_retn_status);

Line: 413


      ROLLBACK to SAVEPOINT delete_activity;

Line: 417


      ROLLBACK to SAVEPOINT delete_activity;

Line: 425


END delete_activity;