DBA Data[Home] [Help]

APPS.ASO_SUP_CAPTURE_DATA_PKG SQL Statements

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

Line: 11

                  p_last_updated_by IN NUMBER,
                  p_last_update_login IN NUMBER,
                  p_commit  IN   VARCHAR2 := FND_API.G_FALSE,
			   x_template_instance_id OUT NOCOPY /* file.sql.39 change */  NUMBER,
                  X_RETURN_STATUS         OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
                  X_MSG_COUNT             OUT NOCOPY /* file.sql.39 change */   NUMBER,
                  X_MSG_DATA              OUT NOCOPY /* file.sql.39 change */   VARCHAR2) IS

l_template_instance_id NUMBER;
Line: 27

        SELECT aso_sup_tmpl_instance_s.NEXTVAL
        INTO l_template_instance_id
        FROM DUAL;
Line: 33

        INSERT INTO aso_sup_tmpl_instance
        (   TEMPLATE_INSTANCE_ID,
            TEMPLATE_ID,
            OWNER_TABLE_NAME,
            OWNER_TABLE_ID,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            CREATION_DATE,
            CREATED_BY )
        VALUES
        (   l_template_instance_id,
            p_template_id,
            p_owner_table_name,
            p_owner_table_id,
            SYSDATE, p_last_updated_by, p_last_update_login, SYSDATE, p_created_by);
Line: 77

PROCEDURE update_data (
                  p_template_instance_id IN NUMBER,
                  p_sect_comp_map_id IN NUMBER,
                  p_created_by IN NUMBER,
                  p_last_updated_by IN NUMBER,
                  p_last_update_login IN NUMBER,
                  p_response_id IN NUMBER,
                  p_response_value IN VARCHAR2,
                  p_multiple_response_flag IN VARCHAR2,
                  p_commit  IN   VARCHAR2 := FND_API.G_FALSE,
                  X_RETURN_STATUS         OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
                  X_MSG_COUNT             OUT NOCOPY /* file.sql.39 change */   NUMBER,
                  X_MSG_DATA              OUT NOCOPY /* file.sql.39 change */   VARCHAR2) IS


l_exists VARCHAR2(2);
Line: 93

l_api_name varchar2(50):= 'update_data';
Line: 96

   SAVEPOINT update_data_int;
Line: 99

        SELECT 'Y'
        INTO l_exists
        FROM aso_sup_instance_value
        WHERE template_instance_id = p_template_instance_id
        AND sect_comp_map_id = p_sect_comp_map_id
        AND ROWNUM = 1 ;
Line: 115

            UPDATE aso_sup_instance_value
            SET created_by = p_created_by,
                last_updated_by = p_last_updated_by,
                last_update_login  = p_last_update_login,
                response_id  = p_response_id,
                value  = p_response_value
            WHERE template_instance_id = p_template_instance_id
            AND sect_comp_map_id = p_sect_comp_map_id;
Line: 127

            INSERT INTO aso_sup_instance_value
                (instance_value_id, template_instance_id,
                 sect_comp_map_id, created_by, last_updated_by,
                 last_update_login, response_id, value,
                 last_update_date, creation_date)
            VALUES
                (aso_sup_inst_value_s.nextval, p_template_instance_id,
                 p_sect_comp_map_id, p_created_by, p_last_updated_by,
                 p_last_update_login, p_response_id, p_response_value,
                 SYSDATE, SYSDATE);
Line: 158

END update_data;
Line: 161

PROCEDURE delete_data (
                  p_template_instance_id IN NUMBER,
                  p_sect_comp_map_id IN NUMBER,
                  p_commit  IN   VARCHAR2 := FND_API.G_FALSE,
                  X_RETURN_STATUS         OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
                  X_MSG_COUNT             OUT NOCOPY /* file.sql.39 change */   NUMBER,
                  X_MSG_DATA              OUT NOCOPY /* file.sql.39 change */   VARCHAR2) IS
l_api_name varchar2(50) := 'delete_data';
Line: 172

         SAVEPOINT delete_data_int;
Line: 175

        DELETE FROM aso_sup_instance_value
        WHERE template_instance_id = p_template_instance_id
        AND sect_comp_map_id = p_sect_comp_map_id;
Line: 197

END delete_data;
Line: 225

	   l_lastUpdatedBy      NUMBER :=l_createdBy;
Line: 226

	   l_lastUpdateLogin    NUMBER := to_number( fnd_profile.value('LOGIN_ID') );
Line: 245

    SELECT quote_header_id
    FROM   aso_quote_lines_all
    WHERE  quote_line_id = p_qte_line_id;
Line: 339

						  p_last_updated_by      =>  l_lastUpdatedBy,
						  p_last_update_login    =>  l_lastUpdateLogin,
						  p_commit               =>  p_commit,
						  x_template_instance_id =>  lx_templateInstanceId,
                                X_RETURN_STATUS         =>   L_RETURN_STATUS,
                                X_MSG_COUNT             =>   X_MSG_COUNT,
                                X_MSG_DATA              =>   X_MSG_DATA
                                );
Line: 363

  		 	 update_data (
			     p_template_instance_id => l_templateInstance,
		   		 p_sect_comp_map_id     => l_compSectMapIds(l_sectLoop),
				    p_created_by           => l_createdBy,
				    p_last_updated_by      => l_lastUpdatedBy,
				    p_last_update_login    =>l_lastUpdateLogin,
				    p_response_id          =>l_responseIds(l_sectLoop),
				    p_response_value       => l_responseValues(l_sectLoop),
				    p_multiple_response_flag => l_multAnsFlags(l_sectLoop),
			         p_commit               =>  p_commit,
                        X_RETURN_STATUS         =>   L_RETURN_STATUS,
                        X_MSG_COUNT             =>   X_MSG_COUNT,
                        X_MSG_DATA              =>   X_MSG_DATA
                       );
