APPS.EGO_ITEMCAT_VAL_TO_ID SQL Statements

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

Line: 42

               SELECT mtl_item_catalog_groups_b_s.NEXTVAL
               INTO l_ccid from dual;

Line: 62

                SELECT item_catalog_group_id INTO l_ccid
		FROM mtl_Item_Catalog_Groups_b WHERE
		item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;

Line: 128

			-- used while insertion or updation.
			--

		-- dbms_output.put_line('before breakup_segments. . . ');

Line: 276

                 	SELECT mtl_item_catalog_groups_b_s.nextval
                 	INTO ccid
                 	FROM dual;

Line: 515

					-- dbms_output.put_line('Error if it is update or delete . . .');

Line: 518

					   when the transaction type is DELETE or UPDATE */

					IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
						(EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
					THEN
                                		Error_Handler.Add_Error_Token
                                		(  x_mesg_token_Tbl     => l_mesg_token_tbl
                                 		, p_application_id     => 'EGO'
                                 		, p_message_name       => 'EGO_CATALOG_DOESNOT_EXIST'
                                 		);

Line: 576

			  		EGO_Globals.G_Catalog_Group_Rec.Transaction_Type := EGO_Globals.G_OPR_UPDATE;

Line: 603

			   when the transaction type is DELETE or UPDATE */

                        ELSIF l_Catalog_Group_Name IS NULL AND
				EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE
                        THEN

                                Error_Handler.Add_Error_Token
                                (  x_mesg_token_Tbl     => l_mesg_token_tbl
				 , p_application_id	=> 'EGO'
                                 , p_message_name       => 'EGO_CATALOG_DOESNOT_EXIST'
                                );

Line: 729

			   	when the transaction type is DELETE or UPDATE */

				IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
						(EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
				THEN
                               		Error_Handler.Add_Error_Token
                               		(  x_mesg_token_Tbl     => l_mesg_token_tbl
                               		, p_application_id     => 'EGO'
                                 	, p_message_name       => 'EGO_CATALOG_DOESNOT_EXIST'
                               		);