Line: 386

              delete_data (
		          p_template_instance_id => l_templateInstance,
		          p_sect_comp_map_id     => l_compSectMapIds(l_sectLoop),
			     p_commit               =>  p_commit,
                    X_RETURN_STATUS         =>   L_RETURN_STATUS,
                    X_MSG_COUNT             =>   X_MSG_COUNT,
                    X_MSG_DATA              =>   X_MSG_DATA
				);
Line: 404

				update_data (
			          p_template_instance_id => l_templateInstance,
				     p_sect_comp_map_id     => l_compSectMapIds(l_sectLoop),
				     p_created_by           => l_createdBy,
				     p_last_updated_by      => l_lastUpdatedBy,
				     p_last_update_login    =>l_lastUpdateLogin,
				     p_response_id          =>l_responseIds(l_sectLoop),
				     p_response_value       => l_responseValues(l_sectLoop),
				     p_multiple_response_flag => l_multAnsFlags(l_sectLoop),
			          p_commit               =>  p_commit,
                         X_RETURN_STATUS         =>   L_RETURN_STATUS,
                         X_MSG_COUNT             =>   X_MSG_COUNT,
                         X_MSG_DATA              =>   X_MSG_DATA
                         );
Line: 462

PROCEDURE update_instance_value(
 	       P_VERSION_NUMBER		IN   NUMBER,
    	    P_INIT_MSG_LIST        	IN   VARCHAR2     := FND_API.G_FALSE,
    	    P_COMMIT                IN   VARCHAR2     := FND_API.G_FALSE,
      			P_Template_instance_id  IN   NUMBER       := FND_API.G_MISS_NUM,
			      P_comp_sect_map_id      IN   JTF_NUMBER_TABLE,
			      P_response_value        IN   JTF_VARCHAR2_TABLE_2000,
			      P_response_id           IN   JTF_NUMBER_TABLE,
			      P_mult_ans_flag         IN   JTF_VARCHAR2_TABLE_100,
			      X_RETURN_STATUS          OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
    	    X_MSG_COUNT              OUT NOCOPY /* file.sql.39 change */   NUMBER,
    	    X_MSG_DATA               OUT NOCOPY /* file.sql.39 change */   VARCHAR2)  IS

	   l_compSectMapId    aso_sup_instance_value.SECT_COMP_MAP_ID%TYPE;
Line: 480

	   l_lastUpdatedBy    NUMBER :=l_createdBy;
Line: 481

	   l_lastUpdateLogin  NUMBER := to_number( fnd_profile.value('LOGIN_ID') );
Line: 493

    l_api_name VARCHAR2(50) := 'update_instance_value';
Line: 502

      SELECT owner_table_id,owner_table_name
      FROM ASO_SUP_TMPL_INSTANCE
      WHERE template_instance_id = lc_template_instance_id;
Line: 512

    SELECT quote_header_id
    FROM   aso_quote_lines_all
    WHERE  quote_line_id = p_qte_line_id;
Line: 524

      SAVEPOINT update_instance_value_int;
Line: 601

    		  update_data (
			      p_template_instance_id => l_templateInstance,
				     p_sect_comp_map_id     => l_compSectMapIds(l_sectLoop),
				     p_created_by           => l_createdBy,
    				 p_last_updated_by      => l_lastUpdatedBy,
				     p_last_update_login    =>l_lastUpdateLogin,
				     p_response_id          =>l_responseIds(l_sectLoop),
				     p_response_value       => l_responseValues(l_sectLoop),
				     p_multiple_response_flag => l_multAnsFlags(l_sectLoop),
			          p_commit               =>  p_commit,
                         X_RETURN_STATUS         =>   L_RETURN_STATUS,
                         X_MSG_COUNT             =>   X_MSG_COUNT,
                         X_MSG_DATA              =>   X_MSG_DATA
                        );
Line: 625

                 delete_data (
		          p_template_instance_id => l_templateInstance,
		          p_sect_comp_map_id     => l_compSectMapIds(l_sectLoop),
                    p_commit               =>  p_commit,
                    X_RETURN_STATUS         =>   L_RETURN_STATUS,
                    X_MSG_COUNT             =>   X_MSG_COUNT,
                    X_MSG_DATA              =>   X_MSG_DATA
                        );
Line: 642

		 	  update_data (
			     p_template_instance_id => l_templateInstance,
				    p_sect_comp_map_id     => l_compSectMapIds(l_sectLoop),
				    p_created_by           => l_createdBy,
				    p_last_updated_by      => l_lastUpdatedBy,
				    p_last_update_login    => l_lastUpdateLogin,
				    p_response_id          => l_responseIds(l_sectLoop),
				    p_response_value       => l_responseValues(l_sectLoop),
				    p_multiple_response_flag => l_multAnsFlags(l_sectLoop),
			         p_commit               =>  p_commit,
                        X_RETURN_STATUS         =>   L_RETURN_STATUS,
                        X_MSG_COUNT             =>   X_MSG_COUNT,
                        X_MSG_DATA              =>   X_MSG_DATA
			   );
Line: 698

 END update_instance_value;